Loading Creditor Transaction batches may error with "Conversion from string %s to type decimal is not valid"

Owned by Beth Blok (Unlicensed)
Last updated: Mar 07, 2019
1 min read

Problem

Loading Creditor Purchases can error with this message "Conversion from string %s to type decimal is not valid".  Applies to 7.02.00.00 and 7.01.00.00

Solution

If the creditor transaction batch number of a saved batch contains non-numeric characters then this error will occur.

It is caused by the attempt to check if the Invoice number of any lines on the batch has already been used for the creditor. If there are, then the attempt to convert the batch number to decimal to display the message to the user causes the error.

Work-around is to turn off the system setting "WarnOfDuplicateInvoiceNumbers" under the Creditor tab of System Configuration until the relevant version and service pack is installed. 

This has been corrected in Service Release 2 for 7.02.00.00.