Sage 100

 View Only

  • 1.  CI_Item Total Value field

    Posted 11-20-2019 09:39
    If you have a standard valuation item and change it's standard cost, the Total Value field in CI_Item does not recalculate (making it worthless).  I have a LOT of people using that in lookups in Item Maintenance - this is a major bummer.  (I tested this on 2019.2)

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------


  • 2.  RE: CI_Item Total Value field

    Posted 11-20-2019 09:42
    Shot in the dark, but did you update the std cost change register? Did the valuation and TB report reflect the new cost?

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



  • 3.  RE: CI_Item Total Value field

    Posted 11-20-2019 09:48
    Edited by Doug Higgs 11-20-2019 09:49
    The inventory trial balance can be printed using either the historical cost (transaction cost) or the current standard cost.



    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    Oscar Wilde - Alice in Wonderland
    (312) 315-0960
    ------------------------------



  • 4.  RE: CI_Item Total Value field

    Posted 11-20-2019 10:13
    I know, but a lot of clients like to see this in the lookup.  Since Sage took away so many fields when they changed to 12 month history files and always open periods, this was the one thing people could still get in a lookup.

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------

    Original Message


  • 5.  RE: CI_Item Total Value field

    Posted 11-20-2019 10:28


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

    Original Message


  • 6.  RE: CI_Item Total Value field

    Posted 11-20-2019 10:38
    I sense no one is getting my point - I do not want a client to have to run a utility each and every time they change the standard costs...  If there is a utility, then pack it into the end of the Standard Cost Change Register and be done with it.

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------

    Original Message


  • 7.  RE: CI_Item Total Value field

    Posted 11-20-2019 09:51
    *utl should fix that.

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



  • 8.  RE: CI_Item Total Value field

    Posted 11-20-2019 10:10
    And... it should be correct in the first place.  Client uses Standard cost for everything and changes happen frequently.  (I KNOW it would seem then WHY USE STANDARD, but owner includes OH in standard cost.)

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------

    Original Message


Related Content