{"id":21562,"date":"2021-01-21T05:07:53","date_gmt":"2021-01-21T05:07:53","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=21562"},"modified":"2021-01-21T05:07:56","modified_gmt":"2021-01-21T05:07:56","slug":"how-to-align-lot-numbers-with-miscellaneous-receipts-numbers","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2021\/01\/21\/how-to-align-lot-numbers-with-miscellaneous-receipts-numbers\/","title":{"rendered":"How to Align Lot numbers with Miscellaneous receipts numbers"},"content":{"rendered":"\n<p>\u201cMiscellaneous Receipts\u201d is the business process that is used to carry out the receipt of products into the warehouse without a corresponding transaction such as a purchase order or works order to receive the product against. Datalinx Warehouse Manager for Sage X3 allows the receipt of product to be recorded.<\/p>\n\n\n\n<p>Whilst completing the receipt, the application checks and validates to ensure that the product code exists and if relevant, captures additional information such as serial and batch numbers together with date related details such as best before or use by dates. The resulting transaction is used to update Sage X3 with the receipt as if the transaction had been completed within Sage X3. The history record will also attribute the transaction details complete with date and time to the individual logged on at the hand held terminal.<\/p>\n\n\n\n<p>Some companies would like to create their Miscellaneous receipts with a Lot Number that is the same as the Miscellaneous receipts transaction Number that created the product. This is useful for general quality assurance and for product recalls. Some lot numbers are generated with the use of date and time stamps to help identify a specific lot.<\/p>\n\n\n\n<p>Why we make the Lot number same as Miscellaneous receipts number because this can make the tracing of the Lot easier. In Sage X3, there is a standard functionality of doing this.<\/p>\n\n\n\n<p>Follow the below steps for the setup:<\/p>\n\n\n\n<p><strong>Steps:<\/strong><\/p>\n\n\n\n<p>First make sure that Lot Management setting of product is checked as a \u2018Mandatory lot\u2019 and under the Lot Sequence field this MUST be blank as shown in below figure.<\/p>\n\n\n\n\n\n<p>Also, product category set up should be same as product setup, as shown in below figure.<\/p>\n\n\n\n\n\n<p>In short product and that respective product category set up should be set as defined above.<\/p>\n\n\n\n<p><em><strong>Navigate To: Common Data&gt; Product category &gt; Receipts Tab &gt; Management Rules Grid<\/strong><\/em><\/p>\n\n\n\n<p>1. Select Movement type as <strong>\u2018<\/strong>Miscellaneous Receipt&#8217;<\/p>\n\n\n\n<p>2. Change the value of Lot entry as a \u2018Free\u2019<\/p>\n\n\n\n<p>3. Change the value of Lot by default as a \u2018Document number\u2019.<\/p>\n\n\n\n<p>4. Click on Save or OK button.<\/p>\n\n\n\n<p>Please refer the below figure for the same.<\/p>\n\n\n\n\n\n<p>We have completed the setup for product master and product category.<\/p>\n\n\n\n<p>Now follow the below path for Miscellaneous Receipts creation,<\/p>\n\n\n\n<p><em><strong>Navigate To &gt; Stock &gt; Receipt\/issue transaction &gt; Miscellaneous Receipts<\/strong><\/em><\/p>\n\n\n\n<p>While creating the Miscellaneous receipts transaction, keep LOT no. as blank on line level and after creation you can see LOT no. is coming same as a Miscellaneous receipts transaction number. Refer below figure for the same.<\/p>\n\n\n\n\n\n<p>With the help of this setup you can align the Lot numbers with the Miscellaneous receipts transaction number and it will also help to make the tracing of the Lot easier.<\/p>\n\n\n\n<p>Hence after doing all the above steps we can able to align the same lot number with Miscellaneous receipts transaction number.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>About Us<\/strong><\/h2>\n\n\n\n<p>Greytrix \u2013 a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.<\/p>\n\n\n\n<p id=\"block-28013e99-0882-44c6-b705-7b16c85053b2\">Greytrix&nbsp;has some unique integration solutions developed for&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-crm\/\">Sage CRM<\/a>&nbsp;with Sage ERPs&nbsp;namely&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-x3-erp\/\">Sage X3<\/a>,&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-intacct\/\">Sage Intacct<\/a>,&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-100-erp\/\">Sage 100<\/a>,&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-500-erp\/\">Sage 500<\/a>,&nbsp;and&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-300-erp\/\">Sage 300<\/a>. We also offer best-in-class&nbsp;Sage ERP&nbsp;and&nbsp;Sage CRM&nbsp;customization and development services&nbsp;to&nbsp;Business&nbsp;Partners,&nbsp;End&nbsp;Users, and Sage PSG worldwide. Greytrix&nbsp;helps in&nbsp;the migration of Sage CRM from&nbsp;Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes&nbsp;addons like&nbsp;&nbsp;Greytrix Business Manager,&nbsp;Sage CRM Project Manager,&nbsp;Sage CRM Resource Planner,&nbsp;Sage CRM Contract Manager,&nbsp;Sage CRM Event Manager,&nbsp;Sage CRM Budget Planner,&nbsp;Gmail Integration,&nbsp;Sage CRM Mobile Service Signature,&nbsp;Sage CRM CTI Framework.<\/p>\n\n\n\n<p id=\"block-4bc42a09-fb13-4598-8137-ce5f7b91ce28\">Greytrix is a recognized&nbsp;Sage Champion Partner&nbsp;for GUMU&#x2122; Sage X3 \u2013 Sage CRM integration listed on&nbsp;<a href=\"https:\/\/www.sage.com\/marketplace\/asb_ListingDetail?listingId=a1h24000007PC3aAAG\" target=\"_blank\" rel=\"noreferrer noopener\">Sage Marketplace<\/a>&nbsp;and Sage CRM \u2013 Sage Intacct integration listed on&nbsp;<a href=\"https:\/\/marketplace.intacct.com\/MPListing?lid=a2D0H000007kiHyUAI\" target=\"_blank\" rel=\"noreferrer noopener\">Sage Intacct Marketplace<\/a>. The&nbsp;<a href=\"https:\/\/www.greytrix.com\/gumu\/\" target=\"_blank\" rel=\"noreferrer noopener\">GUMU&#x2122; Cloud framework<\/a>&nbsp;by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.<\/p>\n\n\n\n<p id=\"block-76376301-1c3e-4250-8a09-727595a606f0\">For more information on our integration solutions, please contact us at&nbsp;<a href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u201cMiscellaneous Receipts\u201d is the business process that is used to carry out the receipt of products into the warehouse without a corresponding transaction such as a purchase order or works order to receive the product against. Datalinx Warehouse Manager for Sage X3 allows the receipt of product to be recorded. Whilst completing the receipt, the\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2021\/01\/21\/how-to-align-lot-numbers-with-miscellaneous-receipts-numbers\/\">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":[5,8,10],"tags":[3170,2927,2619,1424,1535,1549,2530],"class_list":["post-21562","post","type-post","status-publish","format-standard","hentry","category-features","category-sage-erp-x3","category-standard","tag-lot-management","tag-lot-number","tag-miscelleneous-receipt","tag-parameter-values","tag-product-category","tag-products","tag-stock-management"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/21562","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=21562"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/21562\/revisions"}],"predecessor-version":[{"id":21570,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/21562\/revisions\/21570"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=21562"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=21562"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=21562"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}