Hi Gurus,
Is there a way intercompany inventory sold to customers can be tracked? Ie. Subsidiary 1 sold inventory to Subsidiary 2, and then Subsidiary 2 sold the inventory to 3rd party/external customers. There will also be inventory that will remain unsold, and therefore needs to be tracked as well vis-à-vis the sold inventory. The reason for this is because the inventories are intercompany-transferred at a mark-up, and the accounting treatment (elimination) for sold and unsold inventory mark-ups will be different.
There is an enhancement in Netsuite that says this is currently a limitation (answer ID 80908) which is also why intercompany cogs account should not be marked for elimination.
One of the ways I can think of is through saved search of purchase order prices from Subsidiary 1 and subsidiary 2 for the transfer price and quantity transferred; and another saved search for the cogs/item fulfillment sold to external customers; get the difference for the unsold inventory. However, this is just estimation and not the actual inventory movements.
Appreciate any ideas/insights/experience on this, Thanks.