Scheduled Import of Goods Self Cost

In StoreHouse5, it is possible to configure automatic self cost import from r_keeper 7, performed according to the schedule.

To do this:

• Make settings in the manager station
• Create a self cost type
• Configure import plugin
• Specify the period
• Set up the event

Library Copying

To configure the import of goods self cost, copy all DLL files from the StoreHouse folder, and then make necessary settings at the manager station. Do not forget to configure the goods self cost in StoreHouse: create the required goods, make sets for dishes and make a receipt note.

1. Download the archive with library files from the FTP server ftp://ftp.ucs.ru/StoreHouse 5/_utils/sh5rki/
2. Unpack the archive into the reference server folder. Agree to replace the files.
3. Unpack the archive into the manager station folder. Agree to replace the files.
4. Copy RTL60.BPL from the StoreHouse5\Client installation folder into the reference server and manager station folder.
5. Restart the reference server and the manager station. 

Use your dealer ID to authorize at the FTP server.
If your r_keeper 7 is installed from the archive, copy the above-mentioned files to the rkeeper\bin\win folder.

Manager Station Settings

1. Launch the manager station
2. Go to Service > Data export > StoreHouse Database Configurations 
   
   
3. Right-click in the blank field and select New Store House Configuration
    
   Specify the following properties:
   1. User Name: for example, Admin
   2. Server:port: StoreHouse 5 server address and port. They must be divided by a semicolon.
      
   3. User password
   4.  StoreHouse Version in the drop-down menu
   5. Change the Status to active and save the changes
   6. If you use r_keeper 7 version 7.7.0 and higher, click Test
      
      
   7. The message on connection error via WebApi will appear. As WebApi is not used, ignore the message and click OK.
      

Creating Self-Cost Types

1. Go to Menu > Self-cost Type
   
   
2. Right-click in the blank field and select New Self-Cost Type
   
3. Specify self-cost Name
4. Check the following boxes in the properties:
   • Use in Reports
   • Allow Overridings
5. In the Store House Config, select the one, previously created in Database Configurations
6. Optionally, you may specify the Commodity Group — in quotes, exactly as in StoreHouse. It is not obligatory, you may specify this property right before the import. It is also possible to specify several commodity groups, separated with spaces or commas.
   
7. Change the status to Active
8. Save the changes.
   
   

Plugin Settings

1. To launch the plugin, Plugin External user's data is used. Do not delete the Plugin External user.
   
2. In the manager station, go to Personnel > Employees
   
   
3. Go to Head Office > XML-Editing > Properties
   • in the Manager Restrictions, check the HTTP Access box
     
   • in the Priveleges block of the Manager Restrictions section, check the Menu box
     
4. Go to Options > OLAP Reports > Reporting Servers
   
   
5. Click on the References server:
   • In the XML interface line of the HTTP restrictions section, select HTTP Access
   • In Restrictions, check the HTTP Access box
     
6. Go to Service > Plugins configurations
   
   
7. Select the Import SH plugin. Right-click in the blank space and select New Plugin configuration
   
8. Specify the configuration name and change the status to Active
   
   
9. Double-click in the Settings line of the Basic block
   
10. The plugin configuration window will open
    
    Fill in the following lines:
    • Active Only: to import self costs only for active elements of r_keeper 7 reference
    • Department: specify the department name as in StoreHouse. To see the name, start SDBman and go to StoreHouse > Departments and department groups
      
      
    • Item: the item to be imported. Depending on the value, the corresponding type of item will be imported.
    • Item type (first line): item of menu group, where self costs will be imported to
    • Self-Cost Type:!