x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 14 replies
  • Subscribers 104 subscribers
  • Views 5175 views
  • Users 0 members are here
Browse Forums
Announcements
271
topics
260
replies
Databases and Operating Systems
764
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
852
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
877
topics
3k
replies
Sage CRM for Sage 300
183
topics
415
replies
DynamicDrinks2

Ability to change the Extend Price Calculation in Order Entry

Posted By

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.

Parents
  • 0
    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.
  • 0 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.

  • 0 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.
  • 0 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.

  • 0 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.
  • 0 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.

  • 0 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!
  • 0 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.

  • 0 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.
  • 0 in reply to DynamicDrinks2
    You can't - unless you write your own order entry program.
Reply Children

*Community Hub is the new name for Sage City