Sage 100

Has anyone done any integrations or been asked to do any integrations with Bill.com? I have had several inquiries as the Bill.com site has the Sage logo, but the integration they offer is for Intacct, not Sage 100 ERP. I have mapped it out to be able…

Good Day, I hope this message finds you well. I am currently facing an issue with a control I've created in MS Access that interacts with Sage100 (Standard 2020 v6.20.4). I'm reaching out to seek your assistance in resolving this matter. The control…

Hi all, We've been using Starship for years but in the last week have experienced major delays and performance problems EXCLUSIVELY with their integration (meaning other 3rd parties like ScanForce, Avalara, Paya, TrueCommerce, Insynch, etc.... are performing…

We're currently using the Sage100 C# NuGet package noted below. We've run into a situation whereby a miscellaneous item (CI_Item) is visible in the UI and via OBDC connection however, we're unable to find the item using the MASRecordset utilities…

Hi, We are using SAGE 100 2018 Version for the last 5 years. We would like to integrate the following records from SAGE to Odoo using API. Can anyone let me know, whether integration is possible for this records. 1. Customer 2. Work order …

I am writing an API in C#.net, that POSTs sales order entries to Sage 100, using BOI. I am using much of the same code that I've used for other integration projects with success. The client for this project is upgrading to Sage 100 2022 Premium- and testing…

Hello, We just recently upgraded to Sage 2018 to 2021 and our third-party web service(Deposco) sale order imports are now having issues after migration. Error response: FAILED : Exception: Error trying to set property BillToZipCode$ with value 46550…

I am new to this so please bear with me. I have the following script ( i can only post a portion of the code. The SPAM blocker flagged it as malicious) that is used to update two UDF fields from a .csv file. It is called via a custom application. I am…

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…

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…

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…

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…

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…

Looking for a Microsoft Power App expert who can develop a power app application that will fetch data from the SQL database in bulk and then send that data to Sage 100 ERP via Sage 100 API connector which is already installed. Data to be picked and sent…

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…

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…

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…

We have a Sage 100 client who is looking at Concur Expense Management. Has anybody integrated this with Sage 100? How did you do it? What were the difficulties? I'm looking for thoughts and/or recommendations. Thanks.

is there any way by which we can achieve integration between ACT! and Sage 100?

Hello, I have taken over an existing installation that does not have any documentation or support on it. Our website uses a custom sync tool to push orders into Sage. Everyone once in awhile (10% of orders or so), I will see an error, "The column is not…

My apologies if I'm not in the correct forum for this. (It seemed to match the best from the list I was presented with.) I'm looking for documentation on building modules to run from the Sage 100 desktop. I've taken a number of the courses (including…