Posts

Showing posts from October, 2019
http://imdaxershiv.blogspot.com/2016/01/creating-so-and-po-with-x-code-in-ax.html
Image
SSRS Report using Controller , Contract and RDP class in Ax 2012 R2 & Validates fromDate and ToDate Value Hi All, Today I would like to share you ,  how to create SSRS report using Controller, Contract and RDP class in AX 2012 R2? Step 1: Create new Temp Table . Ex:  VendTransTemp  with below listed table. Step 2 : Create a New Class . Ex:  SRDemoDP  which extends  SRSReportDataProviderBase    [ SRSReportParameterAttribute( classStr (SRDemoContract))]   class  SRDemoDP  extends  SRSReportDataProviderBase {     SRDemoContract contract;     VendTransTemp  vendTransTmp; }       [ SRSReportDataSetAttribute( 'VendTransTemp' )] public  VendTransTemp getTmpVendTransDetails() {      select  *  from  vendTransTmp;      return  vendTransTmp; }     [SysEntryPointAttribute] public   void  processReport() {       Query query;     QueryRun qRun;     QueryBuildRange qbr,qbr1;     VendTrans    vendTrans;     AccountNum
X++ code to filter PurchTableListPage form ( here it filters only today's Purchase order) Hi Folks, Today lets say about how to filter PurchTableListPage form. Note: here it filters only today's Purchase order  just goto PurchTableListPageInteraction Class >>initializeQuery() and write below code which is highlighted below, Keep Daxing :) !!!  public   void  initializeQuery(Query _query) {     Query                   query;     QueryBuildDataSource    qbds;     QueryBuildRange         rangeCompanyId;     QueryBuildRange         rangeUserId;     QueryBuildRange         rangeId;     QueryBuildRange         rangeStatus,qbr;     ProjInvoiceTable        projInvoiceTable;     ProjTable               projTable;      if  (EP::isVendor())     {         EPQuery::makeMyVendorSelfServiceQuery(_query,  tableNum (PurchTable));     }      // added by shiva      if (this.listPage().listPageArgs().menuItemName()== menuite
http://aslam111.blogspot.com/2014/01/what-is-difference-between-unique-index.html
X++ Code for Creating New Customer and also update Address of the customer X++ Code for Creating New Customer and also update Address of the customer static   void  SK_CreateCustomerandupdateCustomerAddres(Args _args) {         CustTable                          custTable;         AccountNum                      accountNum =  'ABC-123' ;         CustGroupId                     custGroupId =  '10' ;         Name                            name =  'ABC' ;         DirParty                        dirParty;         DirPartyPostalAddressView       dirPartyPostalAddressView;         custTable    = CustTable::find(accountNum);          if (!custTable)     // if customer not exits            {                  ttsBegin ;                 custTable.clear();                 custTable.initValue();                 custTable.AccountNum = accountNum;                 custTable.CustGroup = custGroupId;                 cust
Difference between OCC and PCC OCC: - Optimistic Concurrency Control            Optimistic Concurrency Control (OCC) helps increase database performance, Optimistic Concurrency only locks records from the time when the actual update is performed OCC Enabled: Yes PCC: -             Pessimistic Concurrency Control locks records as soon as they are fetched from the database for an update. Pessimistic concurrency was the only option available in Microsoft Axapta 3.0 (now a part of Microsoft Dynamics). 
Form templates in ax 2012 ListPage:  Use the template to create a list page you can use to find, analyze, and performs actions on master data. Main entry in to a module DetailsFormMaster :  Use the template to create a Details form to view, edit, and act on master data. DetailsFormTransaction:  Use the template to create details form with lines to view, edit, and act on master data that has line items. view and edit transactional and worksheet data . SimpleListDetails:  Use the template to create a simple list and details form to view, edit, and act on dependent and reference data. reference and setupdata SimpleList : Use the template to create a simple list form to view, edit, and act on dependent or reference data. Basic inquiry TableOfContents: Use the template to create a table of contents form to view and edit configuration or setup data Module configuration parameter Dialog: Use the template to create a dialog window that provides a response to a question. Quick user int