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.
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.
Thanks