Knowledgebase

1. Wholesale cost is the amount you have paid for the item. If it is a consigned piece, the amount is the dollar value paid to the artist when it is sold. A report can be printed to calculate consignee payments. It is not mandatory to have an amount in this field but it is recommended or your inventory value will be incorrect.

2. Markup field will calculate a retail price based on the wholesale cost.

3. Item $ is the retail price charged for the product. If there is a markup entered, then the retail price will be the wholesale cost times the markup. If you do not want the retail price to be controlled by a markup, then blank out the Markup field and enter the retail price.

4. WO$ only applies to artwork in the Products file which was imported into the Work Order file and then updated to a “Framed” item and returned to the Products file using the Convert/Update side bar button in the Work Order file. (See Creating Your Own Readymade Frame, Convert/Update in the related articles at the end of this article). The field displays the retail price of the work order used to frame the artwork. This dollar value is added to the cost of the artwork to obtain a new value (Retail$) for the framed piece now on gallery display. The related work order number appears in #9.

5. Retail$ is the sum of the Item$ field and the WO$ field (if applicable).

6. Discount field is entered as a percentage (e.g. .20 will appear as 20%) and used to discount a sale item. The Sale $ will display the new total. The Retail $, Discount % and Sale $ will all appear on the invoice. Retail items can also be discounted directly on the invoice.

7. Sale $ is a calculated field and cannot by modified manually. The value is calculated by Retail$ minus Discount. If the item has been discounted, the Sale $ will show a different amount than the Retail$. If the Discount field is empty, both fields will show the same amount.

8. Go To Related WO will take you directly to the Work Order file and display the work order identified in the Related WO field.

9. Related WO field displays the number of the work order associated with this item. If the item is artwork which has been framed in the Work Order file and updated to a product using the Convert/Update side bar button, then that work order number will appear in this field.

10. Total Wholesale Cost is a calculated field and cannot be modified. The amount is calculated as: the wholesale cost of the item plus the wholesale cost of the work order (if applicable) multiplied by the yellow quantity IN field.

11. WO Wholesale Cost will be entered automatically when a product is framed and updated. An amount cannot be manually typed in this field unless there is a related work order. The pre-entered amount can be modified. Use the Wholesale Value Calc side bar button to change the % used to calculate the wholesale cost of the work order.