Hello all,
I have been working on ACH export scenario. And I am not able to setup the file name in the format as:
ACH_MMDDYYYYHHMMSS.txt
The current format:
=Format( 'ACH{0:MMddYYYY}-{1:00}.txt', [Document.TranDate], [Document.BatchNbr] )
Solved
Modify ACH File Name
Best answer by DipakNilkanth
Hi
Try the formula below:
=Format('ACH_{0:MMddyyyyHHmmss}.txt', [Document.TranDate])
I haven’t verified it, but I believe it should work.
+13Hi
Have you gone through This link?
Hope, it helps!
Dipak Nilkanth || MVP @2025 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
Hi
Have you gone through This link?
Hope, it helps!
yes i already went thru this. But how to add the HHMMSS part as per my format?
+13Hi
Try the formula below:
=Format('ACH_{0:MMddyyyyHHmmss}.txt', [Document.TranDate])
I haven’t verified it, but I believe it should work.
Dipak Nilkanth || MVP @2025 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
Hey
=Format('ACH_{0:MMddyyyyHHmmss}.txt', Now())
This will work.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.