Margin Report To Include Freight/Delivery Cost

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...