• Encounter error when running Stock Accounting Interface

    Upon running the Stock Accounting Interface interface, I consistently encounter the following error: SOOCKSE22006354 Nonexistent dimension value (STKIS Line 3) Miscellaneous issue VCRNUM=MIOCKSE23003691 Upon thorough investigation, it has come to my…
  • Sage X3 - Consistency Errorrs

    We currently run Sage X3- multiple Versions including V12. SQL Server 2019 and X3 running on the same machine SQL database Collation is Latin1_General_BIN VMWARE 7.0.3n Starwind vSAN Two servers for failover We have noticed that we are getting…
  • Sage X3 - Stock Accounting Task

    Hi Sage X3 V 12 pu 24 Patch. We have recently had a SQL corruption that was repaired on the client. Long story short restoring to a valid backup was not an option. Not ideal and measures have been taken to avoid this in the future. The SQL is…
  • delete product site

    I want to delete product-site records that they do not have transactions in that site. when I use transaction mass update, it dose not check it has transaction or not and delete it directly and it is wrong because I want to delete the same record from…
  • Recovering deleted records

    Case: I have a client who have accidentally deleted some records. The client forgot where it is deleted but the client knows around a period only today. No audit on delete has been set (it was a freshly created folder and masterdata was imported…
  • cannot access sales invoice- division by zero

    I cannot seem to go into the sales invoice function as receive the below error. I believe I know which invoice is causing the issue however when compare the fields to other invoices all looks fine. I do not see a RAT1 field in the table yet it is displayed…
  • Receipt picks up wrong currency exchange rate

    Hi everyone, We found a number of Receipts randomly pick up the wrong currency exchange rate (from Receipt currency to the respective reporting company currency) whereas the respective PO still has correct exchange rate. FYI, the exchange rate is…
  • Application Error 76 - Sales > Deliveries

    I am new to sage and am stuck on how to resolve this issue. From what I am gathering this is related to a table error in the SQL database. I am green when it comes to both Sage and SQL. Any thoughts or ideas on how to resolve this? Thanks in advance…
  • Error message when updating addresses on the Customer Master.

    We just upgraded to version 12 and when Accounting tries to update an address on an existing Customer, we receive the message. Address validation has failed. Connection error: sstValidateAddr: 500 I have checked to make sure that the address is valid…
  • SEED Language Australia

    Just a quick one, we are using a vm supplied by Sage, and we have upgraded SEED to V12 p21. If I login in as Australia and user EMAU, on any of the screens I have lots of language issues eg If I use United states as a Language it is all good but…
  • null PORDERP record

    I am curious if anyone else has experienced the PORDERP record not being displayed and the screen not showing any information on the PO line. This is the second occurrence and I am stumped how this happened. We have an import tracking customization…
  • Non existing file adxora error

    Hi, I have a problem with one of the folders on my solution - I receive an error message when I try to open any function: Thank you in advance for any clue where I should looking for a cause of this problem.
  • stock change error

    what does this error message? What is 107266 referencing?
  • How Can I find deleted POs? Maybe SQL?What would the script be?

    Can someone advise if it is possible to find deleted POs? We are missing some documents that we know exist but cannot be found. It is possible that they might have been deleted by the users. Can we run a script in SQL manager?
  • Deleting Pick Ticket not cleaning up STOPRELISW

    X3 PU 9.0.5 1. We do not allocate stock to sales orders. 2. We generate a preparation list, which created a pick ticket with a global allocation. 3. If we delete a pick ticket, allocations are normally cleared up with no problems. However, we…
  • Conversion failed from nvarchar to int while deleting

    Hey guys, I've encounter problem during deleting record in my custom table. My index datatype is an Alphanumeric. But when I'm trying to delete the record, if the index contains alphabetical, I will get an error saying : [Microsoft][SQL Server Native…
  • Disaster Recovery

    Is there any documentation outlining what needs to be backed up for Disaster Recovery? SQL backups are done, but what happens if the server is lost? What steps can one follow to recover a system having only the SQL backups?
  • MFGITMTRK Date and Time Difference

    Good morning. I was looking at our MFGITMTRK table and I noticed a lot of differences between the CREDAT_0 field compared to the CREDATTIM_0 field and the UPDDAT_0 field compared to the UPDDATTIM_0 field. CREDAT_0 CREDATTIM_0 UPDDAT_0 UPDDATTIM_0 …
  • Unable to download the attachment

    Hi We have attach the document to Quotation but when we try to download it's fails "ERROR : File does not exists) Attach file to Quote 1. Open Quote 2. Click Attachment and Attach document (e.g Pdf) 3. ok to save Print/download file from…
  • Database Recovered, Application server cannot connect. 'The data base is not started' error message in Sage X3 V1 Management Console

    We had to recover the database tonight, and it all checks out, but now the Application server cannot connect to it and I cannot figure out why.