Tag Archives: Sage X3 technical blogs

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 »

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 »

How to define base quantity of Finished goods in Production BOM

Navigate: Common data>>BOMs>> Production BOM Select a Parent product Enter the mandatory fields’ details. Select the entry unit. The base quantity will get updated as per the selected unit. In this example, the COM005 & COM006 will be used to produce Quantity of DIS013 Therefore in a Work order, the FG will be produced on… Read More »

How to set default import parameters in Sage X3

In Sage X3, you may come across a scenario where you may need to set the fixed path for archival and error directories of import files. Generally, in Sage X3, data is imported using template functionality. It behaves in below two ways: If you import proper data file, then it will move to Final directory… Read More »

Folder Validation Using Batch Process

You may have come accross a situation where Folder Validation gets interrupted due to user/browser timeout. For achieving uninterrupted folder validation, batch process can be used. Example: Let us assume that a Folder named “SEED” needs to be validated. Now, to validate the folder using batch process, follow the following Steps: Go to Usage>Batch Server.… Read More »

Banking Position Inquiry in Sage X3

We may come across a scenario where we want to know Balance of a company by the Bank filter. In Sage X3 this functionality can be achieved by the “Banking Position” Inquiry Screen, which includes Accounting, Sales and Purchase cash forecast management. This Inquiry screen displays Initial balance, the previous open items and all types of cash forecast. Navigate:- A/P-A/R accounting… Read More »

How to find out any special character is used in a text

You may come across the situation where you have to find out whatever any special character is used in a text or not, parse allows you to analyze an expression contained in a character string syntactically. Parse, returns zero (0) when the expression analyzed is syntactically correct – or, otherwise, a non-null value that corresponds… Read More »