Folks,
We initially struggled with how to handle customer returns in NetSuite. We eventually settled on using two additional locations for returned items, in addition to our main location, as follows:
- Open Box
- Damaged
When a customer returns a perfectly fine widget, we issue a credit memo with the location at the line-item level being "Open Box". We eventually fulfill this item from the same location (at a cheap price) to some lucky customer, and so ideally the # of items in the Open Box warehouse is usually zero.
The only problem is that the COGS of all these credit memos is wrong! In fact, Netsuite has created a whole whack of credit memos into (and fulfillments out of) the Open Box warehouse that have no G/L impact on either Cost of Sales or Inventory. Those lines are just missing!
As this has been explained to me, this is occurring because NetSuite has computed a cost of sales of exactly $0 for this item in the "Open Box" location. More accurately I guess, it has not computed a cost of sales for that item in that location. There is no data on cost for that particular location because we never purchased inventory into that location. And we won't either, since that location is just a box in the middle of our room that contains returned items that we hope to sell.
Just to be clear, there is no item receipt record from any purchase from any vendor into that warehouse, EVER. We have plenty of purchases and item receipts into our main warehouse, and in that warehouse NetSuite knows all about last cost, and current cost (we use FIFO), and all the credit memos and fulfillments from that location are correctly assigning COGS.
I should note that this is only a problem with non-serialized inventory items. Serialized items use a 'specific' cost I think, and they get the cost right no matter what location the item is in because the cost is tied to the actual price paid for that item (at least I assume it is).
This feels like a bug to me. I mean NetSuite should try to work quite hard to get a realistic estimate of Cost of Sales, and if it fails and comes up with zero due to lack of data you might think it could warn you. Our staff have now created literally thousands of transactions that are incorrect, and our inventory profitability reports on items that we see a lot of returns on are BADLY wrong. If you ask me, this is a major argument against using locations for handling returns and/or defective products, especially because I don't see any way to fix the current bogus transactions, or to prevent this from happening again to all new credit memos.
-Darren