Requirement
When a Sales Order generates multiple invoices due to split shipments, the freight charge should only be applied to the first invoice created from the Sales Order.
Current Issue
The freight charge is currently being carried across to every invoice generated from the Sales Order. In addition, the invoice balance calculation is including freight on all invoices, resulting in duplicate freight charges being displayed and charged to customers.
Expected Behaviour
- The freight charge should be displayed only on the first invoice generated from the Sales Order.
- The freight amount should be included in the balance calculation of the first invoice only.
- Any subsequent invoices generated from the same Sales Order should not display the freight line item and should not include freight in their balance calculations.
This will ensure customers are charged the freight amount only once, regardless of how many invoices are generated from a single Sales Order.
I have attached the report.
