All Collections
Inventory
Stocktakes
Stock Take Results And Settlements
Stock Take Results And Settlements

Resolution of discrepancies in the quantity of goods, after stocktaking an inventory

Amalia avatar
Written by Amalia
Updated over a week ago

Before you dive into the article, please make sure to learn How To Take Stock.

Stock Take Results

So, you've completed the stock take and hit the Complete the stock take button. This created a new stock take document in the table on the Inventory > Stock takes page. Hit the document number to open it.

There are multiple filters to search the stock take entries from the list. These include but are not limited to the following:

  • Document number

  • Warehouse

  • Category

  • An employee that initiated the stock take

  • Related documents (Posting, Write-off, Transfer documents)

  • Document comments.

Here is the information the stock take results contains:

  • stock take date

  • warehouse

  • category

  • an employee that initiated the stock take

  • products quantity recorded via stock take

  • products quantity that corresponds to the accounting information (accounting quantity and actual quantity match)

  • shortage and excess (in units)

  • product table with the following columns: Accounting quantity, Actual quantity, Excess, Shortage.

Hit the Print button to print the stock take results or click Export to download the data into the Excel file. You can always leave a comment on a document if needed.

Stock Take Settlement

Use stock take settlement to resolve excesses and shortages, and to consolidate your actual and accounting product stock levels. RemOnline allows you to achieve that with postings, write-offs, and product transfers.

Hit the Stock take settlement button in the stock take document to initiate the settlement process.

The stock take settlement dialog window exposes the following information:

  • document number and stock take date

  • warehouse and product category

  • excess and shortage quantities in the stock take results

  • chart indicating the percentage of settled shortages and excesses

  • related documents the system generates as the stock take settlement goes

  • the discrepancy table divided into the following sections: Shortage, Excess, Products of other categories, warehouses, and bins, Unknown products.

Resolving Discovered Issues

We encourage you to resolve issues in the same order they appear in RemOnline. First things first, check the missing products as they may be in another bin or warehouse.

Remember: RemOnline generates the list of stock take issues based on the stock take results. Just add a comment and mark a product as resolved as soon as you manage to find all the missing products.

This way, you can resolve the problems one by one. There are 5 discrepancy types. Let's consider each one of them in detail.

Shortage

You settle the shortage with the product write-off operations.

Select the products you need to write-off and click + Write-off. This opens a write-off dialog window with all the selected products inserted into the write-off table.

Excess

Use product posting to settle your excess issues.

Select the needed products by checking their checkboxes and click + Posting. Remember: you can only post products to a target warehouse for stock take. The system sets the default bin as the bin where you found the product if you enable bin locations. You can change the bin but it will remain the same in the settlement dialog window.

The posting dialog window you open will have all the selected products in the table. You can always change the product quantity you need to post.

Products In Other Warehouses and Bin Locations

Transferring products is a remedy for this discrepancy type.

Keep in mind: Serial products are the only ones that can cause such discrepancy because only serial products can have a specific warehouse and bin to store.

Select the needed products and click + Transferring. Don't forget that you can only transfer products from a single warehouse at the same time.

Products Of Other Categories

This discrepancy arises when you perform a stock take by the specific product category, and the product of some other category gets into a list.

In this case, navigate to the product profile and change the product category to the correct one. After that, mark the problem as resolved.

Unknown Products

You need to post each unknown product manually and mark the product as resolved.

This will create related documents of posting, write-off, and transfer.

Hit the Print button to print the stock take settlement document to see the full discrepancy list and the total discrepancy sum.

Stock Take Settlement Indicator

Every table row in the settlement has the tick icon. This icon indicates that you've resolved the problem with that specific product. You can either just click the icon to mark the issue as solved, or tick the product and create the write-off, posting, or transfer document.

There is a settlement progress indicator on the right of the dialog window. It shows the percentage of resolved problems relative to the total discrepancies in the stock take.

Keep settling the stock balances until you hit the 100% rate of solved problems.

Did this answer your question?