Customer Price Schedule

I would like to delete the 'Customer Price Schedule' for just 1 customer.  Is there an easy way to do this without having to delete each item individually?

I noticed another reply that mentioned something about script - which is foreign to me and another that would have the price schedule exported to excel & then imported back to the customer.   I just want to completely delete the schedule as it's no longer needed.

Any responses are appreciated.

  • 0

    The way to do this without a script (or manual changes) is to:

    • Export / query the entire IM_PriceCode table to Excel. 
    • Edit the spreadsheet to remove the rows you don't want anymore.
    • Reinit the IM_PriceCode table (which is done using a utility to empty a table completely... use with caution).
    • VI import to bring in the edited spreadsheet data.

    Try this in a test company first to make sure you get the results you want (and that your VI import works properly).  The IM_PriceCode table includes different types of pricing data.  Only remove what you specifically want to remove, and import everything else back into the table after a reinit.

    Or, if you are on Premium, you can just remove the rows in SQL, but with Advanced / Premium the available data tools (DFDM) are significantly less powerful.