Bill Complete invoices repeat lines for every snapshot rather than consolidating on the last snapshot - 7.02.00.00 and 7.02.01.00

Owned by Beth Blok (Unlicensed)
Last updated: Jul 26, 2019
1 min read

Problem

Where a sales order with the Billing Type of Bill Complete has multiple snapshots, printing the last snapshot duplicates lines rather than consolidating previous deliveries

Solution

SQL skills required

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

Download and apply the attached stored procedure to correct the invoice.