I have a problem to get a warehouse Address (Street, City, State). This is my code to find Warehouse Address, I have tried but when did select LogisticsPostalAddress not find. after I check the relationship between LogisticsPostalAddress.Location and LogisticsLocation.Regid correct?
static void Warehouse(Args _args)
Warehouse = “02001”;
InventLocation = InventLocation::find(Warehouse);
Select firstOnly InventLocationLogisticsLocation
where InventLocationLogisticsLocation.InventLocation == InventLocation.RecId;
select firstOnly LogisticsLocation
where LogisticsLocation.ParentLocation == InventLocationLogisticsLocation.Location;
select firstOnly LogisticsPostalAddress
where LogisticsPostalAddress.Location == LogisticsLocation.RecId;
can somebody help me ?