Slideshow

Monday, July 20, 2015

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)