You may come across a situation where you want to append leading Zeros to a number but don’t know how to achieve it. This can be handle with the help of the “format$” keyword which will append the leading Zeros to the number. Format$ : Dim is used to format the expression based on particular… Read More »
You may come across a situation, where you need alternate to the “like” keyword of SQL, that is to search for sub-strings in columns of the table. The one way to achieve it to use instr() function, instr() function takes 3 parameters in account. Syntax : instr( rank, string, sub_string ) Rank: Integer type expression… Read More »
Sage X3 has a feature in which you can assign Delivery type to an Order type. This feature can be achieved by following below steps:- Navigate to Set up -> Sales -> Document types → Delivery types. Create as many types of deliveries as you want as shown in the below screen. Now go to… Read More »
Sage Business Partner Conference – South Africa begins next week starting 26th January and we are excited to be exhibiting there once again this year. Greytrix – known for its award winning GUMUTM Integration framework would be showcasing its flagship products and services i.e. Sage X3 integration with Salesforce, eCommerce (Magento), Sage CRM which are built on robust… Read More »
Greytrix unique GUMU™ CRM integration you can integrate your Sage X3 with Salesforce Cloud CRM solution so you can have the best of both worlds. Nowadays, businesses have multiple software application running the company. Thereby, creating complexity and hindering their ability to gain a single view of the customer, employee and supplier information. Greytrix Integrates… Read More »
Sage X3 has function where you can set the aggregate criteria of journal. Navigate to: Setup>Stock>Accounting Interface parameters If all the criteria are equal, one journal entry is created with as many lines as necessary. These lines can be aggregated by account, nature, tax code, entry title by using the automatic journal. For example: If… Read More »
The port number defines the TCP/IP port in which connection server expects connection requests from folder. For development in X3 version 7, while creating new X3 project in eclipse, we have to define following parameters: Hostname Port Folder Here, Hostname: System IP address. Port number: To be known Folder: SEED\X3 We can find out port… Read More »
In Sage X3 users are allowed to add the line text while creating the purchase request, this text can be a short message related to the product or supplier .If user wants the same text in the purchase order created against that request, Sage X3 allows handling the flow of text from purchase request to… Read More »
Standard function FUNAUTDLV (Order deliveries) is used for bulk shipment creation. There are several filter criteria’s available on this function. But, what if you want to add any additional filter criteria for the orders being passed for shipment creation? Using an Entry transaction we can easily add the additional criteria, follow the below steps for the same.… Read More »
Cash Flow Forecast Management helps to judge if the business has sufficient cash to avoid any crisis of liquidity. Cash flow acts as a bottom line of all businesses, hence it becomes essential that forecast of cash flow is calculated to make sure the business endures the monetary obstacles. Cash Flow Management in Sage X3… Read More »
