{"id":8631,"date":"2025-11-20T14:42:15","date_gmt":"2025-11-20T07:42:15","guid":{"rendered":"https:\/\/www.sterling-team.com\/news\/?p=8631"},"modified":"2026-02-25T15:01:44","modified_gmt":"2026-02-25T08:01:44","slug":"so-vs-do-anomalies-sap-business-one","status":"publish","type":"post","link":"https:\/\/www.sterling-team.com\/news\/en\/so-vs-do-anomalies-sap-business-one\/","title":{"rendered":"5 SO vs DO Anomalies in SAP Business One You Must Watch"},"content":{"rendered":"<p>In company operations, <b>Sales Order (SO) and Delivery Order (DO) are two critical documents that must stay in sync.<\/b><\/p>\n<p>However, in reality, differences or mismatches between them often occur\u2014and are often <strong>not detected in time<\/strong>.<\/p>\n<div class=\"video-container\"><iframe class=\"lazy-iframe\" data-src=\"https:\/\/www.youtube.com\/embed\/pa3K6KnD_V8\"><\/iframe><\/div>\n<p>If these errors are ignored, the business may experience:<\/p>\n<ul>\n<li>Inaccurate data<\/li>\n<li>Potential financial loss<\/li>\n<li>Audit issues<\/li>\n<li>Customer complaints<\/li>\n<li>Internal process bottlenecks<\/li>\n<\/ul>\n<h2>5 Anomalies in SAP Business One SO vs DO Reports<\/h2>\n<p>Here are the <strong>5 most common anomalies<\/strong> that often appear in <strong>SO vs DO<\/strong> reports in SAP Business One\u2014why they are dangerous, and how to detect them faster.<\/p>\n<h3>1. SO is \u201cClosed\u201d, but There Is Still Open Quantity<\/h3>\n<p>This is the most common anomaly. Example case:<\/p>\n<ul>\n<li>SO status is <em>Closed<\/em><\/li>\n<li>But Qty Delivered &lt; Qty Ordered<\/li>\n<\/ul>\n<p><strong>Why can this happen?<\/strong><\/p>\n<ul>\n<li>User manually closes the SO<\/li>\n<li>There is a DO that has not been processed<\/li>\n<li>Wrong data entry<\/li>\n<li>Or the system does not enforce quantity validation when closing<\/li>\n<\/ul>\n<p><strong>Business risks:<\/strong><\/p>\n<ul>\n<li>Customer has not received the goods, but the system assumes the order is completed<\/li>\n<li>Potential late deliveries<\/li>\n<li>Mismatch between inventory and sales<\/li>\n<li>Audit issues due to inconsistent figures<\/li>\n<\/ul>\n<p><strong>Why is this often overlooked?<\/strong><br \/>\nBecause it looks \u201cnormal\u201d in the report\u2014unless someone checks line by line.<\/p>\n<h3>2. Qty Delivered Exceeds Qty Ordered<\/h3>\n<p>This is rare, but <strong>very dangerous<\/strong>.<\/p>\n<p>Example:<\/p>\n<ul>\n<li>Customer orders 100 units<\/li>\n<li>DO shows 105 units delivered<\/li>\n<\/ul>\n<p><strong>Common causes:<\/strong><\/p>\n<ul>\n<li>Input error<\/li>\n<li>Duplicate DO<\/li>\n<li>Mistakes in the warehouse<\/li>\n<\/ul>\n<p><strong>Risks:<\/strong><\/p>\n<ul>\n<li>Margin loss<\/li>\n<li>Inventory shrinkage without being noticed<\/li>\n<li>Audit red flags<\/li>\n<li>Inconsistencies in FIFO\/serial\/batch tracking<\/li>\n<\/ul>\n<p><strong>If not checked regularly, this problem can continue unnoticed for a long time.<\/strong><\/p>\n<h3>3. SO Has Been Open for a Long Time, but No DO Is Created<\/h3>\n<p>Example anomaly:<\/p>\n<ul>\n<li>SO has been open for 60\u201390 days<\/li>\n<li>There is no DO at all<\/li>\n<\/ul>\n<p><strong>Causes:<\/strong><\/p>\n<ul>\n<li>Dummy SO for simulation<\/li>\n<li>Sales forgets to follow up<\/li>\n<li>Customer cancels, but the SO is never closed<\/li>\n<li>Goods are not yet available<\/li>\n<\/ul>\n<p><strong>Risks:<\/strong><\/p>\n<ul>\n<li>Inaccurate forecasting<\/li>\n<li>Biased MRP\/S&amp;OP<\/li>\n<li>Unrealistic sales pipeline<\/li>\n<\/ul>\n<p><strong>There is a hidden backlog<\/strong><\/p>\n<h3>4. DO Exists Without SO (Document Mismatch)<\/h3>\n<p>This usually happens when:<\/p>\n<ul>\n<li>Delivery is processed manually<\/li>\n<li>Sales creates a DO without an SO<\/li>\n<li>Emergency delivery process<\/li>\n<li>Inconsistent data entry process<\/li>\n<\/ul>\n<p><strong>Risks:<\/strong><\/p>\n<ul>\n<li>Inaccurate sales data<\/li>\n<li>Margins are difficult to analyze<\/li>\n<li>Auditors will ask why<\/li>\n<li>SO pipeline does not reflect real orders<\/li>\n<\/ul>\n<p><strong>Not every DO without SO is wrong\u2014but it must be monitored.<\/strong><\/p>\n<h3>5. Delivery Date Is Not Aligned with SO Date<\/h3>\n<p>Example issue:<\/p>\n<ul>\n<li>SO dated on the 1st<\/li>\n<li>DO dated on the 30th<\/li>\n<li>Even though SLA is 3 days<\/li>\n<\/ul>\n<p><strong>Causes:<\/strong><\/p>\n<ul>\n<li>Warehouse overload<\/li>\n<li>Backlog<\/li>\n<li>Picking\/packing queue<\/li>\n<li>Wrong prioritization<\/li>\n<\/ul>\n<p><strong>Business risks:<\/strong><\/p>\n<ul>\n<li>SLA failure<\/li>\n<li>Customer complaints<\/li>\n<li>Decreasing sales due to poor lead time<\/li>\n<li>Cash-flow delays<\/li>\n<\/ul>\n<p><strong>Many supply chain issues start from here.<\/strong><\/p>\n<h2><strong>Why Are These Anomalies Hard to Detect?<\/strong><\/h2>\n<p>Because SO vs DO reports usually:<\/p>\n<ul>\n<li>Contain hundreds or even thousands of rows<\/li>\n<li>Staff are focused on daily operations, not analysis<\/li>\n<li>Small issues seem \u201cnot significant\u201d<\/li>\n<li>It takes a long time to check each line<\/li>\n<li>There is no system that automatically raises alerts<\/li>\n<\/ul>\n<p>This is where AI can help.<\/p>\n<h2><strong>How AI Helps Detect SO vs DO Anomalies Automatically<\/strong><\/h2>\n<p>AI can:<\/p>\n<ul>\n<li>Read the entire SO vs DO report in seconds<\/li>\n<li>Detect quantity mismatches<\/li>\n<li>Flag SO that are \u201cClosed but still Open\u201d<\/li>\n<li>Identify DO without SO<\/li>\n<li>Recognize unusual data patterns<\/li>\n<li>Provide insights like a senior analyst<\/li>\n<\/ul>\n<p>AI can even answer direct questions such as:<br \/>\n\u201cShow me suspicious transactions for this month.\u201d<\/p>\n<p>For a live example, see the main article here:<br \/>\n<a href=\"https:\/\/www.sap-business-one-tips.com\/en\/ai-insight-for-sap-business-one-a-smarter-way-to-read-transaction-reports\/\" target=\"_blank\" rel=\"noopener\">&#x1f449; AI Insight for SAP Business One: A Smarter Way to Read Transaction Reports<\/a><\/p>\n<h2><strong>Conclusion<\/strong><\/h2>\n<p>The SO vs DO report looks simple, but it hides many potential issues that can impact:<\/p>\n<ul>\n<li>Data accuracy<\/li>\n<li>Customer satisfaction<\/li>\n<li>Delivery process<\/li>\n<li>Company profitability<\/li>\n<li>Audit validity<\/li>\n<\/ul>\n<p>By detecting anomalies earlier\u2014especially with the help of AI\u2014companies can work more efficiently and prevent major problems before they occur.<\/p>\n<p>To learn how this AI works directly on your own data, please contact us for a demo.<\/p>\n<p><a href=\"https:\/\/www.sterling-team.com\/sap-business-one\/\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1344\" title=\"What is SAP Business One?\" src=\"https:\/\/www.sterling-team.com\/news\/wp-content\/uploads\/2020\/05\/banner-sap-indonesia-cta-en.jpg\" alt=\"What is SAP Business One?\" width=\"600\" height=\"150\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In company operations, Sales Order (SO) and Delivery Order (DO) are two critical documents that must stay in sync. However,&hellip;<\/p>\n","protected":false},"author":1,"featured_media":8629,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[324],"tags":[],"class_list":["post-8631","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap-business-one-en"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.sterling-team.com\/news\/wp-json\/wp\/v2\/posts\/8631","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sterling-team.com\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sterling-team.com\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sterling-team.com\/news\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sterling-team.com\/news\/wp-json\/wp\/v2\/comments?post=8631"}],"version-history":[{"count":10,"href":"https:\/\/www.sterling-team.com\/news\/wp-json\/wp\/v2\/posts\/8631\/revisions"}],"predecessor-version":[{"id":8886,"href":"https:\/\/www.sterling-team.com\/news\/wp-json\/wp\/v2\/posts\/8631\/revisions\/8886"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sterling-team.com\/news\/wp-json\/wp\/v2\/media\/8629"}],"wp:attachment":[{"href":"https:\/\/www.sterling-team.com\/news\/wp-json\/wp\/v2\/media?parent=8631"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sterling-team.com\/news\/wp-json\/wp\/v2\/categories?post=8631"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sterling-team.com\/news\/wp-json\/wp\/v2\/tags?post=8631"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}