Sage 100

On a 2021.0 and 2021.2 system, exporting to Excel from a list box results in the cell formatting applied being off by one column whereas on a 2020.1 system, the cells have the correct formatting applied. On the 2021 systems, this was observed when exporting…

Just thought I would share this for anyone else that may be looking for problems with emails and TLS 1.0 TLS 1.1. The Additional information is at the very bottom of the KB and could easily be missed. Additional information Note : Microsoft and…

From Main Item Maint Panel I added a button link to run a vbscript, which runs a shell command. How can I pass the ItemCode to the vbscript. ' init vars Dim itemcode Dim oShell itemcode = "S-209220" 'hardcoded here works, but needs to change…

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…

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?

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…

I am working on planning an upgrade and see the SPM for v2020 doesn't officially show support for MS SQL version 2019 yet. Is there a timeline on when that will be added to the SPM?

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?

Hi, I have the code below for automatic registration/update of the production transactions. I've been getting an error on the UpdateInit method. oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI")) objTransactionRegister = oScript2.NewObject…

I'm having issue trying to get into Customer Maintenance from Script. This was working before, but has become an issue over the last week or so. I don't remember changing anything. Maybe you can spot check me to see what i am doing wrong. Shell (…

We are running an old version of MAS200, version 4.40. I had to upgrade my laptop due to it's untimely death. I am currently on Windows 10, Office 2019 (32-bit). For some reason, the Export to Excel button that was available on my old laptop is "grayed…

Hi, I've been wondering for a couple of days now. it seems that the Distribution line is adding a bunch of numbers on my Lot. retVal = oProduction.oLines.oDistribution.nAddDistributionLine("B456") oProduction.oLines.oDistribution.sLastErrorMsg says…

Hi, So i've been trying to put an entry on BOM Produciton entry, it seems to be having an error with the Distribution part. (im using an item with Lot Valuation) retVal = oProduction.oLines.oDistribution.nAddDistributionLine("B456") retVal = oProduction…

How to get PurchaseOrderNo using PurchaseOrder Details & LineItems data from Sage 100 desktop application using C#? I have using DispatchObject and done login and select company functionality. Can you please help me to get PO detail using C#?

Has anyone had success sending emails from BI tools with 64 bit Outlook installed? When I run a report, and clicking the "Send Now" button, or try to edit the address book in BI Tools results in this error: The reason this error makes…

I am working on a C# .net desktop application that needs to be able to connect to Sage 100 2017 and retrieve available inventory quantities for all products. I've run into a complete brick wall trying to figure out how to do this. I have several questions…

I am working on a C# .net desktop application that needs to be able to connect to Sage 100 2017 and retrieve available inventory quantities for all products. I've run into a complete brick wall trying to figure out how to do this. I have several questions…