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

Description

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.

Features

  • 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

Introducing cumulative update 6 for Microsoft Dynamics AX 2012 R2

Microsoft continues its commitment to customer success through a regular release cadence of cumulative updates which is comprised of rollups of released hotfixes, regulatory updates, and existing business process enrichments. click here to read complete post.

Good bye :)

Tuesday, September 10, 2013

Microsoft Dynamics AX 2009 Support

Microsoft Product Lifecycle Search

Mainstream* support for Microsoft Dynamics AX 2009 is extended as shown to provide all customers with the standard lifecycle transition timeline. The mainstream support expiration date will be April 14, 2015.
For additional details, please click here.



Let's Go time to plan for transition!!!

Wednesday, July 10, 2013

Microsoft Dynamics Lifecycle Services Released!

Microsoft Dynamics Lifecycle Services (LCS) is designed to manage and optimize customer implementations – powered by Azure. The customer creates project workspaces for implementation, upgrade and maintenance activities, and will invite implementation experts from partner organizations and Microsoft into these workspaces for the execution of related activities. Partners will be able to create projects for learning and presales purposes. This enables partners to build out expertise around LCS, and demonstrate this in sales cycles.

Take it for a test drive at https://lifecycleservices.dynamics.com or https://lcs.dynamics.com.

AXPulse launches News Bar for Microsoft Dynamics AX 2012

Stay up to date with the latest organization and business updates. Setup news for a specific legal entity or for specific date intervals using the standard MS Dynamics AX 2012 UI. See more on http://www.axpulse.com/product/news-bar/