Compared the data line by line. You find the sales order (SO) analysis and the SO acknowledgment totals are correct, however, with one of the products we have multiple pricings, which throws out the crystal report and only pull through the highest price.
When checking on a line by line basis it appeared that the totals were wrong when in fact it was the line report sales price that was incorrectly pulled through.
To complete a sales order analysis:
Click Sales then click Sales Order Maintenance.
Click Enter then select the relevant sales order and press F5.
Click Analysis then click Details.