/
CRTRN011 and CRTRN012 reports for creditor sourced transactions are reporting incorrectly
CRTRN011 and CRTRN012 reports for creditor sourced transactions are reporting incorrectly
Problem
Reports CRTRN011 - Creditor Purchases and Shipments and CRTRN012 - Creditor Purchases and Shipments by Supplier are reporting the Inc GST amounts as Ex GST Amounts for creditor sourced transactions
Solution
SQL skills are required
A working knowledge of SQL Management Studio is required to complete this task.
Download and apply the attached SQL script to update the stored procedure to the relevant database(s). Please note that permissions need to be applied after running this script.
usp_Jiwa_Grant_Application_Permissions 'jiwauser'
GO
usp_Jiwa_Grant_Reporting_Permissions 'jiwareports'
GO
Related articles
, multiple selections available,
Related content
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
Read with this
DBTRN010 - Debtor Transactions Report - 7.00.175, 7.02.00 and 7.02.01
DBTRN010 - Debtor Transactions Report - 7.00.175, 7.02.00 and 7.02.01
More like this
Solutions in addition to the Service Releases
Solutions in addition to the Service Releases
Read with 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
More like this
CRTRN050 - Outstanding Creditor Invoices includes creditor purchases - 7.02.01 and prior
CRTRN050 - Outstanding Creditor Invoices includes creditor purchases - 7.02.01 and prior
More like this
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
More like this