REINF010 - Receival Slips Uninvoiced report is including reversals - 7.00.175 and earlier

Owned by Beth Blok (Unlicensed)
Last updated: Nov 21, 2022 by Mike SheenVersion comment
2 min read

Problem

Running the report REINF010 - Receival Slips Uninvoiced is incorrectly including reversed and reversal GRN's. 

Solution

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

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


  1. Run the SQL script over the relevant database

  2. Run stored procedure Grant_All_User_Tables

  3. Login to the database

  4. System Settings > Report Configuration > Reports

  5. Click Refresh from Files

  6. Select the report to be imported and OK

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