Posts

How to  Update default dimension with "Fixed value" on a main account  in ax 2012 static void tbs_UpdateMainAccountDefaultDimensions(Args _args) {     MainAccountRecId                mainAccountRecid        = 5637172326;     DataAreaId                      dataAreaId              = "CompanyId";     CompanyInfo                     companyInfo             = CompanyInfo::findDataArea( CompanyId );     MainAccountLegalEntity          mainAccountLegalEntity  = MainAccountLegalEntity::findByMainAccountLegalEntity(mainAccountRecId,companyInfo.RecId,true);     DimensionValue                  costCenter ...
How to add custom lookup (Multi Companies)in Dynamics AX 2012 Through X++ public void lookup(FormControl _formControl, str _filterStr) {         //super(_formControl, _filterStr);         Query                               query                               = new Query();         QueryBuildDataSource    queryBuildDataSource;         SysTableLookup               sysTableLookup;         query.allowCrossCompany(true);         sysTableLookup          = SysTableLookup::newParameters(tableNum(TaxGroupHeading), _ formControl);         queryBuildDataSource    = query.addDataSource(tableNum(TaxGroupHea...
How to import free text invoice in ax 2012 static void importFreeTextInvoice(Args _args) {     SysExcelApplication     application;     SysExcelWorkbooks       workbooks;     SysExcelWorkbook        workbook;     SysExcelWorksheets      worksheets;     SysExcelWorksheet       worksheet;     SysExcelCells           cells;     COMVariantType          type;     Dialog                  dialog;     Filename                filename;     DialogField             dialogFilename;     container               conFilter = ["Microsoft Excel Worksheets (.xlsx)" ,"*.xlsx"]; ...

How to add financial dimensions on form in ax 2012

How to add financial dimensions on form in ax 2012 ·         Add  TabPage  called  FinancialDimensionsTabPage   which should have the property  AutoDeclaration  set to  Yes ·         In classdeclaration declared the DimensionDefaultingController : class FormRun extends ObjectRun {     DimensionDefaultingController     dimensionDefaultingController; } ·         In the form’s override  Init method: public void init() {           super();            dimensionDefaultingController = DimensionDefaultingController::constructInTabWithValues(true, true, true, 0, this, FinancialDimensionsTabPage, "@SYS138487");  dimensionDefaultingController.parmAttributeValueSetDataSource(Table...
Run the DP class (SSRS) in Dynamics AX 2012     DemoContract        contract    = new DemoContract();     DemoDP                 dp             = new DemoDP();     QueryBuildDataSource                qbds;     Query                                            query;     TableNameTmp                tableNameTmp;     contract.parmFromDate(mkDate(1,4,2019));     contract.parmToDate(mkDate(31,12,2019));          query       = dp.parmQuery();     qbds        = query.dataSourceTable(tableNum(CustTable));     ...

How to add custom lookup in Dynamics AX 2012 Through X++

How to add custom lookup in Dynamics AX 2012 Through X++ public void lookup(FormControl _formControl, str _filterStr) {         //super(_formControl, _filterStr);         Query                               query = new Query();         QueryBuildDataSource    queryBuildDataSource;         SysTableLookup               sysTableLookup;              sysTableLookup          = SysTableLookup::newParameters(tableNum(TableName), _formControl);         queryBuildDataSource    = query.addDataSource(tableNum(TableName));                  sysTableLookup.addLookupField(fieldNum( TableName , Field1));         s...

How to get inventory on-hand in Dynamics AX 2012 Through X++

How to get inventory on-hand in Dynamics AX 2012 Through X++     InventDim           inventDim;     InventDimParm   inventDimParm;     InventOnHand     inventOnHand;     inventDim.InventLocationId = "01";     inventDim.modifiedField(fieldNum(inventDim,InventLocationId));     inventDimParm.initFromInventDim(inventDim);     inventOnHand = InventOnHand::newItemDim("111001", inventDim, inventDimParm); inventOnhand.availPhysical();