Sage X3 has a solution which is used to find the number of records in a table with the help of keyword “nbrecord” along condition. In order to know the number of records in the table, perform the below query. The output will be number of the clients available against the corresponding table. About… Read More »
A contract order is a long-term commitment with a supplier concerning one or more products, for a global quantity and value to be delivered. The contract order is further divided in shipment requests that are made as a function of the contract. A contract can also be intercompany or site transfer. These shipment requests are… Read More »
Sage X3 has a feature in which we can increase the address lines for a customer. This feature can be achieved by following below steps:- Navigate to Set up → General parameters → Folders → SEED Under screens tab, there are various activity codes which are used for functional sizing of the screens. To increase… Read More »
Stock count is a process of counting inventory on a periodic basis throughout the year. This is a two-step process as explained below- A stock count session is generated to select the products and /or locations to be counted along with other parameters and selection criteria. A Count screen is used to check the count. To… Read More »
If you come across a scenario where you want to setup automatic generation of commitments then Sage X3 provides a functionality “Commitments” in the Ledger. To set up this functionality: Step 1: Navigation: Set up – Organizational Structure – Ledger Step 2: Check the Commitments in the Type of accounting of ledger. Now whenever… Read More »
While accessing web services in Sage x3 you may get an error message ‘Service Temporarily Unavailable’. This error is related to services- not being started. To overcome this error open Sage X3 Management console and follow the below instructions: – Click on the Web server tab from the left menu. – Select the folder and… Read More »
We may come across the situation, where we want to enable/disable statement creation for particular invoice. Follow the below instructions to enable/Disable statement creation for invoice. Step1: Go to Setup–>Sales–>Invoices–>Invoices You will find the Invoice window and create a new invoice as shown below. Step2: After creating invoice, click the Open items button in… 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 »
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 »
