Piggybacking off of a thread I started the other day (Shipping Charges Not Carrying from IF to Invoice — Oracle NetSuite Support Community), I am curious what NetSuite's best practice is for these types of situations where an order will be partially fulfilled multiple times and thus invoiced/billed multiple times with variable shipping costs.
In the case cited on the last thread, our Sales Order began its life cycle with no shipping charge associated with it. It began with the customer using their third-party account to cover those shipping costs.
However, on 1/25, we started using a mix of our freight for pallets (which require billing the customer for shipping) and still using their account to cover smaller packages.
We understand that even if we key in the shipping cost on the IF, it will not inherit that cost on the Invoice due to how NS treats shipping costs, but what is the best practice in these scenarios? Are we supposed to manually key in the shipping cost on every invoice that uses freight? This can be challenging with the complication of bulk invoice processing.
Is there something we can implement to address this (WF, script, etc.)? Alerting?
Would love to hear from the community on how they've handled situations like this. If we need to lump this in with the original post, please feel free to do so, mods.