The following instructions assume that the user already has a query set up on the product table that prompts for the vendor code and fist few letters of the vendor SKU as filters for the query. More information on setting up queries may be found in chapter 13 of the MicroBiz user manual 

1) Run a query to create the import template

Tools>>Query Records>>Data Dictionary

Select product data dictionary from the dropdown box in the lower right hand corner

Tools>>Query Records>>Query Manager

Select the last cost query

Click Run Query

At the prompts, enter the vendor and vendor id parameters

2) Open the template on the desktop in Excel and make the changes

Click on the icon labelled "qmf_te"

Make the changes that are needed in the last_cost column

Save the template as a CSV(MS-DOS) type file

3)Run a backup of the MicroBiz data

Have all users come out of MBZ

Management>>Custom System Settings>>Global Store Settings

Backup Now

4)Run the import

Make sure all users are still out of MicroBiz

Tools>>Update Item Records via CSV file

Navigate to the CSV file that you just saved to the desktop.