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

Special Prices depending on Heigth & Witdth

Posted on Aug 01, 2006 at 03:17 PM 9 Views

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

SAP Business One Extensibility
Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    author's profile photo Ibai Peña
    Ibai Peña
    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 comment
    10|10000 characters needed characters exceeded

    • Ibai Peña Former Member
      Aug 02, 2006 at 10:03 AM

      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ñ