Product Configurator Result/Price snapshot Answered

Support

We would like to display the chosen Configuration options and their prices on Sales Order and Work Order Documentation.

It would be great if the data on the Result\Price page of a configuration was snapshot into a table that could be queried to view the selected configuration and pricing for an order. 

The table would have the following fields

  • SalesObjType 
  • SalesObjKey
  • SalesObjLine
  • ConfigurationID
  • Item
  • Description
  • Price

This would allow flexible reporting of chosen configuration options wherever required.

In the interim, does anyone have sample scripts they're willing to share that scrape the data from the window?  I was thinking of either inserting the data into a custom table or at least building up a Text string with the contents.  Is it possible to capture events and execute scripts against the product configurator window?

Comments

1 comment

Date Votes
  • Comment author
    Martin Heigl
    • Official comment

    Hi,

    we don't deliver this in standard or is current not planned

    as customizing this is possible. We've an event which is called, if you open this page

     

    Here the Script

     

    windowevent post_result

    // configurator saved?
    if <str_parm.c_parm1> n<= 0 then
      return failure
    end if

    // Name of Tables with fields "ConfigurationID","ConfigurationLine","Item","Description","Price"
    // Primary key = "ConfigurationID","ConfigurationLine"
    setvar=ls_table=ConfigMirror

    // Delete old entries
    sql=delete from "<ls_table>" where "ConfiguraitionID "= <str_parm.c_parm1.#0>

    // Insert all lines
    for ll_row=1 to dw_2.rowcount>
      sql=insert into <ls_table> ("ConfigurationID","ConfigurationLine","Item","Description","Price") &
        values <str_parm.c_parm1,#0>,<ll_row>,&
        <dw_2.item.parameter:[ll_row].value,dbstring>,&
        <dw_2.item.inhalt:[ll_row].value,dbstring>,&
       <dw_2.item.prreis:[ll_row].value,num(6)>)
    next

    end event

    I didn't checked this script. It's only an example how you can solve this with beas script

Please sign in to leave a comment.