It is easy to get the parameter value when the value is defined at folder level. But what if we need the parameter value by User? Well! This blog will help you to get the parameter value by site with the help of the standard subprogram which is present in SUBAUS.src file. Below is the code… Read More »
Sage X3 provides a way to change the posting date of the transaction later after creation. Function: FUNIPTD (Posting date modification) Navigation: Inventory > Utilities > Valuation > Posting date modification Description: Function allow user to changes the posting date of the truncation created in Sage X3. Kindly refer to the below steps: Step 1:… Read More »
If you come across a scenario where you want to restrict sales order for the product which has a service start date then Sage X3 provides a standard functionality “Product start-of-life date”. Product start-of-life date: it is not possible to enter sales orders for this product before its start-of-life date. To set up this functionality:… Read More »
Sage X3 provides a feature to close a line of Sales order after partial shipment. User can set this criterion at Product level. The working of delivery tolerance % is illustrated below. To set the closing criteria go to Product > Sales tab. Define the value for “Delivery Tolerance %” which is used during… Read More »
Manual Sage X3 web service testing method has been changed in Sage X3 V9. The ‘classic’ or ‘legacy’ method of web services no longer works in Sage X3 Product Update 9. Now user can directly test manual Sage X3 web service from Sage X3 screen. Please refer below steps for the same. Navigate: Administration—>Web Services—>Classic… Read More »
Sage X3 provides an inbuilt function to verify if there are any duplicate values in a series of variable or numeric expressions, alphanumeric expressions or dates. The function used for this purpose is UNI. If the series contain duplicate value(s), the UNI() will return the position of the duplicate value. If there are no duplicate… Read More »
To implement the business logic we need to use SQL Query to fetch the required data from the Database. To execute the SQL Query from Sage X3 we need to know the database type. We can fetch the database type as below: The “TYPDBA” column in “ADOSSIER” table holds the value which will help to identify… Read More »
Mass copy of accounts function is used to carry out a mass copy of number of Accounts with a given range from one folder to another. In accounts transfer by giving the range of accounts, the given range account will be copied to another folder. In the following example, the account range from 1010 to… Read More »
There might be a scenario where we want to cancel the posted payment receipt. Sage X3 provide feature to reverse the posted payment receipt. To successfully bring this functionality follow below steps. Navigate to: A/P-A/R accounting>Payment/ Receipt entry >RCHQ>Options/Menu Bar> Accounting Cancellation Click on ‘Accounting cancellation’. Select the negative generation type. Select the accounting. Click… Read More »
Businesses small or large employ two crucial systems in their organization for an efficient business process – Sage X3 deals with the back end operations and Sage CRM for the front end operations. Sage X3 manages the post-order customer information. This includes purchase history, account information, shipping information and supply chain management details. On the… Read More »
