- SQL Accounting Course Outline
3 Lesson & Duration : 6 Hours
1.Maintain GL Account
How assign MSIC code?
How to assign tax code?
How to set special type?
How to drag & drop sub account?
2.Maintain Customer
How to assign tax code & GST No?
3. Maintain Supplier
How to assign tax code & GST No?
4. Transaction :
• Customer Payment
• Customer Credit Note
• Supplier Invoice
• Supplier Payment
• Supplier Credit Note
5. Cash Book Entry
Set Posting Date
Set Tax Date
Set Bounced Status
6. Journal Entry
7. GST Process :
• GST Gain & Loss Process
• GST Listing
Print GST Audit File (GAF)
- SQL Stock Control Course Outline
2 Lesson & Duration : 4 Hours
1. Maintain Stock Group
b. How to set GL account code?
•Sales
•Purchase
•Cash Sales
•Cash Purchase
•Sales Return
•Purchase Return
•More Description
•Maintain Price Tag for Customer & Supplier
a. How to assign Tax Code?
b. How to maintain Multi UOM?
c. How to maintain BOM?
4.Opening Stock Quantity & Cost
6.Transactions :
8. Stock Transfer - Location
10. Production - Stock Item Assembly
12. Reporting
-
SQL Payroll Course Outline
1. Maintain Employee Payroll
2 Lesson & Duration : 4 Hours
2. Maintain Wages
3. Maintain Allowance
4. Maintain Overtime
5. Maintain Payment Method
6. Process Salary
a) Month End Payroll
b) Payroll Report
7. Maintain Leave
8. Leave Application
9. Leave Report
10. Opening Balance for Employee
11. Maintain Contribution
12. Government Report