Posts

Relation between Child and Parent Customers!

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...
Post a Comment
Read more

Get the value of Month or YY in SysComputedCOlumns in AX views

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) + ')' ; }
Post a Comment
Read more

SysDictField object not initialized. - Views

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.
Post a Comment
Read more

How to Filter Data in Report Design In Visual Studio

Image
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!
Post a Comment
Read more

Hot to Put the Header on Each Page in an SSRS Report?

Image
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. :)
Post a Comment
Read more

How to filter data for the last few weeks?

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)); }
Post a Comment
Read more

Best Practice Issues

Image
BEST Practice errors! These are self-explanatory!
Post a Comment
Read more