Price Codes
Price Moulding by Join but Order it by Chop (or Length)
FrameReady formulas offer the flexibility to price moulding by one method (join) yet order your moulding by another (length). You can set up your pricing so that it remains consistent on the Work Order -- even if you change your method of ordering directly on a Work Order.
-
The advantage of this method is that the retail price per foot will always remain the same, regardless of how you order the moulding.
-
Your price remains consistent, even if you change how it is ordered on a Work Order.
Use the Correct Type of Formula
Caution: The Default Pricing Formula cannot be used because "Order Type" is part of that formula. You must use a different formula.
If you are using the FrameReady Default pricing formula, then your pricing is determined by the Order Type field -- and you cannot override it because the Order Type is part of the formula. Instead, you must use a different formula.
There are a few different ways to set up your pricing formula so that you can price by one method and order by another. The formula in this example is very simple:
Option #1
-
Use a simple pricing formula, for example, Join * 2 . This means that only the Join price is used to calculate the retail price and you are free to set theOrder Type to, for example, Chop. FrameReady will only use the Join cost.
-
However, this formula only works if the supplier provides a Join wholesale cost. If not, then your retail price will be zero. This formula does not leave any margin for error.
Option #2
-
Use a slightly more complex formula, such as:
Case(
Join > 0; Join *2;
Chop > 0; Chop * 3;
Cost > 0; Cost *5) -
In this example, notice how we are using all the price variables. Because Join is listed first, it has top priority. However, because we added Join>0 this means that there must be a quantity greater than zero in the blue Join wholesale cost field. So, if the Join field is empty, then FrameReady goes to the next line: it looks for the Chop wholesale cost. And if it is empty, then the Length cost is used.
Buttons Explained
Order This Item As Radio Buttons
-
Use the Order This Item As field to identify how you want to order each individual moulding.
-
The three radio buttons; Length, Chop and Join allow you to order your product as length moulding, chopped moulding, joined or closed corner frame regardless of how you may wish to price your frame (except when using the Default pricing formula).
-
If you are using the FrameReady Default pricing formula, then your pricing will, in fact, be determined by the Order Type radio button. If you change the Order Type field, then the Retail Price per Foot also changes. Therefore, the Default formula will only price moulding by your method of order and cannot be used for the pricing option described above this note.
Apply Order Type to Group Button
-
Use the Apply Order Type to Group button to set this value across a group of records; it changes the Order Type.
-
Depending on your formula, this action could change the retail price of your records.
How to Apply an Order Type to a Group
-
Click the Apply Order Type to Group button.
-
A dialog box appears.
-
Option 1: Select the Cost Type you wish to use when ordering all your moulding.
Click the Length, Chop or Join button. -
Option 2: Select the Cost Type (Length, Chop, or Join) and then select the Supplier and/or Group you wish to use.
Leave the Group field blank to apply to all Groups.
Formula
Price by Join and Fallback to Chop or Length
Copy and paste this Formula into FrameReady:
Round(
Case(
Join>0; Join * 2;
Chop>0;
Case(
Chop<5; Chop * 2.85;
Chop<10; Chop * 2.8;
Chop<15; Chop * 2.75;
Chop<20; Chop * 2.7;
Chop<25; Chop * 2.65;
Chop * 2.6);
Cost>0;
Case(
Cost<2.50; Cost * 5;
Cost<3.75; Cost * 4.9;
Cost<5.00; Cost * 4.8;
Cost<6.25; Cost * 4.7;
Cost<7.50; Cost * 4.6;
Cost<8.75; Cost * 4.5;
Cost<10.00; Cost * 4.4;
Cost<11.25; Cost * 4.3;
Cost<12.50; Cost * 4.2;
Cost<13.75; Cost * 4.1;
Cost<15.00; Cost * 4;
Cost<16.25; Cost * 3.9;
Cost<17.50; Cost * 3.8;
Cost<18.75; Cost * 3.7;
Cost<20.00; Cost * 3.6;
Cost * 3.5))
,1)
x
