Category Archives: Technical

Calculating number of attachments in Sage X3

As we know, using attachment featured In Sage X3, user can attach various documents/files against any masters or transactions screen. With this feature users can attach file types like word document, Image, Text, PDF and Excel etc. The attached documents can be the reference/source documents of that particular entry. This helps all the users to… Read More »

The narration of function and its parameter used to call an external/outgoing REST web service from ASYRRESTCLI library

The function “EXEC_REST_WS” is used to call an external/outgoing REST web service from ASYRESTCLI library and returns the status of the operation, the  parameters used in the function are described below, Refer the previous blog : How to call Third Party REST service from Sage X3. Parameter 1: Code               :NAME Data Type       :Char Description     :… Read More »

How to resolve ‘The quantity to be returned exceeds the maximum authorized’ error message while creating Purchase return in Sage X3

Purchase return is normally a part of business. In which, goods are returned to the supplier if they had any defects or not according to the specifications of the buyer. In Sage X3, while creating Purchase Return we may come across an error like ‘The quantity to be returned exceeds the maximum authorized: 0 UN’.… Read More »

How to transfer file to FTP server

Sometimes, it might happen that we need to transfer a file to the FTP server. The below piece of code will transfer the file to FTP. Parameters: HSTSITE It is the FTP server address on which the files will be transferred. HSTUSR and HSTPWD  It is the Username and Password of the defined FTP server.… Read More »

How to resolve Unit Type error in UOM while defining PACK UNIT in SageX3

In Sage X3, the stocking UOM describes how you store quantities of an item in the warehouse. When you assign UOMs to an item on the Units of Measure tab, it indicates whether each UOM is valid for ordering, shipping, or stocking transactions. If more than one UOM is valid for stocking, specify which of… Read More »

How to solve Unbalanced Payment Error while creating Payment through Import/Export Template

Introduction: After sales invoice generation,next process is payment creation,While creating payment through import/export template using PAY object and GESPAY Function,we come across error Unbalance payment error as shown in below image .The solution for solving this error is following below, Solution: Setup>Usgae>Import/Export Template. In Fig 2.1,There is a Sign field which plays important in solving… Read More »

World Health Day and Business in Times of COVID-19

During the recent times the world is on the verge of emotional and physical outbreak due to the Novel Coronavirus. The outbreak has led to a human tragedy which has further led to the crashing global economy in the absence of a cure. Leaders all over the world are engaged in finding a vaccine for… Read More »

How to set default journal entry type for journal created by import routine

In Sage X3 we can create Journal through import template also sage X3 provides a global parameter in which we can set default entry type using which journal should be created. Navigate To: Setup>General parameters>Parameter Values> Under Chapter Accounting >DEF> Parameter SCHIMPV5 (Entry transaction (import)) The entry transaction code to be assigned as the default… Read More »