In this Article: Show
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.
Use the Order This Item As field to identify how you want to order each moulding.
Use the Apply Order Type to Group button to set this value across a group of records.
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:
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 the Order 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.
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.
In this example, we are ordering by Length. Notice how the Markup = 4.3736. This is the number necessary to have the retail price equal 3.98 (which is the amount calculated by Join * 2).
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.
Change the Order Type for a selected group of records. Depending on your formula, this action could change the retail price of your records.
Option 1: Select the
Cost Type you wish to use when ordering all
your moulding. Click Length,
Chop or Join.
FrameReady may take a few moments
to update all records.
Option 2: Select the Cost Type and then select the Supplier and/or Group you wish to use. Select Length, Chop or Join. Select a Supplier and/or Group (leave Group blank to apply to all groups.) Click Apply.
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)