• Passing list of values as Criteria parameter

    Hi there,

         Is there any way of passing a list of values (comma separated or equivalent) as a Criteria parameter in the printouts > SQL Query Tool

         Also, how to remove character limitation from that field...

    what i'm trying to achieve is something like…

  • How to integrate Amazon and Prestashop?

    Hello everyone,

    I was wondering how I could integrate Amazon and Prestashop to X3?

    Which are the steps to follow?

    Please, could someone guide me?

    Appreciate it!

  • Customer consignment stock management

    Hi all,

    we are using X3 V12 and for selected customers we do keep consignment stocks. Work flow is as following:

    1.) We sell certain products (full pallets) to these customers (fully invoiced) out of our normal stock.

    2.) These sold articles are being…

  • Graphical Query Tool executed query

    I have query in the Graphical Query Tool that I'd like to see the actual query executed.  How do I see the query in SQL syntax?  I want to see the tables and how / what they are joined.  Is there a way of doing that?

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

  • Reminders, Grouping Codes, and FUP report

    Hello -

    Reminder campaigns are a great way to help with AR collections.  In fact, it integrates X3 CRM to help setup tasks, phone calls and other CRM activities.  It also provides the ability to generate "Dunnings" style notifications.  There are…

  • Patch - update failed with error cannot read property '0'

    Should status after a patch say failed with error and should we assume patch 24 was not installed based on the X under applied?

    We went live with X3 on 6/1 after using 100 for many years. We are having some issues and are being told this is normal?…

  • Adding extenstion txt to exports

    Does anyone know why is X3 not exporting the txt file with an extension, what an annoying thing that has never been changed or updated in all this years.

  • Quick Representations/Class Setup for X3V12


    I would like to create more representations using Views/Tables. Requestors are very quick to create in X3V12 using Views/Tables, but very limited functionality specially on Landing Pages. The goal is to give user far more interactive dashboards with…

  • Slow Performance during Report Phase Job Started and Printing X3 V12

    Hi, my company is in the middle of a migration from SAGE X3V5 to SAGE X3V12. R093.001.00019

    When running a report in X3V12, the querying part (Job Started Phase with the green bars) takes an extra 1-3 minutes on average than it did in X3V5. In X3V5,…

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

  • New ADC - Error message on Picking Function

    I am using the new ADC and all the functions seem to operate properly except Pick Ticket. I can select a picking list or a pick ticket, I am then shown the items on the pick ticket, but as soon as I press Update on the first line I picked  .I get this error…

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

  • Carry Forward entries - Accumulated Depreciation

    Please assist. The Carry Forward entry (Opening balance) for accumulated depreciation does not agree to the closing balance at year end on the Fixed Asset register.

    I am not sure what the issue is. The Fixed Asset register appears to have processed an…

  • Sales Kits -Commercial BOM

    I am trying to set up a sales kit - it is a bundle of 6 bottle of wines. 

    I couldn't change the unit of component product. It is grey out. And the system default as "CA" - case.

    Is there any solution that i can change it to a different unit…

  • Subprogram to Create Delivery and Invoice

    I want to build a few subprograms to be executed through web services. Basically, from a given picklist in GESPRH2, I want to click the buttons for 'Deliverable' and then 'Delivery' to create the delivery, and then in GESSDH I want to click the 'Invoice…

  • BOL Number Grayed out

    Who knows why the BOL Number Trailer seal number are grayed out on X3V12P26??


    Hi All,

    Please i want to make the stock transaction field on SALES INVOICE to be defaulted to "YES".

    Please help.

  • Switching between edit and read only Mode with global variable GCONSULT

    Hello everyone,

    For our customer we developed a specific screen to manage plans.

    In order to edit a plan the user has to press a check out button.

    The user who checked out the plan can modify the plan.

    In the FILTRE action we use the global Variable GCONSULT…

  • Variable GLONAYS non existent

    Im getting this error, and I have not find any related articles

    WWAGLOBUSR$adx (244) Variable Non-existent GLONAYS

  • Unable to Autoprint the Crystal Report in Sage X3 from web application

     We are creating Sales delivery from web application(Source code Java) into Sage X3 using Soap web services which is succesful. At the same time We are trying to autoprint the delivery crystal report after creating delivery in Sage X3 for which code was…

  • Back-to-back actions do not turn blue

    In my customers folder i want to make a back-to-back purchase or work order. Normally the options turn blue in the right pane, so that I can make the b-t-b order.

    All the codes are correct for work order generation from the sales order. The work order…

  • Product Not tied to a Particular site allows transaction created with another site on the line.

    Hello All,

    Please i notice of recent when a product is not tied to a particular site, The system allows the transaction to flow while another site is assign to that transaction on the line.

    Which makes it two different site.

    How can i make it to always…

  • Transfer custom fields from STOALL to STOJOU

    I have a custom field in the STOALL table that I would like to transfer to the STOJOU table when the transaction is validated/posted.  I've been looking for an entry point to do this, but I can't seem to find it.  Does anybody know if there is an…

  • The update finished with warnings

    After installing patch 26 on v12 i get this message, but I dont know where is the log or what are the warnings????