Table structure change for Purchase order in MSD ax 2012

Table structure change for Purchase order in ax 2012

There are some Table structure change for Purchase order in ax 2012. In ax 2009 whatever purchase order made its directly insert to inventtrans table but in Ax 2012 there are some more table link.

Initially data stored in purchtable and purchline table then purchline data inventtransid stored in InventTransOriginPurchLine table , Intermediate table between inventtrans and purchline is InventTransorigin.

You can check relation between tables purchline ,InventTransOriginPurchLine,InventTransorigin and inventTrans .

Once you create purchase order and facing any issue in po posting then you need to check data in mentioned tables.

Relation mentioned in below tables
InventTransOriginPurchLine

InventTrans