Skip to main content

How to find BOM Unit and Inventory Unit for item in Ax 2012



   InventTable     inventTable;
   InventUnitId    inventoryUnit,BOMUnit;
   BOM         bom;
   ItemId       curItem;
   ;
   while select BOM
     order by itemid
     where BOM.BOMQty
   {
     if(curItem != BOM.ItemId)
     {
       curItem = BOM.ItemId;
       inventTable = InventTable::find(bom.ItemId);
       inventoryUnit = inventTable.InventUnitId();
       BOMUnit = bom.UnitId;
       if(!UnitOfMeasureConverter::canBeConverted(UnitOfMeasure::findBySymbol(inventoryUnit).RecId,
                       UnitOfMeasure::findBySymbol(BOMUnit).RecId,
                       inventTable.Product))
       {
         if(inventoryUnit != BOMUnit)
         {
           info(strFmt("item %1 has bom unit %2, inventory unit %3",inventTable.itemId,BOMUnit,inventoryUnit));
         }
       }
     }
   }  

Comments

Post a Comment

Popular posts from this blog

D365 : ENABLE AND DISABLE IN LIST PAGE

 here i have added 4 button in salesQuotationlistpage. now i need to enable/disable button according status. so i have Extensionof  of class SalesQuotationListPageInteraction and modify setButtonEnabled method by Chain of Command //list page button enable and diable in listpage interation class [ExtensionOf(classStr(SalesQuotationListPageInteraction))] final class SQTableinimathod_Extension {     protected void setButtonEnabled()     {                SalesQuotationTable SalesQuotationTable;         CustQuotationJour   CustQuotationJour;         CustQuotationConfirmJour  CustQuotationConfirmJour;               next setButtonEnabled();         SalesQuotationTable SalesQuotationTable1 = this.listPage().activeRecord(queryDataSourceStr(SalesQuotationListPage, SalesQuotationTable));         selec...
Post a Comment
Read more

An error occurred during report data sets execution D365 For finance and operations

  Hi all, small tip. I faced this issue, when I extend the custom report in D365 for finance and operations. During development on onebox     Solution was simple, restart IIS services Restart Reporting Services. Happy Daxing.
Post a Comment
Read more

CODE TO PDF IN AX 2012

static void Job1(Args _args) {         PurchPackingSlipController      ssrsController = new SrsReportRunController();         TradeDocumentReportContract     purchPackingSlipContract = new TradeDocumentReportContract();         SRSPrintDestinationSettings     printerSettings;         VendPackingSlipJour             VendPackingSlipJour;         Args                            args;         //select the latest record based on create date         while select VendPackingSlipJour             order by VendPackingSlipJour.createdDateTime DESC             where VendPackingSlipJour.PackingSlipId == 'LJ-01'         ...
Post a Comment
Read more