Skip to Content
author's profile photo Former Member
Former Member

Special Prices depending on Heigth & Witdth

Hy all,

We have the following problem : we want to get prices for items depending on the Height and the Witdth of the item (in a purchase order).

How can i proceed to get this prices with formatted search when creating the pruchase order ??

Thank for your help.

Message was edited by: CHRISTOPHE LUTZ

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Aug 02, 2006 at 06:48 AM

    Hi Christophe,

    I think the price calculating problem is too complex to solve it using formatted searches. With formatted searches you are only able to get the SQL executed when 1 event is raised (field change). But for this scenario, the result value depends on more than one field (Item, height, width, ¿Quantity?... ).

    That´s why I recommend you not to try to solve it this way. Unless you say to the customer he has to push Shift+F2 for each document line.

    Regards,

    Ibai Peñ

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      Depends on what you are able to deal with the customer.

      I think best solution is to catch the validate event of the fields which are needed to calculate the right price (Item Code/Item Name,quantity, weith, width...), calculate it (SQL or whatever), and set it into the price field.

      If you are not going to let the user change the calculated value manually, another option could be to put a button on the form that will recalculate the price for all the items on the document. This would have better performance, but needs more work from the customer, and is less flexible.

      Hope helps,

      Ibai Peñ

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.