In this Article: Show
A common error message when opening FrameReady is a dialog that states:
There are ## records that are missing a pricing formula. A default formula will now be applied to these records.
This error message is trying to alert you to a potential loss of income. The items shown do not have a markup and may have a retail price of zero when you enter them on a Work Order.
Clicking the OK button may not solve the problem.
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.
Log in as level4.
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)?
If any of the records are completely blank (no prices, no item, no supplier, etc.), then you can delete them.
Take a look at the three blue wholesale cost fields: Cost (Length), Chop and Join.
If all three fields are empty, you need to enter the amount(s) manually.
Alternatively, these records may reflect unused or old discontinued items (which you can delete.)
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) indicate how you will order the moulding.
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).
If valid amounts appear in the three blue wholesale cost fields for Length, Chop and Join, then the problem may be the markup.
Click the Frame Pricing tab.
In the Formula tab you should see the calculated markup displayed, e.g. Markup = 3.2.
If it reads, Markup = 0, then the formula needs to be adjusted. (See Solution A below)
If it reads, Markup = ?, then there is an error in your formula. (See Solution C below)
It is always best to have all three price options (Length, Chop, and Join) covered in your 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 blank 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.
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.
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, 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.
If you need any assistance with this, please contact Tech Support at 888-281-3303 or through our website www.frameready.com.