Share
ReportI'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
You’re offline. This is a read only version of the page.
Announcements
65
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
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)?
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.
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.
#1
Almas Mahfooz
3
User Group Leader
All responses (
Answers (
