How to display P.O. vendor Reference in Item Transactions Overview display if Reference is 'Purchase Order".

Finance and Operations/AX Developer Forum
1

How to display P.O. Vendor Reference in Item Transaction if the Reference column is “Purchase Order”?

Here’s my code I put in the main method of “InventTrans Form”. However when I execute this in the Overview Grid it gave me all duplicates in one reference only.

display VendRef vendorRef()

{

return PurchTable::find(InventTrans.TransRefId).VendorRef;

}

3568.VendorRef.jpg
3568.VendorRef.jpg869×620 245 KB

As you can see above table, Vendor Reference is Repeating with the same number. I need to display Vendor Reference according to the Purchase Order no. Anyone has an idea on this matter? Thanks.

2

InventTrans.TransRefId

Replace InventTrans with ur DataSource that represent InventTrans In your form

try

return PurchTable::find(InventTrans_DS.TransRefId).VendorRef;