Freight cost not showing in order profitabilty figures
On profitabilty reports e.g. Daily Sales Profitability AR676000, the freight cost of the order is not included in the overall cost of the order, affecting the profitability. Why is this? Is it possible to change in the settings? Or am I just looking at the wrong report?
The freight cost item in the invoice is SOFreightDetail CuryFreightCost
E.g.: if order size is $100, product cost $60, freight cost $20, the reports are saying profitability is $40 when it should be $20...
That report pulls the cost from the Unit Cost on the Invoice Lines. The Invoice Lines have a "Billed Freight" concept, not a "Freight Cost" concept. As you point out, you'd have to get the cost from SOFreightDetail, but I'm not sure how you'd add that to the report cleanly, especially since the Freight Cost doesn't hit the General Ledger so you wouldn't be able to tie-out the report to the General Ledger.
What about a GI that you could pull the ARTrans and ARInvoice info together to aggregate the line revenue and costs and pull the invoice freight cost and price (also premium freight if used) and give you the overall profitability for the invoice? I did something similar for a client who needed this at the invoice level. What you will not see on something like this is the profitability by line since the freight is on the order and not being distributed by line.
Ok thanks for this, I'll give it a shot.