According to the current behavior of the IFS system, when creating a payment proposal using the ACH payment method that includes both debit and credit invoices for the same supplier across two companies, the system does not consolidate the amounts into a single total for that supplier. This behavior is observed when the debit and credit invoices belong to separate companies.
Due to the discrepancies between the Calculated Total and the Batch Total in the ACH file, the ACH file validator has rejected the file as incorrect.
Above issue has been demonstrating by using an example below.
- Create/select manual supplier invoices as per below combination.
| Core Company | Core Supplier | Inv Type (Credit/Debit) |
| 10 | 095210 | Man. supplier Invoice ($ 1000.00) |
| 10 | 095201 | Man. Supplier Invoice with negative amounts (Debit Note) ($ -200.00) |
| 15 | 095201 | Man. supplier Invoice ($ -100.00) |
| 15 | 095201 | Man. Supplier Invoice with negative amounts (Debit Note) ($ 1000.00) |
Add them to the new supplier proposal created in the demo company.
-Image 01-
-Image 02-
- Acknowledge the proposal and crate new payment order.
- Create payment order.
- View the created ACH file.
When analyzing the generated ACH file, we noticed that it did not sum up the total amount that needed to be paid to the supplier when the company is differ, but summed up the total credit and debit amounts ($-100 + $1000= $900) when the supplier and the company were same. (15 Company)
However, in the image 03, the value highlighted in yellow needs to be summed up with the green-highlighted amount, Because both amounts apply to the same supplier (095201), regardless of the company. (As per the image 02) However, the current behavior of the IFS system does not perform this summation.
-Image 03-
ACH file is being rejected during the validation process due to a mismatch between the Calculated Total of the proposal and the Batch Total. Please refer the image 04 and image 05 below.
- Calculated Total: The sum of all transactions, irrespective of sign (e.g., $900 + $1000 + $200 = $2100).
- Batch Total: Calculated with signs considered, as $900 - $200 + $1000 = $1700 (highlighted in purple in image 03). This is the correct total value of the ACH file.
-Image 04-
-Image 05-
Further when validating the ACH File which included the Addenda records, same as previous file, it has been rejected due to batch total is not same to the calculated total. The negative-signed value is still being considered a positive value in calculated total. Including the addenda records did not resolve this issue.
