• SageX3 - Left List Personalization

    Hi, how can I add custom  view fileds into standard (browser) object Left List ?

    It's easy to add other tables but , what about views ?

    Example:this is a standard object 

    I've added my custom view into Viste tab:

    But in Selezione tab (Selection…

  • X3 Licensing: Badge Consumption

    Hello X3 Family! First off, I would like to thank everyone, whose been with me throughout my X3 Journey over the past 4 years. It's been a pleasure Handshake tone4! X3 has allowed me to develop and grow in many ways, and I'm extremely thankful for my experiences…

  • How do I print a list of the invoices paid by a specific check?

    I just want a way to reprint the remittance. I can't find a report or screen to show me all the invoice numbers on a check, just a listing of the PINs that I can drill back to. Any suggestions?

  • Deleting prospects

    When I'm under All > Common Data > BPs > Prospects and I try to delete a potential prospect, the delete button is grayed out.  Does something within the prospect have to be checked or unchecked?

  • Product configurator Error - "Variable Non-Existent T_xxxx message"

    Since 2021R4 I haven't been able to use the  product configurator as it throws a "Variable Non-Existent T_xxxx message" as soon as there is a (S_xxxx) variable tested in the options/variants or scenario. In my tests, I am not using T_XXXX, just S_XXXX…

  • Manual Allocation of Substandard Stock in X3

    We sometime have defective or substandard stock we sell at a discount.  This is product that has gone through a QA process and has failed to meet our standard but some customers may not care that the product "looks a little funny".

    We do not…

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

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


  • How to register city names that contains strange character as "ñ", "á" or others?

    Hello everyone,

    I am trying to register a spanish city called A Coruña in the customer file but it does not register properly.

    Sage X3 identifies everything but this character "Ñ". Same happens with others character as "á", "Í" or others.…

  • Update Transaction

    Good afternoon

    I am trying to move data from one field to another.  Basically we have a free text field that we used to use and now we are using one linked to AUTILIS and I want those user codes we were using to now populate my new field.  I believe I…

  • Apple operating systems and Sage X3

    Hello all,

    I am the MIS manager for my company and have recently run into an issue with Apple devices and Sage X3. We have both Windows and Apple running in our environment. Our Apple users started reporting numerous fatal errors on their MacBook and…

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

  • Include the shipment requests (open orders) in the On order field of the customers.

    The general parameter OSTORD is used to specify whether the order book value must be included in the Total credit of the customers.

    But, the shipment requests (open orders) are not included in the On order field and thus are not affected by this setup…

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

  • calculate available stock


    i want to add a field in my MGB screen that contain avaible stock , so i added a field type QTY but i have no idea how to write function in spe script that calculate availble stock !!!!!

    please help!!

    i'm under X3 V11

  • Sage X3 connection/interface to coupa?

    Has anyone already implemented a connection/interface to coupa?

    Based on V12, possibly with APIs? Or can someone give me customer experience Sage X3 + coupa as a contact?

    If you don't want to do this on Sage City, feel free to message me directly or via…

  • RTF Pasting adds many carriage returns

    Just upgraded to V12 P27 and when we copy to clipboard from an outlook email in rich text format, when we paste it into a comment box in any screen (customer, supplier, sales or purchase order etc), it is adding _many_ carriage returns after each sentence…

  • Get PSHNUM from PRECEIPT workflow

    hello everybody!!

    i'm trying to create a workflow on PTH object that send an email to REQUSR ; in the message box i can't get PSHNUM that stored in PREQUES!!!

    can any help me please

    i'm under X3 V11

  • Import Products Transalation


    I am pretty new into X3. I am wondering how can I import translations.

    After reading several articles, I have no doubts that ATEXTRA table holds the translations. However when I get into the table, I cannot see any translation. I read about the…

  • Blue Pop up "Empty" notification


    I'm getting an annoying pop-up where the notification is empty. I've validated the screen, table, and transactions related to the function, but the message keeps popping. It does not hinder the action or enter the process; I must press ok two…

  • V12 Time out setting


    I'm having an issue with V12. System users complain of short timeouts, like 3 min or so. As I understand, user parameters have no longer been controlling it. nodelocal.js has been set up to 20 min:

    session: {
    timeout: 20, // minutes

  • Resolve Pending Issues for Lot Managed products

    Hello wise people of the Sage City,

    For a customer we had allowed negative stock on ingredients/raw materials to prevent constantly having to stop production because tracking returns an error due to stock being unavailable. Allowing negative stock results…

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

  • Add option in function advanced bank statement import to record manual payment and split the amount on several accounts in one journal entry

    When recording a manual payment in the advanced bank statement import and splitting the total amount on several accounts, X3 creates a single journal entry for every amount. This means that the amount on the bank account is no longer displayed as one…