Product Configurator Result/Price snapshot

Respondida

Support

• 22 de octubre de 2019 02:32

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?

Vote

1

• Comentario oficial

  

  Martin Heigl

  • 22 de octubre de 2019 03:25

  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

Iniciar sesión para dejar un comentario.