From the Microsoft Dynamics AX Blogs: Performance and retail features; Exchange rates; Purchase orders; Invoice discrepancy

A selection of the latest insight from the Dynamics AX blogs:

• Retail and System Performance;
• How to Fix Error When Running AX 2012 Reports: "An Exchange Rate Cannot Be Found For Exchange Rate Type ZZZ Between Currencies XXX And YYY On Exchange Date";
• AX 2012 R3 for Retail - Clear Statement Greyed Out; Purchase Order Invoice:
• When Product Receipt is Higher than the Actual Invoice Amount

Retail and System Performance

On his DAXNigel blog, Nigel Deacon noted that there have been a number of changes to Microsoft Dynamics AX 2012 with the introduction of the retail module. But if you're not using retail should you disable the key to remove the functionality from your AX solution.

Recently, Deacon had a performance issue with posting a price journal with 200,000 that was taking hours to post.

"If you look at the code you would see the use of update_recordset and insert_recordset which are bulk insert command, but these only work if the insert and update methods have not been overridden.

"There was also some code in the posting routine to prevent the overridden insert and update methods being called, but only if NOT retail."

But after he switched off the license key (System Administration>Setup->Licensing->Licence information) for Retail Headquarter, the performance to post the journal was almost immediate, he said.

Unfortunately, there was a side effect of that action, he said. You can find out what it is here.

...