AX – D365FO – Computed columns in Views examples

Computed columns have been using in SQL server since many versions but this feature was available Dynamics AX since version 2012.Follow steps described here to learn how to create view and walthrough the complete example to understand how can we add computed columns in AX 2012 Views.More examples can be found from here --> http://daxmusings.codecrib.com/2011/10/computed-view-columns-in-ax-2012.html Well, here is an … Continua a leggere AX – D365FO – Computed columns in Views examples

AX – D365FO – Advanced filtering in code X++ on Query object

So, you are creating the query programmatically (of course using the Query* classes), and you need a statement like select * from tableA where columnB = val1 or columnC = val2 just do it like:     QueryBuildDataSource    qbds;     QueryBuildRange             qbr;    str                                      range;     // initializing the query and the datasource(s) here; will go like qbds = … Continua a leggere AX – D365FO – Advanced filtering in code X++ on Query object

AX – D365FO – Compare an XPO file with an AOT Object

To compare an XPO file with an AOT Object follow these instructions : Apen AOT, choose the object you want to compare and click Import button Choose the XPO file, click on Show Details checkbox, expand the tree, and click Compare button Choose the layout (cus, usr, etc..) you want to compare with XPO and … Continua a leggere AX – D365FO – Compare an XPO file with an AOT Object

AX – D365FO – Delete a version controlled object from AOT

If you delete a version controlled object from AOT you will probably also want the change to propagate across all AX environments (Test, UAT, PROD). To do this you need to check in the item. The problem is that the object, once deleted, disappears from the AOT, so where do we find it? To find … Continua a leggere AX – D365FO – Delete a version controlled object from AOT

AX – D365FO – Set NULL value as a default value on an enum type

It's not possible to set an enum type with a null value This is default behavior of Base Enumeration. By default if user doesn't choose a value the index 0 is defaulted for new record. If you want to achieve what you are looking for, you may add a third element in Base Enum, set … Continua a leggere AX – D365FO – Set NULL value as a default value on an enum type

AX – D365FO – SSRS – Use Enum values in filter expressions

When designing SSRS Reports with Data from Dynamcis AX, most of the datasets contains enum fields. But first let me give you a little background on enum fields. How to treat enum fields Those fields must be treated in a special way because each enum field appears as it is splitted into two fields in … Continua a leggere AX – D365FO – SSRS – Use Enum values in filter expressions

AX – D365FO – Configure email (SMTP/Exchange) and email template

The behavior of the email subsystem is influenced by a combination of administrator configuration, user configuration, and user choices. As an administrator, on the Email parameters page, note the following settings on the Email providers tab. The Batch email provider specifies which email provider will be used to send emails that are sent by processes in a batch or non-interactive manner. … Continua a leggere AX – D365FO – Configure email (SMTP/Exchange) and email template

AX – D365FO – Saved viewS

Personalization plays an important role in allowing users and organizations to optimize the user experience to meet their needs. By using the Saved views functionality, users can save multiple sets of personalization. For example, a Warehouse manager needs to view the All shipments list page by Site and Warehouse. Instead of filtering the data daily, the Warehouse manager saves each filtered list … Continua a leggere AX – D365FO – Saved viewS

AX – D365FO – X++ Code to find all the privileges for a menu item in AX

Create this job to find all the privileges for a menu item static void findAllThePrivilegeForSpecificMenuItem(Args _args) { SecurityTask securityTask; SecuritySubTask securitySubTask; SecurityTaskEntryPoint securityTaskEntryPoint; SecurableObject securableObject; while select * from SecurityTaskEntryPoint join SecurableObject where SecurableObject.RecId == SecurityTaskEntryPoint.EntryPoint && SecurableObject.Name == menuitemOutputStr(TaxReport_IT_ERA) //your menu item { while select * from securityTask where securityTask.RecId == SecurityTaskEntryPoint.SecurityTask { info(strFmt("%1,%2,%3,%4", … Continua a leggere AX – D365FO – X++ Code to find all the privileges for a menu item in AX