Is it possible to specify what location you want your COGS to go on an item fulfillment? We keep our inventory in location A, but that warehouse fulfills orders to many other locations. We’d like the inventory side of the GL impact to hit location A, but the COGS side to hit location B, C, D, etc.
s
sam1128
11/01/2023, 7:00 PM
That’s very odd requirement but can be done by custom gl script.
c
Cory Weiner
11/01/2023, 7:03 PM
If you’re selling goods from multiple locations and fulfilling them from a centralized warehouse, how else would you evaluate gross margin by location?
Cory Weiner
11/01/2023, 7:03 PM
I’m not an accounting expert by any means so I’m genuinely curious what the best way to handle that is
s
sam1128
11/01/2023, 7:10 PM
I would leave netsuite locations as it is and crate new custom segment called as store or sales channel and do it that’s way. In that’s way inventory will be depleted on location A and cogs will post to location A plus new segment.
c
Cory Weiner
11/01/2023, 7:16 PM
Interesting idea. We are hoping to create a full accurate income statement by location, so I suppose we would have to blend that custom segment with the new segment to make it work… Worth looking into. Thanks