Skip to main content

What happens if two inventories are closed on the same day?

Updated over a month ago

It is possible to have multiple inventories on the same date (for example, a partial inventory followed by another one later in the day).
In this case, the system relies on the closure date and time to determine the order in which inventories are applied.


1️⃣ Products present in only one inventory

If a product is counted in only one inventory on that day:

  • its stock is updated normally,

  • there is no special behavior.


2️⃣ Products present in multiple inventories on the same day

If the same product is counted in several inventories on the same date:

👉 Inventories are ordered by their closure date and time, from the earliest to the latest.

The inventory closed last is therefore considered the most up to date.


3️⃣ Concrete example

Inventory 1

  • Closed on January 31 at 10:00 PM

  • Counted quantity for the product: 3

Inventory 2

  • Closed on January 31 at 11:00 PM

  • Counted quantity for the product: 5

Applied order

  1. Inventory closed at 10:00 PM

  2. Inventory closed at 11:00 PM


4️⃣ How are stock movements handled?

  • All purchases, sales, and losses for the day are applied before the inventories.

  • The first inventory (10:00 PM) adjusts the theoretical stock to the counted quantity (3).

  • The second inventory (11:00 PM) is then applied by comparing:

    • the quantity resulting from the first inventory,

    • with the newly counted quantity (5).

👉 The difference between the two inventories is then recorded as an inventory loss on the second inventory.

In this example:

  • Going from 3 to 5 → a +2 adjustment between the two inventories.


5️⃣ Key takeaways

  • Multiple inventories can exist on the same day.

  • The order is always based on the closure time, not just the date.

  • Daily movements (purchases, sales, losses) are always applied before inventories.

  • The last closed inventory determines the final stock.

  • Differences between consecutive inventories are automatically recorded.

Did this answer your question?