Versions Compared

Old Version 13

changes.mady.by.user Beth Blok

Saved on

compared with

New Version 14

changes.mady.by.user Beth Blok

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

Panel
bgColor#fff
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.

...