Skip to main content

Posts

Showing posts with the label inventtrans

Example of doupdate in MSD axapta

To update records forcefully in table you can use doupdate method with tablename. Following example is helpful to understand this thing . InventTrans _inventTrans; ; ttsbegin; while select forupdate _inventTrans where _inventTrans.RecId == 5637152999 { _inventTrans.inventDimId = '123213'; _inventTrans.doUpdate(); } ttscommit;

Inventory Transactions table for Inventory modules in MSD Axapta

a) If Item is created using item master module (Inventory Management->Items) then Records get created in inventTable. b) If Sales Order created then Records get created in SalesTable and Sales Line table after confirmation, packing slip and invoicing orders records get created in other tables like custpackingSlipJour,CustPackingSlipTrans custInvoiceJour,CustInvoiceTrans,InventTrans etc. c) If Purchase Order is created then Records get created in PurchTable and PurchLine table after confirmation , packing slip and invoicing of order records get created in VendpackingslipJour,VendPackingSlipTrans,VendInvoiceJour,VendInvoiceTrans, InventTrans etc. d) If Inventory Movement Journal is created then Record get created in InventJournalTable and InventJournalTrans after posting of journal Records updated in invetTrans table. e) Financial Journal created in LedgerJournalTable and LedgerJournalTrans after posting Journals information Stored in LedgerTrans table.

InventTrans entity schema table description in MSD Axapta

InventTrans  The InventTrans table contains information about inventory transactions. When order lines such as sales order lines or purchase order lines are created they generate related records in the inventTrans table. These records represent the flow of material that goes in and out of the inventory. InventTable The InventTable table contains information about items. InventSum The InventSum table contains information about the present and expected on-hand stock of items. Expected on-hand is calculated by looking at the present on-hand and adding whatever is on-order (has been purchased but not arrived yet). InventDim The InventDim table contains values for inventory dimensions. VendTable The VendTable table contains vendors for accounts payable. CustTable The CustTable table contains the list of customers for accounts receivable and customer relationship management.