Skip to end of metadata
Go to start of metadata

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

SQL skills are required

A sound knowledge of SQL 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'


usp_JIWA_Creditors_CreditorTransactionsByDueDate.sql

DEV-8728 - Getting issue details... STATUS