Home

Using Methods in Table Filters & Query Ranges in Dynamics AX 2012

In Dynamics AX, there is a class called SysQueryRangeUtil that can be utilized in both query ranges and table filters. Using methods from this class allow you to be very precise about what dates you want to use in reports or for filtering your data. Let’s say you have a report that you always want to run to see orders with shipping dates of the...

Read more

Simple summary Keys are in Dynamics AX

There is a maximum of one Primary Key per table, whereas a table can have several alternate keys. The primary key is usually the type of key that other tables, called child tables, refer to when a foreign key field in those other tables need a relational identifier. For new tables the default is a primary key based on the RecId field ,...

Read more

Recalculate InventSum in Dynamics AX

InventSum is needed to recalculate sometimes. We should use InventSumRecalcItem class in Dynamics AX. InventSumRecalcItem InventSumRecalcItem; ; InventSumRecalcItem = new InventSumRecalcItem("ITEM001", true, checkfix::fix); InventSumRecalcItem.updatenow(); First parameter : ItemId Second parameter : Show errors Third parameter : Fix or only ...

Read more

AX1004 error in Dynamics AX

I got this error at version Dynamics 2012 R3 CU9, SQL Server 2014, Windows Server 2012 R2. Those kind of errors will come when you move report from Dev Server to Live Server, even compilation in DP Class, Query, Contract, table … without any error AX1004: Reference System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e08...

Read more

CRUD Purchase order using AIF in Dynamics AX 2012 R3

Due to Purchase order doesn’t have Standard document service so we have to create new Document service for that using AIF wizards. I’m using AIF document service with NETTCP or HTTP Adapter to Create Purchase order service, here is steps Create Query with three datasouce (PurchTable, PurchLine, InventDim) likes below As best practice for...

Read more