Deleted SO shows up during Auto-Generate Invoices

There is a SO that shows up when the customer runs 'auto-generate' Sales Orders that is a deleted order.  It is marked as such in the table, doesn't show up on reports or lookup or anywhere else.  The customer doesn't want to invoice it.  Ever.  But it fails when we run the process for all open orders, so I need to get it out of there somehow.  Or bypass it.

So, is what we're seeing "normal" behavior?  I could mark it as "hold" perhaps and make sure they exclude orders on hold but I'm concerned about the longer term implication.  They have to delete orders fairly often.

This is v 5.40.0.0, btw.  

PS For anyone watching, this is the correct definition of the problem I posted last week...customer gave me the wrong info and I didn't verify.  <sigh>

  • 0

    "Auto generate ORDERS" function  or "auto generate INVOICES"?

    If you are referring to auto generate ORDERS,  look for a MASTER or REPEATING order that is the source.

    If you are referring to auto generate INVOICES, you might try rebuild key files and sort files on the S/O module.  If that doesn't work I would go in a delete the s/o record for the offending order problem order using DFDM.  Make sure you rebuild the key files and sort files when you are done. MAKE SURE YOU DO A BACKUP FIRST OF COURSE.

  • 0 in reply to TomTarget

    I am Ok with doing this as a one off so they can generate invoices (I am going to do it in a completely TEST environment of course),but this is a problem if it needs to be done every time they want to delete a Sales Order.  I guess I can test for that condition in my test company, but it seems to me that the system should recognize a deleted order and bypass it.   Or is there a better way for a customer to manage Sales Orders that would not interfere with the auto-create invoice process.

    Also, if I "just" delete the header I will have orphan detail records, so I suppose I should delete them as well.

    Thanks for the tips, Tom.

  • 0 in reply to MClark

    I really don't know if this is just a one time thing or an inherent recurring bug.

    You might try deleting some more orders  in your test database and see what happens.  If you can recreate it, then report it to Sage.

  • 0 in reply to MClark

    I just tried this in in the demo data in the 2018 version and did not get the item that was just deleted.

    What's even more interesting is that when I looked at the sales order header file there was no record there that the order even existed in the first place?  They don't appear to be marked as deleted.  They just go away.

    So I'm a bit confused as to how auto generate can even find anything to work with.

    Maybe I'm not understanding your situation?