Each week we make ‘EFT’ (Electronic Funds Transfers) payments to our suppliers, similar to ACH in the US.
In ‘Payment Method’ the ‘File Creation No’ that is used by Epicor and put into the EFT .txt file must match the number expected by our bank when we upload the file.
A few months ago…possibly around the time we moved AP into Kinetic, this number stopped moving up properly each week.
AP Payment Process is as follows, number was 497
- AP makes a payment group for EFT
- Selects ‘Process Payments’ and changes the report style to ‘EFT Remittance’ and clicks PRINT.
- This creates the EFT .txt file for upload and emails the remittances to each supplier in the payment group, at this point the File Creation No has changed by .5 moving to 497.5. This is normal and expected based on what i know.
We upload that file that is generated to our bank (outside of Epicor) and then we post the AP group.
The FCN stays at 497.5 and does not move to 498, AP must manually adjust the number each week otherwise the EFT file will be created with an incorrect number and it will fail when we upload to the bank.
What i don’t know and can’t find, is this Epicor functionality that moves this number forward by .5, what should trigger it to move forward by another .5 to bring it to the next whole number. Or was this something we created internally, i can’t find any BPMs that would be handling this.
My guess ‘Process Payments’ moves it forward .5, then since posting the payment group is the final step, upon posting it would move it forward another .5.
