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