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.
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