Sage 100

 View Only

  • 1.  How to delete SO's with zero quantities ordered

    Posted 12-15-2022 15:28
    Customer wants to delete SO's with items on them but with quantities of zero. They have a customer who they receive PO's from through EDI. So this customer may submit 10 PO's for the same item instead of one PO for the total quantity. For example, the customer wants a quantity of 50 but for some reason, submits 10 PO's with 5 on each. Then the customer realizes this and submits change orders for 9 of the PO's, zeroing out the quantity ordered then changes one PO to 50. Now MY customer has 9 SO's with an item on them but the quantity ordered is zero. Yes, they can delete them one by one but that is tedious. They could use the SO utility to delete obsolete PO's but I believe they cannot use this if they have anything in SO Invoice Data Entry or Shipping Data Entry. That is next to never for my customer. They run a report and it is about 6 pages long with nearly 100 SO's to delete on each page. 

    So, any ideas?? Am I missing something obvious?? TIA!

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------


  • 2.  RE: How to delete SO's with zero quantities ordered

    Posted 12-15-2022 15:34
    Importing / posting blank invoices might do it.  Just make sure the OrderLineKey list is accurate, and the quantity back-ordered on the invoices is set to zero.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    ------------------------------



  • 3.  RE: How to delete SO's with zero quantities ordered

    Posted 12-15-2022 15:42
    That's an idea @Kevin Moyes but then they will have hundreds of zero dollar invoices mucking things up. I was thinking some sort of script to run once a week or so but I have no idea if that can be done.​

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------

    Original Message


  • 4.  RE: How to delete SO's with zero quantities ordered

    Posted 12-15-2022 16:38
    True, but you can do that without any custom programming / scripting.

    Another idea: Add a "Delete me" UDF to SO header, and import a "Y" into the ones you want to remove... then run a BOI script that loops through the entire open SO list and delete the ones you've flagged for removal.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    ------------------------------

    Original Message


  • 5.  RE: How to delete SO's with zero quantities ordered

    Posted 12-15-2022 16:39
    This should be possible with a script. 

    Read through orders/lines, delete line where quantity ordered = 0, if this is the only line, delete order. I don't know how this might impact the EDI conversation though.  

    Maybe it is possible to handle in options in the EDI to delete/cancel the orders instead of 0ing quantity?

    ------------------------------
    Eric Lunceford
    First Mate Business Solutions
    Oklahoma City, OK
    877-880-8960
    ------------------------------

    Original Message


Related Content