Bulk Supplier Buy Price Amendments

Bulk Supplier Buy Price Amendments

Question/Problem

Requirement to update all stock buy prices from a specific supplier.

Solution

This is something likely to affect all businesses from time to time and can be completed by following the steps:
  1. Go to [Reports | Ad-Hoc Reports] and select the System - Products followed by System - Stock Suppliers.
  2. Open the Products report.
  3. Delete all columns except the following:
    1. CONTROLLED
    2. STOCK_CODE
    3. SHORT_DESC
    4. STOCK_TYPE1
    5. STOCK_TYPE2
    6. BUY_PRICE
    7. SELL_PRICE
    8. TAX_CODE
  4. Add 2 new columns (Case sensitive)
    1. Supplier:COMPANY_CODE
    2. Supplier:PURCHASE_COST
  5. Open the Stock Suppliers report.
  6. Filter this to only show the suppliers you are interested in.
  7. Use this filtered information and use the STOCK_CODE field as the cross reference.
  8. Update the Supplier:COMPANY_CODE & Supplier:PURCHASE_COST columns on your products sheet as required.
  9. When you have finished editing prices save your Products report as "Text (Tab Delimited)" and you can then import it in to KCC as normal using the Stock Data Import feature.