Excel Upload for Deposits changes in Image 29
Our Excel Upload for Deposits spreadsheet process has been working for us through the last few upgrades 9.1 to 9.2.20 to 9.2.24. In Image 28 which we are currently testing with intent to go live March 4th, the AR_PAYLOAD process failed. We discovered two bugs that were fixed in Image 29 that when applied appear to change the way the Excel file needs to be populated. I have not been able to find any documentation about changes to how the Excel spreadsheet needs to be populated.
For example, in Image 24 a deposit with 4 payments would be uploaded as 4 unique Deposit IDs each with payment sequence #1. We did not populate any Item ID fields only Customer ID fields as we use Payment Predictor to make the matches and build worksheets where a match cannot be made.