Sage X3 Africa and Middle East

Setting up LDAP (Lightweight Directory Access Protocol) for Sage X3 involves integrating your Sage X3 application with an LDAP server to enable user authentication and access control. This allows you to use your existing LDAP user directory for manag...

There are handful Sage X3 users that still requires to use their Safe X3 WAS in V12. This feature is shipped standard without any extra cost with the system however the users might just want to make sure that the activity codes are active on the lice...

When a sales order of one line is shipped, and the stock accounting interface run, the shipment journal entry and invoice have each 4 lines as shown below. Sales order with 1 line Shipment Journal Entry has 4 lines The invoice also has 4 lines S...

Time to put on your investigative journalism hat. Check which tables are bulking often? Check if they are temporary tables? If yes then batch task AHISTO might be your best friend, setup tasks to purge off old data. Check if table sizes such as STOJ...

 Reason: Parameter SNSBNQ (Bank Sign) in Chapter :TRS, Group: BNK is not setup according to how the matching is done. Solution: The parameter SNSBNQ is used to define the display sign of the postings on the statement in the bank statement recon...

When creating a new product site and clicking on save the below error occurs. @X3.TRT/SUBITF$adx (4668) Error 6: Variable Non-existent LSTOFCY. This issue might occur in other environments after upgrading from Version 11 or 12 to Version 12 Patch 33....

General parameters>Chapter sales>Parameter OSTORD (On order in order total) The OSTORD parameter is used to specify if the sales order book value can be included in the Total credit. The loan orders and the shipment requests are not includ...

Fixed asset physical asset Function A physical element is an equipment used in the company and carrying the specific information to track this equipment (receipt, report, transfer, disposal) and its count (bar code, localization) and is assigned to a...

It is very important to understand what is going wrong with a report when it does not print. Or printing takes too long. Or the report does not finish. To address the above successfully, Sage has a built-in Print Debugger, inside the Sage X3 Print Se...

MRP Processing not generating work orders. When using MRP processing and enterprise planning to generate suggestions for finished goods. Only customer orders were generated for the finished goods and no work orders were generated. Create demand fore...

A budget is an estimation of revenue and expenses over a specified future period used to manage your expenses. A budget expresses intended expenditures along with proposals for how to meet them with resources. You can define analytical budget informa...

Documentation component version: 12.0.33 (Component can be downloaded on the Sage FTP site) X3 patch level 33 Install your documentation server.   Fill in the component name of your choice.         &nb...

Setting up ZAF VAT Declaration Below is the guide to setup ZAF VAT declaration. The prerequisites: Parameter Setup     Activity Codes DCL – Tax Declaration This activity codes is used to activate the VAT declaration on debits an...

Related to Bug Fix X3-297958 Mobile Automation - Unable to process a pick ticket line when the "All authorized functions" option is not selected. x3-services-23.0.62-win.zip is now available on our FTP server for download und...

To correct a mismatch in the quantity column in a stock report in Sage X3, you can follow these steps: Identify the mismatch: Review the stock report and identify the specific items or transactions where the quantity column shows a discrepancy. Veri...

To use Robo 3T (formerly Robomongo) to back up your MongoDB dup your Database, you can follow these steps:  Install Robo 3T: Download and install the Robo 3T software from the official website (https://robomongo.org/). Launch Robo 3T: Open the ...

Data Patching Setup and configuration information is not protected by an activity code, does that mean after testing the new setup on test environment one cannot create a patch to upload changes to production environment? Actually it is possible to p...

Compliments from our colleagues Amir Shahi and Casey. Reproducing the article for our community. "If you are up to exposing your Sage X3's environment to the public, it is strongly recommended that you avoid using X3's standard authentic...

You can create direct invoices or invoices based on orders and shipments. Follow the steps below to locate a shipment, add product to the shipment and generate an invoice: 1.Go to Sales>Invoices>Invoices. 2.Select the ALL full entry Invoice 3....

On some older versions of Sage X3, HMailserver is configured occasionally to relay email to other email servers. When this is done, knowing how to configure SMTP on HMailserver is helpful. To assist with this process the below extract from the offici...

With the inclusion of Powershell 7 from higher X3V12 Patch Levels it introduces Powershell modules which is required to communicate with the X3 Database Server in-order to populate the X3 Tables inside the Database. This introduces in some cases some...

Scenario:  Enforcing that customers with credit hold cannot have stock allocated when sales orders are entered. N.B: Customer NA012 is used as an example. A. Setting the authorized credit limit to $0 for customer NA012 Go to Common Data>BPs&...

Error message: Debit: The entered field does not respect the field format type. Causes: The format (digit)on the Currency setup does not accommodate the amount/number of digits being inserted. The format is interpreted as follows: Format 1 = the le...

Workflow functionality in X3 can be used to accomplish a variety of tasks. It is most commonly used for controlling transaction documents in the system such as Purchase Requests, Purchase Orders, master data creation and modification, through an appr...

This blog aims to briefly outline the basic principles for the valuation of stocks. In Sage X3, the management of the stock is based on the following tables: STOCK The stock itself is materialised in the database by records in the STOCK table (Stocks...