How to control the Scrap percentage while we make the Production tracking in Sage X3

We do have request to control the scrap when the manufacturing of the product needs to be done. If as such control are not placed then the end user will not hold any control on the wastage while preparing the finished goods.

This setup can be done within the Sage X3 functionality toachieve the control on scrapping out the material while making the production tracking.

This setup can be done in the below way as follow:

  1. On the product site
  2. In Routing

On Product Site:

Fig01: Shrinkage Percentage

The maximum this percentage of the loss while manufacturing of finished goods. This shrinkage is most applied on the raw material,this shrinkage is carried to the routing as well.

This value will be in percentage and proportionate quantity of the produced quantity will be considered while considered.

Routing screen

We do have the screen on the routing which fetched the value from the master, but incase user wish to modify it from the screen then it can be modified.

The shrinkage on the routing can be assigned to the routing in the following way:

On the BOM Level we assign the component and each component has its own Operation, this operation code on the Component grid indicates that particular product is consumed in mentioned operation.

Fig02: Manufacturing BOM

Each operation has its own set of products that are consumed, during this consumption wastage or shrinkage can be taken place.

Fi03: Shrinkage Percentage in Routing tab

This shrinkage is then carried to Workorder and according to it the quantity is increased in Material tracking.

The above are the points which we need to do for the setup. Below are the reflection we can observe in the Work order.

On the work order, when we track finished goods according to the finished goods quantity the component are filled in raw material tab.

At the time when the raw material are tracked, quantities are being populated in the respective product and the quantities are increased according to shrinkage.

This increase in quantities help the user to allow the quantities to get perfectly allocated, so incase even if it is shrinked at the time  of the Production it should not affect the process of due to shortage.

Example:

The shrinkage on the finished goods is mentioned when the final product is produced:

Fig04: Work Order

This is the loss percentage consider in the assumption while we make the production tracking, and this loss percentage are being carried from the Product site as mentioned earlier.

The second setup which we have done in the Routing is being carried in the Component as shown below:

Fig05: Scrap according to operation

This is being carried from the second setup which we have done in the routing while we define the BOM. This will indicate the scrap that will be generated from this product.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged 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 competence. 

Greytrix caters to a wide range of Sage X3, a Sage Business Cloud Solution, offerings. Our unique GUMU™ integrations include Sage X3 for Sage CRMSalesforce.com, Dynamics 365 CRM and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3. Currently we are Sage X3 Implementation Partner in East Africa, Middle East, Australia, Asia, US, UK. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight  and Letter of Credit and India Legislation for Sage X3 to Sage business partners, end users and Sage PSG worldwide. Greytrix Sales Commission App for Sage X3 simplifies commission calculations and postings on sales transactions.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.

Greytrix is a recognized Sage champion ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star rated app listed on Salesforce AppExchange and GUMU™ integration for Dynamics 365 CRM – Sage ERP listed on Microsoft AppSource.

For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com, We would like to hear from you.