Browse By Tags

I would like to integration third party system with Sage 100 Contractor using API to sync data between systems. Does Sage 100 Contractor have API?

We are running Sage 300 2020. Our finance team has been working with Excel files on a network share and then importing to Sage 300 GL transactions. We are in the process of decommissioning an old file server and moving their files to SharePoint Document…

Hi All, I am having an issue running PO_ReceiptRegister_upd. I am trying to run the Receipt of Goods Register from BOI. oSS.InvokeMethod("nSetDate", "P/O", date); oSS.InvokeMethod("nSetModule", "P/O"); //DispatchObject security = new DispatchObject…

HI All! We've put together a netcore API hosted on IIS for integrating with other tools we have. All of our services on the API are scoped to give the requests their own instances and dependencies. public static void AppServices(this IServiceCollection…

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…

Is there anyone that can help with providing an example of creating an AR Invoice with lines/details in C# using either BOI or the nuget package www.nuget.org/.../

We have a python (3.10) application that we want to use to create a sales order in Sage 100. I have installed pywin32 so the python script can access win32/COM. This code works up to the point where I try to call a method on the SY_Session object…

var sessionLogon = new SessionLogon { CompanyCode = companyCode, UserLogon = new NetworkCredential { UserName = userName, Password = password }, ModuleCode = ModuleNames.AccountsReceivable, ModuleDate = DateTime.Today }; using (var…

I am on Sage 100c Standard 2016 (Version 5.30.5.0) (yes, I know it is very old, and have plans to upgrade to a supported version). I am attempting to create a program in C# that creates a sales invoice from a sales order. When my program executes the…

I have a C# code that integrates with Sage 100 2021 Standard. After performing some action I want to clean and close the session I opened. for this I'm using: session.nCleanup(); session.DropObject(); for some reason the nCleanup() returns null…

Hello Group We are a custom software group. Recently we are getting inquiries to integrate our software with Sage X3 ERP. We are looking for the access and technical details to integrate receiving or sending data from/to Sage from our system. Where…

Is there a way to get a list of all the business object names for a table from the Sage 100 BOI? The SY_File object from the FileObj property on the session object seems to have methods to get a list of all the table names. Looking to expand on that where…

I have written an application to post general journals to SAGE 50 using data from a point of sale application. The program works fine on the server where the company files are located but when we moved the application to a workstation where the accounting…

Hi, I want to loop through all my not-registered invoices. What I do (in general) is: dynamic obj = pvx.NewObject("AP_ManualCheck_bus", oSession); obj.nMoveFirst(); //To get to the first record //Rest of code The problem is that I have…

How can I access the table object PO_ReceiptReturnMatRqByPO? I need to delete a record from this table which refers to a ghost receipt and locks my PO. There isn't a file with _bus or _svc, so using NewObject returns "NewObject Error 90". When I…

Hi all, I'm in need of some guidance and help as I'm stuck in my process of inserting an SO Invoice using SO_Invoice_Bus that includes non inventory (like misc or charges item) these items are in sales order with 0 quantity and need to be in the invoice…

Hi Everyone, I am working on one sage integration with python web application and I want to send data from python application and create customer in sage. I am using desktop version of sage. My question here is if the API https://cdn.na.sage.com/docs…

Hi folks, We have been searching for purchasing software that integrates with Sage 300 CRE for quite some time and it looks like Agora Systems may be a good fit for us. We don't currently use the purchasing module; we manually verify POs and enter everything…

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…

Hi, We are looking for consultant to help in installation of Sage API into our sage 100 2020. Please check below link for understanding: www.sagecity.com/.../getting-started-with-the-sage-100cloud-custom-connector-for-the-microsoft-power-…

I created a receipt of invoice, applied PO to it, changed some info- and in the end I called record.nWrite(); where record is the pvxDynamic representing PO_Receipt_bus. I know that after the write, I have a new receipt in Sage and it's valid …

Hi, I'm trying to write a code that gets all the invoices which were fully paid. My idea was to take all the invoice and remove all the open invoices from "AP_OpenInvoice". But, I see invoices in that tables that have 0 balance. So probsbly it doesn…

Hi, I'm trying to write a code to create a new invoice from PO set the key ReceiptType$ set the key ReceiptNo$ call setKey() set PurchaseOrderNo$ set InvoiceNo$ Now i want to add the lines of the po to the receipt. In addition, i want…

Good day I would like to know if it is possible to integrate Sage with Adobe Sign for e-sign in. I went on the Adobe page but there are no instructions for Sage. But I would like to know if is possible to do that And if it is, how well can one go about…

Hello All! I have an issue with creating a PO via BOI that I was hoping someone can help me with. We're using Sage 100cloud Premium 2019 Version 6.10.4.0. Here's my code: using (DispatchObject poObject = new DispatchObject(pvx.InvokeMethod("NewObject…