Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Restricting Purchase Orders with no line items (Flex?)

Status
Not open for further replies.

SamW41

IS-IT--Management
May 13, 2011
5
US
Currently, people are opening up a screen to create a new Purchase Order, keying in a vendor #, then leaving before going to the line item screen. This has been "using" the PO but nothing is getting saved for this.

I am looking for a way to prevent anyone from creating a PO Entry and then escaping before a line item is added. This way it will prevent that particular PO from being "used".

Does anyone have any advice on how to achieve this? We have the Flexibility module available, but a non-flex solution would work too(if possible)

Thanks.
 
Progression or ES?

I believe this is doable but will require more tinkering around than I am prepared to do at the moment.

On the MacForm_Close event, perform a quick SQL query to see if the PO you are working on actally has and poordlin records. If it doesn't,have a message box ask the user if they want to abandon the PO. If they answer yes, run another SQL statement to delete the poordhdr record.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
 
Is the problem the consumption of the PO number that never gets used or the creation of a PO with no line items? If the former, there is no good solution. Macola increments the PO number at the time that the user starts creating a new PO, if the user then cancels/escapes then the PO number is put back in the queue unless someone else has already started creating a PO, in which case the number is just lost.

Which of the two scenarios is your problem?

Scott Travis
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top