Does editing or inserting transactions affect the inventory balance?
πŸ”Έ

Does editing or inserting transactions affect the inventory balance?

Yes, your inventory balance will be automatically recalculated if you edit or add missing transactions.

The example below is the transaction of 5 products from January 1st to 30th. The first row is the oldest transaction product.

Previous Transaction Details

TransactionIDCreatedTypeProductDifferenceQuantity
1
2020-01-01
Stock In
Mackerel
+5
0 β†’ 5
2
2020-01-10
Stock Out
Mackerel
-2
5 β†’ 3
3
2020-01-15
Audit
Mackerel
+5
3 β†’ 8
4
2020-01-20
Stock In
Mackerel
+1
8 β†’ 9
5
2020-01-30
Stock Out
Mackerel
-3
9 β†’ 6

If the first transaction is revised so that the quantity is revised from 5 to 10, the current quantity automatically is revised to 11.

First Transaction Edited

TransactionIDCreatedTypeProductDifferenceQuantity
1
2020-01-01
Stock In
Mackerel
+10
0 β†’ 10
2
2020-01-10
Stock Out
Mackerel
-2
10 β†’ 8
3
2020-01-15
Audit
Mackerel
+5
8 β†’ 13
4
2020-01-20
Stock In
Mackerel
+1
13 β†’ 14
5
2020-01-30
Stock Out
Mackerel
-3
14 β†’ 11

Adding a missing transaction of 5 mackerels for January 12th is calculated identically, which makes the total quantity 11.

A Missing Transaction for January 12th Added

TransactionIDCreatedTypeProductDifferenceQuantity
1
2020-01-01
Stock In
Mackerel
+5
0 β†’ 5
2
2020-01-10
Stock Out
Mackerel
-2
5 β†’ 3
6
2020-01-12
Stock In
Mackerel
+5
14 β†’ 11
3
2020-01-15
Audit
Mackerel
+5
3 β†’ 8
4
2020-01-20
Stock In
Mackerel
+1
8 β†’ 9
5
2020-01-30
Stock Out
Mackerel
-3
9 β†’ 6

β¬… Go back