Thursday, February 11, 2016

To Reuse Void check number if journal is not posted.

Check reuse functionality in Dynamics AX is only available for US region.

Step1- Reject payment : Journal Lines > Payment status > Rejected.

Step2- Change payment status to None.

Step3- Go to AOT > tables > BankChequeTable.

Step4- Search Check number in CheckNum filed.

Step5- Change CheckStatus to created.

Step6- Go to Cash and Bank Management > Common > Check

Step7- Search check number. Check number should have status Created.

Step8- Select Check and Press Delete.

Step9- Enter Check number in From and To field.

Step10- Write Delete in Text box and press ok.

All Done!

You can now use this check number again.

Note: Test this solution on your test environment first. 

Sunday, January 31, 2016


During configuration of General Ledger in GL parameters form Batch Transfer rules has to be defined. When I was configuring it and clicked new, a line was created with "Document" in Rule type filed, since we need to create a synchronous posting so I had to change it to Company but I was unable to do it. After tying to do it multiple times I googled this issue and found below post and run the below job:

static void AST_SubledgerJournalTransferRuleCreate(Args _args)
   info( "Created" );

After running this job record was created with rule type company.

Below is the link of Forum post:  

Friday, January 9, 2015

Database Entity Relationship Diagrams

Found a very good source for Dynamics AX 2012 ERD.

This "AxErd" website hosts entity relationship (ER) diagrams for core tables of the application modules in Microsoft Dynamics AX 2012 R2. You can use the site to quickly list all the foreign key relationships for a table, involving both its child and parent tables. You can also use the site to determine which module a table is in, and which tables are in a module.

Wednesday, August 13, 2014

Dynamics AX 2012 Missing Labels

After upgrading to Dynamics AX 2012 R2 C7 it might happen and few label are missing from the application due to which a very annoying situation has be been faced.

for this kind of issue solution is provided on msdn blog at below link.

Thursday, March 20, 2014

ERROR IN INVENTORY RECALCULATION "Account number for transaction type Catch weight loss account does not exist"

During inventory closing I had an error which stopped posting recalculation result to ledgers.

As the error shows that Catch weight loss account is missing.  I checked item group for posting and surprised to see that main accounts are defined for this posting type.

So I digged it further and checked its record in inventtrans. But the problem was which transaction to check so for this I checked settlement that were under progress.

Here I found that there is one Transaction in which system used CW loss account. So I opened that transaction in Inventtrans. and checked what mainaccounts does this transaction has.

And we found that there was no ledger account assigned to CW loss account posting. Now the question was where to update that main account.

Above is the screen shot of Inventsettlement table. As we can see clearly that OperationsLedgerDimension for the same transaction is missing. This field contains the Recid of mainAccounts in which adjustments are to be posted. So I updated it with the recid of mainaccount.

And then Resume recalculation and this resolved error.

What I think is that mainAccount in Item group posting was updated after recalculation utility was run. 

Tuesday, October 22, 2013

Windows 8 App for Microsoft Dynamics :: Microsoft Dynamics Business Analyzer


Microsoft Dynamics Business Analyzer provides an insightful dashboard that enables you to view and interact with SQL Server Reporting Services (SSRS) reports without requiring you to log on to your Microsoft Dynamics ERP solution. Choose from a set of default reports based on your selected role or personalize the application with the reports that are most important to you.


  • Connect to SQL Reporting Services to display Microsoft Dynamics AX 2012 R2, Microsoft Dynamics GP 2013 and Microsoft Dynamics SL 2011 FP1 reports.
  • Interact with reports using a variety of report actions, such as copy, edit, view and refresh.
  • Open Microsoft Lync Windows 8 edition from a report to initiate a conversation with someone about the report.
To read more about it click here

Tuesday, October 8, 2013

Finding out which tables were updated by an operation in AX

At times when troubleshooting Microsoft Dynamics AX you need to know which tables were updated by a particular operation, for example after performing a posting. This could be if you want to be sure that all the right tables are updated correctly after an upgrade, if you have unexpected results on one customer/vendor etc or if you have made an update the system and you want to be sure that everything is ok.

Read complete blog from here