Purchase Order, order status drop down menu

I would like to add the completed (X) to the order status drop down menu.   We use purchase orders to order items such as Truck Chassis / tanks that we never recieve or sell in the system.  In our prior system when the chassis or tank arrived we complete the purchase order without receiving it so it was in the system for tracking purposes at a later date.  I can do it through Data File Display and Maintenance, but it is klunky and not something that I want to teach other users how to do.  The drop down menu is labeled program - defined so I cannot add it there.  I didn't know if there was a utility to let me modify what is in this drop down.  Thank you for your help!

  • 0

    Have you considered using a Drop Ship type PO?  Those should complete when fully invoiced (with no RoG).

    Edit: And a $0 invoice should work too, if you aren't receiving a proper invoice.

    Completing a PO has specific technical requirements that are controlled by the program, so there is no easy way to force a PO closed like you are suggesting.

  • 0 in reply to Kevin M

    Thank you Kevin for the suggestion.  We never invoice these items.  We are a truck upfitter, we order a chassis based on our customers request using a PO, we are not a truck dealer and do not have a dealer license.  When the chassis comes in we install the tanks and all the equipment and return the completed unit back to the truck dealer.  We invoice the truck dealer for our work.  When we close out the Work TIcket and Invoice the work, the PO for the Chassis stays open.  We are on 100 premium (SQL).  I have a little script set up to update the sql record.  It would be easier to allow the person billing do it from the PO Screen.   My thought is to create a checkbox on the menu that executes a VB script that will run the SQL script.  Again, easier if I can just add to the existing drop down box.   

  • 0 in reply to Keith Wrisley

    That is never going to be possible unless you get a Master Developer to make an enhancement.

    Alternative idea: turn on PO history with the option enabled to Retain set to Prompt... then delete the PO.  You can then set the cancellation code appropriately during the deletion (Cancelled, Received...).  Keeps your open PO table clean, with completed PO's in the history table.

    Direct SQL edits are not recommended.  (I limit myself to SQL edits of UDF / UDT data only to avoid any unforeseen issues in bypassing Sage programming for normal fields).