• Personal information DB federation X3

    Hello, Our Sage X3 instance is located in AWS Frankfurt. We will migrate our Australian Operating Company to Sage X3. However, we know about Australian data protection law. Can we host a personal information db in Australia and federated to the X3…
  • Balance Update column in Accounting Tasks

    We are seeing a value in the "Balance Update" column in Accounting Tasks and we can't get rid of it no matter how many times we run the resynchronization functions. When we try to run the "Account Balances resynchronization, we get this error which also…
  • Payment is not posted in PAYCUR

    Hello everyone, I have encountered an issue while processing payments in All > A/P - A/R accounting > Payment. Here are the details: Open Item: AMTCUR = 20,100 1st Payment: 6,030 2nd Payment: 10,050 Upon making the payments,…
  • Product is in stock with 0 quantity, location shows a quantity with no product

    Hi there. There seems to be a de-synchronization between the product and its location. The product shows null quantity in the location. The location shows a quantity (59) but a null product and is "empty" Misc. issue and receipt is also messed…
  • Seeking Guidance on Managing Permissions and Data Differentiation in Multiple Sage X3 Folders

    How can I manage multiple folders in Sage X3, where I need to add users, adjust permissions globally, but ensure that data (such as products and orders) remains distinct for each folder?
  • Desynchronized Lot Stock

    We recently performed a count session and came across some issues. One was trying to zero out product we no longer have. and we came across this error Anyone know how we can fix this?
  • work order # on production tracking does not match work order # on line

    We have encountered today a very strange issue have never seen. We created, completed 4 work orders- 3 of same product. The first one was fine. The second and third were completed however it appears the work order numbers are out of sync. Meaning the…
  • Synchronisation de plusieurs Dossier X3

    Bonjour Je travaille dans une société qui utilise plusieurs dossiers X3 pour ses filiales par type de filiale. Je recherche un outil me permettant de m'assurer que certaines tables restent identiques dans ces différents dossiers. Par exemple, j…
  • Multiple Folders pointing to single SQL database

    Hi I have a customer with a v12 installation with multiple folders (SEED, PILOT, X3). Every folder is somehow pointed to the PILOT data. I have checked SQL, and the normal SEED data is present,. If I add record in any folder, it is reflected in all…
  • Default Customer Contact checkbox location

    On the customer screen, there is a default contact checkbox. Which table is this stored on? I cannot find it on CONTACT or CONTACTCRM table. On V11, Patch 14
  • Does Sage X3 supports Invoice PDF?

    Hello Team, I want to start the syncing process for the Account Receivables invoices. But I cannot find information does Sage X3 allows syncing invoice PDFs?
  • Journal line descriptions not showing in inquiries and tables

    Hi everyone, In an attempt to increase the length of the description on the journal entry line, the data type on the table(GACCENTRYD) and screen was changed to "AMSG" from "DES". It worked for a long while until recently Account inquiry description…
  • sage x3 data management suite

    Hi At Sage Summit 2020 there was talk of the Sage x3 Data Management Suite being released. Does anyone have any information on Or experience with? thanks Stacey
  • Item Key Change with existing stock

    Helllo, I performed a key change on an item that had existing stock not realizing that key change does not affect stock. I have looked around in SQL and still see the old item code in STOCK, Neither code in ITMCOST, both codes in ITMMVT, and the new…
  • Can not close work order: Table : MFGITM [MFI] No current records

    I try to close work order with function WO Close (FUNMCLOSE), but receive error: Table : MFGITM [MFI] Key : XXX No current records Checked MFGITM table against this Work order - all seems ok. Any ideas how to solve it? Thank you in advance!
  • Sage X3, problème de validation de table

    Bonjour, J'ai ce message d'erreur lors de validation d'une table (j'ai ajouté 2 colonnes). Merci d'avance pour vos réponses.
  • Records in STOWIPW Table

    My understanding is that STOWIPW table shows the users who are in the process of selecting stock. And when we runs "Quantities entered resync" (FUNSTOWIPW), the system will check STOWIPW records and correct the CUMWIPQTY and CUMWIPQTYA fields on the STOCK…
  • SQL Server Error @X3.TRT/BATCHCPT$adx 312 [Microsoft][SQL Server Native Client 11.0]Shared Memory Provider: No process is on the other end of the pipe

    Hi All, I am attaching the error screenshot, I am facing during the 'Accounting tasks' and can't proceed with activating it. Please need urgent assistance. Thanks
  • Remove Quantity from CUMWIPQTY column on stock table

    A stock movement ran into an error and it made the quantity stuck in the CUMWIPQTY column. How do I get the product to be released from this column?
  • X3 CRM

    Hi, Is there a way to synchronize X3 crm Task and Appointments with Google Calendar? Thanks
  • Photos for ldap users

    can anyone help with info on setting up photos to sync from LDAP active directory. i have the ldap sync set up for user auth and provisioning but i haven't used the photo field of the mapping. I just tried putting "thumbnailPhoto" in that field since…
  • Call WS

    Hi! I'm trying to call an web service using Visual Basic in a spreadsheet but it returns me an error: xsi:type="xsd:int">0</traceRequestSize></technicalInfos></runReturn></wss:runResponse><multiRef id="id0" soapenc:root="0" soapenv:encodingStyle=…
  • Controlling no.of incoming connections in mongodb

    [conn91798] SocketException handling request, closing client connection: 9001 socket exception [SEND_ERROR] server [x.x.x.x:39903]
  • Live database sync to test database for daily testing and trainings

    I am looking for solutions to copy our sage x3 production folder either nightly or live sync to another folder in the database. This backup/synced database should be accessible through sage as well for testing, always with up to date information (nightly…
  • REST API - Cannot set query visibility of certain fields in the SORDER representation

    FormerMember
    FormerMember
    Hi all, I'm integrating with EM via the REST API and trying to get more information to show for SORDERs when using the query representation. Most fields are fine, but when trying to set the Query visibility of any totals (Gross, Net Price etc.) it doesn…