Purchase Order Generator calculations

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Tim Foster 8,515 on at

Like (0)

Report

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

Was this reply helpful? Yes No
MG-16101311-0 26,225 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No