Freight is incorrectly included in the total for invoices for snapshots > 1 in version 7.01.00

Owned by Beth Blok (Unlicensed)
Last updated: Jan 16, 2018
1 min read

Problem

The  sales order invoice reports are incorrect adding the Freight + freight GST to the total of snapshots > 1

Solution

SQL skills are required

A working knowledge of SQL Management Studio is required to complete this task

The attached SQL Script corrects the stored procedure and invoice reports using this stored procedure correctly report freight and courier charges.