Skip to main content

Posts

Showing posts from September, 2011

Deploy reports right from the MSD Axapta

Deploy reports right from the AX 1. First install Reporting Extensions, Configure reporting Servers  then Go to  > AOT. 2) You can check your AX folder if you actually have Report Deployment installed. For example; C:\Program Files\Microsoft Dynamics AX\50\Reporting Services\AxReports.exe 3) You can also try to run it from the AX installation CD itself, For example; D:\Msi\Components64\Progra​m Files\Microsoft Dynamics AX\50\Reporting Services

Code to create csv file from table data in MSDAX

If you want  Code to create csv file from table data using x++ code in Axapta application Try this code in job //Declaration of variables #File CommaTextIo commaTextIo; FileIOPermission permission; CustTable custTable; //assign file path and file name str fileName = strFmt('%1\\ax_%2.csv', WinAPI::getTempPath(), "Name"); // @"C:\My Documents\abc.csv"; ; permission = new FileIOPermission(fileName,#io_write); permission.assert(); commaTextIo = new CommaTextIo(fileName,#io_write); //select data in query to write in csv file while select custTable { commaTextIo.write(custTable.AccountNum,custTable.Name); } CodeAccessPermission::revertAssert(); //After execution of job you can see .csv file in temp folder

Fundamental of Class Declaration in MSD axapta

Class Declaration The classDeclaration consists of three types of definitions: Variables used to create fields in the dialog Variables used within the data manipulation Local macro to define which variables to pack (in other words,remember for next time, and/or use on the batch server) In this example the class declaration is as follows: public class DemoRunBase extends RunBase { DialogField dialogAccount; DialogField dialogFromDate; DialogField dialogToDate; LedgerAccount ledgerAccount; FromDate fromDate; ToDate toDate; #DEFINE.CurrentVersion(1) #LOCALMACRO.CurrentList ledgerAccount, fromDate, toDate #ENDMACRO } The individual fields of the dialog will be initialized in the method dialog(). When the dialog is accepted by the user, the contents of the dialog fields are read in the method getFromDialog(). As both methods have to access the same variables, they are defined as members of the class. The manipulation in the method ru...

What is RunBase Class in MSD axapta ?

What is RunBase Class? The RunBase class is an abstract class which defines common structure for all data manipulation functions in AX. The minimum implementation of a RunBase class includes following methods a. ClassDeclaration b. Dialog c. getFromDialog d. Pack e. UnPack f. Run g. Description (static) h. Main (static)

Describe Args in Microsoft dynamics axapta MSDAX

1. The Args Class defines information communicated between running application 2. This Communication can occur automatically without any X++ programming. 3. If the caller is activating the called object by a menu item the Args object is automatically initialized and set as a parameter to the object called. AOT properties of the menu item  will be used. 4. Different type of Args sent to caller as follows. Type of Args Args.record(Table_Obj) Used to access the value of the caller’s record of Table_Obj Args.Caller(this) Send the Caller as an object to the called object. Args.ParamEnumType(Enum_Obj) Send ID of enumType that is specified in param Enum. Args.ParamEnum(Enum_Obj::Value1) Sends an EnumValue Args.ParamObject(AnyObject) To transfer any object ,Args.Param(str) To transfer a string, but this method is not considered as best practice.

Execution sequence at the time of Report run in MSD axapta

  Report Run with execution sequence 1. Init – Called on Report is initialized. 2. Dialog / getFromDialog – Called before fetch to interact with Client. 3. Fetch – Do the following     a. Initialized the QueryRun     b. Prompt a Query     c. Prompt printer settings     d. Fetch the data     e. Send the data 4. Send – This method is activated every time a record is to be printed. 5. SectionId.ExecuteSection – print the control/s of the section

Purpose of Ledger Account statement report in MSD axapta

Ledger Account statement report in axapta Ledger Account statement report  is a very important report for accounting purpose in Axapta ERP.  Main tables used to fetch data is ledgertrans, ledgerTable and balancedimtrans. To show opening balance and ledger transaction one temparary tables tmpdimtrans . There are some fields like accomulatedAmountMST and AmountDebitCredit. AccumulatedAmountMSt gives calculated opening balances as per transaction and amountDebitcredit should debit and credit amount for particular period. One important class used in this  report is LedgertransReportEngine. All functionality of data handled through this class. Ledger report work as per dimesions through this class.