Default Dimensions associated with manufacturing in Sage X3

By | November 26, 2021

In Sage X3, for the entry of documents requiring analytical dimensions, a default dimensions function specifies how to enter these dimensions by default. Strictly speaking, they are not accounting documents (most of them are generated outside the Financials module), but they can generate postings. These setups are useful to enter the analytical allocations in all the movements where they are stored.

        The main principle is to define for each dimension type an order of priority when searching a default dimension, by providing a list of tables where to search for these dimensions.

E.g.:

        To enter the order lines and for a given dimension type, it is possible to specify that the default value be searched in the product record, then (if the field is not assigned at this level) in the customer record and then, by default, in the order header. Later one, the places (usually tables) where the dimensions can be searched are referred to as Identifiers.

        The identifiers that can be used are the following: Product, Customer, Supplier, Sales executive, Buyer, Fixed asset, Bank, Company, Site, Currency, Tax, Payment, Journal (it is the header of the journal being entered, and which can be used to initialize the lines), Sales footer, early discount, Account, Miscellaneous BP, Valuation dimensions, Overheads, Original document, Previous dimensions.

Fig01: Default Dimensions

Here, we will discuss about the dimesion that are used in Manufacturing whether creating a work order manually or automatically, creating the production, closing, and costing the work order.

The three default dimensions for standard work order are:

        MFI: Released products

        MFO: Operations

        MFM: Components

        If the work order is automatically created within the plans (Enterprise planning, Planning workbench, Grouping), the default dimensions are:

        MFIAUT: Auto Released products

MFOAUT: Auto Operations

        MFMAUT: Auto Components

        When a production tracking is manually created, these are the dimensions used:

        MKI: Tracking of released products

        MKO: Operations tracking (principal work center)

        MKOLAB: Operations tracking (secondary work center)

        MKM: Material tracking

        When tracking is created using a Time tracking plan, the dimensions are:

        MKIAUT: Auto tracking of released products

        MKOB: Auto operations tracking (principal work center)

        MKOLABB: Auto operations tracking (secondary work center)

        MKMAUT: Auto material tracking

        When using the Production plan to create a tracking, the dimensions are:

        MKIB: Released products tracking plan and MKMAUT: Auto material tracking.

        If using a Material tracking plan, the used default is MKMB: Material tracking plan.

        When the work order is completed and closed, these are the dimensions used:

        MKOAUT: Auto operations tracking (Principal WC)

        MKOLABAUT: Auto operations tracking (Secondary WC)

        MKMAUT: Auto material tracking        

Finally, when the work order is costed, MWIF: Balance/Close Works Order variance default dimension is used in Parameter values, TC common data, Accounting Interface.

Fig02: Parameter Values

This blog helps to understand what are the default dimensions associated with manufacturing in Sage X3.

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.