Transaction Flow for Manufacturing Accounting
This table identifies which tables the manufacturing programs update; unless specified separately, the update applies to both standard and actual costing:
Programs |
Work Order Master (F4801) and Work Order Master Tag (F4801T) |
Work Order Parts List (F3111) |
Work Order Time Transactions (F31122) |
Work Order Routing (F3112) |
Production Cost (F3102) |
Item Ledger (F4111) |
Account Ledger (F0911) |
|---|---|---|---|---|---|---|---|
Order Processing (R31410) |
Work order status and quantity on order Cost method in the tag file |
Required quantity and accumulated costs |
NA |
Required hours and outside operations |
Standard costing: standard units and amounts, current units and amounts Actual costing: current units and amounts |
NA |
NA |
Work Order Inventory Issues (P31113) |
NA |
Quantity issued Unaccounted units and actual cost unaccounted amounts |
NA |
NA |
NA |
Creates issue (IM) transactions (no batch number or GL date) |
NA |
Component Scrap (P31116) |
NA |
Actual costing: Unaccounted units and amounts |
NA |
NA |
Reclassifies A1 to A2 |
NA |
NA |
Hours and Quantities (P311221) and Speed Time Entry (P051121) |
NA |
NA |
Hours reported Actual costing: Rates |
NA |
NA |
NA |
NA |
Hours and Quantities Update (R31422) |
NA |
NA |
Activates the processed flag |
Unaccounted units and amounts |
NA |
NA |
NA |
Full Completion (P31114) |
Work order status, unaccounted units and amounts for completions and scrap |
NA |
NA |
NA |
Actual costing: unaccounted units and amount for completions and scrap |
Creates completion (IC) and scrap (IS) transactions (no batch number) |
NA |
Manufacturing Accounting Journal Entries (R31802A) |
Work order status Resets unaccounted units to zero |
Resets unaccounted units to zero |
NA |
Resets unaccounted units to zero |
Planned, actual completions and scrap units and amounts Actual costing: resets unaccounted units and amounts for completions and scrap to zero |
Batch number and GL date for IM, IC, and hours and quantities (IH) transactions |
Creates IM, IH, IS, and IC transactions |
Variance Journal Entries (R31804) |
Work order status, production price variance flag |
NA |
NA |
NA |
Records variances and optionally restates standard, current, and planned amounts and units |
For cost method 09: Creates journal entry (IB) transactions Actual costing: writes IC transactions |
Creates (variance (IV) transactions in the Account Ledger Actual costing: creates IC and IS transactions |
The Manufacturing Accounting Journal Entries program updates the W.O. Cross Reference table (F3106) with the work order number, document number, document type, and GL date, and the batch number, type, and date.
The General Journal Post program (R09801) updates all account balances in the Account Balances table (F0902).