Skip to main content
Solved

Configuring NACHA File

  • 13 July 2023
  • 1 reply
  • 294 views

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

=Left(Provider.Coalesce(sAPPaymentList.ExtRefNbr],bAPPaymentList.RefNbr]),10)

But to instead use the tAPInvoice.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?

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.

Reply


Terms & ConditionsCookie settings