Tag Archives: Sage X3

Greytrix Sage X3 Blog 500+ posts and still getting bigger and better

In our commitment to consistently contribute toward Sage X3 knowledge databank we have now crossed 500 blogs covering varied functionalities of Sage X3 ERP and its extended solutions. All the Greytrix Sage X3 Blogs are typically written by dedicated technical and business expertise team who have industry insights and over a decade of experience of… Read More: Greytrix Sage X3 Blog 500+ posts and still getting bigger… »

Automated Intercompany transaction feature of Sage X3

Many organizations have subsidiaries which they have created to serve the main company. This is done for various purposes, the main amongst them would be for taxation benefits. Since each company itself is a separate legal entity so they are taxed separately because their turnover is depicted separately. So, for example, in a company which… Read More: Automated Intercompany transaction feature of Sage X3 »

How to concatenate a field in Sage X3 V7

In Sage X3 version 7 ,’Append’  allows concatenating a string or CLOB value to an existing string or CLOB. New Stuff: How to check if the transaction is being locked in another workstation? From a functional point of view, Append A, B is equivalent to A+=B if ‘A’ and ‘B’ are strings or CLOBs. Kindly refer to the below screen… Read More: How to concatenate a field in Sage X3 V7 »

How to check the file exists or not in Sage X3

You may come across a situation, where you may want to know the file exists or not to access the file. We have the special command “filexist” in Sage X3 to accomplish the situation. New Stuff: How to delete Detail(Product)lines from Sales order via Import template ? FOUND=filexist(SERVER, FOLDER, SCRIPT_NAME) This function checks if a… Read More: How to check the file exists or not in Sage… »

How to copy Parameter Values from one folder to another..?

Function: ACOPADO (Copy Parameter Values) Path: Development > Utilities > Miscellaneous > Copy parameter values New Stuff: How to find the current source file name Description: This function is used to copy the values of parameters defined at a given level (company, site, user, legal) for a given code, to a group of destination codes defined… Read More: How to copy Parameter Values from one folder to another..? »

Link tables in Sage ERP X3 through coding

Function name: Link Description: Link is used to defining a set of links between various tables, as well as the single abbreviation to access these tables with one instruction. Syntax: Link class_p with list_links as class_l Refer below snippet of code for better clarification. New Stuff: How to get the number of records modified by Update… Read More: Link tables in Sage ERP X3 through coding »

How to restrict the Automatic allocation in Sage X3

An allocation is an amount of something, especially money, that is given to a particular person or used for a particular purpose. Allocation is the process of assigning product items from the inventory to shipping orders and then fulfilling the shipping orders from appropriate fulfilment sites such as drop-ship vendors, virtual sites, warehouses, or a… Read More: How to restrict the Automatic allocation in Sage X3 »

How to add Sales Invoice elements in X3?

Sales invoice is a bill issued by the seller and is proof the selling process has already happened. The setup of the invoice footers is used to define the numbered codes which are calculated upon valuation of the invoice footer. Based on the setup, this valuation can be performed starting from: The value defined when… Read More: How to add Sales Invoice elements in X3? »

Purchase Request Signature

In our previous blog, we had discussed about some tips on configuring the Signature Workflow. Continuing on the same topic, we will discuss the Signature Workflow of X3 but with some specialized scenarios in this blog. Related Post: How to Setup Quote Signature Management Let’s take an example of a business scenario wherein the business… Read More: Purchase Request Signature »