Price Codes

Matboard Pricing Options and Defaults

Price Codes > Matboard sidebar button > Matboard Pricing Tab > Pricing Options and Defaults Button

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, such as a new matboard, it needs to know what pricing formula to apply to that particular record.
FrameReady searches the Pricing Options and Defaults file for a Default Record which describes and instructs FrameReady on how to price the item.

It is important to understand and properly set up the Default Records.

Open the Price Codes file, switch to Matboard (form view) and open the Matboard Pricing tab.
Click the Pricing Options and Defaults button.

The Pricing Options and Defaults window appears.
In this screen you will see numerous Pricing Records, on alternating colored rows, going down the screen.

Each record (or row) consists of the Markup, Set Price, Minimum Price, Code, Area unit, Combination box and Default selection boxes. These can be divided into three parts:
- The part which determines the price to be calculated: Markup, Set Price, Minimum 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.

The New Record button creates a blank record at the bottom of the screen for you to fill in. If one is created in error, use the Delete button to remove it.

Find provides 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.

Done returns you to the Price Codes file and the matboard record you were previously viewing.

Show Defaults Only is both a heading and a button (that’s why it is underlined). When clicked it finds all records selected as Default.

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 as a number not a decimal, e.g. 3 not 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 keyword “Dimensions”.
The Set Price field is a fixed dollar amount added to the calculated retail price of a matboard. Set Price can be entered as a number or a formula; it is consistent regardless of the size. Use it to ensure your wholesale cost is covered by a specific size, e.g. 16×20, or used to cover shipping costs, or damage.
The Minimum Price field.
The Code field allows you to specify a Code Table or a series of Code Tables based on a series of cost increments.

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.

The Combine Formula and Code Pricing checkbox 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.

The Enlarge button takes you to another screen where the Formula and Set Price are 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 the FrameReady Team for tech support.

Click the Select button to apply the formula to the matboard record that you were previously viewing in the Price Codes file.

The Apply to Group button presents a dialog box where you can apply the formula to a select group of records.

Click the Duplicate button to create a duplicate record which you can then modify for a different group, size, or supplier.

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 list determines which records will have the Pricing Formula applied it.

The Dimensions field allows you make a Pricing Formula size-specific.
If the dimensions field is left blank, then the pricing default will be applied to all sizes belonging to the selected group(s).

Supplier fields allows you make a Pricing Formula vendor-specific.

For example, 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 supplier field is left blank, then the pricing default will be applied to all suppliers with items belonging to the selected group(s).

For any given Group (Metal, Wood etc.) there should always be at least one default generic record, i.e., the Supplier field is left blank.

Use the Omit Category field (optional) to exclude items belonging to a specific category.

When you click the Lookup My Default button (located on the Matboard Pricing tab), it pastes 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 is applied to all new moulding records for that vendor.
If the Default checkbox is not selected, then the formula is not be applied to any records. It is then simply a pricing option that you may chose to use at a later date.