Tag Archives: Sage X3

How to solve if new field added in inquiry screen and still not visible after global validation of window.

As we all know, generally after adding fields in screens, we globally validate window of that screen and we are able to see the new added field in that screen. But in inquiry screens, it is little different. In this we will see how we add new field in inquiry screen and how we can… Read More »

How to restrict dimension relationships within dimension type

As we all know sage x3 uses dimensional accounting which helps to improve and simplify the reporting. There may be a case where dimensions should not be used in combination with another dimension. Restriction codes can be configured to prevent such cases. We have seen how to configure restriction code and setup Account/Dimension restriction code… 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

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 these should be… Read More »

How to control Calculation basis of discount in Price structure

In Sage x3 we can control Discount calculation on what basis it should be calculated. In sales document we can enter Discount which will be calculated on 3 basis ‘By unit’, ‘by Line’, ‘by Document’ Navigate to Setup > Sales > Price list > Structures User can see the different values for Calculation basis (Refer… Read More »

Setup of Analytical Allocation and Assigning at transaction

In some of scenario we need to assign the distribution according to the multiple dimension. This can be achieved through the analytical allocation and mentioning the same at the transaction level. Define the analytical allocation: Navigate through: Common Data >>G/L Accounting table >>Analysis>> Analytic Allocation Dimension types Block: In this Grid user need to mention… Read More »