Page 1 of 1
Spool price list to Excel
Posted: Mon Jan 16, 2006 10:28 am
by Lawrence Lai
I would like to spool from Capital in Excel format a price list for a customer showing
List Price
Discount $ or %
Net Price
for all the products
Pls advise how this can be done
Posted: Mon Jan 16, 2006 10:33 am
by COBS Tech Support
There are several ways you might do this.
1. Locate the file STOCK.DBF (your primary inventory file) using Explorer and drag & drop this file onto your Excel desktop icon. This should load the inventory file in Excel. Remove any columns you do not need.
CAUTION: Before making any changes, immediately save your spreadsheet under a different file name to ensure that you do not save the altered file back into your database, which would damage your data.
2. Use the Catalog Wizard if you have the Enterprise Edition or above, select the fields you want to export and click on the OfficeLink output option.