I have just started doing imports for cash batches which I am really liking! I am finding a very odd issue though in that the Payment Method field seems to be ignoring the first record and importing the data from the next record instead. For instance, the first record has a Payment Method of Cash and the second record has a Payment Method of cheque, the batch will import with the first record having a payment method of cheque and other records will be off by one importing the next records data and then the last record has a blank Payment Method. I have checked all other fields and they are importing correctly, it is just Payment Method that is doing this.

Hello Sage,

It can be difficult to troubleshoot imports over the Forum. Perhaps a conversation with your Adagio Consultant might be the fastest way to figure out what is going on.

Or, you can post a printout of your import template format and the file you are trying to import, remembering that this is a public Forum.

This is what the test CSV looks like:

Transaction Date Customer Number Description 1 Payment Method Cheque Number Transaction Type Amount
20160510 3900 Test batch, record 1 CC 5771 CA 100
20160510 1605 Test batch, record 2 Cheque 5780 CA 200
20160510 1694 Test batch, record 3 Debit 5781 CA 300
20160510 1873 Test batch, record 4 Online 5782 CA 400

It will import correctly except that record 1 will have Cheque as the Payment Method, record 2 will have Debit, record 3 will have Online and the record 4 Payment Method will be blank.

Hi Sage,

This "CSV file" has only one comma. As I said, you'll need to zip the printout of the import template you are using and the actual data file you are trying to import.

Sorry.

Hi Sage,

I did a quick test on sample data and having different payment methods on each of the 4 cash entries. In the specific case where the H-Payment Method field was listed before the H-Check Number field in the import template field list, I could replicate the problem you ran into. I'm guessing from your file layout that the check numbers are 5771, 5780, 5781 and 5782.

If I move the H-Payment Method field to a place after the H-Check Number, then the import is successful.

If it is possible to create your import CSV file with the payment method after the check number, that will solve the problem, at least as a workaround for now.

Ah, perfect, tested and got the same result. Thanks so much for testing that and finding the work around. Appreciate your help.

This import issue has been fixed in the AR 92A (161013) SP.