Moving on to D365 Finance and Operations

Search This Blog

AX2012 - Sort records by default dimension

on April 18, 2013

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Just an example:

AX2012 Dimensions

Get link
Facebook
Twitter
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) { InventTransWMS_Register

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

AX2012 R2 Get a list of Duties and Privileges based on Security Role

This is a SQL script to get a list of duties and privileges based on a security role. I definitely saw something similar before, but couldn't find it again. So I'm putting it down here for reference. USE [Model_database_name]; SELECT secRole.AOTNAME [Role_Name], secRoleExplode.SECURITYROLE, secRole2.AOTNAME [Subrole_Name], secRoleExplode.SECURITYSUBROLE, secTask.AOTNAME [Task_name], secRoleTask.SECURITYTASK, secTask2.AOTNAME [secTask2_name], secTaskExplode.SECURITYSUBTASK, CASE WHEN secTask2.TYPE = 0 THEN 'Privilege' WHEN secTask2.TYPE = 1 THEN 'Duties' ELSE 'Other' END AS OBJECTTYPE --,secTaskEntryPoint.ENTRYPOINT, secObject.name, --CASE -- WHEN secTaskEntryPoint.PERMISSIONGROUP = 0 THEN 'No access' -- WHEN secTaskEntryPoint.PERMISSIONGROUP = 1 THEN 'Read' -- WHEN secTaskEntryPoint.PERMISSIONGROUP = 2 THEN 'Update' -- WHEN secTaskEntryPoint.PERMISSIONGROUP = 3 THEN 'Create' -- WHEN secTaskEntryPoint.PE

Powered by Blogger

AX2012 - Sort records by default dimension

Comments

Post a Comment