FrenCo

Cache is king

Cache Cache

Never a dull moment when working with Ax, right? Today I ran into an interesting problem involving table caching in AX2012. Table caching in AX2012 This story starts with the request to create a new company in an existing AX environment. This company should have all general data from the old company, but none of…

Read More

Digging up the dirt. Inside the InventTrans (Part 3)

forklift

Continued from part 2 In parts 1 and 2 of this series on the InventTrans, I explained how a purchase order line mutates in the InventTrans table during the various stages of its life. The following table summarizes the changes in the inventTrans at various stages of the purchase order line. field create orderline post…

Read More

Digging up the dirt. Inside the InventTrans (Part 2)

purchase order

In this part of the series on the inventTrans, we will take a look at one of the processes that uses this table. The previous part can be found here. Purchase order The steps of the purchase order process: Create order Confirm order Post arrival journal Post receipt Post invoice To keep things simple, imagine we…

Read More

Digging up the dirt. Inside the InventTrans (Part 1)

ledger

I thought about naming this post ‘InventTrans for Dummies’, but we have to consider the source. We all know that the beating heart of the AX in- and outbound process is the inventtrans table. In essence this table is a ledger of any and all inventory movements and as such it is the ultimate source…

Read More