D365 Excel add-in: link table between purchase orders and purchase requisition

Finance and Operations/AX Technical Forum
1

Hi all,

does anyone knows the name of the table to see the link between purchase requisition and purchase order in excel add-in?

thanks!

2

I’m not sure if there is any table for that. The link between purchase requisition and purchase order I use is: PurchLine.PurchId=PurchReqLine.PurchId; PurchLine.PurchReqId=PurchReqLine.PurchReqTable; PurchLine.LineNumber=PurchReqLine.LineNum; PurchLine.ItemId.ItemId

I don’t know if there is an entity to import in Excel add-in with all this information, maybe you’ll need to import PR and PO information in separate sheets and then link them