Calculation#

General#

With the help of the calculation you can make the following business evaluations and calculations directly in KUMAVISION factory365:

Regular item costing with highlighting of variances.
Quotation costing
Development calculation
Co-calculation
Calculation up to the target price
Access protection of the calculation data
Separate reporting of costs
Calculation with planned values
Extension to include cost elements in the single-level as well as multi-level area (e.g. "material overhead")

Production costing#

The production costing is primarily used to determine the production costs / cost of goods sold as well as the sales price for an article. These values can then be transferred to the corresponding price fields on the article card.

The result of this calculation can also be used for the valuation method "Standard" for the bearing valuation.

Furthermore, simulations can also be carried out in the cost of goods manufactured in the event of changes in purchase prices, labor time prices or overhead rates.

Development calculation#

When creating new products, not all parts list items or work plan items are always known or their prices have not yet been determined. However, it is necessary to know the approximate manufacturing costs at an early stage and also to determine a sales price.

To make this possible, a "Simulated production order (cost estimate)" can be created manually for such an article. The known information from the routing and bill of materials is used. These values can then be changed as desired.

In addition, there is the possibility to manually. "Additional costs" with quantities, times and prices and, if required, the "Overhead rates" can be adjusted or supplemented.

Quotation costing#

For make-to-order manufacturers, the challenge is to perform calculations for individual customer orders as efficiently and accurately as possible. Therefore, KUMAVISION factory365 can provide the calculations for similar projects or articles as a basis via the Smart Start packages. Based on this, employees can calculate different variants without having to start from scratch. This means a significant time saving compared to before. This also comes into play for old, already expired offers. A new calculation can be created with just a few entries, as only the new prices need to be transferred. For contract manufacturers, transparency is another important factor. With the old calculations stored, sales staff can explain to customers, item by item, why there is a price difference compared to previous quotations. This is also important for projects that run over a longer period of time: If deviations from the original quotation occur during the course of the project, the customer can be told in detail what the causes are at the touch of a button. This is because the concurrent costing does not use the theoretical planned values, but the current actual values.

Bearing evaluation#

The material overhead costs can be entered separately with the use of the costing solution. This means that costing can now also activate the material overheads based on consumption. This makes the inventory values transparent and traceable and also ensures clarity in the balance sheet. Thus, these additions to the Microsoft Dynamics 365 Business Central¹ standard not only make the calculation of sales prices more comprehensible.

Cost types#

In Microsoft Dynamics 365 Business Central¹, there are a wide variety of cost types. These fields are visible in several masks. The explanation of these will now take place at this point. Basically, Microsoft Dynamics 365 Business Central¹ distinguishes between single-level costs and multi-level costs.

Single level costs#

Single-level costs are costs that are incurred only for this item. This means that for the calculation only the respective cost price of articles from the bill of materials or the prices and overhead costs are taken directly from the routing. No structures are exploded in the process.

Example:
An assembly in the bill of materials, is shown with the cost price in the material costs.

Multilevel costs#

Multi-level costs, are costs that are broken down to the lowest level and then presented in the respective cost pools.

Example:
An assembly in the bill of materials is not shown with the cost price in the material costs, but is broken down further to the purchase item. Only the purchase item is shown as material cost, the rest is capacity/external labor or production cost.

Consumption-capitalized material overheads#

The material costs can be included directly in the cost price of the raw material at the time of stock receipt, but also as consumption-capitalized material costs that are not included in the product until production.

The overhead and consumption capitalized costs can be mixed on the item card and in the costing condition lines.

Hierarchy of Consumption Capitalized Overhead:
a) Calculation conditions consumption activated
b) Calculation condition line
c) Article

Hierarchy Overhead:
a) Calculation conditions not consumption activated
b) Calculation condition line
c) Article

Note

Overhead costs and consumption activated overhead costs can be used in parallel. The only difference is that you can only define either a costing condition or a consumption activated costing condition. Both do not work.

Cost types#

Below you will find an overview of the cost types that exist in Microsoft Dynamics 365 Business Central¹ in connection with KUMAVISION factory365:

Field	Description
Single-level material costs	All costs (cost price - overhead) that come from the bill of material.
Single-Level Material Overhead	All overhead costs resulting from purchased items in the bill of material.
Single-level capacity costs	All costs (cost price - overhead) that come from the routing.(No external labor operations)
Single-level capacity overhead	All overhead costs that come from the item's routing. (No outside labor operations)
Single-Level Production Overhead	Production overhead stored with the item being costed.
Single-level external labor costs	All external labor costs (cost price - overhead) of external labor operations, from the corresponding routing.
Single-level external labor overhead	All overhead costs of external labor operations, from the corresponding routing.
Multi-level material costs	All material costs (cost price - overhead) of purchasing items totaled over all levels.
Multi-level material overhead	All material overhead costs of purchase items summed over all levels.
Multi-level capacity costs	All capacity costs (cost price - overhead) from all routings summed over all levels.
Multi-level capacity overhead	All capacity overhead costs of all operations summed over all levels.
Multi-level production overhead	All production overhead costs of all items summed over all levels.
Multi-level external labor costs	All external labor costs (cost price - overhead) of all external labor operations summed over all levels.
Multi-level external labor overhead	All external labor overhead costs from all external labor operations totaled across all levels.

Note

The totals of the single-level and multi-level prices only match as long as no bookings or price changes are made. As soon as bookings have taken place, these values diverge. They can then be made equal again by means of a new cost price calculation across all levels. (Depending on the settings)

Establishment#

Evaluation & calculation facility#

In the "Valuation & Costing Facility", the basic facilities for controlling the operation of the costing facility are defined first.

Inforegister General#

Field	Description
Basic Std.price calculation (make-to-stock)	The selection you make here is only used for items with the production type "make-to-stock". The following selections are available: Cost price: The value of the "Cost price" field from the item's master data is used. Cost price (latest): The value of the "Cost price (latest)" field from the item's master data is used.
Basic Std.price calculation (order production)	The selection you make here will only be used for items with the production type "order production". The following selections are available: Cost price: The value of the field "Cost price" from the master data of the item will be used. Cost price (latest): The value of the "Cost price (latest)" field from the item's master data is used. Purchase price (purchase prices): If the article has the procurement method "Purchase", first the purchase price valid for the vendor no. of the article is determined from the table Purchase price and the valid line discount % from the table Purchase line discount (both best price determination according to calculation date and quantity to be calculated). The combination of both fields results in the cost price to be used. If the item has the procurement method "Production order", the determination of the cost price to be used is based on the option value of the field "Basis Std. cost price calculation (make-to-stock)" of the Valuation and Costing Setup.
Default Transfer of cost price (fixed)/ target price Adopt proposal	At this point, you can decide whether the results of these calculations are written back for the respective articles. The following selection options are available: One level: The cost price (fixed) is only written back at the article for which the calculation was performed. All levels: The cost prices (fixed) are written back at all assemblies / components that were determined by the calculation.
Unit price decimal places	This is where you specify the minimum and maximum number of decimal places to be specified for unit prices in the calculation. Example: 2:5 means: minimum 2 decimal places and maximum 5 decimal places. For further information, use the Microsoft Dynamics 365 Business Central 1 Helpsite on the topic "Unit price decimal places field". .
Quantity Decimal Places	At this point you define how many decimal places should be specified in the calculation minimum and maximum for the quantities. Example: 2:5 means: Minimum 2 decimal places and maximum 5 decimal places. For further information use the Microsoft Dynamics 365 Business Central 1 Helpsite on the topic "Unit price decimal places field".
Fixed costing sheet name for costing proposal (E+D)	This setting applies to the costing sheets matrix that can be called up from the costing proposal (E+D) - i.e. via the production orders. With this field you have the option of specifying a standard costing sheet. If you enter a schema at this point, the user can only work with this schema and no longer select another (lock function). If the user should have the option to select other calculation schemas, then do not put anything in this field.
Calculate E+D Order (Sales)	This field refers to the calculation from a sales quotation or a sales order. The following options are available: Calculate only: The system creates the calculation, but does not perform any further action afterwards. If you want to display the newly created Simulated E+D Order, you must call it up manually. Calculate+Display: After the system creates the calculation, the created Simulated E+D Order is displayed directly in a window. Calculate+Apply: If the calculation proposal could be created without errors, the value of the "New target price" field of the executed calculation proposal will be applied to the "Sales price" field of the sales line.

Assuming that consumption-based items (make-to-stock) are procured on a regular basis, the cost price or delivered price (latest) provides a good basis for costing because the prices usually represent realistic values.

The cost price is - except for the stock issue method standard - an average value over all cost prices of the quantities currently in stock.

The Current price (latest), on the other hand, is not an average price. It refers to the last value at which the item was added. For a more detailed definition of the cost price fields on the item card, please use the Microsoft Dynamics 365 Business Central 1 Helpsite.

Items that are procured on an order basis (make-to-order production), on the other hand, can either also be costed on the basis of the cost prices, or - and this makes sense especially for articles that are procured infrequently - on the basis of the currently valid purchase prices. If there is no current purchase price for the article, a planned value can also be entered in the preliminary costing.

Note

The cost prices are always "adjusted" prices, i.e. freight costs or precious metal surcharges entered per article surcharge/discount are added, purchase discounts or similar are deducted. The purchase price, on the other hand, is the pure purchase price without taking into account any surcharges, discounts or rebates. The final costing always calculates only with the cost prices.

Note

A production type must be stored for each article - even for pure purchase articles, for which the production type is irrelevant by default.

Inforegister numbering#

Field	Description
Calculation Default Numbers	Enter the code of the number series to be used to assign records to the Calculation Default Numbers table.
Calculation Condition Numbers	Enter here the code of the number series to be used to assign records to the Calculation Condition Numbers table.

Note

If you want to use more than one number series for this table, you can set up a connection between the corresponding series in the "Connections" call in the number series. This way you can use one code for two or more number series.

Inforegister Assembly#

Field	Description
Costing item direct costs (resource assembly)	Select here a costing item from the costing item plan to which the direct costs incurred when a resource is used in an assembly order are allocated.
Description Costing element Direct costs (resource assembly)	Specifies the description of the selection in the "Costing item direct costs (resource assembly)" field.
Costing element overhead costs (resource assembly)	Select a costing item from the costing item plan here, to which the overhead costs incurred when a resource is used in an assembly order are assigned.
Description of costing element overhead costs (resource assembly)	Specifies the description of the selection in the Costing Item Overhead (Assembly Resource) field.

Costing components plan#

The costing components plan is the foundation of the costing and is comparable with a chart of accounts. It takes over the task of standardizing and grouping the components of a cost estimate and thus ultimately making them comparable with each other. This applies to both article costing and quotation costing.

In principle, the costing sheet is structured in the same way as the chart of accounts in the Financial Accounting application area.

KUMAVISION factory365 can already provide you with a set up costing element plan via the Smart Start packages. You can either use this directly in the form or further adapt it to the requirements of your company. Of course, you also have the option to create your own complete component plan.

Note

If you want to use more than one number series for this table, you can set up a connection between the corresponding series in the "Connections" call in the number series. This way you can use one code for two or more number series.

Field	Description
No.	The "No. " field is used to identify the costing element. You can enter up to 20 characters, both numbers and letters. Each number may be assigned only once. You can set up as many costing items as you like. Note: Choose sufficient intervals between the numbers of the individual costing components. This will allow you to insert additional costing items later if required. For example, you could assign only the end digits 00 to all account groups and only the end digits 0 to all accounts.
Description	Here you can enter any text to describe the content of the costing element.
Cost range	Articles and capacities are later assigned to the costing items table via the costing conditions. The Cost area field indicates the application area of the respective costing item. The following selection options are available: Cost of materials and material overheads: The costing items with these options are used in costing conditions of the type "Material" (procurement method of the item = purchase). Material costs describe the direct costs (from the field EK price (latest)). Material overhead describes the indirect costs (from the fields Cost %, Overhead rate, Cost % (consumption capitalization), Overhead rate (consumption capitalization)). Capacity costs and capacity overhead: The costing items with these options are used in costing items of the type "Capacity".Capacity costs describe the direct costs (field EK price of the used work center or work center group). Capacity overhead describes the indirect costs (cost %, overhead rate) of the work center or work center group used. Outside labor costs and outside labor overhead: The costing items with these options are used in costing items of the type "Capacity" if it is an external labor work center group (or assigned external work center) (Vendor number field is not equal to ). External labor costs describe the direct costs (field EK price of the used external work center group or the assigned external work center). External labor overhead describes the indirect costs (cost %, overhead rate) of the external work center group used or the assigned external work center.
Cost range	Production Overhead: The costing items with these options are used in costing conditions of type "Production" (procurement method of the item = production order). Costing items of the cost area production overhead describe the indirect costs (fields cost %, overhead rate) of the used article (production article or assembly). Sales overhead, administrative overhead, risk/profit, commission, discount, rebate: The costing items with these options are used in costing conditions of the type "markup". Costing items of these four cost areas describe the non-capitalizable costs of an article, i.e. the difference between the sales price and the cost price of the article.
Type	With this field you specify the type of record. You can choose from the following: Costing component: This option is used for the actual calculation components. The later assignment is only done via these data records. Headline: A heading for a group of costing components. Sum: The Sum option is used if you want the application to sum up individual costing items. Please then enter a filter text in the Sum field to specify the costing components to be included. From-total / To-total: The From-total option marks the beginning of a continuous series of costing items to be totalized. The end of this series is a costing item of the type To-Sum. In this case, please also enter a filter text in the Totalization field to specify the costing items to be included.
Counting up	Here you can now specify the interval or other filter specification of numbers of the costing elements. The results of the specified costing elements are added to a total balance. For the type "Calculation component", "From-total" or "Heading" this field must remain empty. For the "To total" type, the field is automatically filled when the chart of accounts is indented (function in the ribbon). Only the costing items that lie between a From total and a To total are added together. For the "Sum" type, you must manually specify the costing items to be added together.

Note

You must assign a cost range to each record in the Costing item table with the type Costing item. For all other costing items (headings, totals, from-totals or to-totals), the Cost range field remains empty.

Supplied Costing Components Plan:

No.	Description	Cost area	Type	Counting
1	Energy overhead	Material overhead	Costing item
10000	manufacturing costs		from-total
10001	Material costs		From-total
10010	Direct material costs	Material costs	Costing element
10011	Direct material costs 2	Material costs	Costing item
10020	Special direct costs material	Material overhead	Costing item
10030	Material overhead	Material overhead	Costing item
10040	Material surcharges	Material overhead	Costing element
10045	Freight costs	Material overhead	Costing item
10046	handling costs	material overheads	costing element
10049	Total material costs		To-total	10001 ..10049
10100	Capacity costs		From-total
10110	individual costs elm	capacity costs	costing element
10120	Single cost worker	Capacity cost	Calculation item
10130	individual costs machine	capacity costs	costing element
10150	Overhead costs elm	Capacity overhead	Costing element
10160	overhead labor	capacity overhead	costing element
10170	machine overhead	capacity overhead	costing item
10180	electricity/buildings	capacity overhead	costing element
10210	Individual costs external labor	External labor costs	Costing item
10250	Overhead costs external labor	External labor overhead	Costing element
10299	Total capacity costs		To-total	10100 ..10299
10300	Individual costs assembly res.	Capacity costs	Calculation component
10305	Overhead assembly res.	Capacity overhead	Costing element
10310	Tools	Production Overhead	Costing Item
10320	Certifications	Production Overhead	Costing Item
10400	Total cost of goods sold		To-total	10000 ..10400
10410	Shipping	Sales overhead	Costing item
10420	Quality Control	Sales Overhead	Costing Item
10430	Sales	Sales overhead	Costing item
10510	Administration	Administrative overhead	Costing item
10520	Special direct costs of technology	Administrative overhead	Costing item
10600	Selbstkosten		Summe	10000..10599
10610	Risk/profit surcharge	Risk/profit	Calculation component
10620	Special direct costs other	Risk/profit	Costing item
10700	Mindestrichtpreis		Summe	10000..10699
10710	Commission	Commission/Discount	Calculation Item
10720	Discounts	Commission/Discount/Discount	Calculation Item
10730	Discounts	Commission/Discount	Calculation Item
10800	Richtpreis		Summe	10000..10799
10810	Rounding income/costs	Commission/discount/discount	Calculation component
10900	Guide price (rounded)		Sum	10000 ..10899

Actions via the ribbon#

Indentation of the component plan#

By executing the "Component plan indentation" function, the filter text in the "Totalization" field is automatically determined by the system for the costing components of the "To total" type.

Comments#

Date-dependent information can be stored for the respective costing element via the remarks.

Calculation conditions#

The costing conditions establish the link between the master data tables such as article, work center group, etc. and the costing components, thus enabling the results of a costing to be assigned to an account.

In the header of a costing condition the assignment to the costing element costs and the costing element overhead costs is made. The lines of the costing condition allow you to define the costing costs more precisely over any number of lines. This applies to both direct costs (field EK price) and indirect costs (fields Cost %, Overhead rate) of the respective master data table.

A distinction is made in the following calculation condition types:

Costing condition (material)#

The calculation condition is used in records of the table Article calculation condition with the calculation type Material. That is, you define here costing conditions that you subsequently assign to some of your articles. The condition is taken into account in the calculation when it comes to the calculation of raw materials (purchase items).

Inforegister General#

Field	Description
No.	Number of the calculation condition
Description	Description of the calculation condition
Costing element costs	Select the appropriate costing item in the "Costing items costs" field. For the costing condition "Material", this is usually the material direct costs.
Description costing element costs	Specifies the description of the selected costing item from the Costing Item Cost field.
Costing element overhead costs	Select the appropriate costing element in the "Costing element overhead" field. This is usually the material overhead for the costing condition "Material".
Description costing element overhead costs	Specifies the description of the selected costing item from the Costing Item Overhead field.

Inforegister lines#

Field	Description
Description	Here you enter a description of the content of your calculation condition line.
Costing item	A costing item is assigned to each costing condition line. In principle, a costing item with any cost range can be assigned to a costing condition line. However, you should make sure that you use a costing item whose cost range corresponds to the intended application area of the respective costing condition.
Calculation Component Description	This field is automatically filled by the selection of the costing component.
Heading no.	The Rubric No. field is used to relate calculation condition rows to each other in order to define a calculation base for percentage surcharges.
Calculation	The field is a choice field and controls with its option value the meaning of the field Value: Amount: If you select Amount, then the specification in the field Value is understood as absolute number input. So you have here the possibility to store fixed values, which will be taken into account in the calculation. In addition, you can provide this line with a rubric number to refer to this line in another line with the setting Percent - so, for example, to take into account an additional overhead. Percent: If you select Amount, then the specification in the Value field is understood as a percentage number entry. If the line has been assigned a rubric no., then the basis of the percentage is the sum of all calculation condition lines of the same calculation condition with the same rubric no. and calculation amount. Note: If the line is not provided with a rubric no., the application uses either the purchase price of the origin line of the corresponding calculation value or (if available) the sum of all calculation condition lines of the same calculation condition with the calculation value as basis for the percentage. The rubric no. of these lines will then be ignored.
Value	The meaning of the field depends on the value you have selected in the Calculation field. Amount: In this case, the field contains an absolute amount. Depending on the selected costing element, this amount is part of the EK cost or part of the overhead rate. Percent: In this case, the Value field contains a percentage value. The basis of the percentage value is the sum of all calculation values with the same rubric no. If the row was not assigned a rubric no., the application uses as a basis either the purchase price of the origin row of the corresponding calculation value or (if available) the sum of all calculation condition rows with calculation value and specification of any rubric no. (but only if these calculation condition rows were interpreted as part of a purchase price).

KUMAVISION factory365 can provide you with predefined costing conditions (material) for use or further individual additions via the Smart Start packages:

Material (single) and material (single2):

Field	Material (simple)	Material (simple2)
No.	KK0000	KK0010
Description	Material (simple)	Material (simple2)
Calculation item costs	10010	10011
Description of costing element costs	Direct material costs	Direct material costs 2
Costing item overhead	10030	10030
Description Costing Item Overhead	Material Overhead	Material Overhead

Material (complex) and material (complex2):

Field	Material (complex)	Material (complex2)
No.	KK0011	KK0001
Description	Material (complex)	Material (complex2)
Calculation item costs	10010	10010
Description of costing element costs	Direct material costs	Direct material costs
Costing item overhead	10030	10030
Description Costing Item Overhead	Material Overhead	Material Overhead

Field		Material (complex)
Description	Handling	Freight	Overhead costs	Special direct costs	Material surcharges
Kalkulationsbestandteil	10046	10046	10046	10046	10046
Costing Item Description	Handling Costs	Freight Costs	Material Overhead	Special Direct Costs Material	Material Surcharges
Heading no.		R1+R2		R1	R2
calculation/value	7 .00 MW	6.00 %	4.00 %	5.00 MW	2.00 MW

Field		Material (complex2)
Description	Handling	Freight	Overhead costs
Kalkulationsbestandteil	10046	10045	10030
Costing Item Description	Handling Costs	Freight Costs	Material Overhead
heading no.
Calculation / Value	1 .00 MW	6. 00 %	4.00 %

Calculation condition (production)#

The calculation condition is used in records of the table Article calculation condition with the calculation type Production. This means that you define calculation conditions here which you then also assign to some of your articles. The condition is taken into account in the calculation if it is about the calculation of products (production items).

Inforegister General#

Field	Description
No.	Number of the calculation condition
Description	Description of the calculation condition
Costing element costs	Select the appropriate costing item in the field "Costing item costs". In the case of the costing condition "Production", these are usually the direct material costs or the special direct costs of production.
Calculation Item Cost Description	Indicates the description of the selected costing item from the "Costing Item Cost" field.
Costing element overhead costs	Select the appropriate costing item in the "Costing item overhead" field. In the case of the costing condition "Production", this is usually the cost of tools, special direct costs, etc.
Description costing element overhead costs	ISpecifies the description of the selected costing item from the Costing Item Overhead field.

Inforegister lines#

Field	Description
Description	Description of the calculation condition
Costing item	A costing item is assigned to each costing condition line. In principle, a costing item with any cost range can be assigned to a costing condition line. However, you should make sure that you use a costing item whose cost range corresponds to the intended application area of the respective costing condition.
Calculation Component Description	This field is automatically filled by the selection of the costing component.
Heading no.	The field "Rubric no. " is used to relate calculation condition rows to each other in order to define a calculation basis for percentage surcharges.
Calculation	The field is a choice field and controls with its option value the meaning of the field Value: Amount: If you select the option "Amount", then the specification in the field Value is understood as absolute number input. So here you have the option to enter fixed values that will be taken into account in the calculation. In addition, you can provide this line with a rubric number to refer to this line in another line with the setting Percent - so, for example, to take into account an additional overhead. Percent: If you select Amount, then the specification in the field "Value" is understood as a percentage number entry. If the line has been assigned a rubric no., then the basis of the percentage is the sum of all calculation condition lines of the same calculation condition with the same rubric no. and calculation amount. Note: If the row was not provided with a rubric no., the application uses as the basis for the percentage either the EK price of the origin row of the corresponding calculation value or (if available) the sum of all calculation condition rows of the same calculation condition before the current row with the calculation value. The rubric no. of these lines will then be ignored.
Value	The meaning of the field depends on the value you have selected in the Calculation field. Amount: In this case, the field contains an absolute amount. Depending on the selected costing element, this amount is part of the EK cost or part of the overhead rate. Percent: In this case, the Value field contains a percentage value. The basis of the percentage value is the sum of all calculation values with the same rubric no. If the line has not been assigned a rubric no., the application will use as a basis either the EK price of the origin line of the corresponding calculation value or (if available) the sum of all calculation condition lines before the current line with calculation value and specification of any rubric no. (but only if these calculation condition lines have been interpreted as part of an EK price).

KUMAVISION factory365 can provide you with predefined calculation conditions (production) for use or further individual additions via the Smart Start packages:

Field	Production (simple)	Production (complex)
No.	KK1000	KK1001
Description	Production (simple)	Production (complex)
Calculation item costs	10011
Description of costing element costs	Direct material costs 2
Costing item overhead	10310	10320
Description costing component overhead	Tools	Certifications

No further information is defined in the calculation condition lines of the condition "Production (simple)".

Field		Production (complex)
Description	Tool	Certification
Calculation component	10310	10320
Calculation component description		Certification tool
Category no.
Calculation / Value	2.00 %	5.00 MW

Costing condition (capacity)#

The costing condition is used in data records of the Work center costing condition table. This means that you define costing conditions here which you then assign to your capacities (work center groups and work centers). The condition is taken into account in the calculation as soon as a capacity is addressed (e.g. because a routing is stored for a production article).

Inforegister General#

Field	Description
No.	Number of the calculation condition
Description	Description of the calculation condition
Costing element costs	Select the appropriate costing item in the field "Costing item costs". For the costing condition "Capacity", this is usually the direct production costs.
Calculation Item Cost Description	Gives the description of the selected costing item from the "Costing Item Cost" field.
Costing element overhead costs	Select the appropriate costing element in the "Costing element overhead" field. This is usually the production overhead for the costing condition "Capacity".
Description costing element overhead costs	Indicates the description of the selected costing item from the "Costing Item Overhead" field.

Inforegister lines#

Field	Description
Description	Here you enter a description of the content of your calculation condition line.
Costing item	A costing item is assigned to each costing condition line. In principle, a costing item with any cost range can be assigned to a costing condition line. However, you should make sure that you use a costing item whose cost range corresponds to the intended application area of the respective costing condition.
Calculation Component Description	This field is automatically filled by the selection of the costing component.
Heading no.	The Rubric No. field is used to relate calculation condition rows to each other in order to define a calculation base for percentage surcharges.
Setup time	This field is only included in costing conditions of the type capacity or external labor. It can be used to define costing elements that only refer to the setup time in their calculation.
Share %	The content of the field is used as a percentage share in the formula for calculating the Costing price field of the costing value.
Calculation	The field is a choice field and controls with its option value the meaning of the field Value: Amount: If you select Amount, then the specification in the field Value is understood as absolute number input. So you have here the possibility to store fixed values, which will be taken into account in the calculation. In addition, you can provide this line with a rubric number to refer to this line in another line with the setting Percent - so, for example, to consider an additional overhead. Percent: If you select Amount, then the specification in the Value field is understood as a percentage number entry. If the line has been assigned a rubric no., then the basis of the percentage is the sum of all calculation condition lines of the same calculation condition with the same rubric no. and calculation amount. Note: If the row was not provided with a rubric no., the application uses as the basis for the percentage either the EK price of the origin row of the corresponding calculation value or (if available) the sum of all calculation condition rows of the same calculation condition before the current row with the calculation value. The rubric no. of these lines will then be ignored.
Value	The meaning of the field depends on the value you have selected in the Calculation field. Amount: In this case, the field contains an absolute amount. Depending on the selected costing item, this amount is part of the EK cost or part of the overhead rate. Percent: In this case, the Value field contains a percentage value. The basis of the percentage value is the sum of all calculation values with the same rubric no. If the line has not been assigned a rubric no., the application will use as a basis either the EK price of the origin line of the corresponding calculation value or (if available) the sum of all calculation condition lines before the current line with calculation value and specification of any rubric no. (but only if these calculation condition lines have been interpreted as part of an EK price).

KUMAVISION factory365 can provide you with predefined calculation conditions (capacity) for use or further individual additions via the Smart Start packages:

Field	Capacity (Energy)	Capacity (Simple)	Capacity (Complex)
No.	01	KK2000	KK2001
Description	Capacity (energy)	Capacity (simple)	Capacity (complex)
costing item cost		10130	10130
Description of costing item cost		Individual costs machine	Individual costs machine
Costing item overhead	1	10170	10170
Description of costing element overhead costs	overhead costs energy	overhead costs machine	overhead costs machine

No further information is defined in the calculation condition lines of the conditions "Capacity (energy)" and "Capacity (simple)".

Field		Capacity (complex)
description	machine	worker	scrubber	apprentice	GK machine	GK worker
Kalkulationsbestandteil	10130	10120	10110	10120	10170	10160
Costing component description	Individual costs machine	Individual costs worker	Individual costs elm	Individual costs worker	Individual costs machine	Individual costs worker
Rubric No.	M1	A	A	M1	A
armament		Yes
share %	100.00	100. 00	100. 00	100.00	100. 00	100.00
calculation/value	2 .20 MW	1. 20 MW	1. 50 MW	0 .90 MW	20. 00 %	10.00 %

Field	External labor (simple)	External labor (complex)
No.	KK2050	KK2051
Description	Foreign work (simple)	Foreign work (complex)
Costing item costs	10210	10210
Description of costing item costs	individual costs external labor	individual costs external labor
Costing item overhead	10250	10250
Description of costing element overhead costs	Overhead costs external work	Overhead costs external work

No further information is defined in the calculation condition lines of the condition "External labor (simple)".

Field	External labor (simple)	External labor (simple)
Description	Freight	Overhead costs
calculation component	10250	10250
Calculation Item Description	Overhead Costs External Labor	Overhead Costs External Labor
heading no.
armament
Share %	100 .00 %	100. 00 %
Calculation / Value	5 .00 %	15. 00 %

Calculation condition (markup)#

The calculation condition is used in records of the table Article calculation condition (cannot be activated) with the calculation type markup. This means that you define calculation conditions here which you then assign to some of your articles. The condition will be taken into account in the calculation if it is the calculation of "end products". Here you no longer define the cost price of the article, but the markup up to the target price.

Inforegister General#

Field	Description
No.	Number of the calculation condition
Description	Description of the calculation condition
Takeover guide price	In an article calculation you can transfer the determined target price from a calculation proposal into the master data of the calculated article. You specify here, in which field of the master data the determined target price should be transferred: None: There is no transfer. Target price: The value is transferred to the field target price of the article (table article). Sales price: The value is taken over into the field Sales price (table article). Sales price: The value is taken over into the sales price table of the article. The entry is made taking into account the sales type and sales code. Price + Sales Price: The value is transferred to both the Price field (Article table) and the Sales Price table record.
Sales Type	This field is taken into account when entering the target price in the sales price table. The following selection options are available: • Debitor , • Debitor price group, • All debtors • Campaign It can only be edited if the option "Sales price" or "Target price+sales price" has been selected in the Transfer target price field.
Sale code	This field is also taken into account when entering the target price in the sales price table. What you can select here depends on what you have specified in the "Sales type" field. For example, if you have selected customer price group there, all your customer price groups will be displayed for selection in the "Sales code" field. This makes it possible to define individual markup calculations for special customer groups, campaigns or even for individual customers.

Inforegister lines#

Field	Description
Heading no.	The field "Rubric no. " is used to relate calculation condition rows to each other in order to define a calculation basis for percentage surcharges.
Description	Here you enter a description of the content of your calculation condition line.
Calculation	The field is a choice field and controls with its option value the meaning of the field "Formula/Code": Empty: If the field is left empty the line has no influence on the execution of the calculation. For example, it can be used for a heading or explanation line. Value: If you select "Value", the "Formula/Code" field will contain an absolute number entry. In addition, you can assign a heading number to this line to refer to it in another line with the Percent setting. Formula: If you select Formula, the Formula/Code field contains an arithmetic formula. The parts of the formula refer to the heading no. of other costing condition lines. Costing Item: If you select Costing Item, the Formula/Code field contains a costing item. Thus, this setting allows you to determine a markup line based on the costing values of a specific costing component. This costing item can also be a to-total. Project Planned Line: If you select Project Planned Line, the Formula/Code field contains a project task number.
Formula/Code	The meaning of the field depends on the value you have selected in the "Calculation" field. Empty: In this case, the "Formula/Code" field is also empty. The calculation condition line has no influence on the execution of the calculation. For example, it can be used for a heading or explanation line. Value: In this case, the field contains a constant (decimal number). You can use this constant also, in which you provide the line with a rubric no. and in another calculation condition line with the calculation formula reference to this line. Formula: In this case the field contains an arithmetic formula. A rubric no. can also be used here to determine the calculation basis. In the arithmetic formula, the basic arithmetic operations +, -, , /, multilevel brackets () and the two special characters % and § can be used. % stands for "percent of one hundred". Example: 5% A means "5 percent of the sum of all markup lines with rubric no. A". Suppose the total is 100, then the markup is 5 (100/1005) § stands for "percent of one hundred". Example: 5 § B means "5 percent from the total of all markup lines with rubric no. B". Let's say the total is 100, then the markup is 4.76 (100/1055). Calculation Item:* In this case, a calculation item is selected. If this line is used in a calculation, the application will calculate the calculated field "Multi-level amount per 1 unit". For example, the Costing Ingredient option value allows you to calculate a markup line based on the costing values of a specific costing ingredient. This costing item can also be a to-total.
Rounding Method Code	The field specifies whether the costing price of the costing value that will be created when applying the costing condition in a costing proposal is to be rounded.The type and manner of the desired rounding is thereby controlled with the help of a rounding method defined in the master data. This table is a standard table. You have the option to always round up or down amounts or to round them up or down commercially (in this case, amounts are only rounded up if the digit to be rounded is >=5. For further explanations on how to set up the rounding methods, please use the Microsoft Dynamics 365 Business Central 1 Helpsite.
Costing item	A costing item is assigned to each costing condition line. In principle, a costing item with any cost range can be assigned to a costing condition line. However, you should make sure that you use a costing item whose cost range corresponds to the intended application area of the respective costing condition.
Guide price	Tick this field only in the line that should determine your guide price.
Bold	The Bold field controls the visual highlighting of the row in the E+D Order markup calculation window.
Error text	If you specify an incorrect formula, the corresponding error message appears in this field.

KUMAVISION factory365 can provide you with predefined calculation conditions (markup) for use or further individual additions via the Smart Start packages:

Field	Impact	Impact Calculation
No.	AUFSCHLAG	KK3000
Description	Surcharge	Surcharge Calculation
Takeover target price	Target price	Target price
Sale	Debitor	Debitor
sale code

No further details are defined in the calculation condition lines of the condition "Surcharge".

Heading no.	Description	Calculation	Formula / Code	Rounding code	Lime. Component	Lime. Component Description	Indicative price
HK	Manufacturing costs	Calculation b .	10400
	Shipping	Formula	HK * 0,5/100		10410	Shipping
	Quality control		Formula	00 .70% HK		10420	Quality control
	Sales overhead	Formula	03 .00 % HK	10430	Sales
	Administration		Formula	02 .50 % HK		10510	Administration
	SEK d. Technik	Calculation b .	10520
SK	Self cost	Calculation b .	10600
	risk	formula	02 .00 % SK		10610	Risk/profit surcharge
	Profit	Formula	30 .00 % SK		10610	Risk / Profit
MRP	Minimum Indicative Price	Calculationb .	10700
	commission 1	formula	03 ,00 § MRP	10710	Provision
	commission 2	formula	01 ,00 § MRP	10710	Provision
	Saccount	Formula	03 ,00 § MRP	10720	Account
	Discount	Formula	10 ,00 § MRP	10730	Discount
RP	Guide Price	Calculationb .	10800
RPG	Directive price rounded	Calculationb .	10800	PRICE
	Rounding	Formula	RPG-RP		10810	Rounding income / costs
	Guide price (incl. rounding)	Calculationb .	10900				Yes

Calculation scheme#

The "Costing" application area allows you to evaluate the results of item costing and job costing in so-called costing sheets. Costing schemes have the form of a matrix with a freely definable row layout and a freely definable column layout and are comparable to the account schemes (Microsoft Dynamics 365 Business Central¹ Standard).

A costing sheet can basically follow the structure of the costing sheet, but it is usually presented in somewhat less detail by grouping certain items together. For example, you can display the total material costs in the chart of accounts; without subdividing them into direct material costs and material overhead costs. This is possible because when you create a costing proposal, the application automatically assigns each costing value to a costing item.

Any number of calculation schemes can be created. Two calculation schemas are already included in the basic setup of the calculation - namely the standard calculation schema and the overview schema. Of course, these schemes can be further customized according to your requirements.

You can call up the overview using the search term "Kalkulationsschemanamen".

Via "New" in the ribbon you can define a new scheme using the table below.

Field	Description
Name	In this field, assign a name for the calculation schema.
Description	In this field, specify a description for the calculation schema.
Standard column layout	The field "Standard column layout" is used to define the criteria for the calculation in the column view. The column layout stored there will always be used as the basis for the calculation.

Via "Calc. Edit scheme" in the ribbon you have the possibility to define the scheme in detail.

Field	Description
Heading no.	Enter a rubric number for a unique description of the row or to be able to use this row later for a calculation.
Description	Here you specify a description for the line.
Totalization type and totalization	The Totalization type field is a choice field. It determines which records will be included: Ingredient Sum: The sum is formed from the amounts taking into account the costing elements of the costing element type. To do this, specify an expression in the Total field to filter the costing components to be used. Example: The Total field contains the expression 10100..10299. Specifying this causes the costing sheet row to display amounts resulting from the costing components in the range 10100 to 10299. Only costing items of the type costing item are taken into account. Total: The total is formed from the amounts taking into account the costing items of the type total or to-total. To do this, specify an expression in the Total field to filter the costing items to be used. Example: The Total field contains the expression 10100..10299. Specifying this causes the costing sheet row to display amounts that result from the costing items in the range 10100 to 10299. Only costing items of the type Total or To total are taken into account. Formula: The total is formed from the calculated amounts in other lines of the same costing sheet. To do this, specify an arithmetic formula in the Total field. When doing this, use the Heading No. field to refer to the other rows in the schema in the formula. Example: The Add Up field contains the expression A+B. The amounts from all other spreadsheet rows in the same schema that have the value A or B in the Heading No. field are added together.
Display	This field is relevant for the Costing Sheet report. You have the following choices: Yes: The row will be printed in the report. No: The row will not appear in the report. For example, you can use this option to define a calculation scheme row that contains subtotals of a longer calculation scheme. If a column is not 0: The row will only be printed in the report if it is not 0. Thus, rows without an amount will not be printed at all.
New page	If you mark the calculation schema line with a check mark, the report will make a page change at this point.
Bold	If you mark the calculation scheme row with a check mark, the row will be displayed in bold in the report.
Cursive	If you mark the calculation scheme line with a check mark, the line will be displayed in italics in the report.
Underlined	If you mark the calculation scheme row with a check mark, the row will be underlined in the report.
Reverse sign on	If the field of the calculation scheme row is checked, all calculated amounts of the row will be displayed in the Calculation scheme matrix window with reversed sign.

Delete#

You can delete the calculation schema via the "Delete" menu item.

Print#

Via the menu item "Print" you have the possibility to print the calculation schema considering a defined column layout and the specification of at least one calculation proposal line.

Set up account#

The "Insert accounts" function transfers the records of the Costing item table to the present book sheet, creating exactly one costing item row for each costing item. The no. of the costing item is then placed in the Totals field of the costing sheet row.

You can select the costing elements to be transferred individually after starting the function. All costing elements are displayed in an overview. Select the data records you want in the window and then click OK to start the transfer.

Set up column layouts#

Via the menu item "Set up column layouts" you have the possibility to define a column layout for the defined calculation schema.

KUMAVISION factory365 can already provide you with two predefined calculation schemes for use or further individual additions via the Smart Start packages:

Calculation scheme standard:

Heading no.	Description	Counting type	Counting	Advertisements
10010	Direct material costs	Inventory total	10010	Yes
10011	Direct material costs 2	Inventory total	10011	Yes
10020	Special direct costs material	Inventory total	10020	Yes
10030	Material overhead	Inventory total	10030	Yes
10040	Material surcharges	Component sum	10040	Yes
10045	Freight costs	Inventory sum	10045	Yes
10046	Handling costs	Inventory sum	10046	Yes
10049	Sum of material costs	Sum total	10049	Yes
		Component sum		Yes
10110	Individual costs elm	Component sum	10110	Yes
10120	Single cost worker	Summary	10120	Yes
10130	Individual costs machine	Inventory total	10130	Yes
10150	Overhead costs elm	Component sum	10150	Yes
10160	Overhead labor	Component total	10160	Yes
10170	Overhead machine	Components	10170	Yes
10180	Electricity/Building	Component sum	10180	Yes
10210	Individual costs external labor	Individual costs	10210	Yes
10250	Overhead costs external labor	Inventory total	10250	Yes
10299	Sum capacity costs	Sum total	10299	Yes
		Component sum		Yes
10300	Individual costs assembly res.	Component sum	10300	Yes
10305	Overhead assembly res.	Component sum	10305	Yes
		Component sum		Yes
10310	Tools	Components	10310	Yes
10320	Certifications	Inventory	10320	Yes
		Component sum		Yes
10400	Total cost of goods sold	Sum total	10400	Yes
		Component sum		Yes
10410	Shipping	Inventory	10410	Yes
10420	Quality control	Component sum	10420	Yes
10430	Sales	Inventory	10430	Yes
10510	Administration	Component total	10510	Yes
10520	Special individual costs engineering	Inventory total	10520	Yes
	(Sales overhead)	Inventory total	10400 ..10499	Yes
	(Administrative overhead)	Component total	10500 ..10599	Yes
10600	Self cost	Sum total	10600	Yes
10610	Risk/profit surcharge	Component sum	10610	Yes
10700	Minimum reference price	Sum total	10700	Yes
10710	Provision	Component sum	10710	Yes
10720	Discounts	Inventory	10720	Yes
10730	Discounts	Inventory	10730	Yes
	(Commission/Discount/Discount)	Cumulative total	10710 ..10799;10810	Yes
10800	Guide price	Sum total	10800	Yes
10900	Guide price (rounded)	Sum total	10900	Yes
		Component sum		Yes
		Component sum		Yes
	Summe Aufschläge	Bestandteilsumme	10401..10499 10501..10599 10601..10699 10701.. 10799 10810	Ja

Calculation scheme overview:

Heading no.	Description	Counting type	Counting	Advertisements
MAT	Sum of material costs	Sum of components	10010 ..10048	Yes
KAP	Sum of capacity costs	Sum of components	10110 ..10199	Yes
FREMD	Total external labor costs	Component total	10210 ..10298	Yes
PROD	Total production overhead	Inventory total	10300 ..10399	Yes
	Sum of material costs	Sum total	10049	Yes
		Component sum		Yes
10410	Shipping	Inventory	10410	Yes
10420	Quality control	Component sum	10420	Yes
10430	Sales	Inventory	10010	Yes
10510	Administration	Inventory	10010	Yes
10520	Special individual costs engineering	Inventory total	10010	Yes
10600	Self cost	Sum total	10600	Yes
10610	Risk/profit surcharge	Component sum	10610	Yes
10700	Minimum reference price	Sum total	10700	Yes
10720	Discounts	Inventory	10720	Yes
10730	Discounts	Inventory	10730	Yes
10900	Guide price (rounded)	Sum total	10900	Yes
		Component sum	10010	Yes
	Summe Aufschläge	Bestandteilsumme	10401..10499 10501..10599 10601..10699 10701.. 10799 10810	Ja

Article card#

Article Calculation Conditions#

The article calculation conditions can be called up via the article card. With this mask you can define the calculation conditions specifically for a certain article or a species group for the later calculation.

The "General" area of the article calculation conditions mask initially contains filters that you can use to control your view. When you open the mask, the filters are initially always preset to the article from which you have called up the mask.

Field	Description
Sales Type Filter	Using the sales type filter, you can limit your view to lines of a specific costing type or none. The following selections are available: • Material • Production • None
Species filter	Using the species filter, you can limit your view to rows of a specific type. The following selections are available: • Article • Article category • Product booking group • Stock booking group • All articles • None
Code filter	You can use the code filter to further restrict your view in addition to the species filter on a specific article or similar.
Start date filter	Use the start date filter to narrow your view to specific validity lines.

Using the rows you can directly define the calculation conditions with the help of the table below.

Field	Description
Calculation type	In this field you define for which calculation type you want to define the line.You can choose from: Material: The condition is taken into account in the calculation, if it is the calculation of raw materials (purchase items). Production: The condition is taken into account in the calculation, if it is the calculation of products (production items).
Type	Using the "Type" field, you have the option of defining the condition line for an article or for faster entry of a type group. The following options are available: • Article • Article category • Product booking group • Stock booking group • All articles
Code	You can limit each selection in the "Type" field to a specific article number or species group number in this field.
Indirect Cost Rate	Enter the indirect cost of the item as an absolute amount at this point. Note: If you are working with costing, it is recommended that you do not maintain the default field on the item card.
Indirect costs %	Indirect costs of the item as a percentage value. Note: This field is identical to the field on the item card. However, if you are working with costing, it is recommended that you do not maintain the standard field on the item card, but only this one instead.
Overhead Cost Rate (Consumption Capitalization)	Enter the consumption capitalized overhead as an absolute amount at this point. Note: Overhead and consumption capitalized overhead can be used in parallel. The only difference is that only either a Costing Condition or a Costing Condition Consumption Activated can be defined. Both do not work.
Cost % (Consumption Activation)	Indicate the consumption-activated costs as a percentage value at this point.
Calculation Condition No.	Enter the appropriate calculation condition.
Start date	Indicates the date from which the calculation line is valid.
End date	Indicates the date until when the calculation line is valid.

Via "Manage" > "Delete" you can delete a selected calculation row.

Article calculation conditions (cannot be activated)#

The article calculation conditions (not activatable) can be called up via the article card. This screen allows you to define the non-activatable costs (costs that are not included in the cost price) specifically for a particular article or species group for later costing.

In the "General" area of the article calculation conditions (cannot be activated) mask, there are initially filters that you can use to control your view. When you open the mask, the filters are initially always preset to the article from which you have called up the mask.

Field	Description
Sales Type Filter	Using the sales type filter, you can limit your view to lines of a specific costing type or none.The following selections are available: • Markup • Special Direct Cost • None
Type filter	Using the type filter, you can limit your view to rows of a specific type. The following selections are available: • Article • Article category • Product posting group • Stock posting group • All articles • None
Code filter	You can use the code filter to further restrict your view in addition to the species filter on a specific article or similar.
Start date filter	Use the start date filter to narrow your view to specific validity lines.

Using the rows you can directly define the calculation conditions with the help of the table below.

Field	Description
Costing type	In this field you define for which costing type you want to define the line. You can choose from: Surcharge: The condition is taken into account in the calculation, if it is the calculation of "end products". You define here no longer the cost price of the item, but the markup up to the target price. Special direct costs: The condition is defined the costs that are incurred for a product, but are not quantity-dependent.
Type	Using the "Type" field, you have the option of defining the condition line for an article or for faster entry of a type group. The following options are available: • Article • Article category • Product booking group • Stock booking group • All articles
Code	You can narrow down each selection in the "Type" field to a specific article number or species group number in this field.
Calculation Condition No.	Indicates the corresponding calculation condition.
Calculation Condition Description	Gives the description for the calculation condition selected in the "Calculation Condition No." field.
Calculation condition no. (E+D)	Indicates the corresponding calculation condition (E+D).
Calculation Condition Description (E+D)	Gives the description for the calculation condition selected in the "Calculation Condition No. (E+D)" field.
Start date	Indicates the date from which the calculation line is valid.
End date	Indicates the date until when the calculation line is valid.
Special direct costs	Indicates possible special direct cost values.
Quantity per unit	Indicates the quantity per unit.
Special direct costs per unit	Indicates the special direct costs per unit.
Costing item no.	SEK Specifies the costing item for the special direct costs.
SEK Costing Component Description	Indicates the description for the costing component selected in the "SEK Costing Component No." field.
Project no.	Indicates a possible project number.

Via "Manage" > "Delete" you can delete a selected calculation row.

Calculation specifications#

You can use the "Costing specifications" to specify different lot sizes in advance for the cost of goods manufactured simulations, which are then taken into account in the subsequent costing.

Field	Description
No.	This is assigned automatically on the basis of a stored number series.
Item no.	This is automatically assigned with the article number from which you started the call.
Description	Corresponds to the item description.
Start date	From when should this costing specification apply.
End date	To when is this costing specification valid.
Lot size	Indicates the lot size number.
Standard	This field is queried when calculating the cost price. If this is set and the checkbox "Only standard costing specifications" is also set in the function "Costing price (fixed)/Calculate target price for item", then only lot sizes that have the checkmark set in the costing specifications are used.

Job costing conditions#

You call up the Costing conditions mask work center via the work center group card. Via this mask you can define the costing conditions you want to assign to your capacities (work center groups and work centers). The condition is taken into account during costing as soon as a capacity is addressed (e.g. because a routing is stored with a production article).

In the "General" area of the Calculation conditions mask workstation, there are initially filters that you can use to control your view. When you open the mask, the filters are always preset to the workstation group from which you called the mask.

Field	Description
Type filter	Using the type filter, you can restrict your view to lines of a specific type or none.The following selections are available: • Department • Workstation group • Workstation • Workstation line • None
Code filter	You can use the code filter to further restrict your view in addition to the type filter on a specific workstation group or similar.
Start date filter	Use the start date filter to narrow your view to specific validity lines.

Using the rows you can directly define the calculation conditions with the help of the table below.

Field	Description
Type	Using the "Type" field, you have the option of defining the condition line for a workstation group or similar. The following options are available: • Department • Workstation group • Workstation • Work plan lines
Code	You can limit each selection in the "Type" field to a specific workstation group or similar in this field.
Version code	Specify the appropriate version code.
Operation No.	Indicate a corresponding operation.
Indirect cost rate	Enter the indirect costs as an absolute amount at this point.
Indirect costs %	Enter the indirect costs as a percentage value at this point.
Calculation Condition No.	Enter the appropriate calculation condition.
Calculation Condition Description	Indicates the description for the calculation condition selected in the "Calculation Condition No." field.
Start date	Indicates the date from which the calculation line is valid.
End date	Indicates the date until when the calculation line is valid.

Via "Manage" > "Delete" you can delete a selected calculation row.

Article calculation#

The costing proposal is used for the cost of goods manufactured calculation. You can call this up directly from the respective article card via the menu ribbon.

Calculation proposal#

In the costing proposal lines, historically already preceding costings are displayed (if available).

Field	Description
Warning	Blank: The proposal line does not contain any errors and can be accepted if necessary. Errors: The proposal line contains errors that can be viewed and corrected via the error log. After correction, the proposal must be run through again.
Calculation Run Seq. No.	Indicates a sequential number per proposal line. For proposal lines that contain different article costing specifications (lot sizes), these are displayed with the same sequential number.
Calculation Run Description	Indicates the description that has been specified for the respective calculation run.
Item no.	Indicates the article number for which the suggestion line was calculated.
Description	Indicates the description of the item.
Procurement method	Indicates the stored procurement method of the item.
Status	Indicates the status of the proposal line. A distinction is made here between: • Empty • Preferred • Rejected • Transferred For more information, see the section "Change status".
Lot size	Indicates the lot size on which the proposal line was costed. Note: Please note that the lot sizes on the item card as well as in the costing specifications can be used for costing.
Calculation date	Indicates the date when the proposal line was calculated.
Cost Price (Fixed)	Indicates the deposited "Cost Price (Fixed)" on the item card.
New cost price (fixed)	Specifies the new cost price (fixed) of the proposal line.
Cost % (Consumption Activation)	Displays , (if available) the "Cost % (Consumption Activation)" determined from the costing definitions.
Overhead rate (consumption capitalization)	Displays, (if available) the "Overhead rate (consumption capitalization) determined from the costing definitions.
Guide price	Indicates the previous guide price.
New target price	Indicates the recalculated target price.

Calculate set price (fixed)/direct price for article#

When this function is executed, the cost price for the corresponding item(s) is calculated.

Field	Description
Calculation date	Specifies the calculation date. This is used to take into account the start and end dates of purchase prices, costing conditions or even bills of materials and routings for costing.
Calculation Run Description	This input is a mandatory input and defines what kind of calculation it is.
Standard costing specifications only	Here it can be defined whether the lot size of the article to be calculated is to be drawn from the article card or the calculation specification. If the switch is not activated, the stored lot size of the costing specification (if available) is treated with priority than that of the article card. If the switch is set, only the stored lot size with the identifier=standard (if available) is treated with priority than that of the article card. Note: This applies only to the first level, that is, the article to be costed.
Costing Proposal Name (Plan)	Specification of the costing proposal (plan) if simulations are performed. Note: In order to determine the correct cost price based on the structure, which is then also written back to the item card, this field must not be filled in.

Change status...#

This function allows you to set the status of the costing proposal line according to the selection (Preferred or Rejected) in the "Status" field.

The status is relevant for the function execution "Accept costing proposal (preferred)". Only costing proposal lines with the status "Preferred" are adopted.

When the price is accepted, the "Status" field is set to "Accepted".

Adopt costing proposal (preferred)#

Using this function, the values from the costing proposal lines with the status=Preferred are taken and transferred to the article card.

When executing the function, it is also possible to perform a revaluation at the recalculated price for the items that are still open.

Field	Description
Posting date	Required for the revaluation ledger sheet. Corresponds to the valuation date
Fill revaluation book.sheet	Will be selected if you want to revaluate the currently still open article items. Depending on the selection of the field "Transferred from" either the whole structure can be revaluated or only the article from the calculation proposal. The revaluation book sheet can still be controlled afterwards. It must always be posted manually.
Voucher no.	Indicates which voucher number is to be written to the revaluation ledger sheet.
Article Book. sheet template	Indication of the revaluation bookb sheet
Article Book. sheet name	Revaluation book sheet name
Transfer from	One level: Only the prices from the item from the costing proposal line will be updated. The items in lower levels will not be updated. All levels: All prices and price fields of all items that occur in the structure will be updated.

Article costing specifications#

The "Article costing specifications" can be used to carry out manufacturing cost simulations with different batch sizes. As a rule, these defaults are already defined in advance in the "Costing defaults" on the respective article card and displayed accordingly at this point. If required, changes and/or entries can be made here.

Note

This always only affects the article that is currently being costed. If costing specifications are also defined for assemblies in subset levels, these are not taken into account. Here, the lot size is always taken from the article card.

Field	Description
No	This is assigned automatically on the basis of a stored number series.
Article No.	This is automatically assigned with the article number from the data record of the calculation proposal line.
Description	Corresponds to the item description.
Start date	From when this calculation specification should apply. Reference date is the "Calculation date" when executing the function "Calculate set price (fixed)/Directive price for article".
End date	To when is this calculation specification valid. Reference date is the "Calculation date" when executing the function "Calculate set price (fixed)/Directive price for article"
Standard	This field is queried when calculating the cost price. If this is set and also at the function "Calculate cost price (fixed)/Directive price for article" the hook "Only standard costing specifications" is set, then only lot sizes are used, which have the hook set in the costing specifications. Note: Lot size from the article is not used, if valid costing specifications were found.
Remark	Indicates whether a remark exists for this calculation specification. Remarks can also be stored here.
Corrected on	Set by the system when the record is created or corrected.

Note

If there are several valid entries, the system automatically creates a separate calculation for each valid entry.

Costing proposal (planned values)#

With the costing proposal (planned values) you can simulatively calculate proposals with modified planned values and also transfer them via batch processing. Since the basis for the cost of goods manufactured calculation is always the master data, the exchange of the articles is not possible at this point. Only amount values and cost values can be changed (no times and no component quantities).

Via the calculation proposal (plan values) mask you can first select an already created proposal for editing via the "Name" field or define a new one via "New" by entering "Name" and "Description".

You can use the function calls "Propose article costing condition", "Propose capacity unit price (costing)", "Propose article unit price (fixed) (costing)" and "Propose costs according to structured BOM" to redefine the respective stored planned values in batch processing.

The function call opens a mask on which you can define new plan values in the option areas and limit your change project to certain criteria by means of the filter area.

Fixed factor:
These radio buttons allow you to define fixed values for your changes, which will be taken into account over the run and written into the "New value fields" provided for this purpose.

Correction factor:
You can use these option fields to specify factor values that are to be multiplied by the original values. Via the run, these results are also written into the "New value fields" provided for this purpose.

Via the menu item "Accept costing proposal (plan values)" you can finally accept the new plan values.

Note

Please note that only valid condition values are considered for replanning. For example, if an end date of an item calculation condition is in the past, no change value will be written into the "New value field" for this record.

Costing proposal (planned conditions)#

With the costing proposal (planned conditions) you can change the costing conditions defined in the system via batch processing. The logic here corresponds to that of the costing proposal (planned values).

Retrieve error log#

The error log lists all errors that occurred during the calculation. By clicking on the integrated lookups or the call "Display" in the menu ribbon, the errors can be edited directly from the mask.

Note

Please note that you will need to recalculate the costing after you fix the error.

Calculation values (matrix)#

In this view the rows of the account scheme are superimposed with the columns of the column layout. According to the filters entered, the values are displayed. By selecting a predefined column layout for comparison, a comparison of two calculation proposals is possible at this point.

Costing values (structure)#

In this view you see all considered costing values in a structure detailed on cost type level. Thereby you have the possibility to view the origin documents on row level via the call of the same name.

Structure list#

Using the structure list, you can view a costing proposal aggregated over all costed levels and their costs.

Field	Description
Calculation proposal 1 Filter	Select a calculation proposal that you want to have displayed.
Including overhead costs	Activate the check box if you want to consider the overhead costs included in the respective costs.
Material only	Activate the check box if you only want to view the material costs.
Cost selection	You can use the cost selection to specify the BOM depth over which you want to display the costs. Single-level: Displays the costs of the top level of the BOMs. Multi-level: Displays the costs multi-level, broken down to the last assembly/component. Multi-level: Displays the costs multi-level, broken down to the last assembly/component.

Structure list comparison#

With the help of the structure list comparison you can directly compare two costing proposals. This structure list comparison allows you to see at a glance, through visualized representation in the "Symbol Deviation" fields, at which level a change to the previous proposal has taken place.

Field	Description
Calculation Proposal 1 Filter	Select a calculation proposal that you want to compare with another proposal.
Calculation Proposal 2 Filter	Select another calculation proposal that you want to compare with the one already selected from the "Calculation Proposal 1 Filter"
Including overhead	Activate the check box if you want to consider the overhead included in the respective costs in the comparisons.
Material only	Activate the switch if you only want to compare the material costs.
Cost selection	You can use the cost selection to specify the BOM depth over which you want to display the costs. Single-level: Displays the costs of the top level of the BOMs. Multi-level: Represents the costs multi-level, broken down to the last assembly/component.

After your selection, you then execute the "Compare" function in the ribbon to compare the values in the row display.

Quotation costing#

In a quotation, you can transfer the corresponding article lines for customer-specific inquiries into a calculation in order to modify them according to customer-specific requirements and to calculate them separately. The calculated cost price and sales price can then be transferred to the offer.

Calculate manufacturing costs#

With the "Calculate production costing" function, you first initiate the costing for the selected article line. When the function is executed, a "Simulated production order" is automatically created. Depending on the setting in the "Valuation and calculation setup", the production order will then also open automatically or not.

For item rows for which a calculation has already been created, the row in the "Calculation tracking rows available" field has the "Yes" identifier. By clicking on the identifier, the costing lines can be viewed.

Calculation tracking lines#

This call opens the costing trace lines. The links between the production order and the quotation/order are displayed in the calculation tracking lines. Several production order lines can be linked to one quotation line.

Field	Description
Status	Indicates whether the quote line is linked to a calculation. When selected, the calculation tracking lines will be opened.
FA No.	Displays the FA number. This can be an FA in "Simulated", "Firmly Scheduled", "Released" or "Finished" status.
FA line number	Indicates to which FA line number the offer / order line number is linked.
Project no.	Indicates which project it is
Project task no.	Indicates which project task no. is involved.
Project plan line no.	The project plan line number is shown here.
E+D project no.	Indicates which E+D project number was entered in the production order.
Production order type	Displays the production order type from the production order.
Article No.	Displays the article number from the production order.
Variants Code	Displays the variant from the production order.
Description	Display the description from the production order.
Number of costing proposals (E+D)	Number of costing proposals (E+D) Indicates how many different costings have been carried out for this production order. There is no differentiation between target and actual costing.

Delete#

By executing the "Delete" function in the ribbon, you can delete a calculation line. If there are no more calculation lines after executing the function, the sales line will be marked with "No" in the "Calculation tracking lines available" field.

Display E+D order#

With this call you can display the corresponding E+D order. At this point, the structure of the E+D order is omitted and only the fields/calls relevant for the calculation are explained in more detail. Further information about the E+D order can be found here.

Additional costs#

Additional costs" allows you to take into account customer-specific quotation requests for the calculation. In addition to general additional costs, you can also include additional resources, articles or similar. Via the call "Costing condition" you establish the connection between the additional cost line and the costing elements and thus enable an account assignment of the results of a costing.

Components#

Via the "Components" you have the possibility to change prices and quantities, exchange items and add overhead costs if necessary.

Work plan#

Through the "Routings" you have the possibility to change prices, swap operations and add overhead costs if necessary.

Add calculation tracking manually#

With this function you can manually add already calculated E+D order lines and take them into account for the current sales line if required.

E+D markup calculation#

If the customer asks for certain discounts, the function "E+D markup calculation" is especially helpful, this allows you to run through possible markup calculations for an offer.

Costing proposals (E+D)#

The costing proposals (E+D) are structured in the same way as the conventional costing proposals. In addition, you can use them to create a simultaneous cost estimate.

To do this, you use the function "Calculate unit price/price for unit order" in the costing proposals (E+D). By specifying the costing base, actual/actual (Posted quantity) and target/actual (Expected quantity) comparisons are available.

You can use the "Change status" and "Adopt costing proposal (Preferred)" functions to adopt the calculated values for the sales line.

Microsoft, Microsoft Dynamics, and Microsoft Dynamics 365 are trademarks of the Microsoft group of companies. ↩↩↩↩↩↩↩↩↩