Sunday 9 November 2014

Lesson - 4 G/L Module -- Sage 300 ERP (ACCPAC)

Lesson - 4
G/L Module -- Sage 300 ERP (ACCPAC)

Lesson - 4
G/L Module -- Sage 300 ERP (ACCPAC)

How and where to set up my GL
GL – GL Option
Company:
    
Account:
     Use A/c Group
     Default Closing A/c 1520 Retained Earning
Posting:
     7 Years of Fiscal Sets
     7 Years of Transaction Detail
     Current Fiscal year                            2015
     Oldest Year of Fiscal Sets                  2014
     Oldest Year of Transaction Details   2014
Segments:
     Account                            4
     Department                      3
     Account Segment             1
     Default Structure Code    ACC
How to set up Source Code for G/L Set up
G/L Set up - Source Code
     GL - JE
     GL - CR
     GL - CD
What is Source Code? And
How to Add Source Code?
Source Code is like the Sub-Ledger Code.  Like GL for General ledger and SA for Sales
How to set up Source Journal Profile in G/L Set up
G/L Set up - Source Journal Profile
     Bank Reconciliation
        GL - JE
        GL - CR
        GL - BC
What is Source Journal Profile? and
How to Create Source Journal?
It is a combination of sub-Ledgers that are inter-linked like Bank Reconciliation would have
CD-Cash Disbursement,
CR-Cash Receipts and
BC-Bank Charges
How to set up Segment Code in G/L Set up
G/L Set up – Segment Code
     Department
         100   Consulting
         200   Textbooks    
What is Department Segment? and
How to Define Department segment?
It is a segment of a GL Account act like department and it can be Define through GL Setup – Segment Code
How to set up Account Structure in G/L Set up?
G/L Set up – Account Structure
     Structure Code:
       ACC                        Account
                                       ACCOUNT
       Use as Company Default
       
       DEP                         Department
                                        ACCOUNT
                                        DEPARTMENT   
What is Account Structure? and
How to Define Account Structure?
Account Structure is composite of GL Account number plus Segment Code….
How to set up Account Groups in G/L Set up
G/L Set up – Account Groups
        01 Cash and Cash   
        02 Account R/A      
        03 Inventory
How to set up Recurring Entry in G/L Set up
-Common Services - Schedules (Reminder)
-G/L Set up – Recurring Entries
     Month :  Monthly Cleaning Fee
        1810-100                50
        1810-100                50
        1360 R/A               13
        1300                                  113
-G/L Periodic Processing – Create Recurring                              Entry Batch - Process
-G/L Transaction Batch List – to CHECK n      Post
Where to Post Batches in G/L?
-G/L Transaction - Post Batch (All)
-Make first all Ready to Post ‘Yes’
What for is the Optional Fields and How to set up in G/L Set up.
G/L Set up – Optional Fields
     REGION
How do I create a GL Account
GL Account Account
Account : 1000
Description : Bank - Checking
   Tab.1 – Detail
     Structure Code :  ACC
     Normal Balance : Debit
     Account Type: Balance Sheet
     Account Group: 01
     Status: Active
     Account Group: 01
     Control Account: Yes
     Auto Allocation: Yes – No
                Allocation Tab will appear
                Make Account selection
                Make Percentage selection
      Post to Account :
                 Details
                 Consolidated
                 Prohibited
   Tab.2 – Optional Fields
   Tab.3 – Trans. Optional Fields


How do I create New Year what is G/L Periodic Processing?
-Dump the Current Year files in the folder
-Create Default Retained Earning Account  under G/L Option Set up
-Click Create Recurring Entries Batch  I-con in G/L Periodic Processing
-Click Create Allocation Batch I-con in G/L Periodic Processing
-Press Create New Year I-con and Process under G/L Periodic Processing.
How and where to create new Fiscal Year
Common Services – Create New Fiscal Year and Check it from G/L Setup Option to see the current Year is change to 2015
And the old Year is 2014


No comments:

Post a Comment