Hello All,

    Please i need your help, anytime i transfer an item from One site to another Site the cost amount doesn't transfer along with it.

    Please Help.

  • Field data not present until Update clicked

    Good morning

    I created a new field and used the type AUS since i am using this to look up employees, once you select the employee and save you will notice the selected user code is present. 

    The problem is when you go back into the function and see the…

  • SageX3 - Left List Personalization

    Hi, how can I add custom  view fields 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…

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

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

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

  • Screen Field Size

    Good day Ladies and Gents 

    Can anyone let me know if there's a way to make the fields appear larger on a screen?  It seems to dynamically change when you change the size of your screen, but ideally there are some I could make larger by default and…

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