Hi guys,
My company is trying to implement inventory management on NetSuite using the item field. We don't have any difficult requirements. We basically want to start issuing PO's and match the bills to the right PO once we receive the bills. We order items in different countries/subsidiaries but there is only one location per country and one subsidiary per country. We do some intercompany transfers every now and then, but except for that is should not be too complex.
From what I tested it looks like NetSuite does not populate a transfer price by itself, it doesn't look like we have great options besides updating transfer price manually (maybe having a fixed price for each year). Is this so? We work with multiple vendors and prices might change for the same item (of course).
I tested different scenarios and NetSuite records the fields ''last purchase price'' and ''average cost'' properly but once you process a transfer order or sales order the system only fetches a specific amount if the ''transfer price field'' is populated. Even if we would have a workflow that would automatically consider the ''average cost'' as the right cost to use it, the logic would be faulty.
For example, using FIFO:
I bought 10 qty at 40 eur per item, I sold 5 of those. So I kept 5 qty at 40 eur.
I bought 10 qty at 30 eur per item, so NS shows me that my average cost of my 15qty is 33.33eur, which is correct.
The issue is if we would make the transfer pricing to copy the ''average cost'' and sell 5 qty then it would take 33.33 as cost instead of the correct one that based on FIFO would be 40.
I still don't understand why NS would give the option of having different cost methods if it doesn't do anything with it, unless I am missing something. Does anyone have an idea whether I missed something?
Regards,
Manuel