Analysis

WARNING To calculate the price for the item of own production, with the items category P - Product can proceed in a different way different because of the BOM report and value from the BOM! For more information see the example Pricing and price difference for own products.

In the Analysis tab, you can view the mark-up for an individual item or for the entire order. If a line contains a compound item, you can also view the mark-up for components on any subordinate level. Click the + sign next to the item ID to show the mark-up for each individual line. 

The sale price serves as the basis for calculating mark-up or price difference. Four different values can be subtracted from the value of the sale, that is, you can choose from four methods for calculating the purchase price of the goods.

• Costing can be searched in 4 possible ways.
• Pricing is searched in the analysis panel in the sales order line.
• Difference is defined as the difference between the sale and purchase price (=sale-purchase)
• (% of the difference) is defined as the relation between the difference and the costing value (% = difference / costing). The calculation of this percentage is equal to the calculation of the percentage of the surcharge in the Items register | Costing/pricing | pricing section (Markup fields) of the items register.

Analysis

Analysis

Analysis

In the Analysis tab, you can view the mark-up for an individual item or for the entire order. If a line contains a compound item, you can also view the mark-up for components on any subordinate level. Click the + sign next to the item ID to show the mark-up for each individual line. 

The sale price serves as the basis for calculating mark-up or price difference. Four different values can be subtracted from the value of the sale, that is, you can choose from four methods for calculating the purchase price of the goods.

Items Register	If you select the Items Register option button the program will use for the costing the price from the items register | costing/pricing | costing section - Gross in LCY field (this the suppliers price plus calculation factors of the costing value: transport, direct costs,...)
Pgm. Parameters	If you select the Pgm. Parameters option button the program will use for the costing the price from the price determined by the formula in the AP | Settings | Program parameters | Orders - BOM Prices Formula field. When this parameter is predefined is the price to be calculated suppliers price, excluding the calculation factors of the costing value.
Contract Prices	If you select the Contract Prices option button the program will use for the costing the suppliers price from the supplier's contract price list, if the one does not exist, the program will calculate the costing value by price ranges. If you select this option button you required to select in the Supplier field the the supplier's ID, where the program shall look for the price.
Valuation Prices	If you select the Valuation Prices option button the program will use for the costing the price for valuation (i.e. currently valid average price) on the primary warehouse.
Supplier	If you select for the calculation of the costing value the Contract Prices option button, you are required to select the supplier in the Supplier field, where the program shall look for the price. If you do not enter the information the program will report an error:
	If you change the search type of the purchase price, click the Recalculate button to calculate the difference in the price with new defined parameters.
	Click the Print button to print a Analysis.
(Analysis)	In the panel for analysis display values of purchase (by selected type of purchase valuation) and sale and the difference between both prices on the individual document level. If you double click this record the program will on the level of an individual item display also the sale and purchase price and the difference between these two prices.

• Costing can be searched in 4 possible ways.
• Pricing is searched in the analysis panel in the sales order line.
• Difference is defined as the difference between the sale and purchase price (=sale-purchase)
• (% of the difference) is defined as the relation between the difference and the costing value (% = difference / costing). The calculation of this percentage is equal to the calculation of the percentage of the surcharge in the Items register | Costing/pricing | pricing section (Markup fields) of the items register.

To calculate the price for the item of own production, with the items category P - Product can proceed in a different way different because of the BOM report and value from the BOM! For more information see the example Pricing and price difference for own products.