Hi all -
My company is moving toward a multi-store, single-shopping-cart scenario soon (Magento for eComm), and ideally we want to track revenue and expense differently for the different stores (they'd be tracked as Sales Channels in NetSuite, which is what we have renamed the "department" segment). I'm able to track the Magento Store ID via Celigo at the line level no problem so that we can report / account the product revenue properly, however we are hung up on the shipping.
Has anyone tackled this before? Obviously the shipping cost field on a NS sales order gets the main/header-level GL classifications, but we would want to split it ideally. Furthermore, the allocation of revenue in a multi-store order would ideally be by weight, I'd think, to match up best later on with the expense side.
I'm wondering if I'm missing anything in native NetSuite before I start looking for 3rd-party solutions, or begin architecting something myself w/ Suitescript. I wonder if a custom GL plugin might be the way to go? I don't have much experience there. I took a look at the "enable line-item shipping" checkbox feature on sales orders, but that doesn't seem to include a field for shipping cost at the line level. It looks like it groups by ship-to location on the "shipment" subtab, so I suppose I could fudge that by making two "ship-to" addresses that are the same but different based on sales channel - that seems like a hack, however.
I'd love any insight anyone has on a problem like this - and if there is a 3rd party solution you've seen in the past that has worked, I'd love to hear that as well.
Thanks in advance!
Alex