Browse By Tags

  • How to import and export data from Sage 50 using PowerShell?

    Hello, I need some help with importing and exporting data from Sage 50 using PowerShell. I received an email from a service consultant from Sage that contained a PowerShell script that runs an import or export state with a command line launch. The script…

  • File \\xxx\share\Sage\SAGEX3\runtime\ebin\MsOdbcSql.install.ps1 cannot be loaded. The file is not digitally signed.

    Hi, Sage X3 v12p33, runtime installation. Windows Server OS only. In an Active Directory. I have a shared drive and using UNC Path. Installation on C:\ OS drive was not possible at the moment due to management decision. When running the Runtime…

  • X3V12 Patch 12.0.32 PowerShell inclusion

    With the inclusion of Powershell 7 from higher X3V12 Patch Levels it introduces Powershell modules which is required to communicate with the X3 Database Server in-order to populate the X3 Tables inside the Database. This introduces in some cases some…

  • ALERT: SQL Server PowerShell module

    Do not use SQL Server module version 22.x with Sage X3 until further notice. Use SQL Server 21.1.18256 only. PowerShell 7.2+ is a prerequisite for Sage X3 and the SQL Server module for PowerShell. SQL Server module version 22.0.59 has been…
  • Installing SQL Server PowerShell module when offline (.nupkg)

    Installing SQL Server PowerShell module when offline (.nupkg)

    With Sage X3 2022 R4, a new prerequisite was introduced for the Sage X3 console, the requirement to install PowerShell v7.2+ and, subsequently, the SqlServer module for PowerShell that allows database scripts to be executed when configuring the application…

  • ALERTA: Módulo Powershell de SQL Server

    Alerta importante: No utilice el módulo SQL Server versión 22.x con Sage X3 hasta nuevo aviso. Utilice SQL Server 21.1.18256 PowerShell 7.2+ es un requisito previo para Sage X3, junto con el módulo SQL Server para PowerShell. La versión 22.0.59…

  • Error al actualizar Runtime > 95.2.85 “The certificate chain was issued by an authority that is not trusted”

    Si en el servidor se ha actualizado el módulo SQL Server de Powershell a la version 22 o se ha instalado esta versión directamente, al actualizar el Runtime, o al realizar una primera instalación obtendrá un error similar al de la segunda imagen. …
  • 2022R4 introduces support for Azure Elastic Pool Database - installation requires PowerShell 7.2

    2022R4 introduces support for Azure Elastic Pool Database - installation requires PowerShell 7.2

    One of the New Features introduced in 2022R4 is its support for Azure Elastic Pool Database. This has necessitated the installation and configuration of Powershell 7.2 during the Console configuration process. This change means that all the Components…

  • SO SalesJournal Update via BOI - retVal = 0 in nSelectBatch

    Experts, I am working on a script that modifies the comment on a batch, sets it to private, and eventually attempts to post batches. I am getting the following error message when attempting to do the nSelectBatch on the SO_SalesJournal_upd object: …

  • Accessing Sage 300 ODBC via powershell [Sage][SQLEngine] (31830) Username and password is required.

    I am trying to establish a ODBC connection to Sage 300 using Powershell ODBC. I am getting below error. I have tried using the same username and password for importing via ODBC in MS Access and it works. What am I missing? Exception calling "Open…

  • Create Purchase Order Invoice via BOI

    Experts, I am able to create Sales Order, Sales Order Invoices, and AP Invoices via BOI without any issues. I am missing something about the order of things for PO Receipt of Invoice. Here is an excerpt of my code (it's in Powershell, but the methods…

  • Get to Lines object in PowerShell

    Hi Experts, I am working on a data import into Sage 100 in PowerShell through BOI. It works fine. The one problem I have is to get to Lines Objects. In VBScript i used the following line to get a handle for the oLines object: Set oLines = oSession…
  • How to check if a port is open from a local machine

    How to check if a port is open from a local machine

    Have you ever run into connection issues with X3 and needed a quick way to check if the proper ports were open on the server without getting access to the server? Well today is your lucky day! In this post, we will take a quick look at two different options…

  • BOI in Microsoft PowerShell

    I am trying to use PowerShell instead of VBScript to access Sage via BOI. I am able to login, set the company, set the module and get a handle to the table I want. But I am not able to retrieve values when looping through the table. I tried multiple variations…

  • Geting The Last Run Date For Your Reports

    A customer running version 6 recently requested the ability to retrieve the last execution date of all reports run within Sage ERP X3 as they wanted to deactivate reports that had not been run in a while. They were seeking to ensure only business critical…

*Community Hub is the new name for Sage City