But one of our client wanted to have a control on the issuance of the raw material to production on the basis of formula they have already defined. When GRN is received QC is done, on the basis of results QC department note down the Assays and Moisture contain in raw material.<\/p>\n\n\n\n
In order to compensate this loss additional quantities of that particular material should be issued to production when that particular LOT is used in production on the basis of the formula defined.<\/p>\n\n\n\n
Let\u2019s understand this concept with an example:<\/p>\n\n\n\n
When GRN is done QC entry is created automatically in Sage X3. When QC user does the quality testing we will create the technical sheet at QC entry where he\/she will enter Assays and Moisture attribute as shown in the below screenshot.<\/p>\n\n\n\n
New Stuff:<\/strong> How to solve \u2018User does not have any Badge for product\u2019 error while running the batch server during Migration process in Sage X3<\/a><\/p>\n\n\n\n We have entered values in Technical Sheet for raw material \u201cRA010\u201d i.e. Assay: 98 and Moisture: 2. At Work Order, the allocation of the LOT will be as per FEFO basis but even if user wishes to change the allocation he\/she can alter it. Now we will see the requirement quantity of \u201cRA010\u201d before allocation in the work order as mentioned in the BOM.<\/p>\n\n\n\n Formula which we are using is:<\/p>\n\n\n\n We will use this formula in our example for better understanding:<\/p>\n\n\n\n We have a work order which determines that 80000 quantity of FG1 (TEST Product) needs to be produce. RA010 = 24 KG is required to produce 1 Batch (80000) of FG1 which is already mentioned in BOM as shown earlier.<\/p>\n\n\n\n ASSAY: 98 %, MOISTURE: 2 % = 24.989 Kg per Batch<\/strong><\/p>\n\n\n\n Now, we have customized the screen in such a way that when user clicks on the \u2018SAVE\u2019 button of Work Order after creation and lot allocation, components quantity gets updated as per the quantity derived after formulation:<\/p>\n\n\n\n NOTE: To enable the save button, you need to select the \u201cAllocation\u201d checkbox in the header after lot allocation.<\/p>\n\n\n\n Quantity for \u201cRA010\u201d is updated as expected but for \u201cRA051\u201d component we have not entered values in the technical sheet. Due to which quantity remains same for that component.<\/p>\n\n\n\n In this way on the basis of formula, allocation will be done. By doing this, correct calculated quantity of required materials will be issued on every work order in the manufacturing of the FG Product.<\/p>\n\n\n\n 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 Greytrix has some unique integration solutions developed for Sage CRM<\/a> with Sage ERPs namely Sage X3<\/a>, Sage Intacct<\/a>, Sage 100<\/a>, Sage 500<\/a>, and Sage 300<\/a>. We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users, and Sage PSG worldwide. Greytrix helps in the migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like Greytrix Business Manager, Sage CRM Project Manager, Sage CRM Resource Planner, Sage CRM Contract Manager, Sage CRM Event Manager, Sage CRM Budget Planner, Gmail Integration, Sage CRM Mobile Service Signature, Sage CRM CTI Framework.<\/p>\n\n\n\n Greytrix is a recognized Sage Champion Partner for GUMU™ Sage X3 \u2013 Sage CRM integration listed on Sage Marketplace<\/a> and Sage CRM \u2013 Sage Intacct integration listed on Sage Intacct Marketplace<\/a>. The GUMU™ Cloud framework<\/a> 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 For more information on our integration solutions, please contact us at sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":" This \u201cFormula based material issue\u201d concept will be mostly useful in Pharmaceutical Industries, as these type of industries produce medicines. In manufacturing process, drugs will be considered as Raw Material to produce one particular tablet\/ medicine. For this, quantity of required drugs should be correctly calculated. By using this formula based concept we will be\u2026 Read More »<\/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":[13,8],"tags":[217,1588,1590,2248,2428],"class_list":["post-21875","post","type-post","status-publish","format-standard","hentry","category-integration","category-sage-erp-x3","tag-bom","tag-quality-control","tag-quantity","tag-technical-sheet-in-qc","tag-work-order"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/21875","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=21875"}],"version-history":[{"count":11,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/21875\/revisions"}],"predecessor-version":[{"id":21903,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/21875\/revisions\/21903"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=21875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=21875"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=21875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"Technical](\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2021\/02\/Technical-Sheet-1024x524.jpg\")
<\/a><\/center>\n
These attributes will be linked to that particular LOT.<\/p>\n\n\n\n![\"Requirement](\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2021\/02\/Requirement-Qty-before-Allocation.jpg\")
<\/a><\/center>\n![\"Formula\"](\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2021\/02\/Formula.jpg\")
<\/a>\n\n\n\n
BATCH SIZE: 8000, KG per Batch: 24<\/p>\n\n\n\n![\"Formula](\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2021\/02\/Formula-used-in-example.jpg\")
<\/a>\n\n\n\n![\"Requirement](\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2021\/02\/Requirement-Qty-after-Allocation-2.jpg\")
<\/a><\/center>\nAbout Us<\/strong><\/h2>\n\n\n\n