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.
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…
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,
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…
Hi,
I've been wondering if someone else encountered or might have a solution for this.
Im getting the error "The register must be printed prior to posting"
oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI"))
objTransactionRegister…
Hi, i've been constantly getting the error "System.Exception: <NewObject Error: 200>" when I register the BM production entries.
here's what I have coded:
oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI"))
objTransactionRegister =…
Does anyone have any suggestions on the best way to use Microsoft SSIS (SQL Server Integration Services) to connect to SAGE 100 Business Objects API? We came across this product, but were curious to know what recommendations the community had. https:…
Hello,
This might be an easy fix, but I seem to be having issues opening the SO_Shipping_bus object. Am I setting the following object up correctly?
Microsoft.Win32.RegistryKey SageKey = Microsoft.Win32.Registry.CurrentUser.OpenSubKey(@"Software…
There is a system table named "CM_UDF". I want to get records from this table. The corresponding data file for this table lies in folder named "MAS_SYSTEM" which is outside the folder structure belonging to any company. Moreover, there are no business…
I want to get a list of all the UDF columns in a particular table eg. AR_Customer. Is there a way to get this list?
There is a method which returns a list of all the columns in any particular table but I cannot differentiate between the custom ones…