REINF010 - Receival Slips Uninvoiced report is including reversals - 7.00.175 and earlier
- Beth Blok (Unlicensed)
- Mike Sheen
Problem
Running the report REINF010 - Receival Slips Uninvoiced is incorrectly including reversed and reversal GRN's.
Solution
DEV-5192: REINF010 - Receival Slips Uninvoiced includes Reversal & Reversal GRN'sPassed Testing
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