{"id":32244,"date":"2026-06-29T13:58:28","date_gmt":"2026-06-29T13:58:28","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=32244"},"modified":"2026-06-29T14:01:36","modified_gmt":"2026-06-29T14:01:36","slug":"setting-up-automatic-cost-types-for-miscellaneous-receipts","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2026\/06\/29\/setting-up-automatic-cost-types-for-miscellaneous-receipts\/","title":{"rendered":"Setting Up Automatic Cost Types for Miscellaneous Receipts"},"content":{"rendered":"\n<ol class=\"wp-block-list\">\n<li>Navigate to Setup > Stock > Valuation Methods (Function: GESTCM).<\/li>\n<\/ol>\n\n\n\n<p><strong>New Stuff:<\/strong> <a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2026\/06\/29\/creating-a-custom-sequence-number-in-sage-x3-using-a-function\/\" target=\"_blank\" data-type=\"link\" data-id=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2026\/06\/29\/creating-a-custom-sequence-number-in-sage-x3-using-a-function\/\" rel=\"noreferrer noopener\">Creating a Custom Sequence Number in Sage X3 Using a Function<\/a><\/p>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2026\/06\/Figure-1.png\" target=\"_blank\" rel=\"noreferrer \nnoopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; \nalign: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2026\/06\/Figure-1.png\" alt=\"Figure 1\"><\/a><\/center> \n<font size=\"2\"><center>Figure 1<\/center><\/font>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>Once you select one of the valuation methods for your products, find the &#8220;Primary method&#8221; field and click on the magnifying glass for &#8220;Non-Standard Setup&#8221;.<\/li>\n<\/ol>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2026\/06\/Figure-2.png\" target=\"_blank\" rel=\"noreferrer \nnoopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; \nalign: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2026\/06\/Figure-2.png\" alt=\"Figure 2\"><\/a><\/center> \n<font size=\"2\"><center>Figure 2<\/center><\/font>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>Here is where you can set up an exception rule for the movement type Miscellaneous Receipt.You have the same options for the primary and alternate sources for costing:Standard cost,Revised standard, Last cost, Cumulative AUC, Lot AUC, Order cost,and Last purchase price.<\/li>\n<\/ol>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2026\/06\/Figure-3.jpg\" target=\"_blank\" rel=\"noreferrer \nnoopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; \nalign: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2026\/06\/Figure-3.jpg\" alt=\"Figure 3\"><\/a><\/center> \n<font size=\"2\"><center>Figure 3<\/center><\/font>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li>In the example below, I&#8217;ve entered the following:<br>\u2022 Valuation Source = Lot AUC<br>\u2022 Valuation Alternate = Lot AUC<br>\u2022 Receipt source = Order cost<br>\u2022 Receipt alternate = Order cost<br>\u2022 Negative quantity variance = Lot AUC<br>\u2022 Negative alternate = Lot AUC<br>\u2022 Positive quantity variance = Cumulative AUC<br>\u2022 Positive alternate = Cumulative AUC<br>\u2022 Adjust receipt cost = checked<br>\u2022 Movement type = Miscellaneous receipt<br>\u2022 Valuation source = Last purchase price<br>\u2022 Valuation alternate = Cumulative AUC<br>\u2022 Cost adjustment = Yes<br>\u2022 Allow null cost = No<\/li>\n<\/ol>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2026\/06\/Figure-4.jpg\" target=\"_blank\" rel=\"noreferrer \nnoopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; \nalign: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2026\/06\/Figure-4.jpg\" alt=\"Figure 4\"><\/a><\/center> \n<font size=\"2\"><center>Figure 4<\/center><\/font>\n\n\n\n<p>5. On the Miscellaneous Receipts screen, you may wish to hide the price and order price fields. They will NOT show the costing that will be used. Rather, they will remain blank, which can be confusing to see.<\/p>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2026\/06\/Figure-5.jpg\" target=\"_blank\" rel=\"noreferrer \nnoopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; \nalign: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2026\/06\/Figure-5.jpg\" alt=\"Figure 5\"><\/a><\/center> \n<font size=\"2\"><center>Figure 5<\/center><\/font>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2026\/06\/Figure-6.jpg\" target=\"_blank\" rel=\"noreferrer \nnoopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; \nalign: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2026\/06\/Figure-6.jpg\" alt=\"Figure 6\"><\/a><\/center> \n<font size=\"2\"><center>Figure 6<\/center><\/font>\n\n\n\n<ol start=\"6\" class=\"wp-block-list\">\n<li>When you examine the stock transactions, you can see the cost used for the miscellaneous receipts.<\/li>\n<\/ol>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2026\/06\/Figure-7.jpg\" target=\"_blank\" rel=\"noreferrer \nnoopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; \nalign: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2026\/06\/Figure-7.jpg\" alt=\"Figure 7\"><\/a><\/center> \n<font size=\"2\"><center>Figure 7<\/center><\/font>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>New Stuff: Creating a Custom Sequence Number in Sage X3 Using a Function Figure 1 Figure 2 Figure 3 Figure 4 5. On the Miscellaneous Receipts screen, you may wish to hide the price and order price fields. They will NOT show the costing that will be used. Rather, they will remain blank, which can\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2026\/06\/29\/setting-up-automatic-cost-types-for-miscellaneous-receipts\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,13],"tags":[421,4576,1287,1822,4577],"class_list":["post-32244","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","category-integration","tag-cost","tag-cost-type","tag-miscellaneous-receipt","tag-sage-x3","tag-set-up"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/32244","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=32244"}],"version-history":[{"count":6,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/32244\/revisions"}],"predecessor-version":[{"id":32257,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/32244\/revisions\/32257"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=32244"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=32244"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=32244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}