Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
Using NetSuite "locations" for returns whacks COGS!
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!