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 restrict dimension relationships within dimension type »
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 resolve ‘The quantity to be returned exceeds the… »
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 activate customer allocation »
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: How to transfer file to FTP server »
In some industries the company wants to migrate the data from lower version to higher version in Sage X3. Every company wants to upgrade the system functionally or data on the higher version. For that we run some per-migration script. At that time, we will get Error: ‘Incorrect version No (AMIGKEY/MIG_RELEASE)’. With the help of… Read More: How to solve error “Incorrect version No (AMIGKEY/MIG_RELEASE)” Error while… »
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 display missing invoices during payment proposal and how… »
As we all know sage x3 uses dimensional accounting which helps to improve and simplify the reporting. There may be cases where a specific dimension is restricted for specific account although the dimension type is allowed on the GL account. To prevent such cases Restriction codes can be configured. First we will check how to… Read More: How to setup Account/Dimension restriction in Sage X3 »
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: HOW TO CLOSE SALES ORDER THROUGH CODE »
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 resolve Unit Type error in UOM while defining… »
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 control Calculation basis of discount in Price structure »
