Tag Archives: 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 »

Grow your online business with Magento Integration for Sage ERP X3

Greytrix presents another integration under our “GUMU™” brand. This time we bring together the two most leading names in their respective domains to get you improved business productivity and tremendous cost savings. Let’s see how Magento integration for your Sage ERP X3 is beneficial for your business. Our integration link does not require any customization in Magneto.… Read More: Grow your online business with Magento Integration for Sage ERP… »

How To End Fiscal Year End in Sage X3

A Fiscal Year is Known as Financial year or Budget year , it plays a very Important role in Sage X3 , It Usually records and report the transactions for the year. It may be varied from the calendar year. it helps to calculate the financial statements in businesses. Before proceeding with any transactions we have open… Read More: How To End Fiscal Year End in Sage X3 »