Physical inventory

At the end of the financial year, a count is carried out to check whether the recorded quantity corresponds to the quantity in the warehouse. Differences must be recorded before stock valuation takes place.

The article items are processed according to the information you have entered. Lines are created in the inventory book sheet. The field "Inventory quantity" is automatically filled with the same quantity as the "Quantity (calculated)" filled in. With this function, it is not necessary to enter the counted available stock for items that correspond to the calculated quantity. If the value of the counted quantity differs from the entry in the "Quantity (calculated)"this must be overwritten with the actual quantity counted.

In the first step, you calculate the expected stock level and can perform the calculation in the base stock configurations or in the extended base stock configurations.

Calculation in the base camp configurations:

1. In the search function, enter "Carry out a physical inventory" and select the action "Calculate bearing"

2. To create the book sheet lines, enter the following in the "Calculate stock" to specify the conditions to be taken into account for this step.

3. It is possible to set filters if only the stock of certain items, in certain storage bins and storage locations or dimensions are to be calculated.

4. With the button "Ok" to confirm this process.

Calculation in the extended base camp configurations:

1. In the search function, enter "Fibu book sheet" and select "Calculate storage location adjustment"

2. Enter the numbers of the items you want to count in the request window and then enter the storage location.

3. With the button "Ok" confirm this process and, if available, post the settlement.

4. In the search function, enter "Physical inventory book sheet" and select the action "Calculate bearing" The window for the batch order request opens "Logistics stock calculated.".

5. It is possible to set filters to limit the articles that are to be counted in the book sheet.

6. With the button "Ok" A line is created for each storage bin, which you can still delete at this point. The items present in all storage bins must be counted in order to be able to post the result as an inventory. It is also possible to determine differences, register them and then post them later using the "Calculate compensation" to calculate. This option can be selected if you cannot count the item in all storage bins when time is limited.

7. In the search function, enter "Carry out a physical inventory" and open the report request page to print the lists where employees can record the quantity of items counted in each bin location.

8. The counted quantity is entered in the "Inventory quantity" of the logistics inventory book sheet is automatically entered in the logistics inventory book sheet. "Quantity (calculated)" filled in on the basis of the storage bin items. These quantities are entered in the "Inventory quantity" of each line is copied. If the count deviates from the quantity entered in the "Inventory quantity" was entered, it is necessary to enter the quantity actually counted.

9. After entering all counted quantities, confirm this with the action "Capture"When registering the book sheet, two storage bin items are created in the logistics journal for each line that has been counted and registered, if the calculated and counted quantities do not match:
   - The positive and negative quantity for the storage bin is recorded. In addition, a balancing quantity is posted to the balancing storage bin of the storage location if the calculated quantity matches the counted quantity:
   - An item of quantity "0" is registered for the storage bin and for the clearing storage bin. The registration date shows that a logistics inventory was carried out and that there were no differences in the stock levels of the item.

No article, inventory or value items are generated when the logistics inventory is registered. However, the data records are available for reconciliation at any time. For traceability, it is advisable to immediately enter the logistics results as an inventory in the "Warehouse" to book.

Before starting or continuing the stock count, you will find below the description for printing the report to be used during the count. All deviations can be recorded in the printed report.

1. In the window "Physical inventory journal" tab, select the "Actions" in the group "General" the option "Print"

2. Whether the report should show the calculated quantities and whether the report should list stock items by serial/batch number can be set as an option on the info tab in the "Inventory list" must be specified.

3. It is possible to set filters if only a report is to be calculated for certain articles, storage bins and storage locations or dimensions.

4. With the button "Print" to confirm this process.

The last step involves entering or adjusting and posting the stock actually counted in the base warehouse configurations. Here again, a distinction is made between the warehouse configurations and the extended base warehouse configurations.

Input and booking in the base camp configurations:

1. In the window "Physical stock" the actual available stock determined by the count is displayed in each line in the field "Inventory quantity" entered. The linked fields are updated accordingly and no entry is made in the inventory book if the count shows differences caused by items with incorrect storage location codes. In this case, use the stock transfer book sheet or a stock transfer order to redirect the items to the correct storage locations.
2. To adjust the calculated quantity to the actual quantity, use the option "Buchen" via the tabs "Actions. Both article and inventory items are created. The resulting inventory item is displayed when the item card is opened.
3. In the search function, enter "Article" and open the relevant article card.
4. In the tab "Navigate" in the group "Article" the option "Inventory items" from.

Entry and booking in the extended warehouse configurations:

1. In the search function, enter "Fibu book sheet" and select "Calculate storage location adjustment"

2. You select the same items that were counted as part of the cyclical inventory, as well as all other items that need to be balanced, and confirm this process with "Ok".

3. By opening the window "Phys. inventory book. sheet" the lines for these items are created. Net totals are created as Article items consolidated and synchronized.

4. Post the book. sheet line without changing the quantities. Stock quantities (item items) and logistics quantities (storage bin items) are identical again for these items.
   This updates the last inventory date of the item (or the inventory data).