Sage X3

Hi, In 4GL, I know for silent import, there is IMPORTSIL (From GIMPOBJ). How about, in 4GL, the silent export function with filter option? I know I can do a manual file write inside the 4GL script but it is very annoying to maintain. Web service…

Greetings! We are a while off from having MRP up and running and even with that I believe I will still have to consolidate lines. We are a low volume high mix manufacturer so it is more common that I am making 16 different widgets from 1 material and…

Hi, We are trying to use Sage X3 to generate BPAY files. We have set up as follows Below you can see the output file we receive and the bank rejects it because of the spaces at the end. If the user manual removes the yellow highlighted spaces…

I am getting the attached error when trying to import fixed assets in Sage X3. The error message says "Error in the writing of the flow" Using the FAS import template.

Hello, We have a current inventory process that requires pulling and Excel exporting a full stock list by site (using the CONSSAR function - stock by product - entering a site and leaving the From/To Product fields blank). Once that list is pulled, we…

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?

Hi, We have upgraded to V12 recently (from V11). When we now export any inquiry to Excel, the leading zeros are missed. Example: G/L account no 00270 is exported to Exel as 270. When we did the same in V11, the account number in Excel was formatted…

Use Sales Delivery as example: I want to click new, fill in the site and customer Then import the detail information like product etc from a file Upon completion create the transaction. Possible?

We have just switched to V12. I am wanting to export information from various pages. Is there a way to personalise an export spreadsheet to suit my requirements? Some of the information I require is: Product SKU Product Description Pack …

Hi, h ow can I make the equivalent Del *.* or Del *.txt command execute with the DelFile statement? It seems that it only accepts paths with precise filename indications, such as [xxx]/abc/123.txt and instead [xxx]/abc/*.txt fails. Roberto

We are trying to import standard costs for many sub assembly and manufactured finished goods, to a non manufacturing site. We have in the past, calculated the new standard costs at year end through normal functionality on the manufacturing site, and then…

Hi, Found a situation here: When I observed the Console import, it can import fine. It clears 1.1k tables import like a champ with 100% clear When it comes to Console validation, the tables are hit with warnings. ``` <0001 Erreur en…

Has anyone managed to import values to do a value change of stock?

Hy everyone, I'm having this kind of issue that makes me struggle for some days I've created an import model and a data source for it (.txt) The "file.txt" is bringing an error on purpose, and my goal would be to catch the error When I'm reading…

Hi team, I need some assistance in resolving the unbalanced journal error I am getting when importing a file from Pastel. The import path am using is: More> Usage> Import> Table structuring/ Import. In the other post I saw that this might be related…

I am having problem while import using BIS import template, there is error on DUDDAT field. But when using import simulation, DUDDAT can get the value from my import file. Is anyone facing this problem or anyone can advise me on this? The attachment below…

Hi, I need advice and pointers to identify the root cause of the import failure issue. Sage X3: v12 Patch 31 (latest patch by time of writing) Database: SQL Server 2019 Standard All components are updated to match Sage X3 v12p31 requirements. On…

We are working with AvidXchange to import payables into X3 and have run into an issue. We are using he standard import process to upload .csv files exported from their system, however Credit Memos are being created by Avid with a negative value. X3 is…

Hi. Sage X3: v12 Patch 30 Console version: CFG 2.54.0.5 SQL Server: 2019 Standard When I import a relatively small folder (about 20 GB). ``` Storage is not online Database filegroups check failed Error while creating database schema…

When entering the UPC code against a product in Sage X3, there is check to ensure that the UPC code is unique. When importing products this check appears to be bypassed, so it is possible to import multiple products with the same UPC code. Has anyone…

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…

Hi, I Would like to know, if this behavior on the Query tool(GESALH), has another way to export all the records to see in excel (NOT CSV). Nowadays behavior, when you export is possible to see 9999 lines, but we need all the records that were made…

hi everyone i have been created a custom head/detail tables and the object, windows,screen,funtion, and it work good. head table:ZPACKH, detail table:ZPACKD ZPARKH -> index: ZPKID + FCY ZPACKD -> index:ZPKID+VCRLIN i can creation / update /…

I am searching for Customer Returns Import Template. Sage X3 v9 does not have any default template to import customer returned stock . If anyone has any idea/suggestion then please share, Thanks & Regards

Hello, I just started at a company using X3. So I am still getting familiar with it. One of the projects we are wanting to complete is being able to export a BOM out of Revit and import it into X3. My first question would be, has anyone here done anything…