CRMGT040 - Creditors Listing - Transaction Due Date Report - V 7.00.175.00 SR13, V 7.02.01 SR4

Owned by Monica Holliday
Last updated: Nov 21, 2022 by Mike SheenVersion comment
1 min read

Problem

Report does not include invoices with as at date included selected. You have to set the selected date to one day after the due date in order for the invoice to appear on the report.

Solution

SQL skills are required

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



Download and save the attached stored procedure.

  • Run the SQL script over the relevant database.


  • Version 7.00.175.00 SR13

  • Execute GRANT_ALL_USER_TABLES



  • Version 7.02.00 and higher

  • Execute usp_Jiwa_Grant_Application_Permissions 'jiwauser'

  • Execute usp_Jiwa_Grant_Reporting_Permissions 'jiwareports'

All versions

  • Import the updated report into the database using Refresh from Files from System Settings > Report Configuration > Reports



  

https://jiwa.atlassian.net/browse/DEV-8728