Manufacturing Interface

Listed below for the Manufacturing Interface is the posting type, the posting type description, what transactions are used for the postings, and the calculation for the posting.

For example, the posting type INVEN is used to post for each inventory transaction and is calculated as the cost type S for the item times the transaction quantity.

When entering manufacturing posting templates in program GPTM, Posting Template Maintenance, if the credit and debit accounts are the same, postings will not be created for transactions meeting that template's criteria.

Note: Make sure to activate the Manufacturing to General Ledger Posting Interface for your plant and enterprise using program MACM, Manufacturing General Ledger Posting Control.

Manufacturing Interface uses Two-sided entries

CURR Currency Gain/Loss 

FIXOV  Fixed Overhead Each labor transaction (in the labor transaction log). The worked * rate * overhead rate for overhead applied to fixed burden.

I2FOV Inventory 2 Fixed Overhead Only Each inventory transaction (in the item transaction log). The second posting cost type fixed overhead cost * transaction quantity.

I2LAB Inventory 2 Labor Only Each inventory transaction (in the item transaction log). The second posting cost type labor cost * transaction quantity.

I2MAT Inventory 2 Material Only Each inventory transaction (in the item transaction log). The second posting cost type material cost * transaction quantity.

I2SER Inventory 2 Service Only Each inventory transaction (in the item transaction log). The second posting cost type service cost * transaction quantity.

I2VOV  Inventory 2 Variable Overhead Only Each inventory transaction (in the item transaction log). The second posting cost type variable overhead cost * transaction quantity.

INFOV  Inventory Fix Overhead Only Each inventory transaction (in the item transaction log). The cost type S fixed overhead * transaction quantity.

INLAB  Inventory Labor Only Each inventory transaction (in the item transaction log). The cost type S labor cost * transaction quantity.

INMAT  Inventory Material Only Each inventory transaction (in the item transaction log). The cost type S material cost * transaction quantity.

INSER  Inventory Service Only Each Inventory transaction (in the item transaction log). The cost type S service cost * transaction quantity.

INVE2 Inventory 2nd Cost Each inventory transaction (in the item transaction log). The second posting cost type unit cost * transaction quantity.

INVEN Inventory  Each inventory transaction (in the item transaction log). The cost type S * transaction quantity.

INVOV Inventory Variable Overhead Only Each inventory transaction (in the item transaction log). The cost type S variable overhead cost * transaction quantity.

LABOR  WIP Labor Each labor detail transaction (in the labor transaction log). The hours worked * rate.

NSMAT Non-stock Material Cost Each purchasing receipt for a non-stocked item. The purchasing cost per item*received quantity.

NSRMA Non-stock Return Material Cost Each return to inventory for a non-stocked item. The cost per item*returned quantity.

POWIP  Outsourced Operations Each purchasing or service receipt to a work order. The purchasing cost of the receipt.

SCRAP  WIP Scrap Each labor detail transaction (in the labor transaction log). The routing cost detail unit cost at the scrapping operation * the quantity scrapped.

VAROV  Variable Overhead Each labor detail transaction (in labor transaction log). The hours worked * rate * overhead rate for the overhead applied to variable burden.

WICST  WO Close Total Cost Adjustment When the work order is closed, if actual or lot costing is being used, the difference between the actual total work order cost and the received total work order cost.

WIFOV  WO Close Fix Ovhd Cost Adjustment When the work order is closed, if actual or lot costing is being used, the difference between the actual fixed overhead cost and the received fixed overhead cost.

WILAB  WO Close Labor Cost Adjustment When the work order is closed, if actual or lot costing is being used, the difference between the actual labor cost and the received labor cost.

WIMAT  WO Close Material Cost Adjustment When the work order is closed, if actual or lot costing is being used, the difference between the actual material cost and the received material cost.

WISER  WO Close Service Cost Adjustment When the work order is closed, if actual or lot costing is being used, the difference between the actual service cost and the received service cost.

WIVOV  WO Close Var Ovhd Cost Adjustment When the work order is closed, if actual or lot costing is being used, the difference between the actual variable overhead cost and the received variable overhead cost.

WOMFO  WO Misc Fixed Overhead Fixed Overhead adjustment in program JCCA, Work Order Cost Adjustment. The amount of the adjustment is posted.

WOMLB  WO Misc Labor Labor adjustment in program JCCA, Work Order Cost Adjustment. The amount of the adjustment is posted.

WOMMT  WO Misc Material Material adjustment in program JCCA, Work Order Cost Adjustment. The amount of the adjustment is posted.

WOMSV  WO Misc Service Service adjustment in program JCCA, Work Order Cost Adjustment. The amount of the adjustment is posted.

WOMTC  WO Misc Total Cost Total cost adjustment in program JCCA, Work Order Cost Adjustment. The amount of the adjustment is posted.

WOMVO  WO Misc Variable Overhead Variable Overhead adjustment in program JCCA, Work Order Cost Adjustment. The amount of the adjustment is posted.

Manufacturing Post Types and Parameter Items

When entering manufacturing posting templates in program GPTM, Posting Template Maintenance, if the credit and debit accounts are the same, postings will not be created for transactions meeting that template's criteria.

INVEN, INVE2, INMAT, INLAB, INSER, INFOV, INVOV, I2MAT, I2LAB, I2SER, I2FOV, I2VOV - These posting types are taken from the item_trans_log table activity, also known as perpetual inventory transactions.

SCRAP, LABOR, FIXOV, VAROV - These posting types are taken from the labor_detail table activity, also known as perpetual labor transactions.

POWIP - This posting type is taken from the updates of purchase order received cost in the work_matl_cost table. This information comes from material or service purchase order receipts.

NSMAT - This posting type is taken from the update of the receiving detail for non-stocked items only.