I’m trying to get the Warehouse name from Details in the SOShipment. I was able to get the integer ID using this:
SOShipLine firstLine = Base.Transactions.SelectSingle();
The firstLine.SiteID has the ID but how do I get the SiteCD (name)?
Answer
SOShipmentEntry graph extension: how do I get the SiteCD using the SiteID from the first SOShipLine?
Best answer by Django
INSite site = INSite.PK.Find(Base, firstLine.SiteID);
.PK.Find gives you a way to find the INSite record using the SiteID
.UK.Find gives you a way to find the INSite record if you have the SiteCD
INSite site = INSite.PK.Find(Base, firstLine.SiteID);
.PK.Find gives you a way to find the INSite record using the SiteID
.UK.Find gives you a way to find the INSite record if you have the SiteCD
+13Hi
To fetch the SiteCD, you can use below code snippet.
SOShipLine firstLine = Base.Transactions.SelectSingle();
if (firstLine != null && firstLine.SiteID != null)
{
INSite warehouse = PXSelect<INSite,
Where<INSite.siteID, Equal<Required<INSite.siteID>>>>
.Select(Base, firstLine.SiteID);
if (warehouse != null)
{
string siteCD = warehouse.SiteCD;
}
}Hope, it helps!
Dipak Nilkanth || MVP @2025 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.