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

SQL skills are required

Sound SQL skills are required to complete this task

^{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.}

Jiwa 7

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

Problem

Solution

SQL skills are required

Related articles

Related content