BoostExcel main content
Thewindow provides a number of fields that you may optionally store data in. The only required field on this window is the field. However, you will want to fill in other fields like price, and stock if applicable.
First, let us look at the Command List bar.
|Whenever you edit or add a product you want to be sure to save your changes!
|Deleting a product totally removes the product record from the database. This does not affect previously created invoices.
|By default, the product cost of an invoice item is set to the cost value of that product when you create an invoice, and the total cost of the invoice is calculated based on that cost. However, you can use this button to update all invoice items related to the product and to set their cost value to the product's current cost.
|This button displays thewindow where you can add, edit, and delete product categories.
|This button displays thewindow where you can create new reports.
|Reload data from the database. This command is used basically in a network environment where multiple users open the same database. You can use this button to refresh data modified by other uses.
Below is a description of some important fields on thewindow.
|The category field helps you organize products. Click thebutton on the Command List bar to manage categories.
|The ID value uniquely identifies a product. This value is generated automatically if left blank.
|The product's description is the only required information you must enter. It is a free-form text field.
|Potential values areand . Only active products will be displayed when you click the icon button on the worksheet.
|Is a service
|Check this box If you do not maintain a physical inventory for the product.