Hi,
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.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/c12f2922-4a7f-4384-baa2-3775aec2f3e7.png)
Then I joined ApAdjust Table(column - AdjdRefNbr) and ApTran (column-RefNbr)Table below like that.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/f181d982-6920-4445-bc8f-7c7d50838d79.png)
But,After adding 2nd join report designer show below error.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/72476578-8d2a-4b4e-9e08-6c1901fdd30f.png)
If we remove the second join error is gone. Can you give the solution for this issue.
Thanks