A customer orders the last jacket on your website. Twenty minutes earlier, a branch sold the same jacket at the till, but the online store is still counting it as available. The order is accepted, then cancelled the next morning with an apology. This scenario is illustrative, not a client case. If you recognize it, the problem is not your staff. It is that the numbers describing your stock live in more than one place and are updated at different speeds.
This guide explains the symptoms of mismatched stock, what causes them, what they really cost, how to measure inventory accuracy and turnover, and how unified inventory visibility across channels works, including what Dynamics 365 Commerce with Finance & Operations (F&O) offers. It is written for retail operations, finance and IT leaders.

What are the symptoms of inventory numbers that don’t match?

The three most common symptoms are selling an item that is not available, holding stock that does not move, and counting differences that surprise you at stock take. They look unrelated, but all three come from the same gap between what the system says and what is on the shelf.
Selling a product that is not available shows up as cancelled online orders, customers told “it’s not in stock” after paying, and staff checking the back room for items the screen promised. Stagnant stock shows up as items that sit in one branch while another branch or the website runs out, because nobody can see the whole picture to move them. And count differences show up as stock take or cycle-count results that do not match the book figures, sometimes in both directions: items missing, and items found that the system did not know about.

Why don’t inventory numbers match across branches and online?

They fail to match because separate systems, delayed updates and manual entry each create gaps between the record and the physical stock. In most retailers all three are present at once.

Separate systems.
Each branch point of sale, the e-commerce platform and the warehouse system often keep their own stock figure. There is no single record that all of them read from and write to.

Delayed updates.
Many traditional integrations synchronize inventory in batches—hourly or overnight—leaving channels to operate on outdated figures between syncs. Relying on these asynchronous updates often creates stock discrepancies that lead to lost revenue. This exact operational friction is what prompted Microsoft to deliver the real-time Inventory Visibility service within Dynamics 365, eliminating the sync gap entirely.

Manual entry and process gaps.
Receiving goods, branch transfers, returns, damaged items, and adjustments are all moments when someone must record an event. A missed scan, a late entry, or a wrong quantity creates a record that no longer matches reality-and the gap grows with each transaction.

How common is this? Research commissioned by ECR Retail Loss, a European retail industry group, found that about 60% of total SKUs analyzed suffered from inventory record inaccuracies, with a wide variation between retailers-ranging from 6% for the most disciplined stores to nearly 73% for the most impacted (ECR Retail Loss, Measuring the Sales Impact of Improving Inventory Records). One reservation: this study involved a small sample of mostly European retailers, showing that the problem is widespread rather than defining its exact scale in your specific stores.

What is the hidden cost of mismatched stock?

The hidden cost has three parts: sales you never made, discounts you did not plan, and customers you disappointed. None of them appears as a line in the accounts, which is why they are underestimated.

Lost sales.
When the system says an item is out, but it is physically there, nobody sells it. When the system says it is there, but it is not, the sale is lost after the customer has already committed, which damages trust more. In the ECR research, correcting inventory records was associated with a sales increase of roughly 4% to 8% for the participating retailers, a range that depends on the retailer and should not be taken as a forecast.

Markdowns to clear stagnant stock.
Stock that cannot be seen is not moved to where it would sell, so it ages and is eventually discounted. The margin lost does not appear as an “inventory error”, only as a lower gross margin.

Unhappy customers and extra labor.
Cancelled orders, refunds, support calls, urgent transfers between branches and repeated recounts all consume time and goodwill. Capital tied up in surplus stock in one place while another place runs short is also a cost, even though no one invoices it.

Which metrics show accuracy and turnover?

Inventory record accuracy and inventory turnover are the two measures to start with, and they should be supported by a few operational indicators. Without a baseline, no improvement can be demonstrated.
Inventory record accuracy is the share of SKUs whose system quantity matches the physical count, within a tolerance you define. A strict definition counts only exact matches, while a practical one allows a small margin per item. Decide the definition first, apply it consistently, and measure by category and by location, because a small number of high-value or fast-moving items usually explains most of the discrepancy.
Count variance is the value of the differences found at stock take or cycle counts, which shows the financial weight of the problem. Stockout and cancellation rates, including online order cancellations caused by unavailable stock, show the customer-facing effect.
Inventory turnover shows how many times stock is sold and replaced in a period, usually the cost of goods sold divided by average inventory. Read it together with days of stock and the share of aged stock. The goal is for accuracy to improve while turnover holds or rises, not accuracy bought by hoarding extra stock. We do not give benchmark figures, because they differ by category, so set your own baseline first.

What is the path to a solution?

The path is a single, shared view of stock that every channel reads from and writes to, supported by process discipline. Technology without discipline reproduces the old gaps faster, and discipline without a shared view cannot keep up with sales.

In practice, the steps are these:

1. Agree one source of truth for stock, and make every channel (branches, website, warehouse) use it.
2. Capture every stock movement as it happens: sales, returns, receipts, transfers and adjustments, with as little manual re-entry as possible.
3. Define availability rules per channel, such as safety buffers and reservations, so one channel cannot sell what another needs.
4. Run risk-based cycle counts on the items that matter most, and use the results to find process causes, not just to correct numbers.
5. Roll out in phases by category or branch, measure against your baseline, then extend.
For what an ERP project involves in cost and time, see our guide to ERP implementation cost for manufacturers, which applies to retail projects as well in its structure.

How does Dynamics 365 Commerce with F&O support unified inventory?

Dynamics 365 supports this goal through Inventory Visibility, a service of Supply Chain Management that Microsoft describes as providing real-time on-hand change postings and visibility tracking across data sources and channels. It lets you query stock, make soft reservations to avoid overselling, and define available-to-promise calculations across channels, including sources that are not part of Dynamics 365.

For retailers using Dynamics 365 Commerce, Microsoft documents an integration in which inventory queries and changes from Commerce channels—such as the Store Commerce point of sale and the e-commerce site—go through Inventory Visibility, so that changes are reflected in near real time instead of waiting for batch synchronization. Finance & Operations adds the back-office layer behind it: procurement, warehouse operations, replenishment, costing, and finance on the same data. According to Microsoft Learn, the Inventory Visibility add-in is available at no extra cost for companies with a valid Supply Chain Management license.

Two operational realities are worth noting clearly. Microsoft’s own documentation notes that availability values shown in the point of sale and e-commerce may remain estimated for fractions of a second until transaction synchronization is complete. Furthermore, technology alone cannot prevent manual receiving errors or unrecorded damaged goods; counting and process control remain essential. This is where Mazaya Integrated Solutions comes in: the technology narrows the gap between systems, while we help you configure operational rules and inventory governance to ensure your system accuracy approaches 100% in everyday operations.

Frequently asked questions

Why does my website show an item in stock when the shelf is empty?
Usually because the website’s figure was last updated before the item sold in a branch, or because a physical difference was never recorded. Delayed synchronization and manual entry are the two most common causes.
What is inventory record accuracy, and what is a good level?
It is the share of items whose system quantity matches the physical count within a defined tolerance. There is no universal target: it depends on your definition, categories and risk, so set a baseline and improve against it.
How often should we count stock?
More often for fast-moving and high-value items and less often for slow, low-value ones. Risk-based cycle counting is usually more effective than relying only on an annual stocktake.
Do all channels need real-time stock updates?
Not equally. Fast-moving items and items sold online benefit most from near real-time updates, while slow movers can tolerate longer intervals. Decide by item and channel.
Can Dynamics 365 work with our existing e-commerce platform?
Inventory Visibility exposes interfaces that other channels can use, and Dynamics 365 Commerce includes its own point of sale and e-commerce. Whether to keep or replace your current platform depends on its integration capabilities and your plans, so it is a design decision to assess early.

See your own stock gap

The quickest way to see whether this applies to you is to measure it: take your top-selling items, compare the system quantity with a physical count in two branches and the online store, and note the difference. Contact us to book a consultation or a demo, and we will review how your stock is recorded and shared across channels and what a unified view would involve. Reach us at info@mazayasolutions.com or at www.mazayasolutions.com.

About Mazaya Integrated Solutions

Mazaya Integrated Solutions is a Microsoft Solutions Partner with more than 20 years in the technology market and a growing footprint across the Gulf. Founded in 2005 as a software development company, Mazaya moved its headquarters to Kuwait in 2014 to expand regionally, and in 2023 relocated it to Riyadh as part of a company-wide restructuring. Its end-to-end implementation and consulting services center on Microsoft Dynamics 365, including Finance & Operations for financial and supply chain management, Business Central, CRM and Contact Center, alongside AI and robotic process automation, cybersecurity, risk and compliance, and cloud and infrastructure solutions.
Mazaya works with Saudi ministries and government authorities as well as companies in the food, financial, real estate, healthcare and education sectors across Saudi Arabia and Kuwait, and holds ISO 9001, 27001, 45001, 14001, 20000-1, 22301 and 42001 certifications. With offices in Riyadh and Kuwait, the team helps decision-makers choose the systems that fit their operations and turn them into measurable results.