Tag Archives: Sage X3 Technical assistance

Mass Validation of Stock transactions in Sage X3

We may come across a situation where we want to validate multiple stock entry transactions at a time. This can be achieved in Sage X3 by “Validate Stock transactions”Screen. Navigate: Setup -Stock -Entry Transactions – Validate Stock transactions Step 1: Select Stock Transaction Type Step 2: Select Entry Transaction Type Step 3: Click on OK… Read More »

How to Validate Postal code Field in Sage X3

In Sage X3, we can enter the Postal code on the addresses of entities as Company, Site and all the BP entities (BP, Prospect, Customer, Supplier, Carrier and Sales rep). In Sage X3, we can manage the entered postal code by verifying with existing postal code. Kindly follow the below steps to enable this validation.… Read More »

Find the Number of Days passed between Years

One of the date function which will return the number of days passed between 1/1/1600 and the parameter date. Syntax :     nday(date_exp) Parameters:    date_exp –   date expression Example :   X = nday(date$) Description : The nday function allows us to go from a date to a number of days. We may replace nday(DATE) with DATE… Read More »

Perform Supplier Intercompany Invoice

We may come across scenarios where we want to issue a Supplier Intercompany Invoice. This functionality can be achieved by the following step: Navigate to A/P-A/R accounting>Invoicing>Supplier Intercompany Invoice. When Supplier Intercompany Invoice screen open it will show below error message: To overcome this error message navigate to Set up>General Parameters>Parameter values>TRS Business partner>Folder>INV Group(Invoicing… Read More »

Automatic Work order Allocation in Sage Enterprise Management

In order to automatically allocate work order. Sage X3 provides a feature to automatically allocate work order in a global or detailed manner. To successfully bring this functionality follow below steps Navigate to: Set up >> Manufacturing >> Entry transactions>>work orders Select Allocation method in the parameters tab. About Us Greytrix – a globally recognized… Read More »

Enable Deprec.total field in Fixed Assets master in order to capture accumulated depreciable value

Navigate to: Setup –> Parameter Value –> AAS – FAS – PRVSITUPD Set PRVSITUPD=”Yes “After setting this parameter to “Yes “this will allow the user to enter accumulated depreciable value under the Deprec.total (Refer below image). If an asset was purchased in 1st Jan 2013 and it’s deprecation start date was also same. Asset purchase… Read More »

Range Validation between Two Fields

Generally, we have come across a situation in Sage X3 in Inquiries or Invoice screen where we need filter the data as per their ranges. In such condition we need to add some validations such as End range should be less than start range. It can also be done by using action CTLALPVALW. CTLALPVALW is… Read More »

How to get Name of the Program where the Error occurred

Errp returns the name of the script where an error occurred. It can be used in the error handling routine set by Onerrgo. Syntax : errp  Examples :   # Let’s trigger an error (division by zero) Funprog DIV_BY_ZERO Local Integer ZERO, ONE, RESULT Local Char ERROR_MESSAGE(250) ONE=1 : ZERO=0 Onerrgo ERR_HANDLE RESULT = ONE… Read More »

How to Use a not-usable Component in Work Order

In Sage ERP X3, there is a feature where you can check whether the component used in a product is non-usable or not while creating a work order. This can be achieved by following below steps:- Navigate to Setup → General Parameters → Parameters values Under Module → GPA Manufacturing and Group → Work Order… Read More »

How to delete Supplier Intercompany Invoice

We may come across scenarios where we want to delete Supplier Intercompany Invoice. To achieve this functionality follow below steps: Navigate to General Parameter>Parameter values>TC Common Data>Folder>INV Group>SIVSUP parameter. You will see that parameter value of SIVSUP is set as No, change it to yes. Now navigate to A/P-A/R Accounting>Invoicing>Supplier Intercompany Invoices. In above screenshot,… Read More »