Profile cover photo
Profile photo
Anant Dubey
About
Posts

Post has attachment

Post has attachment
AX 2012 for Retail: Common practices and brief explanations for daily EPOS procedures and operations
The intent of this article is to assist with discovering the basic retail daily procedures for a Cashier and Manager from the design point of view.  While there are many combinations of how daily procedures are performed, this article is simply displaying s...
Add a comment...

Post has attachment
9 Simple Math Tricks You’ll Wish To Know For Lifetime
9 Simple Math Tricks You’ll Wish To Know For Lifetime
allaboutknowledgewithanant.blogspot.ae
Add a comment...

Post has attachment
How to create entity relationship diagram (ERD) in AX 2012
Recently I have to generate a ER-diagram for specific list of tables in Dynamics Ax.  Dynamics Ax has built in feature. Prerequisite of this article has Microsoft Visio. Create a project for all tables which require in ER-diagram. For this article I  create...
Add a comment...

Post has attachment
How to connect or access external database from AX 2012
Sometimes we have to communicate with outside of Dynamics Ax with in boundaries of Dynamics ax. Consider following scenario where I have to communicate with StudentDb in Sql server and insert rows in Student Info. We can do this with odbc connection. Now cr...
Add a comment...

Post has attachment
How to clear the cache of all clients in AX 2012
According to that reference we have to reset the GUID, so all Clients have to reset its cache, this method required AOS restart. static void ResetAUC(Args _args)
{
#AiF
SysSQMSettings _Settings;
;
ttsbegin;
update_recordset _Settings setting GlobalGUID = st...
Add a comment...

Post has attachment
List of functions in SSRS reports in AX 2012
During working in SSRS reports I have to handle division by Zero error for calculating accumulated cost by dividing Amount by Quantity. This expression works for me. IIf(Sum(Fields!xyz.Value) = 0, “N/A”, Sum(Fields!abc.Value) / IIf(Sum(Fields!abc.Value) = 0...
Add a comment...

Post has attachment
change date time format in SSRS report in AX 2012
Today is another small tip, I was developing a custom report. Queried table stored the date and time in separate fields ie. Transdate and transtime. On  mapping the transtime to report, its showed time format. Instead of time value. For it solution, I added...
Add a comment...

Post has attachment
Full text index in AX 2012
Consider following points for Full text index on Dynamics Ax 2012 Full text index used only on text fields on table. They find all records from table which contains the key words Queries can be used to and full text index used in range filters If keywords c...
Full text index in AX 2012
Full text index in AX 2012
ax2012anant.blogspot.ae
Add a comment...

Post has attachment
How to create SSRS report using Report data provider (RDP Report) in AX 2012
RDP or Business logic based SSRS Reports in Dynamics Ax 2012 R3. Logic based report in MS Dynamics Ax 2012 can be develop in following steps Create a temporary table Define the report parameters Add business logic for the report Create a reporting project B...
Add a comment...
Wait while more posts are being loaded