Sage X3

Use this function to create journal entries based on late charges calculated according to the terms defined in the Bad debt terms function (GESBDT). Bad debt is an account receivable due to a business when the repayment of credit previously...

The following error occurred after one of our BP’s upgraded to Patch 37, when you select the relevant receipt on the left list of a Purchase Invoice: @X3.TRT/SUBPIH$adx (1284) Error 8: Index Incorrect CURLED(-1) This only appears when you try ...

When capturing Broker's fee of more than 6 digits plus 2 decimals, the below error occurs and prevent user from processing a Sales Invoice. Error Broker’s fee: The entered value does not respect the field format or type. Resolution: The is...

The following error was encountered when generating budget lines for projects PLBPRIREM: Incorrect Format  We have found that the error was caused by the rate on the cost type. We imported the cost types and are not sure why there was a fo...

Stock transaction defaults to Yes when creating an Invoice from a Sales order/delivery , however the below changes must be made first. Change the default value for FIELD STOMVTFLG to 2 on the SIH1 screen , validate the screen and the BPCUSTOMER table...

Cost Type in Project Management 2 minute read time. Project management consists most of the time in five classic main phases. Each of these phases are very important. First is the concept and initiation, second is the project definition and planning,...

Data Type Personalization (GESATYC)   Data types (GESATY) define how data is stored, formatted, and validated across the system. They are referenced in multiple dictionaries, including table fields, screen fields, and report parameters, ensuring...

To identify pain points and bottlenecks resulting in Sage X3 system slowness, follow this step-by-step guide: Step 1: Baseline Infrastructure with AIOBENCH The AIOBENCH tool (Performance Index) measures database throughput and environment quality. I...

When trying to dispose an asset I am getting an error.  Please ensure the following: Setup, Financials, Accounting interface, accounting codes (GESCAC):   Fixed asset accounting code linked to your asset line 11, in the accounting cod...

A check (or cheque) is a written, dated, and signed document that directs a bank to pay a specific sum of money from the payer's account to the payee. The person or entity writing the check is the payor or drawer, while the person to whom the che...

A practical guide on Sage X3 and ERP knowledge transfer In Sage X3 environments, the absence of accurate technical records can lead to operational disruption, costly reverse engineering exercises, security exposure, failed handovers, and reduced conf...

When installing Sage X3, there is a specific order to follow pertaining specifically to MongoDB and Syracuse.  To prepare for the installation, you will need to do the following. Create a local user with all the required permissions, this is ess...

To import a folder through the console. The following is the best practice method. Copy the folder to a tmp folder Open the Unzipped Copy the folder from the tmp folder to the \folders (in this example D:\sage\X3V1236\folders) and the \tmp\X3_PU...

Log into the console and select the print server, then click the Add button.   On this screen, enter the details of the server, port, user and password   Select the print server and then enter the user. Click ok. Enter the password and cli...

Integration projects if not managed well end up as bulky and messy. A successful project starts with a granular understanding of how both systems "speak." Clearly defining which system owns specific data. “Source of Truth”. A do...

Inter-site Transactions Inter-site transaction is where two sites under one company are purchasing and selling products to each other. Examples:   Inventory Transfer Between Warehouses A company has a warehouse in Johannesburg and another in C...

Use this function to settle open items for BPs that are customers, suppliers, or both. Possible documents to include are open customer invoices and credit memos, open supplier invoices and credit memos, unapplied cash receipts, and unapplied payments...

Error when clicking search on SQL query   Issue Error when clicking search on SQL query @X3.TRT/VISUSQL$adx (365) Error 6 : Variable Non-existent WTYPDBA   Solution Copy the OALH window and ALH object from the X3 reference folder, validate ...

New menu item (SQL query) only displays as a table   Issue New menu item (SQL query) only displays as a table   Solution Check if all the fields with graph type “value” have the total field set to yes.   If the fields are s...

Getting errors when publishing web service   Error GAS STDCO: Too many published field   Solution Reduce the screen size on GAS activity code  

Archiving in Sage X3 plays a crucial role in maintaining system performance, especially for customers with very large production databases. This blog focuses on the archiving logic related to GACCENTRY, which also represents financial journal entries...

Mobile Automation New features 2025 R2 Mobile Automation: Confirm stock picked in the Pick ticket transaction When the pick ticket is in detailed allocation, you can set up the confirmation of the stock picked. This confirmation can be applied for th...

By-products are secondary products produced when manufacturing another product.  Example: Fruit slices used as a component is a primary product . The left over fruit can be dried and used in another product. Sheet metal cut for a prima...

Section 12C of the South African Income Tax Act provides an accelerated, non-apportioned capital allowance for taxpayers using new or used machinery/plant directly in a manufacturing process, allowing for 40% deduction in year one and 20% over the ne...

The reordering policies are set for a given product to specify certain details during the requirement calculations (MRP & MPS) to identify the suggestion type, the reorder quantity, the splitting, the safety stock, the use of the loss percentage ...