|
 
| |
Tracking GL Numbers
Additional Resources
- GL Setup Overview
- Category Setups (GU
21, 1 also IU 9)
- System Configuration (GU
21, 2 also MU 2)
- Tax code setup (GU
21, 3 also RU 8)
- Transfer Account Setup (GU
21, 4 also MU 10)
- Chart of Accounts (GU 21,
5 also GU 15, 1)
- Financial Format Member (GU 21,
6 also GU 15, 3)
- Vendor Setup (GU
21, 7 also OU 5)
- Vendor GL Assignments (GU 21, 8)
- Department Master (GU 21, 12 also PU 12)
- Unemployment Insurance (GU 21, 13 also PU 13)
- State Disability Insurance (GU 21, 14 also PU 14)
- Payroll Tax Accounts (GU 21, 15 also PU 15)
- Payroll Tax Tables (GU 21, 16 also PU 16)
- Additional Earned Income (GU 21, 17 also PU 17)
- Federal State ID Numbers (GU
21, 19 also PU 19)
- Payroll Control
File (GU 21, 20 also PU 20)
- Tracking how
information gets to the G/L
- Chart of Accounts
- Discounts
- Federal ID
- Financial Format Member
- Freight
- MU 2, Page 2
- This reports to the GL via the Invoice Register
- Inventory (this is the inventory default unless overridden by a category
G/L assignment)
- MU 2, Page 2
- This reports to the GL via the Invoice Register
- Inventory by Category (this overrides inventory G/L defaults)
- IU 9
- This reports to the GL via the Invoice Register
- Inventory Transfers
- MU 10, line 19
- This reports to the GL via the Invoice Register
- Payroll Control File
- Receivables Adjustments
- MU 2, Page 3
- This reports to the GL via the Invoice Register
- Sales
- MU 2, Page 2
- This reports to the GL via the Invoice Register
- State ID
- System control file
- Taxes
- RU 8
- This reports to the GL via the Invoice Register
- Vendor Expense Accounts
Outline of Processing |
What Shows in the Reports
Process Path Display (Example 1) Going to the G/L
Types of Transactions
Process Path Display (Example 2) Going to the G/L
- Flash Sales Inquiry (MI 2)
- this is updated immediately upon any system activity
- Pre-Invoice Margin Report (MP 1, 4)
- this is daily activity that has been completed but not posted
- please note that you can change cost errors at this point (prior to
running your invoice register)
- Invoice Register (MP 1,5)
- this is daily activity that has been processed through a pre-invoice
margin report
- IBS Accounting System
Version 1
- This will post all invoice register activity to the ARTR file/
pre-posting accounting transaction file (MP 2, 7) for review.
- IBS Accounting System
Version 2
- This will post all invoice register activity in balance to the
General Ledger
- All out of balance invoice register activity will post to the
ARTR file/ pre-posting accounting transaction file (MP 2, 7)
for review.
- General Ledger Reports
- All GL Reports are based on posted G/L data.
- Information not posted to General Ledger is not included in
any calculated balance.
- Information pending posting (MP 2, 7) to General Ledger is not
included in any calculated balance.
- Inventory Reports
- all are based on current received, on-hand calculated inventory
balances.
|
