Sage 100

 View Only

  • 1.  Item Delete/Change Utility: No Action - Item Found on a Sales Order

    Posted 03-20-2025 18:46

    This message can't be real.  There are ZERO SO_SalesOrderDetail records that have this ONE item that I am trying to delete.  There are ZERO transaction history records, there are no ON SO quantities in IM.  I have even rebuilt sort files.   I have deleted the one record in IM_ItemWarehouse.  This item is Average Costed. What is Sage doing here with this utility preventing me from deleting an item that truly is not on a sales order.  

    Is it because it could be on a sales order in History?  If that is the case then this message needs to be better.  ARRRGH.  



    ------------------------------
    Jane Scanlan
    Partner
    Next Level Manufacturing Consulting Group
    ------------------------------


  • 2.  RE: Item Delete/Change Utility: No Action - Item Found on a Sales Order

    Posted 03-21-2025 06:38

    Try merging it to another number?



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444

    Improving bottom lines for over 25 years!
    ------------------------------



  • 3.  RE: Item Delete/Change Utility: No Action - Item Found on a Sales Order

    Posted 03-21-2025 08:45

    @Jane Scanlan - What about this file?  I've found discrepancies between it and the actual SO_SalesOrderDetail file before.



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 4.  RE: Item Delete/Change Utility: No Action - Item Found on a Sales Order

    Posted 03-21-2025 11:22

    Oh Beth I was so hopeful to find a record in that file, but no such thing.  I guess I need a developer to chime in and look at the code to explain WTH it is looking at to give that message.  I don't want to merge this item into another, dummy item.  I hate having to do that because then all historical SO, PO and AR records have the new dummy part number on the history detail record.  Before I tried the delete item utility, I ran the utility to purge IM transactions through a certain year, and when you do that if an item's net transactions are zero, it doesn't write out an IX record.  So in this case, the item had transactions before I ran the purge transactions utility, and after it has none.  In this instance I would think Sage would let you delete the item because there is no transaction trail for it.  I'm trying to help my client pare down their 40,000+ inventory masterfile and this roadblock is preventing me.  :(  



    ------------------------------
    Jane Scanlan
    Partner
    Next Level Manufacturing Consulting Group
    ------------------------------

    Original Message


  • 5.  RE: Item Delete/Change Utility: No Action - Item Found on a Sales Order

    Posted 03-22-2025 00:52

    Is it in a kit or a bill?



    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    Corvallis OR
    541-829-1054
    ------------------------------

    Original Message


Related Content