Smart Operator

Tally ERP9

1. Introduction of Basic Accounting & Finance

2. Advantage of Computer Accounting

3. Introduction of Tally ERP9, Creation of a company with Accounts and Inventory mode.

4. Company Modification/Deletion/Shut

6. Create of using password and vault

7. Ledger Creation with Single/Multiple Mode

8. Ledger view at a Glance

9. Ledger Modification/Deletion

10. Unit of Measure creation

11. Inventory creation/Viewing/Deletion

12. Vouchers

13. Purchase & Sales Entry with/without inventory

14. Vouchers Modification/Deletion/Date change

15. Active/Deactive calculator and usages

16. Transactions Entry – Purchase/Purchase Returns, Sales/Sales returns

Debit/Credit Notes, Delivery/Receipt Note, Rejection In/

Rejection out, Contra, Journal, Receipt.

17. Cash Book/Bank Book, Purchase/Sales Register with Customized Features Added

18. Allow Zero Values Entries

19. Maintain Bill wise Details

20. Set/change credit limit for customers

21. Create/Alter/Delete Alternate Units

22. Godown Creation/Alteration, Transfer items from one godown into another

23. Shortcut key for Ledger Creation from Vouchers

24. Viewing for Trial Balance/Profit & Loss/ Balance Sheet

25. Stock summary/Ratio Analysis

26. Day Book, Ledger Finance Report Status etc.

27. Cash and Bank flow Statement

28. Bank Reconciliation Statement

29. Single/Multiple Vouchers Entry

30. Using shortcut keys

31. Different settings

GST Part

1. Basics, Basic Terms-IGST, SGST, CGST, UTGST, Composition scheme,

Input Tax credit etc.

2. GST settings- company level as well as Items level

3. GST Ledger Creation

4. GST Transactions: Sales/Sales Return, Purchase/Purchase Returns etc.

5. GST Treatment on Discount on Sales/Purchase items

ADVANCED EXCEL SYLLABUS WITH CLASS SCHEDULE	Time Per Class 1and 1/2 hour
1. WORKBOOK (FILE) ABD WORKSHEET HANDLING
E+A2:M54xcel Limitation	1st class
Excel Shortcut use and benefits	1st class
Excel Setting and Custom List Creation	1st class
Excel Tamplate and File Location System	1st class
Advanced Paste Special	2nd class
Calulation with Paste Special	2nd class
Link Data range as Picture Link	2nd class
Loopkup Picture in Excel Worksheet	2nd class
2. Advanced Formating for Reports and Dashboard
Formatting Triks	3rd class
Date & Time For Trinks	3rd class
Advanced Custom Formating (Number Format using Code)	3rd class
Conditional Formatting	3rd class
Advanced Conditional Formatting using Formulas	4th class
File,Sheets or Cells Protection Method	4th class
Benefits of Data Table or Cells Style	4th class
3. Data Handle and Data Analysis
Data Fill and Selection Method	4th class
Advanced Sorting and Filter Trinks	5th class
Data Summerization with Pivot Table	5th class
Calculation with Pivot table	5th class
Extranal Data Pivot Table	5th class
Relationship and Slicer in Pivot Table	6th class
Power Pivot in Excel 2016	6th class
Use SQL Query in Pivot Table	6th class
4. Page Setting and Form Creation
Draw Form in Excel Sheet	6th class
Hyperlink in Excel	7th class
Text and Symbol	7th class
Page Setup	7th class
Manage View	7th class
Sheets Option and Arrange	8th class
5. Calculation
Mathameticals Calculation in Excel	8th class
Logical Formulas (IF, and, Or, Xor, IfError Formulas)	8th class
Nested If Formulas ( Multi Condition in If,and,or )	8th class
Text and Advanced Text Formulas	8th class
Date and Time Calculation using Data Time Formulas	8th class
Ref# Formulas and VLookup	9th class
Lookup Method(VLookup,HLookup,Match,Index,Offset)	9th class
Advanced VLookup and VLookup Listing	9th class
Math &trico. Formulas	9th class
Data Summerization Formulas (AVERAGEIF,AVERAGEIFS,COUNTIF,COUNTIFS,LARGE,SMALL and more)
Database and list managment Formulas	10th class

SAP ENDUSER COURSE CONTENT

A.    BASIC KNOWLEDGE ABOUT GLOBAL SETTINGS.

B.   GENERAL LEDGER ACCOUNTING

1. Create G/L account

2. Block General Ledger Account

3. Unblocking of General Account

4. Edit General Ledger Account

5. Display Changes of General Master  Account

6. Journal/GL Account  Entry Posting

7. Parking Document

8.Hold Document

9. Release the parking Document by changing the amount

10. Release the parking document by delete the document

11. Park GL Document Entry

12. Park Vendor Invoice Entry

13. Park Customer Invoice Entry

14. View G/L wise balances

15. View GL Line Item Display

16. REFERENCE DOCUMENTS – REVERSALS ENTRIES

C.   RECURRING DOCUMENT CONFIGURATION

1. Create no. ranges for recurring documents

2. Create recurring document template

3. Change recurring documents

4. Display recurring document

5. Display changes of recurring document

6. Overview of recurring documents

7. Execute/Run the recurring document

8. To view document

9. Individual Reversal

10. Mass Reversal

10. Reversal of reversal

11.Sample Document

D.  ACCOUNTS PAYABLE CONFIGURATION

1. Create Vendor Account Groups

2. Create Number Ranges for Vendor Accounts

3. Assign Number Ranges to Vendor Account Groups

4. Create Reconciliation G/L Accounts for vendor

5. Create Number Ranges for Purchase Invoice Posting

6. Creation of Vendor Master Data

7. Tolerance group for Vendor

8. Purchase Invoice Posting

9. Outgoing Payments

10. To View Vendor wise Balances

11. Clear Open Item

E.    GENERAL LEDGER POSTING

F.    CASH DISCOUNT

1. Define Terms of Payment

2. Create G/L account for Cash Discount Account

3. Assignments

ii. Assign Automatic Postings to Cash Discount A/c.

4. Incoming Payments from Customers

5. To view G/L wise balances

6. To view Customer wise balance

G.   AUTOMATIC PAYMENT PROGRAM

1. Creation of House Bank

2. Creation of Check Lots

3. Check Payments

4. To view Check Book

5 Check creation

6. To view check register

7. To create new void reason

8. All company codes

9. Paying company codes

10. Payment method in country

11. Payment method in company code

12. Bank determination

13. Automatic payment program run & printout documents..

H.   SPECIAL G/L ACCOUNTS

1. DOWN PAYMENTS TO VENDORS

2. Create Down Payments to vendors A/C (Asset)

3 Link between down payments to Sundry Creditors

4. Advance made to Vendors

5. Purchase invoice

6. Transfer Special G/L A/Cs to Normal G/L A/Cs

7. Outgoing payments

MM END USER COURSE CONTENT

MM01	SAP MM Procurement (User)
MM01-01	Request for quotation (ME41)
MM01-02	Quotation (ME47)
MM01-03	Price comparison (ME49)
MM01-04	Create contract (ME31K)
MM01-05	Purchase requisition (ME51N)
MM01-06	Assign vendors to purchase requisitions (ME56)
MM01-07	Purchase order vendor unknown (ME25)
MM01-08	Goods receipt for purchase order (MIGO)
MM01-09	Purchase order (ME21N)
MM01-10	PO List display (ME2L)
MM01-11	PO based on Requisitions (ME58)
MM01-12	Goods receipt (MIGO)
MM01-13	Stock overview (MMBE)
MM01-14	Display vendor (XK03) and material master data (MM03)
MM01-15	Display info. record (ME12) and source list master data (ME03)
MM01-16	Return purchase order (ME21N)
MM01-17	Vendor invoice verification (MIRO)
MM01-18	Enter vendor confirmation in purchase order (ME22N)
MM01-19	Monitoring missing order acknowledgements (ME92F)
MM01-20	Monitoring overdue purchase orders (ME91F)
MM01-21	Quota arrangement (MEQ1)
MM01-22	Purchase order without material, text item purchase (ME21N)
MM01-23	Service purchase order (ME21N)
MM01-24	Service entry sheet (ML81N)
MM02	SAP MM Procurement Contract (User)
MM02-01	Create contract (ME31K)
MM02-02	Purchase requisition (ME51N)
MM02-03	Assign contract to purchase requisition (ME57)
MM02-04	Purchase order to contract (ME57)
MM02-05	Goods receipt for purchase order (MIGO)
MM02-06	Invoice receipt and invoice verification (MIRO)
MM02-07	Display purchase order history (ME23N)
MM02-08	Release blocked invoices (MRBR)
MM02-09	Display contract (ME33K)
MM02-10	Display partially completed contract (ME33K)
MM03	SAP MM Physical Inventory (User)
MM03-01	Warehouse Stock Display (MB52)
MM03-02	Physical Inventory Document w/o Special Stock (MI31)
MM03-03	Block Material (MI32)
MM03-04	Freeze Book Inventory Balance (MI33)
MM03-05	Print Physical Inventory Document (MI21)
MM03-06	Enter Inventory Count (MI04)
MM03-07	Set Zero Count (MI35)
MM03-08	Difference List (MI20)
MM03-09	Recount (MI11)
MM03-10	Post Difference (MI07)
MM04	SAP MM Inventory Stock Management (User)
MM04-01	Goods receipt of purchase order (MIGO)
MM04-02	Goods receipt without order reference (MIGO)
MM04-03	Stock quantity report – stock overview (MMBE)
MM04-04	Transfer stock to stock (MIGO)
MM04-05	Transfer plant to plant (MIGO)
MM04-06	Create stock reservation (MB21)
MM04-07	Goods issue to cost center (MIGO_GI)
MM04-08	Display material document (MB51)
MM04-09	Stock quantity and value report – warehouse stock (MMBE)
MM04-10	Physical inventory stock adjustment (MI10)
MM04-11	Create STO stock transport order (ME21N)
MM04-12	Goods issue for STO stock transport order (MIGO_GI)
MM04-13	Material transfer blocked stock to unrestricted (MIGO)
MM04-14	Goods issue for reservation (MIGO_GI)
MM04-15	Stock on posting date (MB5B)
MM04-16	Display stock in transit (MB5T)

SD END USER COURSE CONTENT

T Code	Description
XD01, XD02, XD03	Customer creation, Change, Display (General)
FD01. FD02, FD03	Customer Creation, Change, Display (FI Customer)
VD01, VD02,VD03	Customer Creation, Change, Display (Sales Area)
MM01, MM02, MM03	Material  Creation, Change, Display (Finished Goods)
VA01, VA02, VA03	Sales Order Creation, Change, Display (Standard Order, Cash Sales, Rush Order, Debit Memo, Credit Memo, Return Order)
VA11, VA12, VA13	Inquiry Creation, Change, Display
VA21, VA22, VA23	Quotation Creation, Change, Display
VA31. VA32,VA33	Scheduling Agreement Creation, Change,Display
VA41, VA42, VA43	Contract Creation, Change, Display
VA51, VA52, VA53	Item Proposal Creation, Change, Display
VL01N, VL02N, VL03N	Creation Delivery, Change, Display
VF01, VF02, VF03	Billing Creation, Delivery, Change
VK11, VK12, VK13	Condition Record Maintain, Change, Display
VD51, VD52, VD53	Customer Material Info Record Maintain, Change, Display
ME21N, ME22N, ME23N	Purchase Order Creation, Change, Display
MIGO	Goods Receipt Note Entry
MB1C	Material Stock Upload
VAP1	Create Contact Person
VB01, VB02, VB03	Listing/Exclusion Creation, Change, Display
VB11, VB12, VB13	Material Determination Creation, Change, Display

SOFT SKILL AND COMMUNICATIONS