Processing Automated Clearing House Payments
Effective Date of an ACH transaction
|
paula Administrator Posts: 208
2/18/2016
|
paulaAdministrator Posts: 208
The ACHEfctvdate is a formula on line 12 of the Header tab in the ACH Sample file. If you would like to use a value passed from Sage, assign a different variable in the raw data of the PrintBoss Form and replace our ACHEfctvDate with your variable. You will also need to reformat the date as the slashes are not allowed. The format must be YYMMDD.
|
|
|
0
link
|
|
email submissions Administrator Posts: 173
2/18/2016
|
Greetings, and happy Monday 
Again, working with our mutual client, and they have a question regarding the effective date of an ACH transaction. In the Sage 300 Payment Entry screen, they specified a Payment Date of 3/1/2016 (for example). When they generate the ACH file, the effective date of the transaction is 160202 (February 2nd, 2016).
As you can see from the screenshot below, the payment date shows 3/1/2016, yet you can also see from the attached ACH file that the effective date is 160202.
How can I change the ACH Effective Date to be the payment date? I have attempted to modify the ACH file by changing the ACHEfctvDate value in the Header tab to be DocDate, but that didn’t seem to resolve the issue. Any assistance you can provide is greatly appreciated!
Regards,
|
|
|
0
link
|