FrenCo

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