You can subdivide your financial reports by department or 'division' by
making use of the GL Divisions option in OneSource.
Set up GL Divisions by following these steps:
1. Create Divisions in the Company Setup & Preferences.
- Open the Company Setup & Preferences form
- Select the General Ledger tab
- Click on the GL Divisions tab
- Click the New button and complete the GL
Division fields for each new Division that you would like to create. (Table: tblLocations)
2. Create the required GL Accounts for each Division. (Table: Chart of Accounts)
- Open the Chart of Accounts form. Create new GL Accounts as necessary by pressing the New
button. (Be sure to select the appropriate GL Division for each unique
GL Division account).
- For example, for your inventory accounts, set up a
separate account for each division and assign the division to the account.
(1500-01 for Anaheim, 1500-02 for Long Beach, 1500-03 for Riverside, etc)
- Try to be consistent with the accounts to avoid
confusion. For the above example, always
use -01 for the Anaheim division, -02 for the Long Beach division, etc.).
- If you have 3 divisions, you will probably want to create GL accounts (for each division) that represent your GL accounts for Sales, Sales Discounts, COGS, and Inventory.
- For instance: If Anaheim GL accounts were signified by using -01 on the end of the GL accounts, you might have the following GL Accounts:
- 4000-01 Sales (Anaheim)
- 4001-01 Sales Discounts (Anaheim)
- 5000-01 Cost of Goods Sold (Anaheim)
- 1500-01 Inventory (Anaheim)
- And: If Long Beach GL accounts were signified by using -02 on the end of your GL accounts, you might have the following GL Accounts:
- 4000-02 Sales (Long Beach)
- 4001-02 Sales Discounts (Long Beach)
- 5000-02 Cost of Goods Sold (Long Beach)
- 1500-02 Inventory
- Etc...
3.
Set a GL Division for each Company Shipping/Warehouse
Location (Table: Shipping Locations)
1.
From Purchasing,
select the Company Shipping/Warehouse
Locations form
2.
Select a GL
Division from the drop down list for each location
4. Link each item or service that you sell to the appropriate Divisions. (Table: InventoryLocationGL)
1.
Open the Inventory Management form to the
Financial tab
2.
Click on the GL Divisions button
3.
Select the appropriate Division Code and GL
accounts
4.
Press the record selector button (near the
bottom left hand portion of the form) to advance to the next record to repeat
the process to assign another GL Division and GL Accounts (for the same item).
5.
If necessary, set up a GL Division for each user
1.
Select Tools,
User Security
2.
Choose the User
for which you want to set the division
3.
Select the GL
Division from the drop down box.
