Above has been described how the Calculate Parts Retail Prices program would calculate the new prices by default.
The specials chapter describes extra things like creating your own Calculation reports, Calculation for a single part and an example of creating and / or update Master Price File records from Stock Management.
As mentioned before, it is possible to create up to 10 different reports per market to make the output of the calculation visible.
Note: Such a report can only run from the calculation program itself and not via the REPGEN program as usual!
The selection criteria if defined in such a report will be taken in account when this report runs, e.g. if the report selection is telling to calculate only prices for parts with a discount code 002, only for those parts retail prices will be calculated and updated back into the market price file.
A report must comply some criteria before it can be executed by the calculation program.
The most important one is that from the derived-coding of the report the routine must be called that is present in the calculation-program that calculates the new retail and whole sale price.
The routine that has to be called in the derived-coding of the report should be called as :
'RepGenRetailPriceCalculation( file-1, file-2 , file-3 , file-4 )
This routine needs 4 tables defined in the report, which sequence-number is the same as the file has been defined on the tab-page tables of the report.
The files -2, -3 and -4 are only defined in the report to get the required data printed and will be filled by the calculation program automatically. Therefore these file should be connected via a type = calculated.
In above example the routine should be called as : 'RepGenRetailPriceCalculation( 1, 2 , 3 , 4 )
Note: Although the files on sequence 2 and 3 are defined the same, in the report it will be the market price file before calculation and the market price file after calculation.
It is possible to calculate the prices for 1 single part. This is done by creating and assigning a calculation group to that single part by using e.g. a manually set up Marketing code on the part in the Price File, e.g. to "XXXXXX".
After creating the Calculation Group, you must create a Calculation Report based on the original PRP report, in which you can set up the selection criteria to include only the part with the changed Marketing Code, !1_MARKETCD = "XXXXXX".
If you then run the calculation as explained before in these helpfiles, the result of the report should only show the part for which the Marketing code has been changed to XXXXXX. If the calculated prices are satisfying, you can update the Market Price File with the calculated price.
Calculation formula:
Costprice base VLP = EUR 53.51
In base-currency = EUR 53.51
Multiplied by CIF 5 = EUR 267.55
No Customsduty for this part
Retailfactor 3% = 267.55 + 8.0265 = EUR 275.5765
Wholesalefactor 2% = 267.55 + 5.351 = EUR 272.901
Bring to market-currency SGD = 0.75
Retailprice EUR 275.5765 * ( 1 / 0.75 ) = SGD 367.44
Wholesaleprice EUR 272.901 * ( 1 / 0.75 ) = SGD 363.87
Roundingfactor 5.00
Retailprice SGD 370.00
Wholesaleprice SGD 365.00
Because normally parts-maintenance will be done by the leading SM stock-company, the facility is there to create parts (DC Korea MB100) into the master price file, or update parts when they are already present into the master price file.
Criteria for which parts might be created, can be set up in the Stock Companies option of the General Settings menu.
The Model code of the stock record is considered to contain the full marketing-code and the Line-class field on the stock record is considered to contain the vendor-code.
To create the stock records in the Price File, you must:
Note: The system knows what price is in what price slot because this is set up in the Assign Price File section of the MB parameters.
