Skip to main content

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!

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

 

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

ARTaxTran.Module = ‘AR’

 

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

Reply


Terms & ConditionsCookie settings
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