• Importation of SEED FOLDER Failed

    Hello please should be informed that when i tried to import SEED Folder to console management all steps pass OK unless the last step it give error the impacted envirenement WIndows 2019 server SQL SERVER 2014 SAGE X3 V11 can you help plea…
  • Field BPAPAY: Nonexistent address

    hi, I am importing a file from another system into X3 and getting an error as in subject line and screenshot below. I checked the template configurations in Setup and go into BPAPAY line and couldnt find anything really to change so I have not clue…
  • X3 Console, folder import: Error while running _lstfilseq{folder}.bat in folder to import : NOK (LibAdm.GenScriptsImportFolderNT) The system cannot find the file specified.

    For example, if folder name is: PRD. ``` X3 Console, folder import: Error while running _lstfilseqprd.bat in folder to import : NOK (LibAdm.GenScriptsImportFolderNT) The system cannot find the file specified. ``` Cause: One of the required sequence…
  • [X3v12-4GL] How to run silent Export from an Export template in 4GL only?

    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…
  • Is it possible to import multiple lines on a work order import?

    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…
  • BPAY CSV import file - remove spaces created by length column in bank file definition setup from a string

    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…
  • Fixed asset import error - Error in the writing of the flow

    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.
  • Table Beginning / End message when exporting stock list

    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…
  • Import/Export - BP Numbers

    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?
  • Re-Execute Script Parameters

    Hi Guys, We have added a new environment in SEI and need to re-run the template scripts and would like to confirm what the parameters should be for the following screen: Normally when you import templates, you get to map the X3 and BI endpoints…
  • Export of certain fields to Excel formatted as text

    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…
  • Import data in a table of a transaction while having the transaction open

    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?
  • Sage V12 Exporting Information from Various Pages

    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 …
  • SAFE X3 - DelFile comand

    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
  • Import Standard Costs for Assembled Items into a Storage Only Site (Non Manufacturing Site)

    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…
  • X3 engine error: DBIDENT3 : decla_mbr(OBJECT):File does not exist in the archive!(2) <empty stack>

    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…
  • Import Inventory Value Change values to revalue stock

    Has anyone managed to import values to do a value change of stock?
  • IMPORTSIL()

    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…
  • Unbalanced journal legal (99) when Importing a file

    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…
  • Having error while using BIS import template to import file

    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…
  • BIS import/export template from Sage passed on SEED but failed on Production

    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…
  • AvidXchange Payables Import

    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…
  • [X3 v12p30] Cannot import a Sage X3 folder due to console error about SQL Server but space provided is ample.

    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…
  • Sage Data Migration Tool (DMT) is available now for partners and customers

    The Sage Data Migration Tool (DMT) is designed to help streamline the import process, delivering a 50% to 60% improvement over standard import methods, reducing errors and saving time when importing into Sage X3. Sage DMT improves and simplifies the…
  • Product import not checking that UPC code is unique

    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…