PriceValuation

Contents

Define the type of valuation

Variable

Read

Write

Description

e_WoDocEntry

Work order number

e_WoLineNumber

Work order Position

e_Quantity

Production Quantity in Warehouse unit

e_CloseId

Close process: N=No, J=Yes

e_ValuationType

e_ValuationText

Define the Valuation Text. This is mandatory, if e_ValuationType is "U"

e_MaterialPriceSource

Define the Price source for Material price calculation in the post calculation (real costs)

Valuation method	Type	Description
Posting price	B	The actual posted price is summarized. If a foreign currency was used, it is converted at the moment of the posting. If another item was posted, from what is specified in the BOM, then its posting price will not be considered for pricing. In plan costs, the last posted price of the BOM is used.
Precalculation	V	Corresponds to the price which is entered in the production BOM item. This is to the price of the pre-calculation from which the work order was generated or according to the pricing, which was set up in Configuration Wizard > Calcualtion > Precalcualtion. The price is determined at the moment when the work order is created. In a production BOM item, the price is visible only if Production > View > BOM > Prices changeable is enabled.
Last purchase price	E	Corresponds to the price according to <%SBO%> – last purchase price. All types of inflow are considered (credit vouchers, manual postings). If the price is stored in foreign currency, it is converted at the rate of the last goods movement.
Last valued price	P	In <%SBO%> > Report selection > Warehouse management > Stock valuation Simulation a price can be calculated with different methods. The valuation method refers to the price determined there.
Calculation price	K	Corresponds to the price in <%PROGRAMNAME%> Item master > Calculation > Calculation price. It can be calculated regularly using batch pre-calculation and then can be used as template.
Item valuation method	D	Valued at the Item valuation price Note: With the FiFo or Series / Batch evaluation method, an average price valuation of all goods on stock is performed.
Price list	1-99	The price is according to the selected price list. Price list extensions are considered. If the price is stored in a foreign currency, it is converted at the daily exchange rate to the local currency. A gross price list is considered only in the goods receipt, as well as for posting transactions. In pre-calculation and post-calculation items may not be valued with a gross price list. Note: <%PROGRAMNAME%> only supports price list with numbers 1–99. Price lists with internal id > 99 are not supported.
Last price from goods receipt	W	Relates to Purchase – Goods receipt. If there is no goods receipt, the last purchase price is used as reference (conversion at daily rate). If there is no price, the item is valued at 0.

e_SurchargeSource

The Surcharge is the price in point of Calculation Schema - Material Costs - Production Costs

Here you can define, which price from the Calculation Schema you want to use

Pricing at valuation (Assembly)	Type	Description
Material+Production Marginal Costs	MG	Sum of the pure material and manufacturing costs, without supplements
Material+Production Full Costs	MV	Sum of the pure material and manufacturing costs, without supplements
Costs of goods sold Marginal costs	HG	According to the calculation scheme in line "manufacturing costs", usually material costs + material surcharges + manufacturing costs + manufacturing surcharges
Costs of goods sold Full costs	HV	According to the calculation scheme in line "manufacturing costs", usually material costs + material surcharges + manufacturing costs + manufacturing surcharges
Costs of sales Marginal Costs	SG	According to the calculation scheme in line "primary costs" usually line of COGS + surcharges
Costs of sales Full Costs	SV	According to the calculation scheme in line "primary costs" usually line of COGS + surcharges

e_Projection

Follow settings only working, if e_ValuationType = "U"

Here you can define, which calculation type you want to use and which lines from the calculation you want to use for the valuation

Note: If you use the calculation type "Plan", you can't use the results from the "real" side.

Setting is always:

0=Plan (result from Postcalculation - Plan/PreCalculation side)

1=Real (result from Postcalcuation - Real side)

Part = Valuation for Part receipt

Last = Last Receipt with closing work order

Variable	Write	Description
e_MaterialPartReceipt	x	Material Price from 0=Plan, 1=Real side for Part Receipt
e_MaterialLastReceipt	x	Material Price from 0=Plan, 1=Real side for Last Receipt
e_RoutingPartReceipt	x	Routing/Production Price from 0=Plan, 1=Real side for Part Receipt
e_RoutingLastReceipt	x	Routing/Production Price from 0=Plan, 1=Real side for Last Receipt
e_SurchargePartReceipt	x	Surcharge Price from 0=Plan, 1=Real side for Part Receipt
e_SurchargeLastReceipt	x	Surcharge Price from 0=Plan, 1=Real side for Last Receipt
e_CalculationTypePartReceipt	x	Calculation Type for part receipt 0 = calculate the Plan calculation with the current receipt quantity 1 = calculate the real calculation with (current receipt + all existing receipts) - all costs from existing receipts.
e_CalculationTypeLastReceipt	x	Calculation Type for last receipt 0 = calculate the Plan calculation with the current receipt quantity 1 = calculate the real calculation with (current receipt + all existing receipts) - all costs from existing receipts.