Hi All,
I am working on a report using Detail Sales Profitability as the template to include Freight Cost. Everything works well until I am trying to add up the total for Freight Cost. The issue I am having is that the system somehow keep adding with the same freight cost base on the amount of lines it has within the shipment. Please see below for screen shots:
From the report:
Example 1
Example 2
From Report Designer:
How would I be able to fix it so it don’t repeat adding itself within the same transaction and actually add up all the invoices within the customer?
Kind regards,
Calvin