Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

You can import goods self cost from StoreHouse 5 into r_keeper 7. If you need the instruction for StoreHouse 4, you can find it in the corresponding article.

Excerpt
nameSelf Cost Import

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. 


Note

Google Chrome does not support FTP anymore. So, copy the link and open it via the file explorer or FTP client.

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

...

  1. Go to Service > Data export >

...

  1. StoreHouse Database Configurations 
    Image Added
  2. Right-click in the blank field and select New Store House Configuration
    Image Added 
    Specify the following properties:
    1. User Name

...

    1. : for

...

    1. example, Admin

...

    1. Server:port

...

    1. : 

...

    1. StoreHouse 5 server address and port. They must be divided by a semicolon.
      Image Added
    2. User password

...

    1.  StoreHouse Version in the drop-down menu

...

    1. Change the Status to active and save the changes
    2. If you use r_keeper 7 version 7.7.0 and higher, click Test
      Image Added
    3. The message on connection error via WebApi will appear. As WebApi is not used, ignore the message and click OK.
      Image Added

Creating Self-Cost Types

  1. Go to Menu > Self-cost Type

...

  1. Image Added
  2. Right-click in the blank field and select New Self-Cost Type
    Image Added
  3. Specify self-cost Name
  4. Check the following boxes in the properties

...

  1. :
    • Use in

...

    • Reports
    • Allow

...

    • Overridings
  1. In the 

...

  1. Store House Config, select the

...

  1. one,

...

  1. previously created in Database Configurations
  2. Optionally, you

...

  1. may specify the 

...

  1. Commodity Group in quotes,

...

  1.  exactly as in StoreHouse.

...

  1. It is not

...

  1. obligatory, you may specify this property right before the import. It is also possible to specify several commodity groups, separated with spaces or commas.

...


  1. Image Added
  2. Change the status to 
  1. Active
  2. Save the changes.

    Image Added
Info

In r_keeper versions 7.7.0 and higher, selection of the root node is configured in the Plugin settings. The fields are left for compatibility with StoreHouse 4 and are optional.

Image Added

Import Launch

There are two methods for launching ways to launch the import: directly from the menu or through via data imports.

  1. On In the manager 's station, go to Service > Data Import > Import Self-cost Data Cost from StoreHouse.
  2. Select the Type of the cost of goods soldSelfCostType created in step 4.Select Directory Elements.
  3. Select the ObjectIdent
  4. Select the Division keyDepartmentId from the dropdown menu.
  5. If you need to specify a goods the GroupCode, i.e. commodity group, do it manually in quotes, exactly as in StoreHouse. You can list multiple goods several commodity groups, separated with spaces or commas. For example, Restaurant menu.
  6. If necessary, select the the CalculationDate, Element typeObjectRefNo, Directory elementsand Calculation method.ObjectIdent and SH4CostType
  7. Click OK
    .Image Added
  8. Click OK.
    Image Added

To quickly import only a selected menu group, launch the import directly from the menu. To do this:

  1. In the manager station go to the to Menu > Menu.
  2. Right-click the selected required menu group.
  3. Choose Actions > Import the cost of goods sold Cost from StoreHouse
    .Image Added
  4. Configure import details as described above and perform launch the launchimport.

Troubleshooting

Issue: Import cannot be launched. The Unable to find the sh5rki.dll library. Import from StoreHouse 5 unavailable error is outputunavailable error appears.
Reason.: Necessary libraries are missing in the manager station folder.
Solution.: Check the availability of all required files at if there are all the following files in the manager station folder and add the following them if needed:

  • sh5rki.dll
  • SdbCli.dll
  • msdset.dll
  • RTL60.BPL
  • domm.dll

Restart the directories reference server and the manager station. Check again.

Issue. Import cannot be launched. The following error is outputappearsError import costs (dll: sdbcli.dll, error: [-2147482645] Server library procedure error 1003.
Reason. An enterprise in StoreHouse stands for the restaurant in r_keeper _ 7. Restaurant menu groups are linked to the enterprise. Consequently, when importing, you should select a division department linked to the correct enterprise.
Solution. Link divisions departments to the correct enterprise.

...

.

...

Restart the directories reference server and the manager station. Check again. Importing the cost of goods sold from SH5 via the Feature Server  Switching to the Cinema cash desk (cross-functional cash desk)