/
EX GST Total is not always correct in the standard invoice report - 7.02.01

EX GST Total is not always correct in the standard invoice report - 7.02.01

Owned by Beth Blok (Unlicensed)
Nov 07, 2019
1 min read

Problem

The EX GST total in the standard invoice report may vary by a cent or two from the value in the sales order form.  The Inc GST Total in the report is correct.

   

Solution

SQL skills are required

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

Download and apply the attached stored procedure to the database.

Related articles

 

 

 

Related content

Printing delivery notes in a purchase order report
Printing delivery notes in a purchase order report
Jiwa 7
Read with this
Freight is incorrectly included in the total for invoices for snapshots > 1 in version 7.01.00
Freight is incorrectly included in the total for invoices for snapshots > 1 in version 7.01.00
Jiwa 7
More like this
CRMGT040 - Creditors Listing - Transaction Due Date Report - V 7.00.175.00 SR13, V 7.02.01 SR4
CRMGT040 - Creditors Listing - Transaction Due Date Report - V 7.00.175.00 SR13, V 7.02.01 SR4
Jiwa 7
Read with this
CRTRN011 and CRTRN012 reports for creditor sourced transactions are reporting incorrectly
CRTRN011 and CRTRN012 reports for creditor sourced transactions are reporting incorrectly
Jiwa 7
More like this
Changing the status of a purchase order to Closed when all lines are received/booked in
Changing the status of a purchase order to Closed when all lines are received/booked in
Jiwa 7
Read with this
Standard invoice lists all the serial numbers invoiced rather then the serial number applicable to the delivery - D02 and higher
Standard invoice lists all the serial numbers invoiced rather then the serial number applicable to the delivery - D02 and higher
Jiwa 7
More like this