Skip to main content

Ax 2012 code,Get Inventory On hand qty for item of inventory dimension


   InventDimOnHand     _inventOnhand;  
   InventDimOnHandIterator _InventDimOnHandIterator;  
   InventDimOnHandMember  _InventDimOnHandMember ;  
   ItemId         itemId;  
   InventDim        _inventDim;  
   InventDimParm      _inventDimParm, inventDimParmOnHandLevel;  
    InventDim        inventDim;  
    InventDimOnHandLevel  _InventDimOnHandLevel;  
   ;  
   itemId = '76576';  
   _inventDim.InventLocationId = '1113';  
   _inventDim = InventDim::findOrCreate(_inventDim);  
    _inventDimParm.InventLocationIdFlag = true;  
   _InventDimOnHandLevel = InventDimOnHandLevel::DimParm;  
    inventDimParmOnHandLevel.ItemIdFlag = true;  
   inventDimParmOnHandLevel.InventLocationIdFlag = true;  
   inventDimParmOnHandLevel.WMSLocationIdFlag = true;  
   inventDimParmOnHandLevel.InventBatchIdFlag = true;  
    _inventOnhand = InventDimOnHand::newAvailPhysical(itemId, _inventDim, _inventDimParm, _InventDimOnHandLevel, inventDimParmOnHandLevel);  
    _InventDimOnHandIterator = _inventOnhand.onHandIterator();  
   while (_InventDimOnHandIterator.more())  
   {  
     _InventDimOnHandMember  = _InventDimOnHandIterator.value();  
     inventDim = InventDim::find(_InventDimOnHandMember .parmInventDimId());  
     info(con2str([_InventDimOnHandMember .parmItemId(), inventDim.inventLocationId, inventDim.wMSLocationId, inventDim.inventBatchId, _InventDimOnHandMember .parmInventQty()]));  
     _InventDimOnHandIterator.next();  
   }  

Popular posts from this blog

sales order Totals option getting error in Axapta

Problem: On  click sales order Totals option getting below error. Please help me how to solve it. Microsoft.Dynamics.Ax.Xpp.ClrErrorException: Exception of type 'Microsoft.Dynamics.Ax.Xpp.ClrErrorException' was thrown. at Microsoft.Dynamics.Ax.Xpp.CLRInterop.MakeReflectionCall(Object instance, String methodName, Object[] parameters) at Dynamics.Ax.Application.TaxDocumentProxy.Sumbytaxaccountingprovider(TaxAccountingProvider taxAccountingProvider, TaxAcctPostingProfDistributionSide postingSide, String taxType, String taxComponent, Boolean , Boolean , Boolean ) in TaxDocumentProxy.sumByTaxAccountingProvider.xpp:line 15 at Dynamics.Ax.Application.TaxDocumentProxy.@Sumbytaxaccountingprovider(TaxAccountingProvider taxAccountingProvider, TaxAcctPostingProfDistributionSide postingSide, String _taxType, Boolean , Boolean ) at Dynamics.Ax.Application.TaxDocumentProxy.@Sumbytaxaccountingprovider(TaxAccountingProvider taxAccountingProvider, TaxAcctPostingProfDistributionSide postingSide, ...

X++ Code to run SSRS Report with parameter in D365 F&O (Example Sales Invoice )

Below is sample X++ Code to run SSRS Report with parameter in D365 F&O (Example Sales Invoice )      Args                       args = new Args();     CustInvoiceJour            custInvoiceJour;     SalesInvoiceJournalPrint   salesInvoiceJournalPrint;       select firstonly custInvoiceJour where custInvoiceJour.SalesId != '';       // Add record to be printed.     // In order to have the context table we need to set args.record().     args.record(custInvoiceJour);       salesInvoiceController = new SalesInvoiceController();     salesInvoiceController.parmReportName(         PrintMgmtDocType::construct(PrintMgmtDocumentType::SalesOrderInvoice).getDefaultReportFormat());       salesInvoiceContract = salesInvoiceController.parmReportContrac...