I have the SiteID, SiteCD (Warehouse ID), BAccountID. How do I grab the address information, using C#, from the Address table on the Warehouse (IN204000) page?
Answer
SOShipmentEntry graph extension: how do I find the Warehouse (IN204000) Address?
Best answer by DipakNilkanth
Hi
I believe below BQL query helps you to fetch the address.
Address address = SelectFrom<Address> .InnerJoin<INSite>.On<Address.addressID.IsEqual<INSite.addressID>> .Where<INSite.siteID.IsEqual<@P.AsInt>>
.View.Select(graph, siteID);
Hope, it helps!
+13Hi
I believe below BQL query helps you to fetch the address.
Address address = SelectFrom<Address> .InnerJoin<INSite>.On<Address.addressID.IsEqual<INSite.addressID>> .Where<INSite.siteID.IsEqual<@P.AsInt>>
.View.Select(graph, siteID);
Hope, it helps!
Dipak Nilkanth || MVP @2025 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
Hi
I believe below BQL query helps you to fetch the address.
Address address = SelectFrom<Address> .InnerJoin<INSite>.On<Address.addressID.IsEqual<INSite.addressID>> .Where<INSite.siteID.IsEqual<@P.AsInt>>
.View.Select(graph, siteID);
Hope, it helps!
I’m getting a compiler error on @P what is this? Never mind. I was missing “using PX.Data.BQL;”
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.