/
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
Inventory reports have been re-formatted for readability
Inventory reports have been re-formatted for readability
More like this
SOINF082 - Sales Listing Report
SOINF082 - Sales Listing Report
More like this
Bank Feeds
Bank Feeds
More like this
Purchase Order Workflows and Statuses
Purchase Order Workflows and Statuses
More like this
Jiwa 7.02.01.00
Jiwa 7.02.01.00
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
Read with this