Folks,
I believe I have identified a workflow that results in a relatively major violation of fundamental accounting principles.
Let's assume we have a widget, and we generally drop-ship it. Drop-shipments don't post to our inventory asset account or GOGS when they're fulfilled, so the G/L impact of the item fulfillment is zero.
As a consequence, NetSuite's concept of this item's average cost is undefined. There's an empty space in the average cost column of the inventory tab of the item record.
Customers are customers, ... every once in awhile they return something. We use NetSuite's RMA workflow religiously, generating the return authorization from the original sales order, receiving it into inventory, issuing a credit memo and then eventually a refund to the customer.
UNFORTUNATELY, while the return authorization process restocks this serialized inventory item, it assigns zero cost/value to it. The item receipt record of the return authorization has zero G/L impact.
***HERE'S THE PUNCHLINE***
Unless I'm missing something, I've just received an item into inventory without increasing the value of my inventory, or increasing my cost of sales!
***HERE'S THE PUNCHLINE***
It gets worse. We recondition and re-sell these returned items. When they get sold, because of the zero cost they're recorded as 100% profitable. We compensate our sales reps as a percentage of profit ... so they get commission on 100% of the sale amount, instead of profit.
As far as I can tell, there are two ways one could allocate cost/value to this returned item:
1. Pull the amounts from the originating transactions. In the case of a normal shipment it would be found in the item fulfillment record. HOWEVER, in the case of a drop-shipped item it would be found in the bill of the originating PO (I think).
2. Use the amount on the return authorization as the cost. This is the amount you will be refunding the customer in return for receiving the item back, so it could be argued that this is the new cost/value of this item.
As far as I can tell, NetSuite does neither, instead silently allocating zero cost to the item, restocking it but giving it zero value/cost.
Am I missing something?
-Darren