Thanks for the response, but that will not work for us since we may sell 5 WPs at 10 feet. If we put 50 feet, it will confuse the customer since they will think it is only 1 WP at 50 feet. On the invoice, we want it to show 5 WPs at 10 feet each for $3 each foot = $150 Ext Price.

Thanks, but I don't think you and I are on the same page.

How would you show 5 pieces of WP cut 10 feet long at $3 per foot on an invoice? I need all 3 components to show on the invoice.

I understand your suggestion, but then we would have to create a UNIT of measure for each measurement. If we did this, we would have to create 1 to 50 feet and any custom measurements such as 3.25 feet, etc.

We are looking for a solution where we can manually enter the quantity, length, and unit price on the fly. We want it to be very simplified for our sales people without having them add or modify any UNITS of MEASURE. We are more concerned with the ease of use of taking the order.

Is there a way to create a custom field to called LENGTH. We then would like to take that field and use it in the Extend Price Calculation. For example, the standard calculation is QTY * PRICE = EXTENDED PRICE. We want to change it to QTY * PRICE * LENGTH = EXTENDED PRICE. Is this possible? If so, does anyone have recommendations how to do this?

We are not looking for a workaroud, but want to do it this way.

I understand your suggestion, but then we would have to create a UNIT of measure for each measurement. If we did this, we would have to create 1 to 50 feet and any custom measurements such as 3.25 feet, etc.

We are looking for a solution where we can manually enter the quantity, length, and unit price on the fly. We want it to be very simplified for our sales people without having them add or modify any UNITS of MEASURE. We are more concerned with the ease of use of taking the order.

Is there a way to create a custom field to called LENGTH. We then would like to take that field and use it in the Extend Price Calculation. For example, the standard calculation is QTY * PRICE = EXTENDED PRICE. We want to change it to QTY * PRICE * LENGTH = EXTENDED PRICE. Is this possible? If so, does anyone have recommendations how to do this?

We are not looking for a workaroud, but want to do it this way.

Thank you for your suggestions. I appreciate the suggestions and I am sure it will work in most cases but we do not want our sales people creating the units of measure since there will be too many units of measure to create. The other issue is that you cannot create a UNIT of MEASURE on the FLY if we wanted to do this, but ideally, we do not want sales people creating any new units of measure. We also do not want to create all the possible combinations either.

All the responses are appreciate and I hope I am not offending anyone. The owner wants what he wants. I hope you can understand where I am coming from. If there is a better way without doing any additional steps, it would be appreciated.

Ideally, we feel we just want the custom field to be part of the calculation to create the extended price. Any instructions would be appreciated.