Category Archives: standard

How to display missing invoices during payment proposal and how to change the payment approval controls

We come across the scenario, while creating payment, posted invoice will not be available for the selection, here are the few solutions below to solve. Navigate to : A/P-A/R accounting > Open Items > Open Item Edit to check the status of the invoice. Choose Pay Approval to “Authorize to Pay”. If Authorize to pay… 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 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 »

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 »

Automatic/Manual stock issue in Sales Invoice

User may come across a scenario where they want to setup automatic determination of stock during a direct sales invoice creation. It can differ from user to user. Some may want it automatically and some may want it manually. This can be handled by doing a configuration in sales invoice entry transaction. Follow the below… Read More »

Sage X3 to X3 People Integration

As we all know, Sage X3 provides features to get/create data from third party applications using web services etc. Similarly, Sage X3 People also provides special feature to connect to the outside application. For example, if we need to create journal entries in Sage X3 from the payroll data of employees coming from X3 People… Read More »