SQL Accounting Course 专业电脑会计课程

DECEMBER !! Time Table : SQL Accounting Course

Amend : Time Table-SQL Stock Control Training Course (Advance)

Amend : Time Table-SQL Stock Control Training Course (Basic)

Amend : Time Table-SQL Accounting Training Course

Outline @SQL Computerized Certificate Training Course

SQL Accounting Training Course （華語授課 - Mandarin Language）

SQL Payroll Training Course （華語授課 - Mandarin Language）

SQL Stock Control Basic + Advance Training Course（華語授課 - Mandarin Language）

SQL ACCOUNT SOFTWARE Training Course (Aug Time Table)

SQL Training Course [July Class Time Table]

LESSON 1 :      SQL Accounting     Training Course for Basic, Pro & Value Set   

1) Installation Software
2) Create Database
3) Set Financial Year / Create Company Profile/ Set Report Header / Start GST
4) Maintain Customer/ Maintain Supplier / Maintain Item Code / Maintain GL Account GST
5) Transaction: Purchasing (Invoice, Purchase Return) / Sales (Invoice, Credit Note)
6) Payment: Customer and Supplier
7) Discount Transaction: Customer and Supplier
8) Cash Book Entry (Monthly Expenses)
9) Print Ledger Report/ View Statement/ View P & L Report
10) GST-03 Process

**(Topic might be slightly change on actual, depending on the situation)

LESSON 2 :     SQL Stock Control     Training Course for Basic & Pro Set   

1) Maintain Stock Group

2) Maintain Stock Item / Tax Code/ More Description

3) Opening Stock Qty and Cost

4) Stock Received/ Stock Issue/ Stock Adjustment

5) View Stock Card / Month End Stock Aging

6) Print stock physical worksheet

**(Topic might be slightly change on actual, depending on the situation)

LESSON 3 :    SQL Stock Control+     Training Course for Basic, Pro & Value Set   

1) Maintain Multi UOM / Barcode
2) Create Price Tag / Maintain Price Tag for Customer & Supplier
3) Maintain Stock Category 
4) Maintain Item Template 
5) Maintain B.O.M - Production Assembly and Disassembly
6) Serial Number Module

**(Topic might be slightly change on actual, depending on the situation)

Training Session 3 / Lesson 3 (May 2015 Time Table)

ü  Maintain multi UOM/ Barcode

ü  Create price tag/ Maintain Price tag for customer & supplier

ü  Maintain stock category

ü  Maintain item template

ü  Maintain BOM- Production Assembly and Disassembly

ü  Serial number module

Training Session 2 / Lesson 2 (May 2015 Time Table)

ü  Maintain stock group

ü  Maintain stock item/ tax code/ more description

ü  Opening stock qty and cost

ü  Stock received/ Stock issue/ Stock adjustment

ü  View stock card/ Month end stock aging

ü  Print stock physical worksheet

Training Session 1 / Lesson 1 (May 2015 Time Table)

ü  Installation software

ü  Create database

ü  Set financial year/ Create company profile/ Set report header/ Start GST

ü  Maintain customer/ Maintain supplier/ Maintain item code/ Maintain GL account GST

ü  Transaction: Purchasing (Invoice, Purchase return)/ Sales (Invoice, Credit note)

ü  Payment: Customer and Supplier

ü  Discount Transaction: Customer and Supplier

ü  Cash book entry (monthly expenses)

ü  Print ledger report/ View statement/ View P & L report

ü  GST 03 Process