Introduction
The Online Balances report makes it possible to record balances taking into account current sales in r_keeper 7. R_keeper 7 sales data is taken from the SQL database which needs to be configured in advance.
...
- Set up a connection between r_keeper 7 and MSSQL
- Set up Enterprises in StoreHouse 5
- Enter all incoming, outgoing and internal invoices into SH5
- Process all previous sales transactions.
Report Workflow
- A list of Enterprises is selected from the Online Balnces report filter for compiling the report
- QushSvc that will address r_keeper 7 SQL databases are determined based on the Enterprises attributes
- The Sh5 Database + SQL RK7 Database pair is defined based on the links settings
- Sales data for the current computer date are selected from r_keeper 7 SQL database
- r_keeper 7 Sales — closed (paid) orders, including returns
- The list of used ingredients is defined based on the dish sales in r_keeper 7
- The current sales based on ingredients (for each department) are deducted from the StoreHouse 5 current balances
- The Online balances is formed.
Required System Settings
Recording of current r_keeper sales into r_keeper cumulative SQL base(s):
...
- Launch the SDBMan.exe app
- Go to Maintenance > Statistics
- In the opened window's left-hand part, select the Binary object fields — aDivisions_AttrsEx
- Right-click in the lower right-hand part and select Add attribute...
- The attribute should have the following values:
Identifier — $Qush
Name — Qush IP-address:port
Type — tStrP.
- After the attribute is created, it can be filled in the Enterprises reference.
Report Filters
The Online Balances report filter is shown in the figure below:
...
- Code: contains the good's StoreHouse stock number.
- Goods: contains the good's name. R_keeper dishes expenses are not displayed in the report. Only Store House goods, balances for which are accounted at the enterprise, are displayed.
- UOM: is a measurement unit for compiling reports or a base measurement unit if the respective box is checked in the report filter.
- Quantity: the quantity of the goods calculated for now based on r_keeper sales. A negative value in the Quantity field means that when the Online Balances report was formed there was a shortage of the product in the system for processing r_keeper expenses. And, if writing-off documents are generated for this expense, compensation records will be created for “negative” goods.
Report Sample
An Online Balances report is given below.
...
- Server: IP and connection port for QushSvc.exe specified in the enterprise properties settings
- Link: the link name from QushSvc.exe, through which connection to r_keeper 7 base is performed
- Message: error text.
Possible errors
- Connection refused: QushSvc.exe specified in enterprise settings has not been launched
- The write-off department is not specified for the goods (goods name): there is a dish in r_keeper dish expenses, for which write-off department for sales location is not specified in Store House goods card. Specify the write-off department and update the report
- Goods not found by GUID: there is a dish in r_keeper dish expenses, that has not yet been imported into Store House (a new dish). Import the items to update the Store House references. You also need to create a set if the dish requires cooking
- Goods modifier not found by GUID (name of goods for which problematic modifier is represented in r_keeper dishes expense): there is a modifier in r_keeper dish expenses, that has not yet been imported into Store House (a new modifier). Import items from r_keeper to update the StoreHouse references. You need to create a set if the modifier requires cooking.
If set is not specified for the goods from r_keeper dishes expense, or it is an empty set or an empty set for a semi-finished product, there will be no error message in report protocol.
...