Browse By Tags

  • Customer Parent/Child relationship

    Hello Team,

    Could you clarify, is it possible to create the customer Parent/Child relationship in Sage X3?

    If yes, could you provide screenshots on how to do it?

  • What is the difference between Invoice Due date basis and Invoice Due date

    Hello Team,

    Could you help me with the following question?

    What is the difference between Invoice Due date basis and Invoice Due date?

  • Novedades Financieras #6

    Bienvenidos al resumen de novedades financieras #6, la publicación periódica donde os adelantamos los últimos artículos publicados en nuestra base de conocimiento Sage Knowledgebase referente a temas financieros, novedades…

  • Batch JE Function - reversals?

    Can you create reversing entries in the Batch JE function? If so where? 

    Financials > Journals > Batch Entry

  • Descubra a metodologia STREAM e as vantagens para os seus projetos Sage X3!

    A STREAM é uma metodologia de implementação do Sage X3 e foi criada para desenvolver um processo único, global, consistente e eficaz dos projetos Sage X3.

    Como parceiro, tem à sua disposição o toolkit STREAM, onde poderá encontrar…

  • Facing issue while choosing the endpoint of the imported folder v12.0.21 on a new servers of Sage X3 version 12.0.26

    I got an error while choosing the endpoint of the imported folder v12.0.21 on the X3 version 12.0.26. "Create session error : The folder version is different from the version of the root folder.", As shown in the screenshot below :

    Has anyone…

  • How to upload a file to mark outstanding transactions?

    Hi there

    I have a bank reconciliation of 9,000 transactions, of which 750 of them are outstanding. I have already identified the outstanding transactions in an excel workpaper.  

    Do you know if there is any way to upload or mark the 750 outstanding transactions…

  • Adding current Date to an SEI Dashboard

    Hi Everyone, 

    I am trying to add a current date widget to an SEI dashboard. I have tried to add a KPI view with a calculated column containing @@CURDATE without success. 

    Best regards, 


  • Where can I find the received qty from a PO?

    As seen above, I am looking for received/delivered qty from a Purchase Order. Is it the Received STK or PUR in the PORDERQ table? so far I have been using received stk, but am unsure if that is correct

  • ALERT: **RESOLVED** Mysage Case Management Portal update **RESOLVED**

    Latest Update as of 9AM 17/9/21  

    The issue has now been resolved and the Case Management Portal is now available.  

    We will no longer be monitoring the [email protected] mailbox.


    Latest Update as of 12.10 PM:

    • An emergency release…
  • I need help verifying a variable on creation of Sales Invoice

    I there,

       I'm struggling to get a verification if a Variable is empty or not on creation of a sales order. 

       The Variable is in each line of the sales order, i need to emmit a warning and block te creation if one of the lines has the var empty 

       Here is…

  • How do suppliers work?

    How are suppliers set up? I see in the ITMBPS table, there is a flag for default supplier which makes me think that if it is not a default supplier, is it the last supplier that updates anytime an item is received from a new supplier? 

  • Nueva funcionalidad Factura de anticipo

    Creación y gestión de anticipos para pedidos de venta:

    Con la nueva función de gestión de Facturas de anticipo (incorporada en release 2021R3) es posible crear, gestionar y contabilizar facturas de anticipo vinculadas a un pedido…

  • Home: Sage X3 Year-end Articles

    Find answers to frequently asked year-end questions. Select from options found in the table of contents on the left or select a topic below:

    Note: To access some resources, users…

  • Anyone know how to setup an Export template so that it's output is split into multiple files?


    We are still using version 7. We have an export template we use to export invoices to be sent through EDI. Currently the export template creates a single text document with information from every invoice that needs to be sent. Is there a way to…

  • Trying to read the products of Magento from X3 using rest api integration and Node JS Error

    Hi All,

    We are trying to read the product of Magento from Sage X3 using integration methods such as Rest webservices, Node.Js for one of our client. The Magento API endpoints uses 'OAUTH1' type of authorization for authentication of the Rest API…

  • Budget control on Financial Journals

    Good day,

    Is there a journal type setup that can be used for Financial Journals (i.e. General Journal) that will check the budget on the GL account and block entries to an account if no budget available ?


  • Server batch X3V12

    Bonjour à tous , 

    Nous avons installé SAGE X3 V12 . Mais lors qu'on veux se rendre dans le menu : Administration / Server batch , on a ce message d'erreur 

    Quelqu'un a une idée de ce message ? Comment le résoudre ?…

  • Announcing the release of Sage CRM 2021 R2

    With a range of sales, marketing and service modules that give end-to-end visibility of data and processes, Sage CRM enables customers to make better informed business decisions based on accurate information. 

    We are pleased to announce that we released…


    Hello All,

    Please i need help

    I ran Stock Accounting Interface and this error below came up,

    ACC (CIL) : Tax code mandatory (XSTK Line 22) stat=97 KEY1=HOF2108ISS00000751 KEY2=1000 KEY3=~ KEY4=~ KEY5=~

  • Import performance enhancement

    There are two performance enhancements on Imports using templates that are included on the 2021 R3 patch. You can read all about them  by clicking on the link below.

    Import performance enhancement

  • Consultation de la balance SAGE X3V12

    Bonjour à tous , 

    Est -il possible d'afficher l'exercice en cours dans les champs date début et date fin dans l'écran de  consultation de la balance ? 

    Dans notre cas par défaut nous avons date début =01/01/2016 et date fin…

  • How can I go about joining the SINVOICED table to the STOJOU table?

    As seen in the subject, I am looking to join the STOJOU table to the SINVOICED table without the use of the ITMREF column. Data models show a one way arrow from STOJOU to SINVOICED with VCRNUM;VCRLIN. I am unsure of what to do with that, with VCRNUM only…

  • SIHI Line 30 Legal No Account Found & Rollback Following Error in Transaction

    Hello All, I'm using Sage x3 V5, While posting Invoice, I'm facing an error. Kindly support on below urgently:

    We are passing only Sales Transactions like Invoices & Credit Note  as we stopped using the Finance Module.

  • Advanced selection filter: global checkbox not available


    I am looking to set a default 'STD' filter. The checkbox to set the selection as global is not available. 

    I have Admin rights as my role. 

    Am I doing something wrong?