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.
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.
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
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.
This blog helps to understand what are the default dimensions associated with manufacturing in Sage X3.
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 CRM, Salesforce.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 email@example.com, We would like to hear from you.