Category Archives: Tips

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 »

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 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 »

Enhancement feature in EMV12 for managing serial numbers in Product using “Global Received/Issued”

The new feature in V12 for managing serial numbers for product using the “Global received/issued” radio button under serial no.management section in Product screen increases better usability and increase performance and productivity. Here are the steps to check the benefits using the new option added for serial number products. STEP 1: Navigate to product screen… Read More »

How to solve ‘Payment transaction is not of receipt type’ error message in Sage X3

A Payments is like an accountant. It keeps track of who owe whom and how much. Basically it is a transfer of money or assets to another person or business. You may come across a situation where you would like to do payments for the sales invoices. Sometimes while doing payments for sales invoices we… Read More »

Configuring Financial Data Extraction in Sage X3 with Type of extraction as Reporting code

The Purpose of the Financial Data Extraction is representing Financial Data of an Organization/Company in form of Financial Reporting to their concerned stakeholders. This will help evaluate the Company’s performance over specific period (Half-yearly/Yearly), eventually helping the management to take effective decisions based on the financial reports generated. Financial reports, Balance Sheet and Profit and… Read More »

How to create LOP leave type in Sage X3 People

LOP stands for Loss of Pay. In some organizations, this is also called as LWP (Leave Without Pay) or UPL (Unpaid Leave). In order to calculate the LOP days and deduction automatically in Sage X3 people there are few steps needs to be followed, Below are the details. LOP needs to be applied from the portal… Read More »