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 container (tare) weight in grams is specified, that is, an empty bottle of 0.7 liters weighs 250 grams.
Since the bottle is not full, in the Gross (G) field, we enter 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 (container weight) equals 550 (mass of the contents of the bottle). Since in the UOM field has the Bottle 0.7l value, 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 field, 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. |
In order for the collation statement to include all goods for which there are estimated balances in this department, it is recommended to form a collation statement based on the balance statement.
To do this, create a balance statement for the inventory department on the date of the inventory. To do this, go to Reports > Balance sheets > Balance statement.
Fill in the balance statement filter and click the Apply button.
In the report that opens, call the context menu from the table area and use the Copy to delivery note... item. Specify the copy settings and click the OK button.
Now, on the Goods tab of the created collation statement, you can work with the created list of goods. In the Quantity field, indicate the actual quantity on top of the figures copied from the balance statement.
If necessary, you can reset the quantity for the copied goods. To do this, use the Zero the quantity context menu item. If this function is applied without selecting goods, then the quantity for all goods of the document will be reset to zero. If before applying the function you select goods using Ctrl or Shift, then only the quantity of the selected goods will be reset to zero.
If the same item is entered several times in one collation statement, all lines with this item are summed up to form the estimated balance. |