Skip to main content
Solved

How to Join AR Invoice and AR Tax Tran


Hi Everyone,

 

I am trying to create a GI for YTD Sales vs PY YTD Sales and need the tax value in another column. I found out that ARTaxTran would be the right table to use but I am not able to join it with the ARInvoice. Any help on how to add a relation between these two would be appreciated. Thank you!

Best answer by dcomerford

ARTaxTran is a projection of TaxTran and you can join this to ARInvoice below

 

View original
Did this topic help you find an answer to your question?

3 replies

dcomerford
Captain I
Forum|alt.badge.img+15
  • Captain I
  • 596 replies
  • Answer
  • August 26, 2024

ARTaxTran is a projection of TaxTran and you can join this to ARInvoice below

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • August 26, 2024

@rjasani64  Additionally, you can add one more condition i.e.

ARTaxTran.Module = ‘AR’

 


  • Author
  • Freshman I
  • 7 replies
  • August 27, 2024

Thank you @dcomerford and @Naveen Boga for your help!


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