Sage X3

I want to mass update all the existing products with their respective locations. However, when I am trying to export default locations along with the types, i don't know how to export multiple types. Upon exporting only receipt is getting exported. See…

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…

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…

Hi All, I am trying to export data of supplier using xml in Http Request in .Net with direct credentials not SSO One On calling the below xml i am getting response of Cannot read property 'GRP' of undefined Can anyone kindly guide how to get…

We're working on a remittance import template for our client and are looking for a way to link the PAYFRM and PAYMENTH tables. Currently when adding FRMNUM to the link column, we encounter a warning stating that the link does not appear coherent. The…

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…

Hi Have any Business Partners in Australia been able to successfully setup and import using the Advanced Bank Statement Import function in V12. I can not seem to get any assistance on this as Sage mainly deal with the MT940 files. Do clients actually…

I am trying to import/export BPs from one endpoint to another. However, when I import the file the BP numbers are chronologically assigned instead of keeping the same BP numbers from the exported file. Where do I go to adjust this?

I am looking to join the two above tables, According to the data models, the join is supposed to happen like this: 1;ACCCOD. How is that supposed to work if STOJOU doesn't have any accounting code? Also what does the 1 mean in the data model? Any and…

Hi, as the subject says, I am building a report to pull sales numbers per company by GLCode in sql server. I'm having a hard time getting data that looks correct. I have tried a few different ways of joining SORDER table to GACCOUNT table. I've tried…

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

As seen above, I am looking for received/delivered qty from a Purchase Order. Is it the Received STK or PUR in the PORDERQ table? so far I have been using received stk, but am unsure if that is correct

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…

Hi everyone, I'm looking for the description of this field: Table - FXDASSETS field ACGGRP_0 Example: ACGGRP_0 CM The description must be similar, but I have not been found a table yet with this description, please someone has an…

Has anyone had to create a new V11 (or really any version) application server and connect it to an existing SQL Database server? Assume we don't have access to the old app server (although we might). I have some ideas, but I'd like to know how others…

You can manage Employees at: Common Data > Manufacturing tables > Employees But I can't find the corresponding table. Does anybody know what's the table name?

Hello, I'm trying to build an import template that allows me to create ITMMASTER and ITMFACILIT records at the same time. These are the fields I have listed below. When I attempt to import based on this template, the Product in ITMMASTER is created…

I was able to update BOMD with a line detail thru Usage>Import and the report indicated that the record was modified. However, the Production BOM detail was not updated even though the properties showing that the record was modified?

What table stores these values? It's the status on a work order header.

Hi guys, I need help! My client wants me to achieve an automatic backup from her Production server to a Data recovery Server on a daily basis Please how can this be achieved? Hoping to get a positive response Thanks

Is there a definitive list for what is considered a special character?

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

We have been investigating an odd issue at a customer site where we are unable to upload files as attachments or if we are doing an import. When doing the import, we select client & attempt to select the file and receive the message: file not found…

I am looking to see if anyone is running X3 on Oracle 19c. If so, were there any caveats to this? For example, did database compatibility settings come into play?

Hi everyone someone has successfully installed the latest V12 update ( V12.0.21 - 2020 R1) with SQL SERVER 2014 (not R2) I receive this message while configuring the database by the console any help please