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

  • 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…
  • Batch Server constant result 406 and consuming 100% CPU

    Hi,

    Sage X3 v12p25. All Sage X3 components match v12p25 specification.

    Sage X3's syracuse took over the whole CPU cores with this error repeating with multiple entries consistently. I have no idea on the case of what causing it to happen. This has…

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

  • SUBSCS - Inter-site transfers - CWSIS

    Hello

    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…

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

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

  • Planner One notice: Your desktop is being initialized. Please wait until this action is complete.

    Hi all,

    While using planner one on SageX3 V12,

    our site is initialized and planner one opens perfectly, but after any WO is submitted we get this notice (making it unable to proceed)



    Did any of you guys face such an issue?

    TIA

  • Completed Calls GESCLL

    Hi,

    In the GESCLL call function, we noticed that when marking the check-box as Completed, the call remains with the editable fields, thus allowing changes to the form. Is this behavior correct?
  • 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…

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

    Hello,

    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

    Hi,

    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…