Missing Markups

A common error message when opening FrameReady is a dialog that states "There are ## records that are missing a markup. Click "OK" to apply a default formula to these records?"

  • There are ## records that are missing a markup. Click "OK" to apply a default formula to these records?

  • The items in the list do not have a markup and may have a retail price of zero when you enter them on a Work Order.

  • This error message is trying to alert you to a potential loss of income.

Clicking the OK button may not solve the problem.

What to do when this Error Message Appears

You are given the options of Cancel and OK. If you have clicked OK and still receive this message when opening FrameReady, use the following instructions.

  1. Log in as level4.

  2. Click Cancel and take a closer look at records on screen. Basically, there are two things to check for:

    • Are there wholesale costs in the blue fields for Length, Chop and Join?

    • Is there a Markup Formula under the Frame Pricing tab (in the Form View)?

Yes, there are Blank Records

  • If any of the records are completely blank (no prices, no item, no supplier, etc.), then you can delete them.

Some of the Wholesale Costs are Empty

  • Take a look at the three blue wholesale cost fields: Cost (Length), Chop and Join.

  • If all three fields are empty, then you need to enter the amount(s) manually.

  • Alternatively, these records may be unused or old discontinued items -- which you can delete.

No Wholesale Cost Field for Selected Cost Type

Price Codes > Moulding sidebar button > Auto Inv tab

  • When viewing a record (form view) in your Price Codes, the Order this item as radio buttons for Length, Chop and Join (under the Auto Inv tab) determine how this item is ordered.

  • If there is an amount in the blue Cost (length) field for the Cost Type you have selected, then it is possible that you have only one option in your pricing formula but it is set to a different Cost Type.

    For example, your markup formula may simply say, “Chop * 3.2”. However, if the blue Chop field is blank, then FrameReady cannot do the math to calculate your retail price. (See Solution A below)

  • If the blue Cost (length) field is blank for the Cost Type you have selected, then examine your formula. In some formulas, your price is dictated by which Cost Type radio button is selected.

    For example, select Length and you are pricing by Length. Select the Chop circle and you are pricing by Chop, and so on. (See Solution B below).

The Wholesale Cost Fields Have Values

If valid amounts appear in the three blue wholesale cost fields for Length, Chop and Join, then the problem may be the markup.

  1. Open the blue Frame Pricing tab.

  2. In the Formula tab, you should see the calculated markup displayed, e.g. Markup = 3.2.

  3. If it reads Markup = 0, then the formula needs to be adjusted. (See Solution A below)

  4. If it reads Markup = ?, then there is an error in your formula. (See Solution C below)

Solutions for Markup Formula

Solution A

  • It is always best to have all three price options (Length, Chop, and Join) covered in your pricing formula.

  • If your formula only covers one pricing option, e.g. Chop, and the supplier does not provide that wholesale cost, then FrameReady cannot calculate a retail price (this is because zero times any number is zero).

  • Instead of having only one option, e.g Chop * 3.2, be sure to cover all possibilities, i.e.

 Case( 
 Chop * 3.2; 
 Join * 2; 
 Cost * 5) 

  • In the above example formula, FrameReady looks first in the Chop field. If it does not find a wholesale cost there, it moves to the next field on the list (in the example it is Join). It continues until it finds an amount in one of the fields.

Solution B

  • In some formulas, your price is dictated by which Cost Type circle is marked.

    For example, Select the Length circle and you are pricing by Length. Select the Chop circle and you are pricing by Chop, and so on.

  • One solution is to mark the Cost Type circle of the blue Cost field which has an amount entered.

    For example, if you have selected to price by Length but only the Join cost is available from the Supplier, then mark the Cost Type as Join.

Note: on the Purchase Order, the item will be ordered as a Join frame. You can change the selection on the Purchase Order.

Solution C

  • Check first to make sure that the punctuation at the end of each markup is a semi colon (;) and not a colon (:).

  • Make sure there are an equal amount of opening and closing brackets or parenthesis.

  • Numbers should never end with a period, e.g. 2. Instead, always use  2  or  2.0  in your formula.

  • If all of these seem correct in your formula, then click the Enlarge button (below the formula in the blue Frame Pricing tab) then click the Email to Tech Support button. If you do not have email set up with FrameReady, then copy the formula and paste it into an email.

Your Pricing is Important

If you need any assistance with this, please contact Tech Support at 888-281-3303 or through our website www.frameready.com.

 

© 2023 Adatasol, Inc.