• Sage Access for integration & testing

    Hello Group

    We are a custom software group. Recently we are getting inquiries to integrate our software with Sage X3 ERP. We are looking for the access and technical details to integrate receiving or sending data from/to Sage from our system. Where do we…

  • Error in returning stock - Line movements are pending, please adjust

    Hi team,

    I am facing a challenge in returning a stock where as I have deliveries and I was able to create credit notes among the steps in returning the stock but I am facing an error as in below screenshot as soon as I select the delivery number so as…

  • No data in GACCTMP

    Good day

    We have an issue where no transaction is written to the GACCTMP table.

    Any transaction that we try to post in Sage gives an error and the process stops. When I look at GACCTMP I see no record in this table.

    I have tested Purchase Invoices, Sales…

  • AP / AR Aging Report Shows Fully Applied Invoices


    When i run the aged trial balance it shows fully applied invoices and payments. It is matched already and customer wants to see only outstanding documents. Are there any way to remove all applied documents from aging reports.


  • Find Elimanated record

    Hello evrybody,

    In an intercompany flow, when the sales invoice is produced, the purchase invoice is produced and referred on the sales invoice.

    However, there are some sales invoices that are not refered in the purchase invoice.

    Within the purchase…

  • Default quantity


    Please, how could I put the quantity requested to be 1 automatically as you get on the line.

    thanks to those who answer,


  • SUBSCS - Inter-site transfers - CWSIS


    On V12 Patch 27 Sage introduced CWSIS webservice in order to respond to the new ADC options.

    However, since it was done in order to work with ADC, Sage limited the use to just that.

    We can't use the same service for other third party integrations…

  • Record Print options greyed out

    After posting payment, the record print option is greyed out only the list button is active. I need help.

  • How can I add Word Merge functionality to other objects?

    Hi Everyone

    Currently the Word Merge functionality is available on Sales Quotes. I would like to be able to add this functionality to other objects ie Purchase Orders as the customer requires multiple documents to be created from X3 (but editable by…

  • How to remove line number from the graphical report created using SQL query

    Dear Sagians,

    I have graphical report created using view and sql  query, but the problem here after adding this into dashboard is instead of date, line number is coming[Below screenshot] Any ideas to display the date here.

    Note: When running the report…

  • Web scheduling work orders problems

    The problem is that while importing plant from sage x3 it goes well, the file *.JSON contain all the information from sage x3, but when I opened web scheduling I can't run automatic scheduler (due to inexistence of work orders as show below)

  • Any Easy way to exclude weekend from date calculation in 4GL?

    Is there any easy way to exclude the weekend from my date calculations in X3?

    For example, my delivery is suppose to arrive on Monday. It takes 3 business days to get to the customer. If I do Monday - 3, I would get ship date of Friday when I actually…

  • Problème importation de x3 vers web scheduling

    lors de l'importation de "plant" de sage x3 vers web scheduling via Analytics j'ai rencontré un problème dans le fichier FR012.json "{ "repos": [invalid authentication method: bearer]}"


  • Planner One notice: Your desktop is being initialized. Please wait until this action is complete.

    Hi all,

    While using planner one on SageX3 V12,

    our site is initialized and planner one opens perfectly, but after any WO is submitted we get this notice (making it unable to proceed)

    Did any of you guys face such an issue?


  • Workflow rules: mail notification after create QC analysis requests


    Im looking for solution to create Worfkflow rule/Notification that will return email after create "Analysis requests" from production declaration or receipts.

    Everything what i get so far is email notification only from modification or…

  • How to Manually Recreate the V12 Accounting Task

    Today, I'll be demonstrating and discussing a troubleshooting step that some may be unaware of regarding the accounting task. What's this mysterious and obscure troubleshooting technique....so you say? Disclaimer, I would not consider this troubleshooting…

  • How to setup a Sequence number definition using type Database Sequence type?

    We are having problems with frequent locks on table AVALNUM

    Most of the time the locks are for sequence numbers WRG, WRK (used for various Workflow activities).

    We hoped that changing these two Number series into the type "Database sequence" might…

  • How do I join STOJOU to GACCCODE?

    I am looking to join the two above tables, According to the data models, the join is supposed to happen like this: 1;ACCCOD. How is that supposed to work if STOJOU doesn't have any accounting code? Also what does the 1 mean in the data model? Any and…

  • Is it possible to have a restriction by group of sites on the user's profile ?


    Today we have severals sites in Sage and we need to have restrictions on it.

    We put some restrictions code on the user's profile with the row level permissions  but there is a lenght limit and we will have to add 10 sites.

    I know it's possible…

  • What is the column name for AvailableStock->TotalRequirements in sql?

    I am looking to get the sql column name for  total requirements qty located in available stock. If anyone could point me in the right direction, it would be greatly appreciated.

  • No Applicable Rate when posting purchase invoice


    I am getting an error message when i try to post my invoice that there is no applicable rate for one of the purchase invoice lines. 

    We create our purchase invoices based on the receipt number.

    We are on V11, Patch 14



  • Enter backdated shipment for product that has since expired

    We have a scenario as follows

    Sales Order was done on 18/11/2021

    The product to be delivered expires 20/11/2021

    Physical delivery to the client was done on 19/11/2021

    The delivery was only captured in Sage X3 on 22/11/2021 although we changed the delivery…

  • Default Customer Contact checkbox location

    On the customer screen, there is a default contact checkbox. 

    Which table is this stored on? I cannot find it on CONTACT or CONTACTCRM table. 

    On V11, Patch 14

  • 1) Mass delete BPS Invoices 2) DocLink/DocAlpha

    1) Is there a way to mass delete BPS Invoices? I have 1900 to delete.

    2) Duplicate and triplicate Invoices have imported into Sage X3v12 p17 from DocLink/DocAlpha.  This is the second or third time it has happened.  Does anyone have advice on what might…

  • 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…