x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 28 subscribers
  • Views 4018 views
  • Users 0 members are here
Browse Forums
Announcements
19
topics
3
replies
General Discussion
789
topics
1k
replies
victord66

Is there a quick way to delete CSP ?

SUGGESTED
Posted By

I have a customer who has customer specific pricing on over 300 items.   Is there a quick way to delete them?    Otherwise I must do them one at a time in the customer file.   What if I imported a csp of zero?

Thanks.

  • 0

    If you look in the data directory you may find a file called CUSTPRIC.BTR. I think this MAY contain the CSP data. Rename this file and copy a blank one from a new data folder and see if all the CSP disappear.

    If you have any VENDOR specific prices, you will lose this info as well.

  • 0
    SUGGESTED

    I have found the cleanest way to do it is to export the file into excel.

    Elimiinate the customers other that the one you are working on. Then set the Delete after expiry flag to yes.  Change the expiry date to any date before current.  Reimport the customer pricing.  NExt time you open the customer file, BV will remove prices for you.

*Community Hub is the new name for Sage City