Hi, I'm trying to replicate these calculations into a SQL query, I'm confident I have identified everything except 'Quantity Requisitioned'. Can anyone confirm where this QTY comes from?
Thankyou
*This post is locked for comments
Hi Tim, your first option seems to be correct. I'm not even sure what this is for as the end usercan update the value on the UI, but I'll add it into the query anyway incase supply one day starts using it.
Thanks
Only to add to Tim's response, you can have Quantity Requisitioned filled in by either Business Portal (pre-GP 2015) or by the Purchase Order Requisitions window after transferring a requisition to a PO.
Tania,
2 thoughts (guesses) :
1. The Non-Purch Requisition field on the Item Quantities Maintenance screen when a site is selected.
or
2. The quantity on active Requisitions (if the version of GP you have includes the requisition module).
or
3. Both?
Tim
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
Share
Report
All responses (
Answers (