AX Development

Recently I had a task (Report) To filter on the customer and get the Data from the customer and the Data of the Parent Customers! The Invoice account in a customer is the Parent Customer. Here is the code (in the process report) public void processReport() {     SalesLine salesLine;     LogisticsPostalAddress logisticsPostalAddress;     CustTable              custTable,custTable1,custTable2 ;     CustAccount             custAccount ;     ItemGroupId             itemGroupId ;     InventLocationId        inventLocationId,warehouse ;     CustInvoiceAccount      InvoiceAccount ;     InventTable             inventTable ;     InventDim               inventDim ;     S...

Here is the Code: public static server str WFinvoiceDateMM() {     str sDate =         SysComputedColumn::returnfield(             tableStr (WFSyscoInvoicesV),             queryDataSourceStr (WFSyscoInvoicesQ, CustInvoiceJour),             fieldStr (CustInvoiceJour, InvoiceDate)             );     return 'Month(' + SysComputedColumn::fromUtcDateToDate(sDate) + ')' ; }

One of my Colleague had this issue.. I’m using a View (with some calculated fields), as the source for another View (summed fields, so I’m working with “total” records). This 2 nd View continues to have this error message: SysDictField object not initialized. Stack trace (C)\Classes\SysTableBrowser\AddField - line 32 (C)\Classes\SysTableBrowser\showAutoFields - line 95 (C)\Classes\SysTableBrowser\run - line 67 Solution: Go to the Field Groups and delete the fields that are in the Autoreport and delete the fields that are Autoreport and not in the Field List of the View.

I need to filter the report with some constant values for some columns. So how do we do it? Go to the report design in visual Studio, select the report and click Tablix properties Give the required conditions below!

Here is a brief explanation of how to put on each page of an ssrs report. Once the report is designed, Click on the Header row and click Tablix Properties and check both the rows under Row Headers as shown in Picture 1. Click on the Column Groups and Click the Advanced Mode Select the Static value under the Row Groups and look at the tablix member properties on the right. Set the Properties as shown in Picture 3. Save, Build and Deploy the report. :)

I got a task where I had to get the data for the last few weeks excluding the current week. The week begins on a Sunday and ends on a Saturday. Here is the code: { Date dateFrom; Date dateTo; date fd; ; fd = dateStartWk(systemDateGet()); // get the First day of the Week dateTo = fd - 2; // Subtracted 2 since the first day is a Monday dateFrom = dateTo - ((5 * 7) -1); // shud be 3*7 - 1 as ToDate value is also Included info(strFmt("%1-%2-%3", fd, dateTo, dateFrom)); }

BEST Practice errors! These are self-explanatory!

Its Simple. Select the Column that you want to convert in to a Barcode and change the properties in the properties window. Save and Deploy!

Here is the code that will post the journals that are imported using DMF (in my case). Select the class DMFEntityBase and write the code below in the PostTargetProcess method Code to be written in the PostTargetProcess method /// /// Executes the logic once after processing the target data. /// /// /// A table buffer. /// public void postTargetProcess(DMFDefinitionGroupExecution _dmfDefinitionGroupExecution) {     //     PriceDiscAdmTable               priceDiscTable;     PriceDiscAdmCheckPost           priceDiscAdmCheckPost;     PriceDiscAdmName                priceDiscAdmName;     PriceDiscJournalNum             PriceDiscJournalNum;   /*  while select priceDiscAdmName     {         select reverse firstOnly priceDiscTable      ...

I recently found that there is another method to deploy a report from VS (in AX – through AOT) After we make the changes, in the report in Visual Studio, 1.       Save the Changes (Click Save) 2.        Rebuild the project and add the project to AOT. 3.        Go to AOT > SSRS Reports and find the report. 4.        Restore the Report and deploy element. 5.        The report deploys into AX and ready for use.