Skip to main content
Question

Payment Voucher Report error when joining Aptran and Apadjust Table


Forum|alt.badge.img

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

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings