Moving on to D365 Finance and Operations

Search This Blog

AX2012 - Sort records by default dimension

on April 18, 2013

Get link
Facebook
X
Pinterest
Email
Other Apps

Just an example:

AX2012 Dimensions

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

AX2012: Update Invent Registration from code

*** Update: 2013-2-4 *** Credits go to Andy Adamak for spotting a problem with the code below. This bit of code simply grabs the first InventTransOrigin record where the InventTransID's match, then grabs the FIRST record of the InventTrans table where it matches up with the origin... regardless of status. The issue I was running into was even if it was received/registered, whatever status, it would grab the first InventTrans and override the record and it's InventDim record as well. So... It works, but not really because it totally messes up all your transactions if you receive more than once against the same PO line ------------------------------------------------------------------------------------------------------------------ Here's a job to update Invent Registration in AX2012. Feel free to try the following job in your testing/development environment. static void DEV_InventTransRegistrationFromCode(Args _args) { InventTrans...

Dynamics AX 2012: Use OpenXMLSDK for Excel Export - Part 1

Do you know about OpenXML and the SDK that goes with it? I saw it being mentioned in forum discussion here and there. However, not until recently that I've been start using it for exporting excel documents. And now I won't ever go back to SysExcelApplication. What is OpenXML and OpenXML SDK? For those of you who don't know what OpenXML is: Long answer - http://en.wikipedia.org/wiki/Office_Open_XML Short answer - It's the office document format whose extensions has an 'x' at the end (xlsx, docx, etc) The SDK is the library for manipulating files in OpenXML format. What's good about it? Better performance compare to Excel Object Model You don't need to install Office to be able to use it. The library can be downloaded and installed separately. In terms of AX, it means it is server-batch-friendly How's the code look like? Create a new Console Application project. Add WindowsBase and DocumentFormat.OpenXML as reference. (Use NuGet and...

AX2012 Print multiple reports to screen at the same time

It's common that customer require multiple reports to be printed with one button click. There are many ways to tackle this. The developer can override the click method of the menuitem button to call multiple reports. One can also customize the ReportController class to trigger other reports when run. However, one characteristic with the above approaches is that when printing to screen, user will need to close the first report before the second one will be shown. To overcome this, we can modify the SrsReportViewer form. Create a new form method to call another report private void callSecondReport() { SecondReportController newController; if (controller.parmReportName() == [First report]) { // Print the second report newController = new SecondReportController(); /* * Prepare the new controller */ // ... newController.startOperation(); } } Call the...

Powered by Blogger

AX2012 - Sort records by default dimension

Comments

Post a Comment