/
Invalid filters in the Region Maintenance form - 7.02.00 and prior
Invalid filters in the Region Maintenance form - 7.02.00 and prior
- Beth Blok (Unlicensed)
Owned by Beth Blok (Unlicensed)
Last updated: Nov 25, 2019Version comment
Problem
Loading this form can report an error in version prior to 7.02.01
Solution
SQL skills are required
A working knowledge of SQL Management Studio is required to complete this task
Apply the following SQL script to correct invalid filters.
DELETE FROM SY_Filters WHERE (Name = 'Active Debtors' OR Name = 'Inactive Debtors') AND FilterNo = 4000
Related articles
, multiple selections available,
Related content
Invalid inventory search filters for Category 3 and Category 4 corrected
Invalid inventory search filters for Category 3 and Category 4 corrected
More like this
Debtor Sales tab errors where the General Ledger periods are non standard 'Object reference not set ...' 7.00.175
Debtor Sales tab errors where the General Ledger periods are non standard 'Object reference not set ...' 7.00.175
More like this
Debtor Address Labels does not filter by Postcode
Debtor Address Labels does not filter by Postcode
More like this
Adding new filters to search windows
Adding new filters to search windows
More like this
SOMGT051 - Sales with COGS by Debtor does not filter by Branch
SOMGT051 - Sales with COGS by Debtor does not filter by Branch
More like this
Loading a purchase order errors for one user only - 'multi-part indentifer could not be found'
Loading a purchase order errors for one user only - 'multi-part indentifer could not be found'
More like this