demandPlus+

⌘K
  1. Home
  2. Docs
  3. demandPlus+
  4. 19*
  5. Post Calculation
  6. Schema Templates

Schema Templates

With the help of the schema templates you can predefine schemas and apply or store them at the different schemas.

Row Layout

The row layout contains the actual calculation.

 

Here you can create completely individual schemas for your needs.
The following table provides an overview of the different totaling types.

Totaling Type Description
” “ The “empty” totaling type allows to work without row no.. This allows, for example, to assign “headings” for the upcoming lines.
Formula With a formula you can e.g. summarize, multiply etc. individual lines. The following operators are available:
Addition ( + ), subtraction ( – ), multiplication ( * ), division ( / ), power ( ^ ).
Value With a value you can give a fixed value to a line. e.g. 500
Item Summarizes all items of the calculation, taking into account the stored filters.
Work Center Summarizes all wok centers of the calculation, taking into account the stored filters.
Machine Center Summarizes all machine centers of the calculation, taking into account the stored filters.
Individual Surcharge You can assign individual surcharges for items, wok centers and machine centers. To do this, you must enter the row no. of the corresponding line for which you want to assign an individual surcharge in the “Formula field”. Individual surcharges are stored in a separate table.
Sales Summarizes all calculated sales. See sales

Filter
For items, work centers and machine centers you can store as many filters for the line as you like.

A filter can be stored for each field. The filtering is taken into account when evaluating the schemas. You can only pass filters where data records exist in the system. This prevents you from entering the wrong filters and causing problems when evaluating the calculation.

Column layout

In the column layout you can define your own columns.

The following table describes the associated fields:

Field Description
Columnno. Unique no. for the column. If the column is used in a scheme, the column is automatically incremented and renamed if necessary. The fields for this can be found in the demandPlus+ Setup.
A new column is created for each lot size. In the template, you only need to create one column for it.
Description Here you can enter a description for this column. Make sure that in case of several lot sizes the column automatically appears once for each lot size in the scheme. If there is a %1 in the description, it will be replaced by the lot size in the scheme. So e.g. lot size 10.
Column Type Deviation: If you store a deviation in the column type, deviation columns will be created for the associated columns that are stored in the formula.
Formula: You can create individual columns that do not have the calculation as a basis, but other columns.
Amount Type The amount type specifies the prices/costs you want your schema to be filled with.
Formula The formula field is used to link individual columns. A formula must not refer to deviation columns.

Individual surcharge

The individual surcharge is a possibility to individually value single (or several) items, machine centers or work centers.
Via the search you can find the precalculation surcharges

In principle, 3 “areas” must be distinguished. The following table lists the hierarchy for the surcharges.

Area Hierarchy (Descending) – corresponds to the “Type” field
Item Item, Item Category, All Items
Machine Center Machine Center, All Machine Center, Work Center, All Work Centers, Work Center Group
Work Center Work Center, All Work Centers, Work Center Group