Us Customer check file

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,