Skip to content
Community Hub
  • Login
  • Site
  • Search
  • User

x Want to ask a question or reply? Click here to join the group.
Sage X3
  • United States

Sage X3

Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.
Sage X3 Support
  • Forums
  • Blog
  • Global Hub
  • Members
  • Resources
  • More
  • Cancel
  • Ask a question
  • Subscribe by email
  • More
  • Cancel
  • Tags
  • Subscribe by email
  • More
  • Cancel
  • TRTPROP & SQLDICO functions, what are they and what can they do for you?

    TRTPROP & SQLDICO functions, what are they and what can they do for you?

    NevilleC
    NevilleC
    Database Properties (Function TRTPROP) Ever come across a function that you haven't used or even know about? —let’s look at Database Properties (Function TRTPROP). You can access this function by navigating to: Development →...
    • Feb 5, 2026
  • Understanding Sage X3 valuation methods and the best practice for correcting inventory cost errors

    Understanding Sage X3 valuation methods and the best practice for correcting inventory cost errors

    VanessaQ
    VanessaQ

    Sage X3 provides several valuation methods, such as Standard Cost, Revised Cost, Average Cost, FIFO, and LIFO, and it allows you to define primary and secondary valuation methods at the product‑site level. These methods control how stock movements (receipts…

    • Feb 5, 2026
  • Setup and activation of SageX3 Copilot in 2025_R2

    Setup and activation of SageX3 Copilot in 2025_R2

    NevilleC
    NevilleC
    Sage X3 Copilot (2025_R2) The anticipated release of Sage X3 Copilot has been delivered in the 2025_R2 update. The update to Online help regarding the setup and activation has yet to be released so I thought I’d write this blog to give you a qu...
    • Jan 6, 2026
  • Understanding the Accounting Interface Parameter for Stock Movements.

    Understanding the Accounting Interface Parameter for Stock Movements.

    VanessaQ
    VanessaQ

    Managing how stock movements are posted to the General Ledger (GL) is essential for clean financials and traceable inventory accounting. In Sage X3, the ACCIFA accounting interface parameter controls whether (and when) stock movements generate accounting…

    • Jan 2, 2026
  • Subcontract Purchase order import

    Subcontract Purchase order import

    Shafique Syed
    Shafique Syed

    Often, we get similar enquiries from Business Partners as below

    “For one of our clients, we have the requirement to import the sub-contract order (GESSCO) in the system. To confirm the import process, we followed the below steps to import the orders but…

    • Dec 28, 2025
  • Some tips to troubleshoot the recurring tasks MRP Process and Account Interface

    Some tips to troubleshoot the recurring tasks MRP Process and Account Interface

    Claudia N.
    Claudia N.

    In the case if your recurring tasks are not working as expected, hereafter are some tips that you might need to take into consideration. In this post, I will refer to MRP Process and Account interface as reference.

    1. MRP Process task (FUNMRP)

    • This is…
    • Dec 18, 2025
  • How to configure the Stock Valuation by Period (PIT)?

    How to configure the Stock Valuation by Period (PIT)?

    VanessaQ
    VanessaQ

    The Stock Valuation Report by Period (Stock, Inquiries, Movements) is used to reconcile transaction activities with the general ledger. This report tracks stock valuation across financial periods. Using this report, it is possible to backdate stock valuation…

    • Dec 5, 2025
  • X3V12 Mongo Shell user

    Renier
    Renier

    Good day,

    This is an informative Blog. It highlights some key facts at the time of creation of this blog.
    It focuses on the X3 User that is created for the Mongo Shell.

    Security Authentication for the Mongo Shell maybe enabled by adding the below line …

    • Dec 5, 2025
  • Troubleshooting ElasticSearch Regex Error in Sage X3

    Troubleshooting ElasticSearch Regex Error in Sage X3

    chris h.
    chris h.

    New fiscal year, new FY goals.... We are back at it this year with blogs and vblogs.

    Today's blog will be on an ElasticSearch regex error. Its not very common but I thought it would be good to start with an unusual error. So, here we go...

     

    If you…

    • Dec 3, 2025
  • Enhancing the Left List in Sage X3 V12P37

    Enhancing the Left List in Sage X3 V12P37

    NevilleC
    NevilleC
    Enhancing the Left List in Sage X3 V12P37 In this post, we’ll explore how to customize the left list menu in Sage X3—an essential feature that enhances usability across many functions. For demonstration purposes, we’ll use the User...
    • Oct 24, 2025
  • Embedding SEI view in a Sage X3 function

    Embedding SEI view in a Sage X3 function

    Shafique Syed
    Shafique Syed

    Client’s who is using SEI view frequently may want to open the view within a X3 function rather than login and opening the SEI view externally.

     For instance, I often need to open SEI view “Invoice by Customer” and wish to view the information when…

    • Sep 23, 2025
  • Bricks Import parameter setup

    Bricks Import parameter setup

    Shafique Syed
    Shafique Syed

    Total / Partial Import is frequent activity in Web Scheduling. This is done through the Landing Page in the Control Tower of Bricks.

    This landing page has set of default parameter. 

    • Plant: Plant data to import.
    • Scheduling Start Date: define the beginning…
    • Sep 14, 2025
  • Web Scheduling Log

    Web Scheduling Log

    Shafique Syed
    Shafique Syed

    During Web Scheduling Total Import in Bricks if there are issues and you want to investigate the possible reason of these issue you may want to activate the below logging options

    These steps are for current and more recent GraphQl interface Import / …

    • Aug 25, 2025
  • UOM conversion from Purchase Request to Purchase Order is not converted properly.

    UOM conversion from Purchase Request to Purchase Order is not converted properly.

    Claudia N.
    Claudia N.

    In the business process, there might be a requirement of Stock UOM conversion directly from Purchase Request to Purchase Order instead of using Packaging Unit.

    Hereafter is something that you can consider to achieve your requirement in Sage X3:

    1. Firstly…
    • Aug 15, 2025
  • Schedule Syracuse database backup

    Schedule Syracuse database backup

    Shafique Syed
    Shafique Syed

    If you wish to take Sage X3 installed MongoDB Syracuse database backup and schedule it, you could perform the task in following steps.

    Step 1. MongoDB tool “mongodump” setup

    In the installed MongoDB folder, you should find MongoDB tools. In…

    • Jul 27, 2025
  • What to do when Back-to-back order dimensions are not flowed from Sales Order?

    What to do when Back-to-back order dimensions are not flowed from Sales Order?

    Claudia N.
    Claudia N.

    With reference to the article “How to capture default dimension from WO auto generating from PJM”, you might think that it will be applicable to Back-to-back order when using default dimension code POW because of the same automate order generation…

    • Jul 2, 2025
  • How valuation works with serialized inventory in Sage X3 ERP

    Phil K
    Phil K

    Below is an example of product valuation for serialized inventory when FIF (FIFO) is the cost method on the Product-Sites record, Cost tab.

    SERNA01100043 – 45  -- received at $100  Total: $300

    SERNA01100046 – 48  -- received at $200  Total: $

    …
    • Jun 27, 2025
  • Canceled batch task

    Canceled batch task

    Shafique Syed
    Shafique Syed

    We often get this query – Why my recurring batch task is with cancel status? But if I run the batch task manually, I have no issue.

    Verifying batch server log file, we find information

    “00000041 06-26-25 02:22:10 (Application server time) FINREQ…

    • Jun 26, 2025
  • How to capture default dimensions from Work Order auto generating from PJM

    How to capture default dimensions from Work Order auto generating from PJM

    Claudia N.
    Claudia N.

    If you have come across the post “What-are-the-default-dimensions-associated-with-manufacturing”, you might notice that there is a default dimension called MFIAUT (Auto Released Product) which allows automatically flowing dimensions from some…

    • Jun 4, 2025
  • How to increase timeout value for GraphQL API

    How to increase timeout value for GraphQL API

    Shafique Syed
    Shafique Syed

    Working with GraphQL you may face this timeout issue and would like to increase the timeout value so that you can complete your query /mutation request

    For instance,

    I have the below Stock “Miscellaneous receipt” mutation which runs without issue.…

    • May 25, 2025
  • Why is X3 classic functions looking for file from X3_PUB folder from runtime path !

    Why is X3 classic functions looking for file from X3_PUB folder from runtime path !

    Shafique Syed
    Shafique Syed

    We may face this situation where X3 classic function is trying to open file in X3_PUB folder from runtime path directory rather than X3 root reference folder directory

    This issue is due to missing “.users” and/or “.passwd” file from child folder…

    • Apr 22, 2025
  • Something you should know about Financial Data Extraction in V12

    Something you should know about Financial Data Extraction in V12

    Claudia N.
    Claudia N.

    Part A:

    In the scenario where you have developed some Financial Data Extraction (FDE) reports in V9 using 99 columns maximum. However, you are unable to find them after upgraded to V12.

    Below are the definitions that might be helpful for you to figure…

    • Mar 26, 2025
  • Changing Endpoint setting for Web Scheduling

    Changing Endpoint setting for Web Scheduling

    Shafique Syed
    Shafique Syed

    There could be situations where we need to change Endpoints associated with Sage X3 folders in Web Scheduling.

    For instance, the settings are referenced to UAT / SEED folder, and we now want to change the setup referencing Production Folder.

     

    Prior Web…

    • Mar 24, 2025
  • Reset X3 database schema login password

    Reset X3 database schema login password

    Shafique Syed
    Shafique Syed

    In situations,

    • Due to security concerns we want to change schema login password
    • Someone had changed schema Login password and now we would like to reset the password

    We come across issue where when users are trying to login to X3 folder, experiencing…

    • Feb 13, 2025
  • Info on 1099s for 2024

    Info on 1099s for 2024

    Joel S
    Joel S

    There will be no changes to any of the Sage X3 1099 forms this year. Therefore, there will be no new 1099 downloads for 2024.

    Sage X3 version 12.0.1099 2022 cumulative patch update includes fixes previously delivered, as well as the new 2022 1099/1096…

    • Nov 12, 2024
>
Sage
Africa & Middle East Canada France Portugal Spain United Kingdom & Ireland United States Global Solutions
  • facebook
  • instagram
  • linkedin
  • youtube
COMMUNITY
  • Site help
  • Site map
COMPANY
  • Overview
  • About us
  • Careers
  • News
  • Sage events
  • Investors
  • Sage Foundation
PARTNERS
  • Sage Partner Program
  • Partner Hub
  • Developers & ISVs
  • Sage Marketplace
SUPPORT & TRAINING
  • Contact Support
  • Sage Knowledgebase
  • Sage University
  • Sage Advice Blog
  • © Sage Group plc 2024
  • Privacy
  • Cookies
  • Community guidelines
  • General data protection regulation

*Community Hub is the new name for Sage City