Sage 100

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…

I have the following code working properly to post AR Invoices. var homePath = @"C:\Sage\Sage 100\MAS90\Home"; var userName = "test"; var password = "test" var companyCode = "test"; var sessionLogon = new SessionLogon { CompanyCode = companyCode, UserLogon…

Hey all, As I've been learning how to implement BOI within a C# project I was really bothered by the amount of code reuse in my project surrounding instantiating the main BOI connections. This led me to refactor out that common code into a helper class…

Hi all, I am working on the JobCost Maintainance module using BOI, Can you please anyone let me know what object I need to initiate for this?? Thank you in advance !! Thanks SF

I am trying to duplicate the following UI process using the BOI: 1) Create RMA Receipt (header/details) for an Invoice. (Note that the procedure for us is to skip creating the RMA return in the UI.) 2) Distribute RMA lines. 3) Generate Transactions…

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…

When attempting to create line items for a Inventory Transaction Receipt batch I'm having issues when I attempt to update the distribution. my code was working on Sage 2018 but they are upgrading to Sage 2021 and it now throws an System.Runtime.InteropServices…

I'm using the identical code to nSetValue R/W fields that has worked for years, but I am finding that it fails for some tables even though they show a R/W Business Object. I am modifying a non-key field in GL_DetailPosting, but I cannot get past the nSetKeyValue…

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/.../

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

Attempting to pull data into Excel from a UDT. Raw data will pull, but, when I try to edit Query, receive "Expression.Error: The key didn't match any rows in the table." in Power Query. See screen shot : Any Thoughts? I have used "syzcon" running…

Hi I am looking for a script to update "Daily Sales Report/Updates" in sales order (sage100 v2021). Could anyone suggest me what script i can use in BOI suing c# or VB?

We are looking at a Third-Party software called Master Control for our QA/QC documentation processing. With that, we want to be able to extract data out of Sage 100c Advanced v2019.2 (upgrading to v2021 shortly) from Scanco's Manufacturing module, as…

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'm working on an integration for a client and am trying to create PO Receipts using c# and Sage 100's BOI. The end result shows the vendor when I look at all PO Receipts, but the receipt is empty when I view the full receipt Here are the current…

All of the users in my company have separate SAGE 100 credentials and I wanted to see if there's a way to configure it so that they can authenticate through LDAP instead. I also wanted to see what other authentication methods there are out there for SAGE…

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

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…

Hi I am trying to create an order using C# but I get an error with the "invoke" as below An unhandled exception of type 'System.Reflection.TargetInvocationException' occurred in mscorlib.dll Exception has been thrown by the target of an invocation…

Hi everyone, would you please have a look at this and see why this is running erratically? I've seen some sample scripts here and there, and the bulk of my script is from the other posts on this forum. I must be misunderstanding what objects and what…

Hi All I am facing this error while running BOI "Error 65 in program SO_commonentry detail.pvc". can anyone please help to solve it?

I am trying to check to see if a sales order has been completed from an external VbScript. I'm guessing I'm not hitting the right object. Any suggestions would be appreciated. Public Function IsSalesOrderComplete(strOrderNo) Dim so, rtnVal, status…

Help. I'm getting this error at the ADDLINE. What am I doing wrong? Here is my code: Dim Answer As String Dim MyNote As String 'Place your text here MyNote = "Import AP invoice into Sage?" 'Display MessageBox Answer = MsgBox(MyNote, vbQuestion + vbYesNo…

Hi, I've been encountering the error "ProvideX object has been released" on posting production entries. Im using BM_Production_bus and BM_Bill_bus, and dropping those objects if there's any error/component mismatch on the BOM. Thanks!

Is anyone out there utilizing HubSpot? And if so, are you transferring data both to and from Sage 100? Or just transferring data from HubSpot to Sage? Any problems with the integration?