Browse By Tags

  • Sage X3 GraphQL Connectivity

    As you may already know, starting Sage X3 2021 R2 (V12), a new integration pathway has been introduced; the mighty GraphQL. Invented by Facebook to used internally back in 2012, GraphQL has gained massive popularity for its lightweight query and response…
  • Web service call issue

    Hi All, I am trying to call the web service using the SOUP UI Application but it is giving me error in the screenshot attached. Can anyone please help to resolve it? Thanks SF
  • Adding existing assets to Sage X3 FA Module

    In the past we did not use the fixed asset module. I'm now moving our assets into Sage. First, we were told that we have to use accounting method "RE", where we now use straight line, in order to input the existing accumulated depreciation. Is that accurate…
  • Session Initialization w/.NET API

    I have the following code to create a session. Session s = new Session(); s.Init("", "XY", "XY1000", "67A"); s.Open(User, Password, Company, DateTime.Today, 0); A client had been using ADMIN/ADMIN for the username and password (don't ask why they…
  • Trying to read the products of Magento from X3 using rest api integration and Node JS Error

    Hi All, We are trying to read the product of Magento from Sage X3 using integration methods such as Rest webservices, Node.Js for one of our client. The Magento API endpoints uses 'OAUTH1' type of authorization for authentication of the Rest API requests…
  • Invalid or missing posting date encountered on Bill of Materials transaction update

    Hi, I've been working on automatic registration of transactions for Bill of materials. but I've been encoutering this issue for a couple of days now. its been throwing me an error that says "Invalid or missing posting date encountered" I opted…
  • BM ProductionRegister - New object error:200

    Hi, i've been constantly getting the error "System.Exception: <NewObject Error: 200>" when I register the BM production entries. here's what I have coded: oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI")) objTransactionRegister =…
  • SalesJournal SetShipDate The field you are trying to change or function you are calling is not accessible under current circumstance.

    Hello Friends, I am using SAGE 2019.1 SDK for importing invoice in my application. I am getting error at the time of SetShip date "The field you are trying to change or function you are calling is not accessible under current circumstance.". I am getting…
  • List folder content in native mode

    Hi We have tried listing folder contents using this two approaches without success. First approach used to work in classic mode. 1. Call SYSTEME2(adxmac(0),"LSADX"-FOLDER,"",FILCOUNT, FILLIST) From ORDSYS (error, 'Unexpected end of JSON input') …
  • There was a problem opening company.: (inner exception: FileNotFound)

    var companyId = GetCompany(); try { // Request authorization from Sage 50 for our third-party application. AuthorizationResult authorizationResult = Session.RequestAccess(companyId); This line Session.RequestAccess throws a PeachtreeException: FileNotFound…
  • #C and SDK issues

    FormerMember
    FormerMember
    Hi, A little background... We were asked by a client to create a.Net application to do a few things. The more effort we put in the less success we seem to be having. We are trying to create POs, Time records, and add Cost Codes to the DB. Reading…
  • update onhand on MasterStockItem

    Hi, Is there any way to update the onhand qyt in a MasterStockItem from the SDK?
  • SDK Performance is tooooo slow

    Hi, I have sage 50 accounting, the data are on a local server (within same network). We have no issue with the performance when using Sage 50 but when using the SDK it's really [:@]tooooooooooooo[:@] slow Listing companies takes 45 seconds! Finding…
  • Where payment terms are stored for the customer in Sage 50 CA Edition?

    I'm working on extracting data from the database sage 50 CA, but in the documentation containing the data definition , I have not found the relationship of the payment terms with customers, or where it is stored ( table). Here is the information that…
  • Exist the price levels in Sage 50 CA?

    I'm working on the integration of Sage 50 CA with a third party application with .NET. And price levels are within the required information extracted from the database Sage 50 CA, but so far I have not found any information to verify the existence of…
  • Where stored the data returned by the function wSDBFetchRecord ?

    I'm trying to extract data from tables in the database Sage 50 CA 2016, with a Visual Basic application that uses the SDK Sage 50 CA (Simply.ConnectionManagerService.dll). I'm using the function "wSDBSelectRecords" to extract the data And then I 'm…
  • How to capture the data returned wSDBSelectRecords in sage 50 2016 CA SDK with Visual Basic .NET?

    I´m using ConnectionManagerService.dll and I am using the function wSDBSelectRecords with this syntax: Call wSDBSelectRecords(iDBLink, iTBLink, "", 0, True) But I do not know how to capture the data you are going to select in a DataTable. I´m Working…
  • How do you keep from having to 'allow access' every time you run your app?

    I have an Application ID and I can start a new session and open our production company, but every time I (or anyone) runs this c# .net app it always says that I have to open Sage and allow access. I open Sage and select 'Always Allow' but we have to do…