In my previous post, I stated that InventSumLogTTS table is not updated after related inventory transaction was physically posted. I was totally wrong. In a while I had to make some performance tuning for a couple of installations, which suffered from bad inventory closing performance and overall conflicts between inventory closing and regular user work. […]
Category Archives: Logistics
Two stories about inventory closing and SQL Locks
Story #1: update_recordset considered harmfull. Recently, I was invited to a customer who had started to use Inventory Closing functionality about a month ago. They were using DAX2009 with recent rollup 7. Every time when they were running inventory closing, the system locked all (or at least – most of the) inventTrans records, safely preventing […]
Cost Explorer in DAX2009
It seems that not every Axapta user/consultant is aware about the powerful debugging tool for cost related issues, introduced in DAX2009. This tool is a Cost Explorer form, which is available from Inventory->Cost Explorer button in any of different Inventory Transactions forms. Basically, this form allows you to trace down to the deepest cost sources […]
Update to the IC article
Section on Inventory closing for Physical inventory transactions is just added.
History of inventory locking in DAX
I’ve just translated and published my old article on the history of the inventory data locking in Dynamics AX. Well – It was written as a kind of sales driver for Dynamics AX 4.0, because improvement in inventory locking was the only actually useful improvement of DAX 4.0 against DAX 3.0. 🙂 Maybe this article […]
Costing and inventory closing
Article on Inventory closing and costing has been published. It is a translation from Russian original, first published 2+ years ago in my old blog (http://blogs.technet.com/denisfed/). The translation generally retained info from the old article, but has been cleaned from some peculiarities of Russian accounting and Russian localization of Dynamics AX.