Questions Help to tie Freight Cost to Sales Orders when invoice arrives
We are selling ice cream by the truckload to wholesalers and retailers. We have the freight booked through freight brokers and know our freight cost (manual calculation for now) and want to post the freight cost in each sales order. We found the Freight Cost box on the Totals tab in the sales order and recorded the cost. The customer Freight Price is $0 as we are giving them delivered pricing. Looking in the GL we see a freight cost line once the invoice posts, and the invoice has a Ship Via line added with the amount (not ideal).
Once the freight bill comes, we need to tie the freight invoice amount back to the sales order to keep track of the quoted versus actual, and to have the overall picture of freight as an expense on each order. i cannot find how to create the tie. Can someone help walk me through this or suggest an alternate method?
I did something very similar for dropship orders (sorry I can share the GI at the moment)
The links were
SOOrder to SOOrdershipment
SOOrdershipment to POreceipt
POreceipt to APtran
APtran to APinvoice
Then from the GI add a side panel to the APInvoice passing the parameter through from the GI
This allows you to open the AP and see the freight amount and then open the SO to add in the freight