Solved

Configuring NACHA File

  • 13 July 2023
  • 1 reply
  • 222 views
D
Rank
Userlevel 1

Is there a way to configure the scenario we use for “Export AP Payment to ACH” to not use

=Left(Provider.Coalesce([APPaymentList.ExtRefNbr],[APPaymentList.RefNbr]),10)

But to instead use the [APInvoice.InvoiceNbr] field?

 

There is another question about this in the community:

but it has never been answered.

 

Is there a way to join to the APInvoice table in order to bring this field into the ACH export file?

icon

Best answer by aaghaei 14 July 2023, 07:51

View original

1 reply

aaghaei
Rank
Userlevel 7
Badge +9

It doesn’t make sense to have the APInvoice # because any Payment may account for multiple AP Invoices. Unless Acumatica develops a logic allowing ONLY one invoice per payment, the request technically does not have logical/technical ground.

Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved