Skip to main content

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

Be the first to reply!

Reply