Payment Voucher Report error when joining Aptran and Apadjust Table

  • 11 January 2023
  • 0 replies

Userlevel 3


I have to  get Account Id ,Transaction Description from APTran Table  and adjusted amount from ApAdjust Table for my Payment Voucher Report.

I need to join ApPayment Table , APAdjust Table and ApTran Table.

1st I joined ApPayment Table(column - RefNbr) and ApAdjust Table(column-AdjgRefNbr) below like that.


Then I joined ApAdjust Table(column - AdjdRefNbr) and ApTran (column-RefNbr)Table below like that.

But,After adding 2nd join report designer show below error.

 If we remove the second join error is gone. Can you give the solution for this issue.


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