Centrepay Receipt Import - Fails if Line Amount =>$1,000
If a PYI520 line is for =>$1,000 the import fails with the error: "A centre link pay line must be 10 columns"
The import is treating the "," contained in the amount ($1,000) as a new column.
Temporary workaround is for users to edit the CSV file in notepad and remove the ","'s from those amounts.
The amount is contained within quotation marks. If an amount is contained in quotation marks it should ignore any commas.
Example:
PYI520,SMITH JOHN,104326,"$1,057.80","$1,056.81",23-Feb-23,GCH,111111111X,$0.99,030A2933
2
votes
AdminRussell Budgeon
(Product Owner, MRI Software)
shared this idea