By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Acumatica Generic Inquiries & Pivot Tables
2
Posts
2
Users
0
Reactions
4,699
Views
September 28, 2018 7:49 am
I am trying to create a GI to calculate CAT tax. I am struggling to get the ship to state into my query. Does anyone know for sure what data class it is in (I believe it's in SOShippingAddress) and how I link this up to the ARInvoice or ARTran?
1 Reply
October 8, 2018 8:34 am
Hi Kristin,
Try joining from ARTran to ARInvoice on ARTran.TranType=ARInvoice.DocType and ARTran.RefNbr=ARInvoice.RefNbr.
Then join from ARTran to SOShipment on ARTran.SOShipmentNbr=SOShipment.ShipmentNbr.
Then join from SOShipment to SOAddress on SOShipment.ShipAddressID=SOAddress.AddressID.
That should allow you to get the State like this:
