More on Posting from IC to GL
Inventory |
Miscellaneous |
Service |
Back to top |
Use this program to establish and maintain a set of GL posting tables for the Inventory Control module.
Once GL Posting Tables are created, you can assign a posting table to each item so that the system knows which GL account numbers to post to when it posts a transaction for that item. You can set up one GL posting table and post all items to it, or you can set up multiple posting tables to produce a more detailed accounting system.
The posting tables define how transactions should be distributed in the General Ledger distribution after various FACTS registers have been run.
For more information how to use maintenances, refer to the following topics:
How to use file maintenance programs
To access this program, choose Inventory Control-->File Maintenances --> Infrequent File Maintenances -->GL Posting Table F/M.
*. GL posting table
Enter the GL posting table (up to 3 characters).
2. Description
Enter the description of the GL posting table (up to 30 characters).
eCatelog Note: When a GL posting table is added or the description is changed, the system adds a record to the eCatalog log file for the next update to the eCatalog database. There is currently no way to remove a GL Code description record from eCatalog. However, when a code is deleted, any unprocessed records for this transaction will be removed from the log file.
3. Inventory G/L Number
Enter the GL account number for inventory. The entry must be a valid GL account number that displays the description.
4. Sales G/L Number
Enter the GL account number for sales. The entry must be a valid General Ledger number that displays the description.
5. Cost of Goods G/L Number
Enter the GL account number for cost of goods sold. The entry must be a valid General Ledger number that displays the description.
6. Receipts G/L Number
Enter the GL account number for receipts. The entry must be a valid General Ledger number that displays the description.
7. Adjustments G/L Number
Enter the GL account number for adjustments. The entry must be a valid General Ledger number that displays the description.
8. In Transit G/L Number
Enter the GL account number for in transit. The entry must be a valid General Ledger number that displays the description.
9. Physical Discrepancy G/L Number
Enter the GL account number for physical discrepancies. The entry must be a valid General Ledger number that displays the description.
10. Nonstocked Inventory
Enter the GL account number for nonstocked inventory. The entry must be a valid General Ledger number that displays the description.
11. Non Inventory
Enter the GL account number for non-inventory items (items that are set up in the item file but are not set up in the Warehouse/item file, e.g., labor). The entry must be a valid General Ledger number that displays the description.
1. Manufacturing Control Finished Goods G/L Number
Enter the GL account number for manufacturing finished goods. The entry must be a valid General Ledger number that displays the description.
2. Manufacturing Control Components G/L Number
Enter the GL account number for manufacturing component items. The entry must be a valid General Ledger number that displays the description.
3. Misc (miscellaneous) sales G/L Number
Enter the GL account number for miscellaneous sales. The entry must be a valid General Ledger number that displays the description.
4. Interwarehouse Cost of Goods Sold
Enter the GL account number for inter-warehouse cost of goods sold. The entry must be a valid General Ledger number that displays the description.
5. Interwarehouse Transfer In
Enter the GL account number for inter-warehouse transfers in. The entry must be a valid General Ledger number that displays the description.
6. Interwarehouse Transfer Out
Enter the GL account number for inter-warehouse transfers out. The entry must be a valid General Ledger number that displays the description.
1. Repair Part Sales
Enter the GL account number for repair part sales. The entry must be a valid General Ledger number that displays the description.
2. Repair Miscellaneous Sales
Enter the GL account number for repair miscellaneous sales. The entry must be a valid General Ledger number that displays the description.
3. Labor Sales
Enter the GL account number for labor sales. The entry must be a valid General Ledger number that displays the description.
4. Labor Miscellaneous Sales
Enter the GL account number for labor miscellaneous sales. The entry must be a valid General Ledger number that displays the description.
5. Labor Expense
Enter the GL account number for labor expense. The entry must be a valid General Ledger number that displays the description.
6. Labor Expense Contra
Enter the GL account number for labor expense contra. The entry must be a valid General Ledger number that displays the description.