Sage X3

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…

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…

I installed the new version of web scheduling, when importing the data I have the following error msg: "TOTAL IMPORT ENDED WITH ERRORS; PLEASE CHECK INTERFACE LOG FILE ENTITY: ERROR: La conversion d'un type de données nvarchar en type de données datetime…

I am trying to use the SCS object as a web service to do a stock status change. Has anybody had any luck with this? It accepts the XML with no errors, but it doesn't do the updates. I am trying to move stock from a status of "Q" to "A".

I am looking to get the sql column name for total requirements qty located in available stock. If anyone could point me in the right direction, it would be greatly appreciated.

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 in the subject, I am looking to join the STOJOU table to the SINVOICED table without the use of the ITMREF column. Data models show a one way arrow from STOJOU to SINVOICED with VCRNUM;VCRLIN. I am unsure of what to do with that, with VCRNUM only…

Hi there, I have made 3 different upgrades from Mongodb 3.4 to 4.2 and now when I restart Windows, the mongodb service doesn't autostart. I have to start it manually. The update path was the following: Mongodb 3.4 -> 3.6 Mongodb 3.6 -> 4.0 …

I want to save data from sage to my sql database, the problem is in soap i get a group structure. example: "ITM0_1": { "TCLCOD": "ASSET", "ZTCLCOD": "Invest", "ITMSTA": "1", "ITMSTA_LBL": "Actif", "ITMREF": "ASS001", "DES1AXX": "Serveur informatique"…

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…

Hi everyone, If I were to extract supplier master data for active suppliers including addresses etc. which tables should I export the data from? We use Sage X3 v7. Thanks, Matt K

October 25th, 2020 Hello Teams, Need your help. :) BPSUPPLIER-->CONTACT-->CONTACTCRM Where to find the field KCNTFLG - which is the Default Contact Flag in the MSSQL x3 database tables. Goal - I am looking for where the CNTFLG field is stored…

Hello Im working on importing Expenses but i get this error although i did make sure of the account nature in account function Can you help me please

Sage X3 ERP v7 Patch 8 I'm trying to figure out how to import Journal Entries to alleviate the time spent by our Accounting Dept. I know the data I'm inputting is accurate because I'm just re-importing data exported from the Production server (excluding…

Hi All, I am moving the SQL database from C: drive to D: drive for existing client (Installed and configured Console 2 yrs back) because the C: drive was fully occupied. If I move the SQL database, do I need to change the path on the Safe X3 management…

Hello All! I have some code that imports a text file to generate an inter-site purchase order. I am getting an error for every line that is "Inter-site: No product-site found, for the possible receipt sites!". When I import the file through the Usage…

HI guys, i'm new in this forum and i'm also a beginner in SAGE. A Client ask me to link X3 manufacture module with a your MES software. I think to operate in this mode: Use an Import Schedulate process. Make a frontier table. Create a file from…

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

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…

Hello, I would like to draw links between tables (automatically). But I didn't find any foreign key in INFORMATION_SCHEMA.TABLE_CONSTRAINTS. I checked other tables without success. Could you please help me? Best regards, Nicolas

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?

Is the online help data model correct for V12? The files show v6.....

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…