Category Archives: Integration

Global Settings functionality in Sage X3

Global settings in Sage X3 are system-wide configuration options, applicable across the entire system, allowing administrators to establish default behaviors and parameters for various modules during initial implementation, ensuring consistent and standardized use throughout the organization’s use of Sage X3. Access to global settings is limited to privileged users like system administrators. These settings encompass… Read More »

HOW TO MATCH OPEN ITEMS IN SAGE X3

Sage X3 uses an automatic matching process when posting open items which are applied to other open items. For example a payment made for some invoices is posted. During this posting process the details are loaded into a temporary table called MTCBATCH. Within this table the documents are matched together, open item entries are marked… Read More »

How to provide profiles changing access to a non admin users in Sage X3

All users play a very critical role in Sage X3, also it has a feature where we can set a permissions and access to a particular user. The need to restrict users to access ERP Modules can be based on the employees’ role and their department. User security and access should be the top most… Read More »

Tracking Validation to check proportion of raw material has been tracked or not

During the Production tracking process in Sage X3, it has been identified that there is a need for validation to ensure that the minimum corresponding amount of raw material has been tracked or consumed prior to initiating Production tracking for a specific work order. To tackle this issue effectively, we plan to customize the Production… Read More »

Use of Transcribe Import/Export template in Sage X3

In Sage X3, we make sure of import/export templates quite often for importing huge data with ease. However sometimes the importing data templates are acquired through any external client application which might have different external data parameters which in Sage X3 are stored in different internal codes. Sage X3 provides us a Setup module that… Read More »

Theme based e-mail workflow using notification server in Sage X3

Sage X3 offers the ability to send email notifications using the notification server as well as the ability to establish email in the pretty format. The Notification Server settings give Sage X3 users access to an email client that supports authentication, extra security measures like TLS, and may structure workflow message text using notification themes.… Read More »

Sales Order Attachment Validation in Sage X3

Customizing attachment validation to restrict delivery, shipment and Invoice on Sage X3 involves defining specific rules and configurations within the system. In Sage X3, you can create these customizations using the SDK (Software Development Kit) and scripting capabilities. Customizing attachment validation on a sales order can be done in various ways, depending on the software… Read More »

How to restrict the text based on date condition by using the cdate() function in Crystal report

Crystal report is an application used to create custom reports from a various of data sources. It includes major features such as formulas, cross-tab reports, sub-reports , special fields and conditional formatting etc. In Sage X3 recently we had an requirement that one of our client wants the hardcoded declaration based on supplier type and… Read More »