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:
|
|
(Recalculate) |
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. |
| (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.