• Force to open [M:ENM] to modify stock movement through code or configuration

    Is there a way to force the popup screen on a qty line modification of a purchase receipt?

  • Automatic Allocation

    Is it possible to turn off Automatic Allocation for one particular RAWMA in our database? We have a case where we have multiple work orders open for one part that comes in one at at time. We would like to choose ourselves which work order to consume it…

  • Set Column Titles Dynamically

    Is there a way to dynamically set column titles for a grid on a screen?  I can do this: 

    But I want to make it more dynamic, like this, but X3 doesn't like it.

  • Implementation problems with specific inquiry

    Hello everyone Slight smile

    We have programmed a specific inquiry for our client. There should be a back and next button.

    Only a part of the data records should be displayed. When you click on next other records should be loaded.

    In the function GESGTC (Inquiry screens…

  • Invoice won't post and errors with "Unbalanced Distribution"

    Our Customer Service team started receiving this error when posting some invoices: "CI2200860 ZSIHI : Unbalanced Distribution 4 (ZSIHI Line 410)" and I'm not having any luck resolving it. I have run GTEST to check the posted amounts and they balance. I…

  • What Option to change customer after delivery creation before validating

    Dear Sagians,

    Is there any option to change the customer in delivery after it created? Please note that the delivery is not validated but still it is not able to change. 


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

  • Scrolling after Saving a Change - GESBPC

    When we go into GESBPC (customers) and change the customer from Hold to Check and hit the "Save" button, it is moving the user all the way back to the top of the screen.  Is there a way to turn off the automatic scroll up?  We just want to save…

  • Record Print options greyed out

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

  • Partial Invoicing of a Loan Order

    We are trying to leverage the Loan Order process to manage inventory we consign to a customer. The inventory is delivered to a customer location but it seems that Sage X3 doesn't allow for the partial invoicing of the order line. I've seen several older…

  • How to configure a Payment Term w/ Due Date "As of" a particular AR Invoice date

    I am looking to configure a payment term, to cutoff the payment month on the 25th Net60EOM.  

    If the invoice is dated 5/24/21 - it is due 7/31/21 and if it is dated 5/25/21 - it is due 8/30/21.

    Could you assist on how this can be configured. 



  • Sage X3 upgrade from V PU9 to V12

    Dear Sage City forum users,

    we're currently looking for someone who has already tried or experienced migration from Sage X3 vPU9 to v12. We currently have one project where we've been asked to "test" this migration internally and see how this may work…

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

  • Webservices Pass empty Value in modify method

    Hi there, 

    I'm trying to "clear" a field using the method Modify in a PHP script with SOAP from another plataform, but it's not working, if the field is empty in the XML it appears that it doesn't modify.

    I tried:


  • 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]}"


  • Sage X3 Implementation - Resistance to change

    We are a distribution/manufacturing company who implemented Sage X3 about 2 years ago and acquired another company early last year. We are facing quite the pushback from the acquisition from the employees and their resistance to change. Therefore, there…

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

  • What is the best way to get a GLCode attached to either an Item or a PO?

    I am trying to join one of the following tables to GACCOUNT. PORDERQ or ITMMASTER. There doesn't seem to be many ways to get from GACCOUNT to an ITMREF_0 or POHNUM. 

    I have tried a few different options but none seem to be working. Your help, as always…

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

  • Where can I find GL code and descriptions of the code?

    I am building out existing access report in sagex3. Where can I find GLcode and descriptions? I've looked at the accounting data model tab and am just not really sure what I am looking for. 

    Thank you in advance!

  • Is there a way to see how much quantity was pulled from a specific lot?

    I am creating an invoicing table that has Item, Lot and QtyOrdered. Is it possible to see per lot allocation by sales order number? I know you are able to see the qty on hand/lot. For example, if I have an item that exists in multiple lots, I only want…

  • Is there a documentation for useful standard x3 functions?

    Hello Slight smile

    As a Sage X3 developer, I have found that there are many useful standard X3 methods.

    One example is closing a purchase order with 4GL code via script.

  • Looking for Total Usage Qty

    Good Morning! I am currently working on swapping from Process Pro To Sagex3 and one of the columns in PP is Usage qty which is total qty used for the year. Is there a field in sagex3 for this? As always, your responses are greatly appreciated!

  • Import Material Cost Variance


    We are on Sage X3 2019 R4 (12.0.19).

    We are importing raw materials and when the stocks are arrived, we need to issue those into production as we are in a tight planning schedule. Received materials will be issued to production with the average…

  • Customer Entry Transaction

    Good morning 

    Does anyone know how I can view the entry transaction screen for customers? I can't seem to locate this in any of the setup function options (V11).  Thanks!