Dear All,
Appreciate it if anyone could explain the ‘Customer check’ external file upload template. i.e. which records are needed to upload as per the template?
Hello
Do you still need an explanation? If so please drop a message here then i can help you with this.
Regards
Hi,
The data would be the amount of a payment (check amount), Amount to be applied (matched) with an invoice, invoice number and check number.
Example
300, 100, invoice 1234, 444 as the check number
300,200, 1235, 444
Two records for 1 check as in this example the 300 check number 444 paid two invoices.
If paying one invoice the record would look like the below.
500, 500, 1236, 555.
The group by function groups the payment transactions for the same check number.
The payment amount (300) in the first example may / may not need to be duplicated in the multiple records for the same check number. Depending on patch level and release level, I’ve seen examples where you need the 300 on the two records for the same check, but then I’ve also seen IFS total the 300 from record 1 and 300 from record 2 as 600 when the check amount was only 300. Based on your version you will need to test.
Best regards,
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.