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?
Best answer by aaghaei
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.
+10It 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
