{"id":27021,"date":"2023-08-04T11:29:14","date_gmt":"2023-08-04T11:29:14","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=27021"},"modified":"2023-08-04T11:29:18","modified_gmt":"2023-08-04T11:29:18","slug":"posting-old-stock-entries-for-miscellaneous-issues-receipts-in-sage-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2023\/08\/04\/posting-old-stock-entries-for-miscellaneous-issues-receipts-in-sage-x3\/","title":{"rendered":"Posting Old Stock Entries for Miscellaneous Issues\/ Receipts in Sage X3"},"content":{"rendered":"\n<p>Transactions from Miscellaneous Issues\/Receipts were not linked to the automatic journal. Due to this, the system does not provide stock impact for entries that users create for transactions (i.e., STK entries).<\/p>\n\n\n\n<p>All new entries will have STK impact if we select an automatic journal to that entry transaction. The question is, what happened to the earlier entries that were produced before the automatic journal was selected?<\/p>\n\n\n\n<p>So, to have an impact on the old entries we need to perform the below steps.<\/p>\n\n\n\n<p>Navigate to: &nbsp;Setup \u2192 Stock \u2192 Entry Transactions \u2192 Misc. Issue\/receipts<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><imgtarget=\"_blank\" rel=\"noopener noreferrer\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"563\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\"  src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/fig1-1-1024x563.png\" alt=\"\" class=\"wp-image-27022\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/fig1-1-1024x563.png 1024w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/fig1-1-300x165.png 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/fig1-1-768x423.png 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/fig1-1-660x363.png 660w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/fig1-1.png 1067w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption><strong>Fig01: Miscellaneous Issue Setup<\/strong><\/figcaption><\/figure>\n\n\n\n<p>Select the automatic journal and validate the entry transactions.<\/p>\n\n\n\n<p>After Selection the automatic journal in the entry transaction screen, all new entries which are created will have a stock impact<\/p>\n\n\n\n<p>For the old entries, you need to update the accounting code (ENTCOD_0) \u2018STKIS\u2019 and change the stock interface flag (AGGIFAFLG_0) to \u20181\u2019 through the Table Maintenance.<\/p>\n\n\n\n<p>Navigate to:&nbsp; Development \u2192 Utilities \u2192 Maintenances \u2192 In Lines<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><imgtarget=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" width=\"1024\" height=\"455\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\"  src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/fig2-1-1024x455.png\" alt=\"\" class=\"wp-image-27023\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/fig2-1-1024x455.png 1024w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/fig2-1-300x133.png 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/fig2-1-768x341.png 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/fig2-1-660x293.png 660w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/fig2-1.png 1363w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption><strong>Fig02: STOJOU Table Maintenance Screen<\/strong> <strong>ENTCOD<\/strong><\/figcaption><\/figure>\n\n\n\n<p>Select the Table as STOJOU and enter the details of the entry for which you need to update both fields.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><imgtarget=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" width=\"1024\" height=\"457\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\"  src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/fig3-1024x457.png\" alt=\"\" class=\"wp-image-27024\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/fig3-1024x457.png 1024w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/fig3-300x134.png 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/fig3-768x342.png 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/fig3-660x294.png 660w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/fig3.png 1366w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption><strong>Fig03: AGGIFAFLG table maintenance STOJOU<\/strong><\/figcaption><\/figure>\n\n\n\n<p>You need to search ENTCOD and update the accounting code and similarly update the AGGIFAFLG to \u20181\u2019 and then save that entry.<\/p>\n\n\n\n<p>Once both fields are updated you can run the Account interface for the required date.<\/p>\n\n\n\n<p><strong>About Us<\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a> &#8211; 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\n\n\n<p><a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a>&nbsp;caters to a wide range of Sage X3 (Sage Enterprise Management) offerings &#8211; a Sage Business Cloud Solution. Our&nbsp;unique GUMU\u2122 integrations include <a href=\"https:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-x3-integration\">Sage X3 for Sage CRM<\/a>,&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/sage-x3\/gumu-x3-salesforce-integration\">Salesforce.com<\/a> and&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/magento-sage-integrations\/sage-x3-magento\">Magento eCommerce<\/a>&nbsp;along with Implementation and Technical Support worldwide for <a href=\"https:\/\/www.greytrix.com\/africa\/product\/consulting\/implementation-planning\">Sage X3<\/a> (Sage Enterprise Management). Currently we are <a href=\"https:\/\/www.greytrix.com\/africa\">Sage X3 Implementation Partner<\/a> in East Africa, Middles East, Australia, Asia.&nbsp;We also offer best-in-class&nbsp;<a href=\"https:\/\/www.greytrix.com\/product\/erp-development\/sage-x3\">Sage X3 customization and development services<\/a>,&nbsp;integrated 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>&nbsp;and <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-add-ons\/letter-of-credit\">Letter of Credit<\/a> for Sage X3 to Sage business partners, end users and Sage PSG worldwide.<\/p>\n\n\n\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\u2122 Sage X3 &#8211; 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\u2122 integration for Sage X3 &#8211; 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\n\n\n<p>For more information on Sage X3 Integration and Services, please contact us at&nbsp;<a href=\"mailto:x3@greytrix.com\">x3@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Transactions from Miscellaneous Issues\/Receipts were not linked to the automatic journal. Due to this, the system does not provide stock impact for entries that users create for transactions (i.e., STK entries). All new entries will have STK impact if we select an automatic journal to that entry transaction. The question is, what happened to the\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2023\/08\/04\/posting-old-stock-entries-for-miscellaneous-issues-receipts-in-sage-x3\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,3,3162,7,8,3642,2796,11],"tags":[3195,1287,1288,1493,3786,1822,1839,2871,1945,3785,3784],"class_list":["post-27021","post","type-post","status-publish","format-standard","hentry","category-configuration","category-debug","category-greytrix","category-miscellaneous-tables","category-sage-erp-x3","category-sage-x3","category-technical","category-tips","tag-miscellaneous-issue","tag-miscellaneous-receipt","tag-miscellaneous-tables","tag-posting","tag-posting-stock","tag-sage-x3","tag-sage-x3-blogs","tag-sage-x3-functional-blogs","tag-sage-x3-technical-blogs","tag-stock-entries","tag-stojou-table"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/27021","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=27021"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/27021\/revisions"}],"predecessor-version":[{"id":27025,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/27021\/revisions\/27025"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=27021"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=27021"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=27021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}