CRTRN011 and CRTRN012 reports for creditor sourced transactions are reporting incorrectly

Owned by Beth Blok (Unlicensed)
Aug 04, 2022
1 min read

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