{"id":6401,"date":"2016-06-17T11:53:09","date_gmt":"2016-06-17T15:53:09","guid":{"rendered":"https:\/\/www.inflowinventory.com\/support\/article\/6401\/?p=6401"},"modified":"2024-06-21T09:03:17","modified_gmt":"2024-06-21T13:03:17","slug":"movement-history-inaccurate","status":"publish","type":"post","link":"https:\/\/onpremise.inflowinventory.com\/support\/article\/6401\/movement-history-inaccurate\/","title":{"rendered":"My movement history is inaccurate!"},"content":{"rendered":"<p>It&#8217;s important to note that inFlow On-Premise&#8217;s movement history is only as accurate as the data entered. For example, if one of your users missed inputting a sales order into inFlow but still removed\u00a0the items, you would see a difference between the numbers in inFlow and the physical count.<\/p>\n<p>Here&#8217;s an example situation:<\/p>\n<p>A physical count at the Main Warehouse location for item 04275 yields 540 total. But, inFlow is showing 560. It&#8217;s easy to change the number from 560 to 540 in inFlow, but why is the number different in the first place? This requires a lot of in-depth checking for each movement.<\/p>\n<h2>How do I find out what&#8217;s different?<\/h2>\n<p>To start, go to the product&#8217;s <em>Movement History<\/em> tab. If you use more than one Location, be sure to filter that so it&#8217;s easier to focus on just the location showing the incorrect quantity.<\/p>\n<p><div class=\"article-image\"><img loading=\"lazy\" class=\"aligncenter wp-image-16001 size-full\" src=\"https:\/\/onpremise.inflowinventory.com\/support\/wp-content\/uploads\/sites\/4\/2016\/06\/6401_1.png\" alt=\"6401_1\" width=\"1016\" height=\"734\" srcset=\"https:\/\/onpremise.inflowinventory.com\/support\/wp-content\/uploads\/sites\/4\/2016\/06\/6401_1.png 1016w, https:\/\/onpremise.inflowinventory.com\/support\/wp-content\/uploads\/sites\/4\/2016\/06\/6401_1-300x217.png 300w, https:\/\/onpremise.inflowinventory.com\/support\/wp-content\/uploads\/sites\/4\/2016\/06\/6401_1-768x555.png 768w\" sizes=\"(max-width: 1016px) 100vw, 1016px\" \/><\/div><\/p>\n<p>We know that the excess stock is exactly 20. What we do not know is if that is the total of several actions that were not recorded, or one. For example, this could be the result of one large sale that went unrecorded,\u00a0several smaller sales, or even a stock adjustment. Here are a few things to check:<\/p>\n<p><strong>If the physical quantity is less than the quantity in inFlow:<\/strong><\/p>\n<ul>\n<li>stock adjustment (decrease) was not recorded in inFlow<\/li>\n<li>purchase order return + unstock was not recorded in inFlow<\/li>\n<li>some sales orders were not recorded in inFlow<\/li>\n<\/ul>\n<p><strong>If the physical quantity is more than the quantity in inFlow:<\/strong><\/p>\n<ul>\n<li>sales order return + restock was not recorded in inFlow<\/li>\n<li>some purchase orders were not recorded in inFlow<\/li>\n<\/ul>\n<p>If you have a paper trail for every sales order and purchase order matching the orders in inFlow, then you can rule out any missing orders. This is also true for restocking and unstocking, since this involves some communication between you and your customer\/vendor.<\/p>\n<p>The more difficult transaction to check\u00a0is the stock adjustment. \u00a0Without any paper trail for this, it comes down to questioning your users to figure out what could have happened.<strong>\u00a0Stock adjustments could mean:<\/strong><\/p>\n<ul>\n<li>the item was damaged in your location\u00a0and\u00a0had to be discarded<\/li>\n<li>the item was allowed to be removed from the location but not sold (e.g free gifts to users)<\/li>\n<li>theft (unfortunate, but should not be ruled out)<\/li>\n<\/ul>\n<p>You&#8217;ll notice in the bullet points above that &#8220;stock adjustment (increase)&#8221; isn&#8217;t listed. When an item comes in, it&#8217;s entering your locations\u00a0from somewhere.\u00a0For example, if\u00a0your customer returned the item to you, you bought the item, or it&#8217;s coming from another location. All\u00a0these methods have a proper procedure in inFlow (sales restock, purchase order, or stock transfer). You should record these accordingly instead of as a stock adjustment increase.<\/p>\n<h2>Okay, now how do I fix the numbers?<\/h2>\n<p>That depends on whether you were able to find out the cause of the difference.<\/p>\n<h3><strong>If you&#8217;ve found the cause&#8230;<\/strong><\/h3>\n<p>Great! You could slot that change back into the movement history historically.<\/p>\n<p>For example, if the\u00a0difference\u00a0was because of\u00a0a missing sales\/purchase order,\u00a0<a href=\"https:\/\/onpremise.inflowinventory.com\/support\/article\/96400077\/how-do-i-backdate-my-orders\/\" target=\"_blank\" rel=\"noopener noreferrer\">create\u00a0the order and backdate it<\/a>. This will slot the movement into its proper place in the movement history.<\/p>\n<p>If it was an unrecorded sales\u00a0<a href=\"https:\/\/onpremise.inflowinventory.com\/support\/article\/31388654\/how-do-i-handle-customer-returns-and-print-credit-notes\/\">restock<\/a>\u00a0or purchase\u00a0<a href=\"https:\/\/onpremise.inflowinventory.com\/support\/article\/31384974\/how-do-i-return-items-to-my-vendor\/\">unstock<\/a>, go to the order in question and input that information.<\/p>\n<p>If it&#8217;s an unrecorded stock adjustment due to waste\/damaged goods, unfortunately we don&#8217;t allow backdating stock adjustments. We would recommend <a href=\"https:\/\/onpremise.inflowinventory.com\/support\/article\/60006700\/how-do-i-track-damaged-goods-in-inflow\/\" target=\"_blank\" rel=\"noopener noreferrer\">creating a customer to track waste\/damaged goods<\/a> and reducing the stock from there.<\/p>\n<h4>After backdating, the numbers in movement history look even weirder!<\/h4>\n<p><strong>Keep in mind that backdating anything\u00a0will change the numbers of the &#8220;quantity before&#8221; and &#8220;quantity after&#8221; section.<\/strong><\/p>\n<p>inFlow always tracks your inventory movement by &#8220;differences&#8221; instead of &#8220;quantities before and after&#8221;.<\/p>\n<p>For example, if you have 580 in stock and you enter a sales order for 20, inFlow doesn&#8217;t set your new quantity to 560. It looks at the previous quantity (580) and then removes 20 from that number (bringing it to 560).<\/p>\n<table style=\"height: 95px;\" border=\"1\" width=\"447\" cellpadding=\"5\" align=\"center\">\n<tbody>\n<tr>\n<td style=\"text-align: left;\" width=\"99\">Transaction<\/td>\n<td style=\"text-align: center;\" width=\"107\">Qty Before<\/td>\n<td style=\"text-align: center;\" width=\"108\">Qty Change<\/td>\n<td style=\"text-align: center;\" width=\"105\">Qty After<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\" width=\"99\">Sales Order 1<\/td>\n<td style=\"text-align: center;\" width=\"107\">580<\/td>\n<td style=\"text-align: center;\" width=\"108\">20<\/td>\n<td style=\"text-align: center;\" width=\"105\">560<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\" width=\"99\">Sales Order 2<\/td>\n<td style=\"text-align: center;\" width=\"107\">560<\/td>\n<td style=\"text-align: center;\" width=\"108\">10<\/td>\n<td style=\"text-align: center;\" width=\"105\">550<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>The simple table above shows a chronological sequence of two sales orders. Notice how the qty after on the first line matches the qty before on the second line. Let&#8217;s say we backdate a sales order for 5\u00a0units,\u00a0and it was actually sold before Sales Order 2. This would be your new movement history screen:<\/p>\n<table style=\"height: 95px;\" border=\"1\" width=\"447\" cellpadding=\"5\" align=\"center\">\n<tbody>\n<tr>\n<td style=\"text-align: left;\" width=\"99\">Transaction<\/td>\n<td style=\"text-align: center;\" width=\"107\">Qty Before<\/td>\n<td style=\"text-align: center;\" width=\"108\">Qty Change<\/td>\n<td style=\"text-align: center;\" width=\"105\">Qty After<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\" width=\"99\">Sales Order 1<\/td>\n<td style=\"text-align: center;\" width=\"107\">580<\/td>\n<td style=\"text-align: center;\" width=\"108\">20<\/td>\n<td style=\"text-align: center;\" width=\"105\">560<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\" width=\"99\">Sales Order (backdate)<\/td>\n<td style=\"text-align: center;\" width=\"107\">560<\/td>\n<td style=\"text-align: center;\" width=\"108\">5<\/td>\n<td style=\"text-align: center;\" width=\"105\">555<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\" width=\"99\">Sales Order 2<\/td>\n<td style=\"text-align: center;\" width=\"107\">555<\/td>\n<td style=\"text-align: center;\" width=\"108\">10<\/td>\n<td style=\"text-align: center;\" width=\"105\">545<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Your movement history numbers are different now! This is expected as you&#8217;re backdating stuff and so the history would be different.<\/p>\n<p>While this information seems\u00a0conflicting, it&#8217;s important to note that\u00a0<strong>it&#8217;s still correct<\/strong>. If\u00a0we <strong>didn&#8217;t<\/strong> backdate that order and just slotted it in as\u00a0the latest order,\u00a0the final count is still 545.<\/p>\n<table style=\"height: 95px;\" border=\"1\" width=\"447\" cellpadding=\"5\" align=\"center\">\n<tbody>\n<tr>\n<td style=\"text-align: left;\" width=\"99\">Transaction<\/td>\n<td style=\"text-align: center;\" width=\"107\">Qty Before<\/td>\n<td style=\"text-align: center;\" width=\"108\">Qty Change<\/td>\n<td style=\"text-align: center;\" width=\"105\">Qty After<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\" width=\"99\">Sales Order 1<\/td>\n<td style=\"text-align: center;\" width=\"107\">580<\/td>\n<td style=\"text-align: center;\" width=\"108\">20<\/td>\n<td style=\"text-align: center;\" width=\"105\">560<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\" width=\"99\">Sales Order 2<\/td>\n<td style=\"text-align: center;\" width=\"107\">560<\/td>\n<td style=\"text-align: center;\" width=\"108\">10<\/td>\n<td style=\"text-align: center;\" width=\"105\">550<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\" width=\"99\">Sales Order (new)<\/td>\n<td style=\"text-align: center;\" width=\"107\">550<\/td>\n<td style=\"text-align: center;\" width=\"108\">5<\/td>\n<td style=\"text-align: center;\" width=\"105\">545<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>See another\u00a0example below for backdating using a sales order. Assume that the 20 units were actually sold on 4\/20\/2016 but were not entered into the system. Below, we have backdated an order on 4\/20\/2016 (SO-000013).<\/p>\n<p><div class=\"article-image\"><img loading=\"lazy\" class=\"aligncenter wp-image-16071 size-full\" src=\"https:\/\/onpremise.inflowinventory.com\/support\/wp-content\/uploads\/sites\/4\/2014\/06\/6401_3.png\" alt=\"6401_3\" width=\"1016\" height=\"734\" srcset=\"https:\/\/onpremise.inflowinventory.com\/support\/wp-content\/uploads\/sites\/4\/2014\/06\/6401_3.png 1016w, https:\/\/onpremise.inflowinventory.com\/support\/wp-content\/uploads\/sites\/4\/2014\/06\/6401_3-300x217.png 300w, https:\/\/onpremise.inflowinventory.com\/support\/wp-content\/uploads\/sites\/4\/2014\/06\/6401_3-768x555.png 768w\" sizes=\"(max-width: 1016px) 100vw, 1016px\" \/><\/div><\/p>\n<h3><strong>If you didn&#8217;t find the cause&#8230;<\/strong><\/h3>\n<p>This is understandable as you may not have the time or resources to do so.\u00a0Make the adjustment now and put some notes in the remarks section. If you do find the proper cause later on,\u00a0you can backdate the actual cause following the steps above, then\u00a0cancel this stock adjustment.<\/p>\n<p>You could also\u00a0<a href=\"https:\/\/onpremise.inflowinventory.com\/support\/article\/36195794\/how-do-i-create-and-complete-a-count-sheet\/\">do a count sheet<\/a>. It&#8217;s important to lock down all movement while you do this. After you finish a count, check with all your users responsible for inputting data into inFlow. \u00a0Verify that they are inputting procedures in correctly (adjustments, returns, etc). If they&#8217;re all on the same page, you should start to see less discrepancies going forward.<\/p>\n<h2>I\u00a0don&#8217;t use the sales or purchasing module, only stock adjustment.<\/h2>\n<p>Some users may not want to use the sales \/ purchase \/ transfer modules in inFlow\u00a0and just rely on the stock adjustment module to save time. While this is perfectly fine for previous versions, as of v3.5.1 we do not allow backdating stock adjustments so this will be quite difficult to correct. Keep in mind that reading the movement history for each stock adjustment can be quite confusing,\u00a0if you only keep records of &#8220;quantity before&#8221; and &#8220;quantity after&#8221;.<\/p>\n<p>Focus instead on the quantity in\/out (i.e differences) and you should be able to match each transaction with inFlow.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>It&#8217;s important to note that inFlow On-Premise&#8217;s movement history is only as accurate as the data entered. For example, if one of your users missed inputting a sales order into inFlow but still removed\u00a0the items, you would see a difference between the numbers in inFlow and the physical count. Here&#8217;s an example situation: A physical [&hellip;]<\/p>\n","protected":false},"author":21,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_et_pb_use_builder":"","_et_pb_old_content":""},"categories":[20,23],"tags":[46,49],"_links":{"self":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/6401"}],"collection":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/comments?post=6401"}],"version-history":[{"count":15,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/6401\/revisions"}],"predecessor-version":[{"id":30038,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/6401\/revisions\/30038"}],"wp:attachment":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/media?parent=6401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/categories?post=6401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/tags?post=6401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}