Ability to change the Extend Price Calculation in Order Entry

Posted By DynamicDrinks2 over 8 years ago

Hi,

Is it possible to change the Extend Price Calculation in Order Entry?

Right now, our products are sold by the item number and the length. For example, a wood pole may have an item number called,"WP". We cut the WPs based upon the customer's request. In Sage 300, we have to create a new item number for every length. This creates several item numbers in our system. Right now we have WP1 to WP50 for each length we cut the WPs. The number represents lengths from 1 foot to 50 feet. In our system, we show 50 items, but we really only have 1 item that we cut to order.

To make it easier, we would like to create a custom field 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?

Any Suggestions would be appreciated.

0 Jay Converse Acumen over 8 years ago

No, you don't "have to crate a new item number for every length". Set the stocking unit to the lowest common unit, i.e., Inch, then price by the inch, sell by feet, and the math is automatic.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 DynamicDrinks2 over 8 years ago in reply to Jay Converse Acumen

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jay Converse Acumen over 8 years ago in reply to DynamicDrinks2

Yes, it will work perfectly. Use multiple units of measure. Inch is the stocking unit, but 10 feet is the selling unit, with 120 as the conversion factor. Make as many selling units as you need.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 DynamicDrinks2 over 8 years ago in reply to Jay Converse Acumen

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jay Converse Acumen over 8 years ago in reply to DynamicDrinks2

I'm waiting for your lightbulb to turn on. You can also price by the foot. It's the same theory as stocking by each, and selling by the case. Or the pallet.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 DynamicDrinks2 over 8 years ago in reply to Jay Converse Acumen

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Paul2 over 8 years ago in reply to DynamicDrinks2

Yes, there is a way to create a custom field called LENGTH and use it to calculate the extended price. It's called Unit of Measure inside the software.

I recommend you try Jay's suggestion before dismissing it. You might find it works quite nicely for you. If after trying it you don't like it then feel to ask for other suggestions.

If it was me, I would utilize Jay's suggestion: He's pretty good with this software!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 DynamicDrinks2 over 8 years ago in reply to Paul2

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Paul2 over 8 years ago in reply to DynamicDrinks2

There's no way to see the calculation on the screen unless you buy a custom programmed screen. The only way you can have the calculated extended price using the method you desire is to do the calculation in the Crystal Reports Invoice form.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ettienne Schwagele over 8 years ago in reply to DynamicDrinks2

You can't - unless you write your own order entry program.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 DynamicDrinks2 over 8 years ago in reply to Ettienne Schwagele

Thank you. That is what I needed to know.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jay Converse Acumen over 8 years ago in reply to DynamicDrinks2

But you don't need a custom field, you're making this too hard. Oh well, it's your money.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Paul2 over 8 years ago in reply to Jay Converse Acumen

I wasn't prepared to fight someone's preconceived idea of how to solve the problem. If they aren't willing to try other options that's their choice.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Shane - Ascend Business Solutions over 8 years ago in reply to DynamicDrinks2

A potential simple solution to meet the display requirements would be to setup to sell by the foot then train staff to enter a comment indicating the formula you wish to display.

Additionally - I have a client who sell countertops by the linear foot. They have a challenge of knowing what's in stock by length. For example - they might have 50 feet in stock, but there was no way of knowing what the lengths were. To resolve this, they deployed Lot Tracking. With a tweaked report and finder, they were able to track with much less effort.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

Ability to change the Extend Price Calculation in Order Entry

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING