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 »

How to solve Unbalanced Payment Error while creating Payment through Import/Export Template

Introduction: After sales invoice generation,next process is payment creation,While creating payment through import/export template using PAY object and GESPAY Function,we come across error Unbalance payment error as shown in below image .The solution for solving this error is following below, Solution: Setup>Usgae>Import/Export Template. In Fig 2.1,There is a Sign field which plays important in solving… 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 »

ADDING NEW LANGUAGE IN A FOLDER

We can add a new Language in X3 by using following steps. Let’s consider the new language as ‘Chinese Traditional language’. STEP 1: Switch to X3 Folder. Navigate Development -> Data and parameters -> Local Menu-messages. Add a new Local Menu message in (Chapter 201) for Chinese Traditional language as shown in below screenshot and… Read More »

World Health Day and Business in Times of COVID-19

During the recent times the world is on the verge of emotional and physical outbreak due to the Novel Coronavirus. The outbreak has led to a human tragedy which has further led to the crashing global economy in the absence of a cure. Leaders all over the world are engaged in finding a vaccine for… Read More »

How to solve obsolete product (end of life) error when product status is ACTIVE

Products or Goods which are sold or procured by organization. Both sales and purchase module using product effectively. We can create product by filling all information in product screen, importantly select the product status. If Product Status is Obsolete, then product is no longer available in all modules including sales and purchase. Error Message received… 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 »