Announcements
No record found.
I'm concerned if a user will create a PO without printing it which will cause our On Order Quantity to be wrong.
*This post is locked for comments
If you do not print or email the PO to the vendor how does the vendor know what is being ordered? Is it just a verbal order? You could create an alert listing POs that have not been sent.
The PO could have been placed on a vendor website and then entered into GP after the fact. I'd rather not leave it up to an alert, we will end up chasing these POs all the time in order to get our numbers right. If I run some sql to always set the PO status to released, will that trigger the update of the on Order value? Thanks.
One way to do that would be to put a SQL insert/update trigger on the PO header table to call the same routines as when the PO is printed. Do you have anyone there who can run SQL Profiler to find the routine(s)?
Yes we do,thanks again Richard!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
