WMS OMS Sync Caused Wrong Qty in OMS because of the daily sync
Dear CSO team,
We found that the current WMS to OMS stock synchronization process causes the stock in OMS to be higher than it should be, when an order is coming during the stock sync. This is the example scenario.
|
Time |
OMS available |
WMS available |
WMS SO created |
Locked Qty to Sync |
Note |
|
00:00 |
5 |
5 |
0 |
5 |
WMS lock qty to sync to OMS |
|
01:00 |
3 |
5 |
2 |
Order is coming to OMS, cutting OMS available stock |
|
|
04:00 |
5 |
5 |
2 |
OMS stock overwritten by 5 |
|
|
10:00 |
0 |
5 |
7 |
Order is coming 5pcs, OMS not knowing that actual stock is 3 |
We have found this happened several times in production (see screenshot). Why does the stock sync take so long? We observe that it starts from 00:00 until 05:00 or more. How do you plan to handle this issue?
Answer:
Solution:
Root Cause : WMS – OMS Daily Sync, previously I’ve set up the timer in a way that if the sync cannot be achieved at 12am, it will perform another sync at 3am. We cannot deny that the records of SKU has been increasing monthly and that the sync will take about approx. 30mins – 1hours for close to 18k total SKU at this moment. After the record for daily sync has been generated, only at 3am will the sync happen and that caused it to override the current qty in OMS.
Proposed Solution : Remove the daily sync. As far as all of us are concerned, another stock sync is running after each transactions and its working close to real time. We can remove this daily sync as it only serves as a contingency plan previously if any qty has been excluded. This will greatly reduce the daily inserted rows into the table as well, and in a way reduce the load in the database & datahub.
The daily sync was removed for this current warehouse.
| Files | ||
|---|---|---|
|
|
image (10).png
74 KB
|
|
|
|
image (8).png
90 KB
|