Balance discrepancy: balancing product balances in Torgsoft via the "Inventory Statement"

Instructions for eliminating discrepancies in product quantities between the store and the Torgsoft software by conducting an inventory count.

This material is intended for users and system administrators who have basic skills in working with the operating system, Windows services, and Microsoft SQL Server. All described actions are performed at your own risk: incorrect changes to settings, services, or the database may lead to data loss or the program becoming inoperable. Before making any changes, it is recommended to create an up-to-date backup copy of the database, check available disk space, and make sure there are no active users in the system. If you are not confident in the correctness of your actions or do not understand the consequences — you should contact technical support.

When balance alignment is needed

• When the actual quantity of goods in the store does not match the quantity of goods in the Torgsoft software.

Signs of a discrepancy

• DATA_MISMATCH. The quantity of goods in the store differs from the data in the Torgsoft software.

• NEGATIVE_STOCK. The error «Not enough goods» appears during a sale, although the goods are physically present in the store.

Typical causes

• A mismatch between inventory accounting in the store and in the Torgsoft software (for example: goods arrived from the supplier to the store, but they were not posted as received in the software; goods were actually sold, but the sale was not recorded in Torgsoft, etc.).

• Logical failures: deleting documents in Torgsoft «retroactively» or incorrect manual editing of warehouse documents.

What to do

 Attention! The procedure for processing an inventory sheet will create warehouse documents in Torgsoft: a Write-off Act and a Goods Receipt Note. Profit: a shortage of goods identified after processing the inventory sheet affects the store's profit.

1. Process the inventory sheet (stocktaking of goods) in Torgsoft according to the video tutorial in the article on our website “Inventory in retail: how to correctly perform stocktaking?”

2. Apply the stocktaking results by closing the inventory sheet.

How to check the result

Open the “Inventory Results” report for the required sheet in the “Document” - “Inventory Sheet” form.

How to avoid the problem

• Record all goods operations in the Torgsoft software so that they actually correspond to the movement of goods in the store.

• Do not delete warehouse documents in Torgsoft “retroactively”.

Summary

The stock balances in the store and in the Torgsoft software must match (must be identical) after the inventory sheet is closed.