When filling out the goods of the collation statement, please note that all goods subject to inventory must be included in the document, including those for which the actual balances are zero. If the goods are not included in the collation statement, then the estimated balance for these goods after the creation of the collation statement will remain unchanged.
To enter goods into the collation statement, on the Goods tab:

Example: let us enter the Jameson Irish Whiskey goods into the collation statement and select the Bottle 0.7l as a UOM.

In the goods card, on the Units of measurement tab, the tare weight in grams is indicated, that is, an empty bottle of 0.7 liters. weighs 250 grams.

Since the bottle is incomplete, in the Gross (gr) field we enter the value 800, that is, the mass of the bottle with the contents in grams. The value in the Quantity field has changed.


The calculation is as follows: 800 (gross) minus 250 (tare weight) equals 550 (mass of the contents of the bottle). Since in the field Unit. rev. costs a bottle. 0.7l, in the Quantity field the amount of whiskey is displayed not in grams, but in 0.7l bottles, that is, 0.786 from a 0.7l bottle.

When filling in the "Gross" column, the resulting calculated value in the "Quantity" field should not exceed "1". If you try to exceed this value, the system will generate an error message. If you need to specify several items of goods in incomplete containers, then indicate each in a separate line.


If the product is a semi-finished product, that is, it is associated with a set and consists of other products (for example, “Pizza dough” consists of flour, vegetable oil, yeast, etc.), then a flag is set in the “Decompose into components” field (also the flag can be set using the main menu item "Document" - "Decompose into components"). You can set this flag for several products at once by selecting them with the mouse;
When the flag “Decompose into components” is set, the kit and version of the kit are automatically substituted according to the rules defined on the product card. If necessary, the kit or version can be changed manually in the document;
In the Remains field, the remaining balance (before saving the document) of the goods in the division selected by you in the Division field on the Header tab is automatically displayed.
In order for the matching list to include all goods for which there are estimated balances in this unit, it is recommended to form a matching list based on the balance sheet.

To do this, create a list of balances for the inventory unit on the date of the inventory by selecting the main menu item "Reports" - "Statements of balances" - "Statement of balances".


Fill in the balance sheet filter and click the [Apply] button.

In the report that opens, call the context menu from the table area and use the Copy to invoice… item. Specify the copy settings and click the [OK] button.


Now in the created matching list on the Goods tab you can work with the created list of goods. In the Quantity column, indicating the actual quantity (on top of the figures copied from the balance sheet).

If necessary, you can reset the quantity for the copied products. To do this, use the "Reset Quantity" context menu item. If this function is applied without selecting goods, then the quantity for all goods of the invoice will be reset to zero. If before applying the function you select goods ([Ctrl] or [Shift]), then the quantity of the selected goods will be reset to zero only.

If the same item is entered several times in one collation sheet, all lines with this item are summed up to form the estimated balance.