Share
ReportAny idea how can I add the requisition no. on the POP form used for PO printing. I do not see this field anywhere.
*This post is locked for comments
You’re offline. This is a read only version of the page.
1,146
Any idea how can I add the requisition no. on the POP form used for PO printing. I do not see this field anywhere.
*This post is locked for comments
Hi,
The requisition number lives in the SOP/POP Link table. There is an existing relationship with the Purchase Order Line Rollup Temp, you'll need to add that table to your report. You will also need to create another Restriction which is SOP/POP Link SOP Number = SOP/POP Link SOP Number (yes, it says the field equals itself. The Req number in that file is the SOPNUMBE and you need to add it to the line item. A single Req can generate multiple POs.
Kind regards,
Leslie
Hi Kumar,
I don't think you can do that straight with RW.. not without using some VBA code.. as the Requisition number is not sitting in the regular POP tables, and the POP form only uses by default the POP tables (AFAIK).
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (