hi all,
i tried to get the warehouse telephone number through the folliowing code
ogisticsLocation LogisticsLocation;
LogisticsLocationAccessView LogisticsLocationAccessView;
LogisticsElectronicAddress ElectronicAddress;
// location == LogisticsLocation.recid;
inventsite inventsite;
LogisticsLocation logisticlocation;
LogisticsLocationId LogisticsLocationId;
CustTable CustTable;
custInvoiceJour custInvoiceJour;
Inventlocation Inventlocation;
SalesTable salestable;
InventSiteId inventsiteid;
dirpartytable dirpartytable;
RecId InvoicingAddress;
//InventSite inventsite;
LogisticsEntityPostalAddressView LogisticsEntityPostalAddressView;
select * from
custInvoiceJour
where custInvoiceJour.InvoiceId== ‘W09/INV/1314/000012’
;
select * from salestable
where
salestable.SalesId == custInvoiceJour.SalesId;
select * from inventsite
where
inventsite.SiteId == SalesTable.InventSiteId;
// info(strFmt(’%1’,inventsite.RecId));
while select * from
LogisticsLocationAccessView
where
LogisticsLocationAccessView.Entity == inventsite.RecId
&& LogisticsLocationAccessView.EntityType == LogisticsLocationEntityType::Site
{
select * from
LogisticsLocation
where
LogisticsLocation.RecId== LogisticsLocationAccessView.Location;
info(
strFmt(’%1’
,LogisticsLocation.RecId));
select * from
ElectronicAddress
where
ElectronicAddress.RecId == LogisticsLocation.RecId;
while select * from
ElectronicAddress
where
ElectronicAddress.IsPrimary
&& ElectronicAddress.RecId == LogisticsLocation.RecId
{
// && ElectronicAddress.Type == enum2str(LogisticsElectronicAddressTypes::Phone);
// ElectronicAddress = LogisticsElectronicAddress::findRecId(LogisticsLocation.RecId);
info(
strFmt("%1"
,ElectronicAddress.Locator));
up tp logistic location i am able to get the record , but after that not able to get the data in the
LogisticsElectronicAddress table , if any body get it pls help me ,
thanks,
srikanth