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