Author Archives: Greytrix

Error: “MRK(501): Index Incorrect” in Sage X3

Sage X3 has a feature of BP net settlement, with the help of this feature we can settle open items like open invoices, unapplied prepayment, credit memos and debit memos against suppliers & customers. One of our client tried to create BP net settlement against one vendor but an error occurred as shown in the… Read More: Error: “MRK(501): Index Incorrect” in Sage X3 »

How to set dynamic Status field on screen based on date range

In Sage X3, one of the client’s requirement was to have a dynamic “Policy Status” field which will reflect the current status where the policy is Active or De-active for the selected module. Here another condition was that at a given time span only one policy per module can be kept Active, rest will stay… Read More: How to set dynamic Status field on screen based on… »

Validation on the Sales order screen if credit limit exceeds

In Sage X3, the maximum credit amount for the customer can be defined in the authorised credit field in the Customer master. There are 3 options available in the in Management tab in Customer master:-Check-No check-Hold With the help of these options we can easily manage the Credit limit of the customer.We had a requirement… Read More: Validation on the Sales order screen if credit limit exceeds »

Warning message on the screen when “To date” is smaller than “From date”

Sage X3, is a complete business management solution designed to drive productivity and give you total control and visibility of your enterprise. With customizable configuration, the flexible solution equips you with everything you need to drive business success. Easy to understand all the modules. Recently, we had a requirement from one of our client for… Read More: Warning message on the screen when “To date” is smaller… »

How to Make Adding a Functional Authorization Easier

Functional authorizations are used to restrict access to functions within X3. If a user needs to create a sales order, we need to give them the functional authorization to GESSOH (sales orders). If we don’t want a user to have access to purchase orders, make sure they don’t have the functional authorization for GESPOH (purchase… Read More: How to Make Adding a Functional Authorization Easier »

Marketing campaign in Sage X3

A marketing campaign is a strategic marketing effort aimed at promoting a specific endeavor or goal on behalf of a company, brand or individual. Marketing campaigns are designed to get consumers’ attention in several ways, such as television, print advertising, social media and email marketing. Each campaign expresses a marketing objective to be attained for a… Read More: Marketing campaign in Sage X3 »

Automatic deallocation function in Sage X3

The automatic deallocation processing of material linked to production for a given site, a given period and selected work orders can be initiated using this function. This processing can deallocate the materials based on the initial allocation type (global or detailed). A deallocation processing can be initiated based on the type of initial allocation (global or detailed) for materials assigned to a given site, a given period, and selected work orders. Below are the… Read More: Automatic deallocation function in Sage X3 »

Revised cost calculation in Sage X3

A revised standard cost is usually created in order to prepare for an upcoming new standard cost following the revaluation of a material, an hourly rate, etc. Revised standard costs for the same product and site are retained and can be viewed. A revised standard cost calculation can be associated with an accounting interface, which… Read More: Revised cost calculation in Sage X3 »

Working of customer extension in Sage X3

Sage X3 has provided us a function which is named as ‘Customer extension’ (function PROROGC). Sometimes there can be a situation where we need to extend the due date of payments which is pending from a customer. Here by using customer extension function we can update the new date of the payments for specific customers.… Read More: Working of customer extension in Sage X3 »