The Calculated Purchase Price (CP) in Xentral enables detailed cost calculations and serves as the foundation for margin analysis and inventory valuation. It can be manually entered within the item settings or automatically calculated based on purchase order data. Additional costs such as customs duties, logistics, and shipping costs can also be included to create a more accurate cost structure.
Calculation Methods for the Calculated Purchase Price:
-
Manual Entry: Directly input the CP under the Details tab in the item settings.
-
Automatic Calculation: Derived from completed purchase orders or predefined calculation rules.
-
Bill of Materials (BOM) Calculation: Aggregation of component purchase prices for assembled products.
The CP is used in documents such as purchase orders and sales orders and influences profit margin calculations and inventory valuation. Changes to the CP are automatically updated unless a different calculation logic is defined. Import and export functions allow flexible adjustments to purchase prices and margins.
By maintaining an accurate Calculated Purchase Price, you can ensure better cost control and make informed pricing decisions.
When using bill of materials (BOM), the CP of subcomponents can be automatically transferred to the main item (header item). This ensures a more accurate cost calculation for assembled products.
Note
Automatic Calculation of CP for BOMs:
-
The CP is not automatically inherited from subcomponents to the BOM by default.
-
To enable this, activate the setting "Auto BOM Calculation".
-
If no factor is specified, the CP values of the subcomponents are simply summed up.
-
If a factor (e.g., 30 for a 30% markup) is set, the CP is adjusted accordingly.
Automatic or Manual Update:
-
The CP of the BOM is updated automatically overnight, without requiring a separate process starter.
-
Alternatively, the calculation can be triggered manually via a button in the settings.
-
Any manual CP entries in the header item will be overwritten if the CP of a subcomponent changes or a new factor is set.
These mechanisms ensure that BOMs always reflect current purchase prices, leading to more accurate margin and pricing calculations.
The CP settings for BOMs can be found under: Settings > Master Data > Items > Auto BOM Calculationor via Smart-Search for Auto BOM Calculation.
Steps to Activate Auto BOM Calculation:
-
Navigate to the Auto BOM Calculation settings.
-
Enable the setting for automatic CP calculation. Optional: Define a markup factor in a custom item field (e.g., 30 for a 30% markup). If no factor is set, only the summed CP values of subcomponents will be used.
-
Click Save to apply the settings.
Note
The factor is calculated as a percentage markup:
Calculated Purchase Price = (Calculated Purchase Price × Quantity) × (1 + Factor/100)
Example: A factor of 30 increases the calculated purchase price by 1.3 times.
Use whole numbers and decimals with '.' e.g. '30' or '35.5'.
If no factor is specified, only the sum of the calculated purchase prices of the subcomponents is added.
Caution
If "Auto BOM Calculation" is enabled, the "Calculated CP" checkbox in the BOM header item is automatically checked.
The CP values of subcomponents are summed overnight by an automated system process or instantly when triggered manually. Any manually entered prices in the header item will be overwritten.
|
Field |
Description |
|---|---|
|
Active |
If 'Auto BOM Calculation' is enabled, 'Calculated CP' in the BOM header is set automatically, summing subcomponent CP values overnight or manually, overwriting manual prices. |
|
Custom field for factor |
Custom field for defining a price increase factor. The calculated bill of materials price is determined by the sum of all materials plus a factor in percent. The factor must be entered as a whole number or a decimal number with a dot as the separator. Examples: '30' for 30% or '30.5' for 30.5%. |
To ensure accurate cost calculation for BOMs, you need to set the CP for subcomponents (child items). These values will then be inherited by the BOM header item.
Steps to Enter CP for Subcomponents:
-
Navigate to Master Data > Articles.
-
Find the relevant subcomponent (child item) used in a BOM.
-
Open the item and go to the Details tab. Scroll down to the Calculated Purchase Price field.
-
Enter the CP using one of the following methods: Manual: Directly input the CP. Automatic: Configure the price to be imported from purchase orders under the Calculation tab.
-
Click Save to store the changes.
Steps:
-
Open the BOM header item.
-
Ensure that Auto BOM Calculation is activated in the settings.
-
To trigger an immediate update, click "Run Calculation" to apply the new CP values.
Note
If no manual update is performed, the CP will be updated automatically overnight and inherited into the BOM header item. By following these steps, you ensure that BOMs reflect the latest purchase price data, contributing to more accurate cost, margin, and pricing calculations.