Page History

...

1. Go to  Extensions > Database.
   1. If you see the following error message: Invalid Object Name PLG_OBJECTS
      
      

   2. Open the MS SQL browser and execute the script:

      Code Block
      CREATE VIEW [dbo].[PLG_OBJECTS] AS SELECT GUIDSTRING ,CODE ,NAME ,ALTNAME ,STATUS FROM dbo.RESTAURANTS WHERE (STATUS = 3)

      The error message should disappear.

2. Right-click the ALLCONST section and select the Create New Database Group. Rename it as you wish

3. Right-click the group and create a new database
   

4. Staying the group menu, click on the database in the right-hand menu and fill in the fields:
   1. Name
   2. Specify the data for connecting to the WebAPI 2 server in the Basic section:
      1. Login — StoreHouse user name

      2. Password — StoreHouse user password
         

         Note
         A StoreHouse user must have a password

         
         

      3. Connection string — network connection data for WebAPI in the IP:PORT format, for example: localhost:9797
   3. In the Other section:
      1. Check the SH5 ​box​
      2. Fill in the Params Date Begin and Params Date End
   4. In the StoreHouse Import Parameters section

      1. Enter the import data parameters in the Currency and Group goods fields​

         Info
         The currency and group goods can only be selected if the connection to the StoreHouse server is successful.

         
         

      2. There is no need to fill in the SH LocationLocation field

      3. If a special inventory is performed in StoreHouse, check the Special accounting and Count in units of measurement "for expenses" boxes

   5. Click Save Save Image Added
      Image Added
      

5. The connection has been set, now you need to check it. Right-click the database in the left-hand menu and select Checking DB Connection...

   • ​If the connection is set correctly, the following message will appear:
     Image Added

   • If the connection is set incorrectly, the following message will appear:
     Image Added

6. Now, link the object to the newly created database in the left-hand list. In order to do so, right-click the right-hand field and select the Add New Object.
   Image Added
   Click Add and save the changes.

7. Open StoreHouse 5 and make sure that there is at least one department in the contractorscounterparties. If there is none, create one.
   To do this, open Dictionaries > Contractors Counterparties > Departments.
   Image Added
   If there are no enterprises, create one.

8. Go In the manager station, go to Menu > Dish ClassificationMenu Classifications and copy the GUID of the classification you are planning to use. The classification should have nested categories.!
   Image Added

   1. Stop the Feature Server and open its
   settings
   1. configuration file —  IRReportsFSPrj.ini.

   2. Add the following line into the [FS_ADDITIONAL] block:

      Code Block
      SH4_Class={B07330CD-D17E-4151-AC2F-DE341C163C7D}

      
      

   3. And insert the classification's copied GUID after the

   "

   1. =

   " symbol

   1.  symbol. If there is no [FS_ADDITIONAL] section, add one

   .

   2. Save the file and launch the Feature Server

   .

9. Go

   to the menu Settings > Central

   to  Options > Head Office > Restaurants and right-click the restaurant that needs to be linked with StoreHouse. Select item Actions >

   Storehouse Connection Editor.

   SH restaurant editor.
   Image Added

10. Select the necessary required categories. In the StoreHouse Store House 4 field of their properties, select the unit from which the data department will be downloaded.
    Do not pay attention to the field name, everything will operate properly.
    
    
11. If the classifications are visible but there is no selection of unitsdepartments, make sure that:!
    • There are
    units
    • departments in the StoreHouse 5 database
    ;
    • . There should be at least one.
    • If there are
    units
    • departments in StoreHouse then there should be a unit list in the SQL database base_nameSTAT_SH4_SHIFTS_FOODCOST in tableSTAT_SH4_SHIFTS_CORR. The unit's TYPECORR field should equal 0.
    • If there are no entries with TYPECORR=0 in SQL, clear the Feature Server log folder, change the StoreHouse database connection name and click save. Therefore, FS should request data from StoreHouse 5 once more.

1. Save and close the manager's station.
2. Add the following text at the end of the configuration file of the interactive report plugin RK7MAN\plugins\SchRepPluginClient\ini :​

...

Issue: after upgrading r_keeper to version 7.6.5.459, Feature reports do not work.

Reason: STAT_SH4_SHIFTS_CORR table is not filled.

Solution: upgrade Feature Server to version 1.39.1.7 or later.

1. Launch the FS and the manager station.

...