Hi NS Community!
My company does something a bit unique, (at least i think it is) and I'm not sure if the way we handle it in NetSuite is the correct way. Let me explain...
We sell "products" on behalf of our partners for a 10% commission. We also pay about a 10% fee in order to "ship" the products. The inventory is not owned by us. At the time of sale, we "purchase" the inventory from the partner (which we have tracked in a "partner warehouse"). It hits our "owned" inventory for a brief period of time, before it is transferred to the customer.
The commission and fees are taken directly from the price of the product sale. For example, if we sold the product at $100, $10 goes to us and $10 goes to fees. In turn, the Cost of Goods sold in this case is $80. The price of the products changes from sales order to sales order based on volume and other factors. For example, this same product could be sold at $80, making the COGs $64. This in turn makes the COGs of this inventory item dynamic.
To deal with this in NS, our transactions team is having to manually calculate COGs based on the sale price and commission then make a new inventory item for each sale since NetSuite Inventory items can only have one cost. As you can imagine, this makes things a little cumbersome and hard to track. It results in lots of "copies" of the same inventory item, just with a different COGs.
Has anyone run into this before? Do you have any suggestions on how to deal with this? Is it possible to have an item with a dynamic COGs based on a formula and sales order prices?
Thanks in advance!