Object-Type "Header"

Basic definitions such as usage of prices, item designation, miscellaneous information, automatic generation of the configured variant description and data transfer to SAP Business One sales order / quotation can be set up and stored by clicking the header icon (

) in the 1st row of the product configurators with a double-click. Once provided, the text is highlighted in dark gray and bold font in the navigation area. The header should possibly be the item number.

Field

Description

Name

Item name (item number) After calling the Configurator, this name is displayed at the top in the navigation area on the left

Use prices

Disable:

In the configurator you can't see any price. It's only a configurator of the product

The price calculation can be created with the PreCalculation. This make sense for complex products

In Sales Order / Sales Quotation you have the possibility to calculate the price after creating the configuration

config_price_without

Enable:

Enable the internal price calculation and display this in configurator - Area "Result"

config-with-price

Note: For using Price calculation:

- Define default price list

- Activate "Use BP price list", if needed

Testing:

The Configurator is called from Sales order or Quotation. Here all information for price calculation are available.

For testing you must define the Date, Quanitty, Customer and optional Variant
You can define this in the Configurator - Button "Setup"

config-testing

In all Objects you can define the Price calculation in tab "Price"

Config_Object_Price

artikel_produktkonfigurator_detail

Field

Description

Price determination

Value	Description
Formula	Create a formula to calculate the price
Manually	Insert the price manually in the Price field
Price List	Use price from a Price List - Use default price list, defined in Calculation Header - Use a special price list from a customer, if it is activated in the Calculation Header Supports all price list rules, but unit groups are not supported. If you insert [cprice] in a formula, you see the price determination result by Price List in this parameter.
No	Price determination is not activated for this entry.

beas 9.3 PL 2

Price

Use the entered price, if price determination is set to Manually

Item

Choose the item directly or insert a parameter.

For example for the following sofa cushions there are two parameters:

- Cushions Yes/No: whether cushions are needed

- Number of quantity: how many cushions are needed

In Cushion we the price determination is set to No, so it does not affect the price.

In Number of Quantity we define the price by a price list.

Price comes from price list from "SofaCushion" item that was added to the Item field.

Quantity comes from the current "Number of Cushions" parameter (nrcushion), so the [nrcushion] parameter is chosen in the Quantity field.

configurator_pricedetermination

Result:

Beas searches in the price list for the sofa cushion item.

Total Quantity = Quantity from Sales Order / Quotation * Quantity from [nrcushion]

Result = Price from Price List * Quantity from [nrcushion]

Use the Test button in the product configurator definition list to test the setup.

beas 9.3 PL 2

Quantity

Insert a number manually or use a parameter.

Two quantities are calculated:

Required quantity for 1 product (cquantity)

Required total quantity (calculated quantity * quantity from sales order = ctotalquantity)

For an example, see Item.

beas 9.3 PL 2

Script / Formula

If the price is calculated by a formula (Price determination is set to Formula), insert the formula.

The Parameter Insert field provides a shortcut to all available parameters.

If the "[price]" field is in the formula, Beas determines the price using the price list.

See Script Syntax

The following standard parameters are available

Parameter Name	Description
cprice	Price from a price list (only for the Price calculation field)
cpricequantity	Calculated quantity for this item (only for the Price calculation field)
cpricetotalquantity	Calculated quantity * Quantity from sales order / quotation (only for the Price calculation field)
cdiscount	Discount of the current business partner
cpricelist	Price list of the current business partner
currentuser	Current user
cardcode	Business partner from the sales order
cquantity	Quantity from the sales order
cdocdate	Date from the sales order in yyyy/mm/dd format
cshortvariant	Short variant A-Z

The check button

Check for syntax errors in the entered script

Flag

– The rule is error free

– Warning (default)

– Error in rule

Result

Shows the result of the evaluated formula. The result must be a number.

Attention: Price determination by price list is not working here, [cprice] is always 0.

Evaluation of the rule

Shows the evaluated formula with a status message.

Copy result in Sales order

With Beas 9.3 PL2 we inserted many new functionality

But it was not possible to do this with 100% compatibility to old Versions

Beas 9.3 PL 1 and older:

The automatic price calculation functioned in the past as described below:

- A parameter contains an itemcode as the result of a selection.

- If "Price determination" is selected with "Formula" and the formula field has the parameter "[cprice]" or "[cpreis]" with or without

a calculation rule

From Beas 9.3 PL 2

The "automatic" price calculation will be performed if at least one of the following conditions exists:

- checkbox "Use BP price list" ticked or a "Default Pricelist" selected

- checkbox "Use BP total discount " ticked and a pricelist option selected

Use BP price list

Prices are used from the price list of the business partner currently entered in sales order / quotation.

(Selection only possible for "use prices")

Use total BP discount

The defined total discount from business partner master data is considered.

(Selection only possible for "use prices" – NOT for "use BP price list")

Default price list

Select from a default price list. This price list can be changed at any time in the blue "definition" group in the navigation area of the configurator.

(Selection only possible for "use prices" – NOT for "use BP price list"

Main currency

Local currency is displayed in the configurator (e.g. "EUR") as defined in SAP Business One.

(Selection only possible for "use prices")

System currency

System currency is displayed in the configurator (e.g. "EUR") as defined in SAP Business One.

(Selection only possible for "use prices")

Take over price to SAP Business One

Value

Description

No action

Field Price

write the calculated price back in sales document in field "Unit price"

Limitation:

This field must be visible and editable in Sales Document

beas does not write back the currency

beas 9.3 PL 3

Script

Create own script for write information back to SAP Document

(An additional script in the project folder is needed)

Script-for data transfer

To transfer the price or description from the configurator into the SAP Business One form "Customer order"or "Quotation" a script file is used.

This file needs to be created.

Adjust only red lines in order to ensure a correct function.

The created files need to be stored in beas Project-folder.

Name of the file: "product_configurator.src“. The following structure is required:

//********************************************

//* beas product configurator *

//* *

//* Interface definitions for return value *

//* *

//* (c) Boyum IT Solutions GmbH *

//********************************************

//*** initialization of the interface ***

function pk_init

// please, do not change this function part !!!!

setvar=v_pk_init=Y

end

//*** transfer the TOTAL PRICE from the configurator ***

//*** into column 14 of actual line (changeable) ***

//*** to SAP B1 form SALES ORDER or QUOTATION ***

function write_price

// the PRICE is in the beas variable "str_parm.c_parm4"

parent=item=38=col=14=value=<str_parm.c_parm4>

end

//*** transfer the BRIEF DESCRIPTION from the configurator ***

//*** into column 163 of actual line (changeable) ***

//*** to SAP B1 form SALES ORDER or QUOTATION ***

function write_b_descr

// BRIEF DESCRIPTION is in the beas variable "str_parm.s_parm4"

parent=item=38=col=163=string=<str_parm.s_parm4>

end

//*** transfer the DESCRIPTION from the configurator ***

//*** into column U_item_descr of actual line ***

//*** (changeable) ***

//*** to SAP B1 form SALES ORDER or QUOTATION ***

function write_descr

// the DESCRIPTION is in the beas variable "str_parm.s_parm5"

parent=item=38=col=U_item_descr=string=<str_parm.s_parm5>

end

Explanation of assignments:

parent=item=38=col=14=value=<str_parm.c_parm4>

<str_parm.c_parm4> : Parameter with the current transfer value (in this case the price)

col=14 : Field 14 (single price) in SAP Business One-form

col=U_item_descr : UD-Field in SAP Business One-form

(Selection only possible for "use prices")