• SageX3 - Selection List

    Hi, in a custom selection script like this:

    GSELFAC = 1 : # campo che deve ritornare

    Filter [F:YPROD]
    CRITERE = "[F:YPROD]YITMREF='"+[M:POH2]ITMREF(nolign-1)+"'"

    NBCOL = 0
    NBCOL +=1 : COL(NBCOL) = "[F:YPROD]YCODPROD" : TIT(NBCOL…

  • Quantity in Suspended transaction need to be cleared

    Hi,

    We have some quantity in Suspended transaction for a particular item, which occurred during a Shipment transaction due to the insufficient quantity. Later we received the same item using MISC Receipt, but the suspended quantity not updated, suppose…

  • 3rd party Webservice soap response

    I'm trying to make a call to a 3rd party webservice using Sage X3 scripts on the SDH window, i'm using the func ASYRWEBSER.EXEC_HTTP wich is working fine, it's calling the webservice and receiving the answer of the soap call.


    The Answer:

    <s…
  • Product Description disappeared

    In Sage X3, PU9, Common data Module>Products>Products(GESITM)

    whenever I create a new product or modify the existing product, the data in description 2 and description 3 disappeared. ironically, the previous data in the same field for certain products…

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

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

    Thanks,
    Shereef

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

    Thanks,

    Ta…

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

    <PARAM>
    <FLD…

  • Problème importation de x3 vers web scheduling

    Bonjour,
    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]}"

    voici…

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