Sage 100

 View Only
  • 1.  Ext Desc from nowhere

    Posted 03-14-2019 11:30
    Have a client with an item that keeps displaying the wrong description when entered on a line in Bill of Materials.
    I've looked for that ext description in the Extended Desc file and deleted all 3 records which had that description (none of which were the Key associated with the item).  I totally cleared the Ext Desc in Item Maintenance, made sure Key was 0000000000, and then added the description back in and noted it had a new key.

    And yet - it persisted.  I made sure to get out of Bills Maintenance and back in, in case Sage didn't refresh reading the Ext Desc file.

    So I ask - WHERE IN ALL THAT IS HOLY IS SAGE GETTING THIS BOGUS EXTENDED DESCRIPTION??????

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, and Cagney
    Beth Bowers
    269-445-1625
    ------------------------------


  • 2.  RE: Ext Desc from nowhere

    Posted 03-14-2019 11:34

    We are seeing something similar when the description is placed in the secondary grid.  All kinds of funky things are happening. Is this part of the problem?  Extended descriptions are not stored in grid – I know – but it could affect the item code....

     

    Also, do you have an extended description that does not have a key that could be linking to items that don't have a key?

     

    Not sure if this is a thing, but is there an extended description table in BOM separate from Item maintenance?

     

     

     



    ------Original Message------

    Have a client with an item that keeps displaying the wrong description when entered on a line in Bill of Materials.
    I've looked for that ext description in the Extended Desc file and deleted all 3 records which had that description (none of which were the Key associated with the item).  I totally cleared the Ext Desc in Item Maintenance, made sure Key was 0000000000, and then added the description back in and noted it had a new key.

    And yet - it persisted.  I made sure to get out of Bills Maintenance and back in, in case Sage didn't refresh reading the Ext Desc file.

    So I ask - WHERE IN ALL THAT IS HOLY IS SAGE GETTING THIS BOGUS EXTENDED DESCRIPTION??????

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, and Cagney
    Beth Bowers
    269-445-1625
    ------------------------------


  • 3.  RE: Ext Desc from nowhere

    Posted 03-14-2019 11:41
    Edited by Beth Bowers 03-14-2019 11:41
    This happens on both primary and secondary grid, I don't have an Ext Desc without a key, and I don't think there are Bill Ext Desc because you can't modify them in Bill of Materials.

    OH and forgot to mention - it's also printing wrong on the Work Order Traveler!

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, and Cagney
    Beth Bowers
    269-445-1625
    ------------------------------



  • 4.  RE: Ext Desc from nowhere

    Posted 03-14-2019 11:52
    As far as I can tell this is just a link to the IM extended description, not a value stored separately.


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



  • 5.  RE: Ext Desc from nowhere

    Posted 03-14-2019 11:54
    I would look in related files for a blank key...  I have seen similar things happen when there is record with a blank key in SO_ShipToAddress....

    Jeff

    ------------------------------
    Jeff Fiddelman
    Exeplex, LLC
    ------------------------------



  • 6.  RE: Ext Desc from nowhere

    Posted 03-14-2019 12:30
    is it possible that item has a Bill of Material associated with it either as a subassembly, or maybe someone started to create a BOM for that item by mistake? Maybe the wrong description is pulling from the BOM Header for that item. 



    ------------------------------
    David Overholt
    DWD Technology Group
    ------------------------------



  • 7.  RE: Ext Desc from nowhere

    Posted 03-14-2019 12:34
    Oh, @David Overholt - that is an AWESOME thought!  I will go check!​

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, and Cagney
    Beth Bowers
    269-445-1625
    ------------------------------



  • 8.  RE: Ext Desc from nowhere

    Posted 03-14-2019 12:37
    And... @David Overholt WINS!!!!!!!!!!!!!!!!!!!!!!!!  THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!​

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, and Cagney
    Beth Bowers
    269-445-1625
    ------------------------------



  • 9.  RE: Ext Desc from nowhere

    Posted 03-14-2019 13:07
    Bill descriptions being stored differently (vs CI_Item) is poor design.


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



  • 10.  RE: Ext Desc from nowhere

    Posted 03-14-2019 12:59
    Would it help to do a 'remove obsolete extended descriptions' to see if that would take care of it?
    N

    ------------------------------
    Nancy Hanson
    Blytheco LLC
    Eagan MN
    ------------------------------