Tag Archives: Sage X3 Blogs

How to increase no. of characters in Line text entry using import template

Sometimes, it happens we need to insert description for particular line in any transaction using import template and the standard just allows limited text in line text entry like for around 194 characters. We can increase this number of characters by doing few changes in import/export template of that particular transaction. Consider example for a… Read More »

How to enable serial number field in sales invoice screen in Sage X3

A sales invoice is an accounting document that records a business transaction. Sales invoices provide the business with a record of the services they’ve provided to a client, when the services were rendered and how much money the client owes the business. Typically, a sales invoice will include a description of the service provided, the… Read More »

How to create and add formula on inquiry screen

An inquiry screen is used to extract information from one or more table and present it in the from of a grid. It help us to display the records based on the filter criteria we entered. In Sage X3, we have a multiple inquiry screens available such as Stock by product, stock by lot,stock by… Read More »

How to call an API through POSTMAN tool and map with X3 fields

We come across the scenario, where we will use POSTMAN software tool  to examine the working of external API. Postman is a simple GUI for sending HTTP requests and viewing responses. REST services are available in sage x3 that returns data in a JSON format. In this blog, we are going to visualize the mapping… 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 activate customer allocation

There is functionality in Sage X3 where we can hold stock reservations for each customer based on each site. This functionality is located in sales module. Navigate: SALES -> ALLOCATION -> CUSTOMER ALLOCATION. As shown in the above screenshot, there is also an ‘END DATE’ field which notifies that the customer allocation can be done… 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 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 »

How to enable Lot field in Customer return screen in Sage X3

Customer Returns are basically items that have been purchased from store or any online store but then returned by a customer. In Sage X3, while creating Customer Return we may find difficulty in entering manually lot number in the screen. For solving this , X3 has a functionality to enable this field . Navigate to:… Read More »