The Pricing Options and Defaults screen is a separate file used as a reference for vendor price updates and for storing your own unique formulas. When FrameReady imports a new vendor record it needs to know what formula to apply to that particular record. It searches the Pricing Options and Defaults file for a default record. Therefore, it is important to understand and set up these default records properly.
To get to the following screen, go to the Price Codes file > Matboard side bar button > Matboard Pricing tab > Pricing Options and Defaults button.
1. In the Pricing Options and Defaults screen there are numerous Pricing Records on alternating pink and grey blocks going down the screen. The each record consists of the Markup, Set Price, Code, Area unit, Combination box and Default selection box. These can be divided into three parts. The part which determines the price to be calculated: Markup, Set Price and/or Code. The part that governs how the area will be priced: UI Area, Square Inch, etc. And, the part which governs when and if it will be applied: Default.
2. The Markup field can have a formula entered into it or simply the markup to be used for this pricing option. If you are entering just the markup, be sure to enter the markup in a number not a decimal. E.g. 3 or 3.0 If you are entering a formula, you must identify the cost field as “Cost”. Your formula can also differentiate between matboard sizes by using the word “Dimensions”.
3. The Set Price field becomes a fixed dollar amount which is added on to the calculated price of a matboard. It can be entered as a number or a formula. The set price is consistent regardless of the size. It can be used to ensure your wholesale cost is covered by a specific size, e.g. 16×20, or used to cover shipping costs, or damage.
4. The Code field allows you to specify a code table or a series of code tables based on a series of cost increments.
5. The Combine Formula and Code Pricing check box is used in special circumstances where neither a formula nor a code table will work but a combination of the two will. An example of this is a fabric wrapped mat where the fabric is priced by the linear yard and the mat or substrate on which it is wrapped is priced by a code table.
6. The Area unit allows you to select how the pricing formula will be applied to the matboard. For example, if you want to price by the square foot as opposed to the square inch you can specify that here.
7. The New Record button will create a blank record at the bottom of the screen for you to fill in. If this was created in error, use the Delete button to remove it.
8. Find will provide you with an Enter Search Criteria Screen to find one or more pricing records by whatever criteria you enter. Click the Find button on the left side of the screen or press the Enter on your keyboard to perform your find.
9. Show All will display all of your pricing records in a list view.
10. Done will return you to the Price Codes file and the matboard record you were previously viewing.
11. Default Use Only is both a heading and a button (that’s why it is underlined). When clicked it will find all records selected as Default.
12. The Default check box appears on all records but is only applied if an X appears in the box. When the Default check box is selected, a Group list, Dimensions field, and Supplier field appear below it. The group governs which records will have the Pricing Formula applied it. The Dimensions field and the Supplier fields allows you make a Pricing Formula size and vendor specific (i.e., when a vendor pricing update is performed and new records are imported to the Price Codes file, the program will search for a vendor specific default record before applying a generic record). If the dimensions and supplier fields are left blank, the pricing default will be applied to all sizes and all suppliers with items belonging to the selected group(s).
Important: For any given Group, there should always be at least one default generic record (i.e., the Supplier field is left blank).
When is a Default record used?
• When you click on the Lookup My Default button (located on the Matboard Pricing tab), it will paste the appropriate pricing default into the formula and set price fields for the item you are currently viewing.
• When you download your Vendor Pricing Updates, your default selection will be applied to all new moulding records for that vendor.
If the Default checkbox is not selected, then the formula will not be applied to any records. It is simply a pricing option that you may chose to use at a later date.
13. The Enlarge button will take you to another screen where the Formula and Set Price and will be the only items on the screen. This provides you with more room to view longer formulas. The screen also contains a button to enable you to send your formula, by email, to Adatasol Inc for tech support.
14. Click the Select button to apply the formula to the matboard record that you were previously viewing in the Price Codes file.
15. The Apply to Group button presents a dialog box where you can apply the formula to a select group of records.
16. Click the Duplicate button to create a duplicate record which you can then modify for a different group, size, or supplier.
17. Use the Delete button to remove any unwanted Pricing Formula records.