Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
Hello,
I saw that Microsoft is moving to deprecate VBScript in Windows. Resources for deprecated features in the Windows client - What's new in Windows | Microsoft Learn I know it will be around for a while before this is done. However, I am curious…
Hello we have an inquiry into [email protected] to sign up for the Microsoft 365 integration with Sage 100, but it's been 2 weeks and we have not received a response. Does anyone have any advice on how to reach them alternatively or how to escalate…
Has anyone else had issues with MS365 Access crashing when trying to connect to Sage 100 2022 via ODBC 32 bit connection? We just upgraded, and now when I try to connect the program (Access) crashes and closes. The same version of access will still connect…
I am about 30 days in to trying to get the Office 365 Integration to function properly with my Sage 100 Cloud 2022 software. I have successfully followed all instructions here: https://help-sage100.na.sage.com/2018/Subsystems/LM/LMOffice365Proced/Setting_Up_Office_365_Integration…
I am trying to Set Up Office 365 Integration with my MAS 100 Cloud installation. I successfully installed the software and followed all steps as outlined here: https://help-sage100.na.sage.com/2018/Subsystems/LM/LMOffice365Proced/Setting_Up_Office_365_Integration…
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…
Is Sage 100 2022.1 compatible with Office Professional Plus 2021?
I have it installed and my ALE lookups do not open in Excel, Instead I get Error 65, Windows element does not exist or already exists Program: SY_EXCEL.PVC statement 165 Class SY_EXCEL…
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/.../
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?
Has anyone used a Microsoft Surface to scan barcodes within Sage 100? All I am trying to do is have the cursor in the "order number" field in SO entry and be able to use the surface to scan a barcode on the actual SO paper to avoid having the user type…
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…
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…
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…