Rather frequently these days (since the coming of WHS) I find myself in a situation where I require all items in a company to have at least some provisional barcode. Also bear in mind that as long as you do not use your barcodes outside your own warehouse(s), there is no requirement to have an official gtin-range assigned. To keep things simple (I do like my things on the simple side), here is a little job I wrote to generate […]
The following applies to companies with a make to stock strategy that generally do not work with requested delivery dates (e.g. has customers who prefer their orders delivered yesterday). I bet my left spectacles (the ones I keep in my left-hand drawer) that every manager’s favorite report is “Shipped, not invoiced”. Who doesn’t want to know on a daily basis how much revenue is in the pipeline and just a posting run away. I bet my other pair (from the […]
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 […]
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 create a purchase order with a single order line. Create order The effects of creating a purchase order (with one purchase order line) on the […]
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 […]