Vendor Selling Price Upload Question

Hello, would like some help/advice.

We uploaded a vendor selling price file into BV and there were about 8000 parts.  We later found out we only use 1000 of the parts therefore the system updated 7000 additional parts.  Is there an easy way to delete the 7000 parts instead of one by one?

If we modify the new selling price file without the 7000 parts, they will still be there because the original file was already uploaded.

Hope it makes sense.

Thank You.

Peter

  • 0

    Hi Peter,

    If I understand correctly, you imported additional parts into Vendor Specific Pricing?

    If so, you can use the Pervasive Maintence tool:

    - Save CUSTPRIC.BTR to sequential file CUSTPRICE.SEQ

    - Open CUSTPRICE.SEQ in Textpad (from www.textpad.com). Do not use Notepad to open the file.

    - Remove the additional records and save file

    - Create CUSTPRICE.NEW

    - Load CUSTPRICE.SEQ into CUSTPRICE.NEW

    - Rename CUSTPRICE.BTR to CUSTPRICE.OLD

    - Rename CUSTPRICE.NEW to CUSTPRICE.BTR

    - Test to confirm that the additional records are not there.

    The instruction on how to use Pervasive Maintenance tool can be found on the KB web site.  KB18257