Details:
We’re using Advanced Manufacturing with WIP and Routing and Standard Costing enabled.
For a purchased inventory item, we have Material and Landed cost categories. Upon PO receipt, the GL impact behaves as expected:
- Dr. Raw Materials Inventory (Material amount)
- Dr. Raw Materials Inventory (Landed cost amount)
- Cr. Landed Cost Absorption
This part is working well.
Where I’m stuck is the GL impact at Work Order Completion for an assembly item.
We’re using three cost categories: Material, Labor (in routing), and Overhead (on BOM). Currently, when a work order is completed, the system posts:
- Dr. Finished Goods Inventory (Total standard cost)
- Cr. Raw Materials Inventory (Component usage)
- Cr. Labor Absorption (Actual time x rate)
- Cr. Overhead Absorption (Actual usage)
But I’d like to change the behavior to this:
- Dr. Finished Goods Inventory = Total standard cost
- Cr. Raw Materials Inventory = Actual material used
- Cr. Labor Absorption = !!! Standard labor cost !!!
- Cr. Overhead Absorption = !!! Standard overhead cost !!!
- Dr./Cr. Variance accounts = Capture difference between standard and actual (especially for labor)
I have an inventory item that has Material and Landed Cost categories associated. When I receive the item from a PO:
Here’s an example scenario:
- Labor expected: 10 min @ $1/min = $10 (set in cost reval and routing)
- Actual time: 15 min @ $1/min = $15
Current GL Impact:
- Dr. Finished Goods Inventory - $100
- Dr. WIP Inventory - $80
- Cr. Raw Materials Inventory - $80
- Dr. WIP Inventory - $15
- Cr. Labor Absorption - $15
- Dr. WIP Inventory - $10
- Cr. Overhead Absorption - $10
This leaves a $5 debit left hanging about in WIP Inventory!!!
- Dr. Finished Goods Inventory - $100
- Cr. Raw Materials Inventory - $80
- Cr. Labor Absorption - $10
- Cr. Overhead Absorption - $10
- Cr. Labor Variance - $5
- Dr. COGS (or WIP Variance) - $5
Questions:
- Could my problem stem from how I’ve assigned accounts on the Item > Accounting tab? For example, should I be using the Labor Absorption account there, or does that need to come from the Cost Category or Manufacturing Charge Item setup? I do not have any other accounts selected besides my expense account for manufacturing charge items.
- What is up with the Debit left hanging out in WIP inventory??
- What’s the correct way to ensure NetSuite applies standard costing to absorption accounts and sends actual-vs-standard deltas to variance accounts? Do I need to adjust manufacturing cost templates, routings, item records, or accounting preferences? What am I overlooking!
Appreciate any guidance from anyone who's worked through this before. Thanks a million!