get some bank details to acumatica report

  • 22 May 2023
  • 0 replies

Userlevel 3

Hi, this is a report modification. I need to get below bank details of DetailValue column to my ARInvoice. These information are taken from CashaccountPaymentMethodDetail DAC.

For a particular CashAccountID, Detail Value is changed based on DetailID from 4545 to 4549 as above.

ex: if DetailID=4545, Bank Name

      if DetailId=4546,  Account number….

And also it depends on the PaymentMethodID as well. If I made an expression to retrieve DetailValue Based on DetailID,  It only retrieves the first value which is the Bank Name. I need to get the DetailValue per each DetailID from 4545 to 4549. Can someone help me with a solution to do this?

Thank you.


0 replies

Be the first to reply!


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 — 2023  Acumatica, Inc. All rights reserved