{"id":13412,"date":"2018-08-04T06:05:42","date_gmt":"2018-08-04T11:05:42","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=13412"},"modified":"2018-08-18T12:13:57","modified_gmt":"2018-08-18T12:13:57","slug":"how-to-setup-stock-count-in-sage-enterprise-management","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2018\/08\/04\/how-to-setup-stock-count-in-sage-enterprise-management\/","title":{"rendered":"How to Setup Stock Count in Sage Enterprise Management"},"content":{"rendered":"<p style=\"text-align: justify;\">Stock count is a process of counting inventory on a periodic basis throughout the year. It is the physical verification of the quantities and condition of items held in an\u00a0inventory\u00a0or\u00a0warehouse. This may be done to provide an\u00a0audit\u00a0of existing stock. It is also the source of stock discrepancy information.<\/p>\n<p style=\"text-align: justify;\">Stock-taking may be performed as an intensive annual, end of fiscal year, procedure or may be done continuously by means of a\u00a0cycle count.<\/p>\n<p style=\"text-align: justify;\">Periodic counting is usually undertaken for regular, inexpensive items. The term &#8220;periodic&#8221; may refer to annual stock count. However, &#8220;periodic&#8221; may also refer to half-yearly, seasonal, quarterly, monthly, bi-monthly or daily. For expensive items a shorter period of stock-taking is preferred.<\/p>\n<p style=\"text-align: justify;\">If a company uses cycle counting, the warehouse staff counts the inventory in the warehouse and matches its count information against the records in the ERP system. If there are errors, the warehouse staff corrects them, and also investigates the underlying reasons why the errors occurred.<\/p>\n<p style=\"text-align: justify;\">The Sage Enterprise Management functionality take cares of the Stock Counting.\u00a0Today we are going to check the functionality of Stock Count in Sage Enterprise Management.<\/p>\n<p><span style=\"color: #c71d22; font-size: 13pt;\"><strong>Requirements<\/strong><\/span><\/p>\n<ul>\n<li>Inventory module must be present<\/li>\n<li>Common data module must be present<\/li>\n<li>At least one site with stock management must be defined<\/li>\n<li>At least one product with inventory management must be present<\/li>\n<li>At least one Count Entry Transaction must be present<\/li>\n<\/ul>\n<p><span style=\"color: #c71d22; font-size: 13pt;\"><strong>Basic configuration setup and steps for Stock Count in Sage Enterprise Management<\/strong><\/span><\/p>\n<ol>\n<li>Product-Site Master<\/li>\n<li>Inventory counts \u2013 Physical count calculation.<\/li>\n<li>Stock to Count<\/li>\n<li>Inventory Sessions<\/li>\n<li>Counts<\/li>\n<li>Check the Fields under Product-Site Function<\/li>\n<li>Financial Impact<\/li>\n<\/ol>\n<p><span style=\"color: #c71d22; font-size: 13pt;\"><strong>Product-Site Master<\/strong><strong>\u00a0<\/strong><\/span><\/p>\n<p>The inventory count mode is defined at the level of the product-site record.<\/p>\n<ul>\n<li><strong>Cycle Count<\/strong> &#8211; Plan counts based on the ABC Class of the product and the values defined for the Inventory Parameters with respect to count frequency.<\/li>\n<li><strong>Annual Count<\/strong> &#8211; Perform counts once per year.<\/li>\n<\/ul>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-13413 aligncenter\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2018\/08\/stock-count.png\" alt=\"stock count sage x3\" width=\"674\" height=\"297\" \/><\/p>\n<p><strong>Path: &#8211;<\/strong> <strong>Inventory &gt; Counts &gt; Physical count calculation<\/strong><\/p>\n<p>Select the site you want to calculate and use the Search button.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-13414\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2018\/08\/Inventory-counts.png\" alt=\"Inventory counts sage x3\" width=\"1100\" height=\"163\" \/><\/p>\n<p><strong><u>Example<\/u><\/strong><\/p>\n<p>Number of days between two stock counts: 90 days<br \/>\nNumber of products in Class A: 100<br \/>\nNumber of counts per product: (365\/90)+1 = 5.056 rounded to 5 counts per product<br \/>\nNumber of annual counts: 100*5 = 500 counts per year for the Class A products.<\/p>\n<ul>\n<li>Select the site<\/li>\n<li>Press Search<\/li>\n<\/ul>\n<p><span style=\"color: #c71d22; font-size: 13pt;\"><strong>Stock To Count<\/strong><\/span><\/p>\n<p><strong>Path: &#8211; Inventory &gt; Counts &gt; Stock to Count<\/strong><\/p>\n<ul>\n<li>Site :- Na012<\/li>\n<li>Count date: &#8211; current date<\/li>\n<li>Count mode:- Cycle count<\/li>\n<li>Set Product range:- BMS086 to BMS087<\/li>\n<li>Press:- Search Button<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"wp-image-13415 aligncenter\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2018\/08\/Stock-to-count.png\" alt=\"Stock to count sage x3\" width=\"731\" height=\"225\" \/><\/p>\n<ul>\n<li>Based on the Inputs system will show the result:-<\/li>\n<li>Like Last count date.<\/li>\n<li>Next Court date.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13416\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2018\/08\/stock-count-sage-x3.png\" alt=\"stock count sage x3\" width=\"1022\" height=\"57\" \/><br \/>\n<strong><span style=\"color: #c71d22; font-size: 13pt;\">Inventory Sessions<\/span><\/strong><\/p>\n<ul>\n<li>Create a new Inventory Session and do the setting as per below image for Parameters TAB<\/li>\n<li>In my Case, we are doing Count Product-Wise hence I have selected Product in the Stock Count type.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13417 aligncenter\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2018\/08\/stock-count-session.png\" alt=\"stock count session\" width=\"658\" height=\"355\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13418 aligncenter\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2018\/08\/Inventory-Sessions.png\" alt=\"Inventory Sessions\" width=\"660\" height=\"433\" \/><\/p>\n<p>Under Selection TAB select the product range.\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13419 aligncenter\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2018\/08\/sage-x3-inventory.png\" alt=\"sage x3 inventory\" width=\"616\" height=\"222\" \/><\/p>\n<p><strong>List TAB<\/strong>: &#8211; Based on the input the list will get generate under list TAB and accordingly the Status will get changed from \u201cIn Creation\u201d to \u201cTo be counted\u201d.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13420 aligncenter\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2018\/08\/Stock-to-count-1.png\" alt=\"Stock to count\" width=\"763\" height=\"235\" \/><\/p>\n<p><span style=\"font-size: Medium;\"><strong>About Us<\/strong><\/span><br \/>\n<a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a> \u2013 a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.<\/p>\n<p><a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a>\u00a0caters to a wide range of Sage Enterprise Management (Sage X3) offerings \u2013 a Sage Business Cloud Solution. Our\u00a0unique GUMU&#x2122; integrations include <a href=\"https:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-x3-integration\">Sage Enterprise Management (Sage X3) for Sage CRM<\/a>,\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-x3\/gumu-x3-salesforce-integration\">Salesforce.com<\/a> and\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/magento-sage-integrations\/sage-x3-magento\">Magento eCommerce<\/a>\u00a0along with Implementation and Technical Support worldwide for <a href=\"https:\/\/www.greytrix.com\/africa\/product\/consulting\/implementation-planning\">Sage Enterprise Management (Sage X3)<\/a>. Currently we are <a href=\"https:\/\/www.greytrix.com\/africa\">Sage Enterprise Management Implementation Partner<\/a> in East Africa, Middles East, Australia, Asia.\u00a0We also offer best-in-class\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/erp-development\/sage-x3\">Sage X3 customization and development services<\/a>,\u00a0integrated applications such as <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/pos-system\">POS<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/warehouse-management-system\">WMS<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/payment-gateway\">Payment Gateway<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/shipping-system\">Shipping System<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/business-intelligence\">Business Intelligence<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-x3\/ecommerce-magento-integration\">eCommerce<\/a> and have developed add-ons such as <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-add-ons\/catch-weight\">Catch \u2013 Weight <\/a>\u00a0and <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-add-ons\/letter-of-credit\">Letter of Credit<\/a> for Sage Enterprise Management to Sage business partners, end users and Sage PSG worldwide.<\/p>\n<p>Greytrix is a recognized <a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/07\/26\/greytrix-on-boards-sage-global-rockstar-isv-program-with-gumu-for-sage-crm-sage-x3-solution\/\">Sage Rockstar ISV Partner<\/a> for GUMU&#x2122; Sage Enterprise Management \u2013 Sage CRM integration also listed on <a href=\"https:\/\/www.sage.com\/marketplace\/asb_ListingDetail?listingId=a1h24000007PC3aAAG\" target=\"_blank\" rel=\"noopener\">Sage Marketplace<\/a>; GUMU&#x2122; integration for Sage Enterprise Management \u2013 Salesforce is a 5-star app listed on <a href=\"https:\/\/appexchange.salesforce.com\/listingDetail?listingId=a0N30000000psM5EAI\" target=\"_blank\" rel=\"noopener\">Salesforce AppExchange<\/a>.<\/p>\n<p>For more information on Sage X3 Integration and Services, please contact us at\u00a0<a href=\"mailto:x3@greytrix.com\">x3@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Stock count is a process of counting inventory on a periodic basis throughout the year. It is the physical verification of the quantities and condition of items held in an\u00a0inventory\u00a0or\u00a0warehouse. This may be done to provide an\u00a0audit\u00a0of existing stock. It is also the source of stock discrepancy information. Stock-taking may be performed as an intensive\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2018\/08\/04\/how-to-setup-stock-count-in-sage-enterprise-management\/\">Read More &raquo;<\/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":[8],"tags":[1099,1762,1766,1822,1945,2084,2172,2177],"class_list":["post-13412","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","tag-inventory-session","tag-sage-enterprise-management","tag-sage-enterprise-management-blogs","tag-sage-x3","tag-sage-x3-technical-blogs","tag-setup-stock-count","tag-stock-count-in-sage-x3","tag-stock-to-count"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/13412","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=13412"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/13412\/revisions"}],"predecessor-version":[{"id":15343,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/13412\/revisions\/15343"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=13412"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=13412"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=13412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}