Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
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!