What are Code Tables?
The program uses code tables to price items either by the united inch or by a fixed size (e.g. 8×10, 11×14, 16×20, etc.) or by a square inch increment. A set dollar amount is associated with the UI and the fixed size measure (the fixed size is referred to as XY). Prices can be modified individually by clicking in the price field and entering an amount. This method provides a way of duplicating previously used charts and other arbitrary pricing schemes. Many framers have developed sophisticated charts or tables to price their frame components. Some of these tables cannot be easily translated into a formula that will work in FrameReady.
This article relates to FrameReady Version 9+
Overview
Note: For purposes of explanation, all reference are in imperial measures. For metric, please substitute as appropriate.
The Code table screen allows you to view which items are being used by that table. Once the code table is created, all the owner has to do is select the code on the item record.
Access: Price Codes file > Code Tables side bar button (bottom left), available for all groups except Moulding.
The following screen appears.
The Code Table title field identifies the code table currently being viewed. Click in the field to provide a pop-up menu to select other code tables to view.
X & Y fields represent the size increments for this table. They usually follow set frame or glass sizes but can also be set arbitrarily depending on what the table is to be used for. If left blank, the program will use the UI fields, but when filled in, the XY fields will have priority. For example a size of 15×21 will price at the 18×24 rather than at 36 UI because 18×24 is the closest fit.
NOTE: when entering the XY values, always enter the smaller value in the X field. Also, the UI fields will auto fill with the combined value of the XY fields.
United IN field displays the United inch (UI)measure. The UI field can be modified or deleted as desired from this screen.
Square IN field displays the square increments may correspond with a specific vendor’s price chart. In order for this to be activated, you must click in the check box in the Code field in the Pricing tab.
Price field shows the amount to be charged for either the UI field or the XY fields to which it corresponds. The amount can be changed by clicking on the field and typing over the existing amount. To change all of the prices in a code table, use the Adjust Current Table by % button.
The Create a New Table button presents a dialog box which allows you to select an incremental template to represent your new table. See below.
Adjust All Tables by % button allows you to increase or decrease all of the code tables by the percentage you wish. Use decimals when entering percentage amount.
Adjust Current Table by % button allows you to increase or decrease the current table you are viewing by the percentage you wish. Use decimals when entering percentage amount.
Duplicate Table button allows you to select any Code Table to be duplicated. This offers a quick way to create highly customized pricing structures by duplicating an existing table then adjusting it by a percentage.
Import Vendor Code allows you to assign a Canadian Vendor price code for use with a single item or a selection.
Printer button prints out the code table currently viewed on the screen in 2 columns per page showing UI / XY and price.
Delete Table button allows you to identify the Code Table to be deleted. A second dialog box will identify the number of records in the Code Table and verify that you do wish to delete the table. Once a table has been deleted, it cannot be retrieved. The deleted code table identifier (e.g. AH) can be reused to create a new table.
Note field is your opportunity to enter something to help you identify the usage of the table. (E.g. 25 cents per UI, Conservation Clear, Regular Mats, etc.) The Note field will display when you click on the Code field in the Price Code screen (all screens except moulding).
Date field should be used to identify when the pricing took effect or was modified. This will serve as a reminder to update your pricing on a regular basis.
Item number, Description, Category fields show the items that are currently using the code table for pricing. If the area is blank, then no items are being priced by this code table.
Creating a Code Table
Code Tables can be used to price items in all groups except Moulding.
- In the Price Codes file, click on the group side bar for which the code table will be used. E.g. Matboard, Glass, etc.
- Click on the Code Tables side bar button.
This will take you to the Code Tables screen which will show current code tables which are available and provide you with the option to create a new one. - Click on Create a New Table button.
- Select a template.
The template determines at which UI measurement the price will increase. Your options are:
• FrameReady Default Sizes (same as UI numbers on the related price sampler)
• Increment by 2, 3, 4, or 6 UI (starting at 18 UI and increases by number shown, up to 200 UI)
• Standard Glass Sizes
• Blank Table - Enter the Price per United IN as a decimal number value. (E.g. $1.00 entered as 1, 10 cents entered as .10) or leave blank.
- Click Proceed.
- Enter a name for the code.
Do not use spaces, dashes, slashes, or a previously entered code name. A code may be alphanumeric. Click OK.
The screen will change to show the table you have created. The date field will automatically be filled with today’s date. It is recommended that you enter a note of your rational or formula for creating this pricing structure in the Note field. - If you chose a blank table, enter your dimensions and prices. When entering the X and Y fields for sizes (Eg. 8 x 10), the United IN and Square IN fields will automatically be populated.
Note: The Square IN column takes precedence over the United IN column. For each price entered on the Code Table, the Square IN column should either be all blank or all filled with sizes. When a size is missing in the Square IN column, it will skip the price for that size. If all of the fields are blank in the Square IN column, pricing is determined by United IN.
Tip: On the last line of your code table, it is recommended that you enter a dimension much larger than anything you carry and enter the price as 9999. This will alert sales staff that the size they entered for this glass type is not available. - You may want to make a printed copy your code table for future reference before exiting the screen. Click the printer icon.
- Click the Done button.
NOTE: You have created a table but NO items are currently being priced by this table. You must apply the code table to an item in order for the item to be priced by the Code Table. Select the preferred code in the Code field under the Code tab.
Applying the Code Table
Access: Price Codes file > group Pricing tab > Code tab.
- In the Price Codes file, find the item for which this price chart will be applied. Eg. Mirror, Canvas Stretching, etc.
- Click on the dark blue pricing tab. Eg. Mounting Pricing, Mat Design Pricing, etc.
- Click in the large pale yellow or white window and select the code you wish to apply to this record from the drop-down menu.
- If you wish to price by the square inch, click in the check box above the large yellow box.
- Click on the Reset button to have your prices appear in the sampler on the right. (If pricing by square inch, the prices will NOT appear in the sampler.)