Sage 100

 View Only
  • 1.  I have a customer that is trying to simplify price

    Posted 03-11-2015 09:31
    I have a customer that is trying to simplify price levels in version 4.5. They have about 7K records in the IM_PriceCode table. I don't believe there is a utility to remove item and customer/item price records, so rather than manually deleting all of these one by one we're thinking about just reinitializing the IM_PriceCode table and then entering in the Price Code price levels (about 14 records). Anything I'm missing or warnings or is there a better way?


  • 2.  RE: I have a customer that is trying to simplify price

    Posted 03-11-2015 09:38
    Not that I know of. That's the way I always did that...


  • 3.  RE: I have a customer that is trying to simplify price

    Posted 03-11-2015 09:53
    thanks @SteveIwanowski - I'll back it up and extract the table to excel first as well, so we should be covered


  • 4.  RE: I have a customer that is trying to simplify price

    Posted 03-11-2015 10:41
    Ditto what Steve said. Export to Excel, delete records, reinitialize, Import...