I need a margin report (like the sales profitability report) that includes our freight/delivery costs.
Our sales prices are delivered prices and don’t include the delivery price charged to the customer.
At present, I am using a generic enquiry linked to excel, and then manually allocating the freight/delivery cost manually.
What’s the best way for me to automate this process??
I was thinking of using a custom field during the A/P entry for sales order, and then somehow linking this to a new generic enquiry.
Wanted to check that Acumatica doesn’t do something like this out of the box…..
I have attached my excel report headings...
