Build Financial dimension based on other dimension values in AX 2012



From the above example, If you want to get the CostCenter (first 4 chars)  & deparment (2-3 chars) from ExpensePurpose, we have to customize some standard classes to achieve it. DimensionDefaultingControllerBase class manages the display, user interaction and storage of default dimension check boxes, combo boxes and values. In DimensionDefaultingControllerBase class customize the LoadAttibuteValueSet method to create the CostCenter & Department.


The _dimAttributeValueSetId is the DefaultDimension recId which has the value user entered in ExpensePurpose field. You can write separate method to retrieve the details of Financial Dimension from _dimAttributeValueSetId  & prepare your own DefaultDimension recId and reassign to _dimAttributeValueSetId.



Comments

Post a Comment

Popular posts from this blog

Sales order invoice posting using X++ with custom SalesParmLine fields

private boolean postSOInvoice(SalesTable salesTable) {     SalesFormLetter     letter      = SalesFormLetter::construct(DocumentStatus::Invoice);     CustInvoiceTrans    custInvoiceTransFrom;     SalesParmLine       salesParmLine;     SalesParmUpdate     salesParmUpdate;     SalesLine           salesLineLocal;          boolean             ret = true;         letter.salesTable(salesTable);         letter.initParmDefault();         letter.transDate          (systemDateGet());         letter.specQty            (SalesUpdate::All);         letter.proforma           (false);       ...
Read more

Create a custom lookup with multiple data sources on form using X++

Open the form on which you want to create a custom lookup. Go the data source - fields, select field and override the lookup method. Following code will help you in creating custom lookup using SysTableLookup with multiple data sources.  public void lookup(FormControl _formControl, str _filterStr) {      SysTableLookup            sysTableLookup;      Query                          query;      QueryBuildDataSource  qbds1, qbds2;      ;      sysTableLookup = SysTableLookup::newParameters(tablenum(table1),_formcontrol);      query = new Query();      qbds1 = query.addDataSource(tablenum(table1));    ...
Read more

SalesTable2Line custom field update prompt on Sales order in AX 2012

Image
 Dynamics AX has standard functionality to show a prompt for any common fields on Sales Header & Lines are being updated on header. This prompt is based on the setup done on the AR Parameters form -> Updates -> Update order lines button If we want to have our custom field to behave in same manner, then we need to do following steps. 1. Create your new field on the SalesTable & SalesLine tables. Here for I am going to use field as "AS_TitleTransfer" 2. Add the  AS_TitleTransfer field to SalesTable field group HeaderToLineUpdate. 3. Add the new field on the Header & Lines section on SalesTable form like on General Tab. 4. In the AxSalesTable class add parm & set methods for new field. public <<your EDT>> parmAS_TitleTransfer( <<your EDT>>  _Id = '') {     if (!prmisDefault(_Id))     {         this.setField(fieldNum(SalesTable, AS_Ti...
Read more