• Delete/insert lines with SOAP web service

    Hi, I don't understand how to set up the parameters to insert and delete lines via web service; actually, I can't find much on those parameters in general (their definition, when should I use which, etc). A simple example would do the job as well, I…
  • macOS / M1 / aarch64 / arm64/ Plugin Eclipse Sage X3

    Hi Everyone, Anyone had success running Eclipse arm64 binary version on Mac M1 I got the latest stable build of Eclipse for arm64 : eclipse-SDK-4.24M1-macosx-cocoa-aarch64.dmg Runs fine Was able to install the Eclipse plugin However. Connecting…
  • PO's payment date

    Is there a way to obtain the PO's payment date before the invoice has been created? I'm looking to pull the payment date onto an open PO report for analysis but it seems the only way is after the invoice has been created and the GACCDUDATE record created…
  • Deleting Products

    Hello community, We're having an issue deleting products. Made sure to delete the associated Route and BOM, but receiving the below error. I also went to the product cost the error is referring to but did not see anywhere that would be linked. Does…
  • Hash SHA256

    Hello, I'm writing a script to get results from a REST API. To run this script, i have to put a header that is encrypted in sha256 Is there any method implemented in SageX3 to hash my content in sha256? Thanks
  • Where do we submit issues with the field help?

    I am a huge fan of using X3's Field Help and Function Help. It doesn't always have the answer I need, but has proven very useful over the years. However, I'm sick of finding various help articles that haven't been updated. I went to all those Sage Summits…
  • Purge zero lots

    I plan to use function Zero lots (FUNSTPL). I run the function in simulation mode and compared the generated log file with entries in STOCK table. There were some entries that are still in stock. How the function actually works? It is described -…
  • online sharing of documents in X3

    Is there any function within X3 enabling online document sharing? I would like to share an excel file with other users somewhere in X3 and have online edition for everyone. Same as in Sharepoint. Have anyone an idea how to do it?
  • Eclipse - Connection Issue

    Hi, I got an update on my Eclipse installation to the last version 2021-06. Since that, i cannot connect to any X3 folder. I get the this error : I don't know if it's Eclipse related or X3 plugin Can you look at it? Thank you
  • RFQ Responses - X3

    Good Afternoon, I am wondering if there is someone well versed in the RFQ module of X3; specifically in regards to responses? My question is...am I missing a secret way to enter more than one response at time and one vendor at a time? Seems to me…
  • SQL Query Tool

    Where's a good resource to learn more about this? I used SQL years ago but curious about the specifics for the X3 tool.
  • Batch server difference between U9 and V11/V12

    Hello, I'm curious to know what is the main reason to change the batch server from the application server to the syracuse server level. Any idea about the advantage or the improvement reason behind this major modification ? Can we always check by…
  • Anyone have any tips or tricks on writing SQL views for x3?

    Trying to create a view using the GAUTRCVCR table to pull the details from the tracking records on journal entries. One of the keys is the product ID number.
  • Error 20 File Non-existent when purging trace files

    Hi everyone, I met the below error when trying to purge trace files (ATRACE). Error 20 File Non-existent Error [email protected]/eputra$adx Line number 33 Could you please advise me how to fix it? Thanks !
  • Eclipse error during "attach to process" operation

    Hi, I've a problem with the configuration of Eclipse, to debug Sage X3 programs. I downloaded Eclipse Indigo, as suggested by the support center. I set up both Eclipse and Sage user for connect the IDE with the client. I chose the port 10000, and…
  • Reference in Pharma or Cosmetics sector

    Hi, For our customer who is considering the implementation of the production module, I`m looking for a reference in the Pharmaceutical or Cosmetic sector. The best would be an official reference. The customer must have implemented the Distribution…
  • Deferred Deletion - Removing some deletion requests

    Hi all, I want to remove permanently certain deletion requests from the deletion queue (Navigate: Development—->Utilities—->Miscellaneous—->Deletions) because those were made by users by mistake. I tried deleting a request then clicked Close page…
  • Conditional Style in Delivery Grid

    I am trying to get certain fields to change colors when the quantity being shipped is less than the quantity ordered. I am comparing screen values to SO values. It doesn't link the delivery line back to the proper SO line, so my formula only works on…
  • Value change for bulk products

    Dear Sagians, We have 2000+ products to change the cost. We need to change the cost only without changing the quantity. Sage have the option for this using Value change under stock module. But this has to run one by one. Is there any way to do this…
  • MRP parameters help please ?

    Hello everyone I need a small assistance please I want MRP to consider the first 4 months as firm sales orders and ignore forecasts in those months and then consider forecasts for month 5 onwards . What I noticed is that the MRP did not consider the…
  • Recontrol Status Change- PU11

    Hi, I have setup Recontrol status of the Product. I have created a site and also location authorizing (A,Q, R). When I run the Recontrol Status Change, its returning an error. " The current location is not authorized for the new stock status". Any idea…
  • How to export and import X3 Syracuse Setup like Roles, Groups and Global users, Teams etc.

    I was trying to do a coverage installation of P21 to upgrade from P16, I did it with my demo environment and kept the snapshot of P16 in my VM. After installed all components and validated the SEED Folder, it ran all right except one thing, ALL MY Syracuse…
  • I am trying to create Fixed asset, following error occurred

    I am trying to create Fixed asset, following error occurred. help required. Fixed Assets>Fixed Assets> in the field Accounting code>ITEQP ITEQP The Co. fixed asset account associated with the accounting code is invalid or its nature is incorrect
  • Is it possible to use chinese named attachements ?

    Hello, We have chinese named attachments but we can't use it. If we try to drag and drop or select it inside the folder browser, the attachment widow close. If we put it inside a folder like sage's temp folder and try to select it with the SageX3 browser…
  • Sage X3 Badge Usage

    In a situation where a client has multiple users in the system using different badges is there an inquiry screen or table where I can get a list of users and which badge they are using? If a user is logged on twice need to know that they are using more…