Wednesday, 6 September 2017

AX : Get company Related Data

Today we would see how to retrieve company related data Like Company Name Address, Phone, Fax and Logo. Mostly we need these information when working on SSRS Reports. Below is the sample code how to achieve this :
CompanyInfo     Company;

    Company = CompanyInfo::find();

    SalesGatePassReportTmp.CompanyName       = Company.Name;
    SalesGatePassReportTmp.CompanyAddress    = Company.postalAddress().Address;
    SalesGatePassReportTmp.CompanyPhone      = Company.phone();
    SalesGatePassReportTmp.CompanyFax        = Company.teleFax();

   SalesGatePassReportTmp.Logo                       = CompanyImage::find(Company.dataAreaId, Company.TableId, Company.RecId).Image;

where Logo field in Tmp table is container & extends by Bitmap EDT

1 comment: