We have a crystal report that generates a master vendor cost report for our sales department. We just noticed that on some items there is OLD pricing data showing on the report. We discovered this is happening because when you remove a vendor from an inventory item, it doesn't delete that vendors originally created "Vendor Pricing" record.

When removing a vendor from an item in inventory (Vendor Item Maintenance windows), the system should ask you if you also want to to remove the corresponding "Vendor Pricing" record in the PO_Vendor_Price_level table. In order to remove the pricing you currently have to go into pricing level for vendor and then delete it and then delete the vendor from item.

by: Kevin T. | over a year ago | Sales & Distribution