186
Hi,
Can I use PurchTableVersion table- versioningDateTime field to find the latest PO confirmation journal through code.
(versioningDateTime desc)
VendPurchOrderJour does not have createdDateTime field.
Kindly suggest.
Thanks.
*This post is locked for comments
Hi Divya R,
In addition:
There is some functionality which will get the latest purchase order confirmation. If you select a purchase order, then on the menu go to 'General > Related information > Postings. This will give you an overview of the last postings per purchase order. You can then trace back how this is done technically.
PS. Do you need the latest overall confirmation or per purchase order? The answers from Satish and me are based on the latest per PO.
Hi RDivya,
Suggest that to get the latest version, you use data from VendPurchOrderJour based on PurchOrderDocNum and RecId field. Get the top 1 from this table where purchid = 'ABC' order by PurchOrderDocNum desc, RecId desc
Results may be achieved just by using recid, but just incase same version is there twice. During my analysis, found that for a given purchTableVersion, i had two records in VendPurchOrderJour.
Thanks,
Satish Panwar
Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (