Microsoft Dynamics Axapta Technical,Functional Coverage

By viewing below clip you will able to know Product transaction cycle from Creation of item to sales and purchase and on hand physical in Ax 2012. 1. How to create Item in ax 2012 and assign item group, tracking dimension etc 2.Create, confirm and post-purchase order in the system. 3.Create, validate and post-movement journal in the system. 4.Create, confirm and post-sales order in the system. 5. On hand effect checking on the item on each process against inventory dimension. Please visit and see the clip and subscribe on youtube to get more updates.

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 table base of inventory table its include all transaction related to inventory like following transaction 1. Movement Journal, 2.Transfer Journal 3. Production and BOM transaction. 4. Transfer Order 5. Sales Order 6. Purchase order 7. Counting Journal Each module has separate table after entry and posting for example Sales order entry level table is salesTable and SalesLine and table after posting is custInvoiceJour and CustInvoiceTrans. CustTrans stored line item transaciton of customers related transaction Same funda is for vendor transaction is vendTrans. If you want to search any transaction related to Inventory you first select inventTrans to get basic Idea of transaction.