Problem
Running the report REINF010 - Receival Slips Uninvoiced is incorrectly including reversed and reversal GRN's.
Solution
Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.
SQL skills are required
A sound knowledge of SQL is required to complete this task.
A modified report and stored procedure is attached to the article to that excludes reversals from the report. This correction has been included in 7.01.00 and higher
Download and save the attached stored procedure and report and then
- Run the SQL script over the relevant database
- Run stored procedure Grant_All_User_Tables
- Login to the database
- System Settings > Report Configuration > Reports
- Click Refresh from Files
- Select the report to be imported and OK
- Message displays to indicate report has been successfully updated
NOTE: If you get the error 'Database vendor error code 229 ...' when running the report, then step 2 has been missed.
Related articles