{"id":3854,"date":"2013-09-11T09:06:10","date_gmt":"2013-09-11T09:06:10","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=3854"},"modified":"2025-09-22T09:41:24","modified_gmt":"2025-09-22T09:41:24","slug":"ic-physical-inventory-reconciliation-process","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/11\/ic-physical-inventory-reconciliation-process\/","title":{"rendered":"I\/C Physical Inventory Reconciliation Process"},"content":{"rendered":"

In Sage 300 ERP (formerly known as Sage Accpac ERP), Inventory Control allows you to enter the results of physical counts into your system and helps you reconcile the differences between the physical count and the calculated quantities-on-hand in system.
\nOne important aspect of ensuring that your business runs smoothly is to periodically compare written inventory records against the actual physical stock on the shelves and in the warehouse. If there is a difference between the number of items your records indicate and the actual stock, you will need to reconcile that difference by finding the source of the error. This will help improve your inventory tracking procedure and prevent theft.
\nHere are the steps to do Physical Inventory Reconciliation in Sage 300 ERP.<\/span><\/p>\n

1. I\/C Generate Inventory Worksheet: <\/b>This screen will process Inventory Worksheet based on selection criteria and after completion of process, it will prompt a message \u201cInventory reconciliation has been generated\u201d.<\/b><\/p>\n

\"1\"<\/a><\/p>\n

\"2\"<\/a><\/p>\n

The New Stuff:<\/strong>\u00a0Stock Status Report in Sage 300 ERP<\/a><\/em><\/p>\n

2. I\/C\u00a0 Inventory Worksheet: <\/b>After Inventory generation process, we have to print I\/C Inventory worksheet from Inventory control > I\/C Physical Inventory > Inventory worksheet.<\/b><\/p>\n

This will print quantity on hand, unit cost and UOM of stock item location wise. So based on this worksheet we can match physical stock with system calculated stock<\/p>\n

\"3\"<\/a> \"4\"<\/a><\/p>\n

3. Physical Inventory Quantities: <\/b>After inventory worksheet generation process, we will be able to reconcile the stock item. For example :- we can see in above Inventory worksheet report, system has calculated 128 quantity on hand of item A1-3100 \u201cHalogen Desk Lamp<\/b>\u201d at location\u00a0 1 \u201cCentral Warehouse\u201d. <\/b><\/p>\n

But after physical inventory count of item A1-3100 \u201cHalogen Desk Lamp<\/b>\u201d at location 1\u201dCentral Warehouse\u201d we came to know that quantity physical inventory count is 129. So we have to set quantity as 129 in quantity counted column as shown below.<\/p>\n

\"5\"<\/a><\/p>\n

4. Inventory Reconciliation<\/b>: After updating quantity counted column, we have to run Inventory reconciliation from Inventory control > I\/C Physical Inventory > Inventory Reconciliation<\/b> to check whether quantity counted has been updated or not? And how much variance is showing for every item Reconciled.<\/p>\n

As we can see in below screen shot, quantity counted set as \u201c129<\/b>\u201d for item \u201cA1-3100<\/b>\u201d, quantity variance<\/b> is showing \u201c1\u201d<\/p>\n

\"6\"<\/a><\/p>\n

5. I\/C Post Inventory Reconciliation<\/b>: After verification of Inventory reconciliation, we have to post the reconciliation from Inventory Control I\/C Physical Inventory Post Inventory Reconciliation; this will update quantity at location.<\/p>\n

\"7\"<\/a> \"8\"<\/a><\/p>\n

Hope this blogs provides insight on how Physical Inventory reconciliation process works and how we can reconcile our stock item system calculated with Physical count.
\nAlso Read:<\/strong>
\n1.<\/strong>\u00a0Adjustment Entry in Inventory Control<\/a>
\n2.<\/strong>\u00a0Inventory Reconciliation of Sage Accpac ERP<\/a>
\n3.<\/strong>\u00a0Generate Reports for Slow Moving Items in Sage 300 ERP<\/a>
\n4.<\/strong>\u00a0MRP Report in Sage 300 ERP<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

In Sage 300 ERP (formerly known as Sage Accpac ERP), Inventory Control allows you to enter the results of physical counts into your system and helps you reconcile the differences between the physical count and the calculated quantities-on-hand in system. One important aspect of ensuring that your business runs smoothly is to periodically compare written\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[1346,1924,2357,2451,2767],"class_list":["post-3854","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-inventory-count","tag-physical-inventory-reconciliation","tag-sage-300-erp","tag-sage-accpac-erp","tag-stock-take"],"yoast_head":"\nIC Physical Inventory Reconciliation in Sage 300 ERP<\/title>\n<meta name=\"description\" content=\"Learn how to reconcile physical inventory counts with system data in Sage 300 ERP. Steps include generating worksheets, updating counts, and posting reconciliations.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/11\/ic-physical-inventory-reconciliation-process\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"IC Physical Inventory Reconciliation in Sage 300 ERP\" \/>\n<meta property=\"og:description\" content=\"Learn how to reconcile physical inventory counts with system data in Sage 300 ERP. Steps include generating worksheets, updating counts, and posting reconciliations.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/11\/ic-physical-inventory-reconciliation-process\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2013-09-11T09:06:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-22T09:41:24+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/09\/1.png\" \/>\n<meta name=\"author\" content=\"sage300\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sage300\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/11\/ic-physical-inventory-reconciliation-process\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/11\/ic-physical-inventory-reconciliation-process\/\",\"name\":\"IC Physical Inventory Reconciliation in Sage 300 ERP\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/11\/ic-physical-inventory-reconciliation-process\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/11\/ic-physical-inventory-reconciliation-process\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/09\/1.png\",\"datePublished\":\"2013-09-11T09:06:10+00:00\",\"dateModified\":\"2025-09-22T09:41:24+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"description\":\"Learn how to reconcile physical inventory counts with system data in Sage 300 ERP. Steps include generating worksheets, updating counts, and posting reconciliations.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/11\/ic-physical-inventory-reconciliation-process\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/11\/ic-physical-inventory-reconciliation-process\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/11\/ic-physical-inventory-reconciliation-process\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/09\/1.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/09\/1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/11\/ic-physical-inventory-reconciliation-process\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"I\/C Physical Inventory Reconciliation Process\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\",\"name\":\"Sage 300 ERP \u2013 Tips, Tricks and Components\",\"description\":\"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\",\"name\":\"sage300\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"sage300\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"IC Physical Inventory Reconciliation in Sage 300 ERP","description":"Learn how to reconcile physical inventory counts with system data in Sage 300 ERP. Steps include generating worksheets, updating counts, and posting reconciliations.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/11\/ic-physical-inventory-reconciliation-process\/","og_locale":"en_US","og_type":"article","og_title":"IC Physical Inventory Reconciliation in Sage 300 ERP","og_description":"Learn how to reconcile physical inventory counts with system data in Sage 300 ERP. Steps include generating worksheets, updating counts, and posting reconciliations.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/11\/ic-physical-inventory-reconciliation-process\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2013-09-11T09:06:10+00:00","article_modified_time":"2025-09-22T09:41:24+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/09\/1.png","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/11\/ic-physical-inventory-reconciliation-process\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/11\/ic-physical-inventory-reconciliation-process\/","name":"IC Physical Inventory Reconciliation in Sage 300 ERP","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/11\/ic-physical-inventory-reconciliation-process\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/11\/ic-physical-inventory-reconciliation-process\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/09\/1.png","datePublished":"2013-09-11T09:06:10+00:00","dateModified":"2025-09-22T09:41:24+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"description":"Learn how to reconcile physical inventory counts with system data in Sage 300 ERP. Steps include generating worksheets, updating counts, and posting reconciliations.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/11\/ic-physical-inventory-reconciliation-process\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/11\/ic-physical-inventory-reconciliation-process\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/11\/ic-physical-inventory-reconciliation-process\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/09\/1.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/09\/1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/09\/11\/ic-physical-inventory-reconciliation-process\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"I\/C Physical Inventory Reconciliation Process"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/","name":"Sage 300 ERP \u2013 Tips, Tricks and Components","description":"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5","name":"sage300","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"sage300"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/3854","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=3854"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/3854\/revisions"}],"predecessor-version":[{"id":36343,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/3854\/revisions\/36343"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=3854"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=3854"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=3854"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}