Scrolling debtor records errors "The value property .....'MinValue' and MaxValue' ....'

Problem

Loading a debtor record and using scroll arrows to go to the previous or next record errors - 7.00.157 only.

Solution

^{The issue is caused by negative values for "Terms Days" in debtor classifications. This is not possible through the Jiwa 7 interface, but was in 6.5.13 and earlier.} 
Unsupported text
^{To correct the error run the following update script:} 
Unsupported text
^{UPDATE DB_Classification SET TermsDays = 0 WHERE TermsDays < 0 
GO 
UPDATE DB_Main SET TermsDays = 0 WHERE TermsDays < 0 
GO} 
Unsupported text
^{The issue has been addressed in 7.00.175 and higher.}

Related articles