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 »
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 »
Sometimes, it might happen that we need to transfer a file to the FTP server. The below piece of code will transfer the file to FTP. Parameters: HSTSITE It is the FTP server address on which the files will be transferred. HSTUSR and HSTPWD It is the Username and Password of the defined FTP server.… Read More »
Sometime we may come under a situation where we have to close the sales order through code. Keyword DIVSOHCLE is used to close the sales order record. For example: Below is a sales order which we have to close through our code. Fig1: Sales order record Use the keyword as… Read More »
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 »
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 »
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 »
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 »
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 »
In Sage X3, most of the times, we need to perform some operations on fields like amount, tax etc. or any other cusomized numeric field. As we know, there are number of data types avaliable for decimals in X3 with different length and varying number of digits after decimals. For example, data type DCB supports… Read More »
