Debtor Address Labels does not filter by Postcode

Owned by Beth Blok (Unlicensed)
Last updated: Sept 25, 2017
1 min read

Problem

Filtering the report by Post Code e.g. 6000 to 6999 ignores the filter and prints all records in the database

Solution

SQL skills are required

Sound knowledge of SQL is required to complete this task



The report was corrected in developer build 7.00.181 and is attached here for importing into 7.00.175 and 7.00.157 databases.



Download and save the attach 2 files


  1. Run the SQL script over the relevant database

  2. System Settings > Report configuration > Reports

  3. Click the ribbon icon Refresh from Files and select the downloaded report

  4. Save changes

Report will now filter by post code