Skip to main content
Answer

How to Join AR Invoice and AR Tax Tran

  • August 26, 2024
  • 3 replies
  • 102 views
R
Freshman I
Forum|alt.badge.img

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

 

3 replies

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

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

 

Dermot Comerford
Naveen Boga
Chris Hackett
Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Naveen Boga
  • Captain II
  • August 26, 2024

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

ARTaxTran.Module = ‘AR’

 

Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Chris Hackett
R
R
Freshman I
Forum|alt.badge.img
  • rjasani64
  • Author
  • Freshman I
  • August 27, 2024

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

Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved