The Product List worksheet contains the following fields as detailed information about each product or service available in the system.
| Product List Fields | Description |
|---|---|
| Product_Id | The unique Product Id assigned when a product is added to the system. |
| Product_Name | A short name used to uniquely identify a product or service in the system. Used on the Order Form worksheet to select products or services for an invoice. |
| Product_Description | A longer description of a product or service. Automatically added to the Order Form worksheet when a product or service is added to an invoice. |
| Default_Quantity | The default quantity to include on an invoice when the product is added. Will appear in the Quantity column on the Order Form worksheet and can be changed for each invoice after adding the product or service. |
| Product_Price | The per unit price for product or service. If the Default_Quantity is greater than one (1) unit, the Product_Price will be multiplied by the default quantity to create the Item_Total on the Order Form worksheet. |
| Product_Cost | The per unit cost of the product or service. |
| Vendor_Name | The name of the vendor providing the product (if applicable), from the Vendor List worksheet. |
