Hi everyone, has anyone faced a situation where different COGS accounts need to be assigned to the same inventory item based on different business types within the same subsidiary? Looking for advice or alternative solutions.
Scenario:
We’re using the same inventory item across both our Construction and Repair businesses, operating under the same subsidiary. However, each business type requires different accounting treatment for item fulfillment.
Background:
- For Construction, we’re using Item Fulfillment (instead of Work Order Issuance) to issue inventory, as Work Order Issuance only allows one cost code per issue, which doesn’t meet our need to split costs across multiple codes.
- We use a custom segment for Cost Code assignment.
Example – Construction (via Item Fulfillment):
Dr. WIP - Cost Code: Raw Materials
Dr. WIP - Cost Code: Machinery
Cr. Inventory
Thus, the inventory item’s COGS account is expected to be a WIP account.
Example – Repair (via Item Fulfillment):
Dr. COS - Cost Code: Raw Materials
Dr. COS - Cost Code: Machinery
Cr. Inventory
Here, the same item should instead post to a COS account.
The challenge is that NetSuite only allows one COGS account setup per item, which creates a conflict:
Options we've considered so far:
- Create two separate inventory items:
ItemA_ConstructionItemA_Repair
➤ Problem: Difficult to manage quantity and visibility within the same subsidiary. Also complicates intercompany transactions if other subsidiaries share the same item.
- Use Work Orders for Construction:
Since only one cost code can be assigned per Work Order Issuance, we’d be forced to create separate issuances for each item usage, which is inefficient
➤ Problem: Requires significant manual effort and creates a high volume of transactions, which we’d like to avoid.
Question:
Has anyone successfully handled a similar case? Is there a more efficient or automated way to achieve this—where the same item can post to different COGS accounts based on business type or cost code segment?
Would love to hear any insights, tips, or best practices. Thanks in advance!