Sage 100

 View Only
  • 1.  PO creation from SOThe generation of PO's from SO

    Posted 04-07-2016 04:25
    PO creation from SO The generation of PO's from SO lines is a cool feature for some users. If there is a default vendor it creates a PO when the PO generation order qty is based on the qty in SO. Does anyone know of a way to have it omit lines? I have a client that wants to buy some items for the order but deliver other items on the order from Stock. The Items all have a default vendor assigned. The work around is to create the PO's and then delete either the lines not needed or the PO itself. Or create a bogus vendor assign that vendor to the line and delete any orders from that vendor. But that doesn't write back to the SO.


  • 2.  RE: PO creation from SOThe generation of PO's from SO

    Posted 04-07-2016 04:54
    We did this for a customer but used custom programming. Put a UDF on the lines tab ""PO"" and if checked, it went to the PO Generation, if not then it didn't. I think we may have defaulted it from CI Item and for items that were sometimes shipped from stock, they could uncheck it at SO level.


  • 3.  RE: PO creation from SOThe generation of PO's from SO

    Posted 04-07-2016 05:16
    Unless I'm mistaken, even if there is a default vendor assigned in CI_Item, if the ""vendor number"" field on the sales order line does not have a vendor assigned, that line will not generate a line on a PO. Assuming that is true (I did not test that this morning) : 1. Work around would be to simply blank out the vendor number field on some Sales Order lines as you populate the line. 2. Use a UDF in CI_Item like @NancyHanson suggested for the items that should not create a PO. Pull that on to the SO Line detail. Then add script during SO Line Entry to blank out the vendor field. This script could fire on post validation of the item code. Or you could add a button on the SO lines tab that the user could click on. The script could then read through each line and blank out the field based on the value in the UDF.