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

Posted on by Francesco
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 confirmation post arrival journal post product receipt post invoice StatusReceipt Ordered Ordered Registered Received Purchased ItemId ZF123 ZF123 ZF123 ZF123 ZF123 Qty 3 3 3 […]

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

Posted on by Francesco
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 for answers to inevitable questions about changes to inventory cost, inventory value and inventory levels. The table itself is no great mystery, but considering how […]