See also: REKA Tool (Workshop Analysis)
What do you want to do?
This form is displayed when you click Manufacturer systems (Module) and MB. Mercedes-Benz (Company) > Menu - Service > Collect Stock Value For REKA.
Buttons:
Collect: Starts the collection of stock value data.
Export: Starts the export of stock value data.
Cancel: Returns you to the Mercedes-Benz Service menu.
Help: Displays this help topic in a web browser.
To collect stock value:
On the master menu, select Manufacturer systems (Module) and MB. Mercedes-Benz (Company) > Menu - Service > Collect Stock Value For REKA.
The Collect stock value for REKA form is displayed.
Click Collect.
The stock file is checked for each stock record:
Parts with a franchise code that is not set up in the Parts Category Mapping tab of the REKA Tool (Workshop Analysis) Parameters, are excluded from collection
Parts with no stock quantity (or negative stock quantity) on the Stock locations that are set up in the Miscellaneous Parameters tab of the REKA Tool (Workshop Analysis) Parameters are ignored.
The date last purchased on the stock record is used to determine if the part should be considered as dead stock. Parts are handled as dead stock, when they are not purchased in the number of month as set up in the Mark parts as dead stock after in the Miscellaneous Parameters tab of the REKA Tool (Workshop Analysis) Parameters.
The stock value for each part is calculated based on the stock value of the Stock locations that are set up in the Miscellaneous Parameters tab of the REKA Tool (Workshop Analysis) Parameters versus the Stock locations on the Stock record.
The stock value is multiplied with the retail price from the stock record. The Assign pricefile parameters are used to determine the price slot on the stock record which holds the retail price.
The Collection date, Stock value and Dead stock value are stored in a file. The stock values of the subsequent parts will increase the corresponding stock value. The values are stored in the systems base currency. The price converted to the system base currency in case the price in the stock record is stored in a different currency.
Note: The REKA interface will use this stored information within the REKA export file. The Collect stock value for REKA function can be run multiple times per month, the collection details of the most recent stock and dead stock values are used in the export.
The sum of the dead stock and stock value are reported under REKA ID 8, Parts stock.
The dead stock value is reported under REKA ID 9, Dead stock.
Both values will be reported on parts department BU.
Two CSV files are created during the collection of the stock value, one for dead stock and one for the active stock. The CSV files can be used for verification.
Warning: The generations of the CSV verification files might slow down the collection process, you can switch this function on via the Miscellaneous Parameters tab of the REKA Tool (Workshop Analysis) Parameters.
The filename will have the following file format, [Company number]_REKA_[Collection type: Stock_Dead or Stock_Active]_[Creation date]_[Creation time].csv, and will be stored in the directory (^ ENV(LOGS)/MB/REKA) of Autoline.
To export stock value data:
On the master menu, select Manufacturer systems (Module) and MB. Mercedes-Benz (Company) > Menu - Service > Collect Stock Value For REKA.
The Collect stock value for REKA form is displayed.
Click Export.
The last generated CSV files are downloaded the to computer of the user.