Sage X3 Africa and Middle East

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 ...

Understanding Manufacturing Costs  What are manufacturing costs?  Manufacturing costs encompass all the expenses incurred in the process of producing a good. They are crucial for determining the selling price of the finished product and ***...

  ISSUE: System is not allowing access after the component upgrades where done in preparation for latest patch,   CAUSE:  There seems to be an issue with the Syracuse component for the version and a hotfix has been released.   SOL...

ISSUE:   The issue of the “Uncaught Javascript exception” comes from when uploading, the user does not wait for the filename to appear on the upload before clicking ok or is uploading more than 5 files.   SOLUTION: &nb...

In order to make this change, you will need to follow the below steps in your X3 application, Log into the X3 reference folder Go to Setup, General Parameters and then folders Specify the folder you want to copy in the “Copy Folder” fiel...

The above error may be observed when running depreciation calculation on 2024 R1 (12.0.35). Resolution: Verify Global Variables GSQLOPTIMZ and GSQLOPTNB are defined in Development, Data and Parameters, Development Setup, Gl...

The above error may be observed when running depreciation calcualtion on 2024 R1 (12.0.35) Resolution: Verify Global Variables GSQLOPTIMZ and GSQLOPTNB are defined in Development, Data and Parameters, Development Setup, Gl...

ssue Payment proposal screen does not load transaction but gives Variable non-existent error Resolution: copy the screens 2, PAYPROPAL, PAYPROP0, PAYPROP1, PAYPROP2, PAYPROPAL and windows DGENPAY, DRAPPRO, FPAYPROCTL  from the X3 reference fo...

Issue When trying to close a period you get an  error that the period all periods are closed while the periods are not closed.   Resolution  This is due to in  reference date setup. You will need to change the date to a futu...

Issue When trying to close a period you get an  error that the period all periods are closed while the periods are not closed.   Resolution  This is due to in  reference date setup. You will need to change the date to a futu...

Parameters that influence the Costing of a Word Order When the work order is created, the provisional production cost calculation can be done automatically if the general parameter Auto provisional costs CLCWOCAUT (GPA Manufacturing, COS) i...

Preview of coming transactions Did you ever want to see what accounts were going to be hit by the posting of a transaction before you committed it to the General ledger? Maybe, you are setting up a new company and/or product line and want to check th...