Sage 100

 View Only

  • 1.  Customer Price Schedule

    Posted 11-15-2022 10:28
    Customer had a specific customer with a price schedule.  At the moment they would like to delete ALL the specific item price schedule so it can grab the price from the Price Level.  Do I need to go one by one on the customer pricing to delete the price schedule?????

    ------------------------------
    Lourdes Sobrino
    LU² DSD Puerto Rico
    Guaynabo Puerto Rico
    787.485.9638
    ------------------------------


  • 2.  RE: Customer Price Schedule

    Posted 11-15-2022 10:31
    (Do this in a test company first):
    Dump the table into Excel.  IM_PriceCode
    Reinit the table.
    Re-import the rows you want to keep.

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



  • 3.  RE: Customer Price Schedule

    Posted 11-15-2022 10:53
    I was trying to avoid doing that...................ohhh well.....

    ------------------------------
    Lourdes Sobrino
    LU² DSD Puerto Rico
    Guaynabo Puerto Rico
    787.485.9638
    ------------------------------

    Original Message


  • 4.  RE: Customer Price Schedule

    Posted 11-15-2022 10:57
    For a one-time transition, that is the best way for big changes (unless they are Premium / SQL, where you can delete data through SQL).
    For recurring resets (like resetting pricing by item, or resetting a specific customer's pricing...) button scripts can do that.

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

    Original Message


  • 5.  RE: Customer Price Schedule

    Posted 11-16-2022 09:22
    I posted a way to use a VI import job to delete records in this thread.
    (+) IM_PriceCode_bus doesnt have a delete Function ? - Business Object Interface - Sage 100 - Sage City Community

    You can use ODBC or a flat file as the source and tweak it as needed to delete just the records meeting your criteria.

    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------



Related Content