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 Afternoon
Does anyone have feedback on Scanco Warehouse as a solution to automate receiving inventory transfers and shipping? If you have experience with this product would you recommend it?
We are struggling with the decision as the receiving…
I'm exporting column names in my Visual Integrator export. I need to rename one of the column headings, but I can't seem to find a way to do that. Anyone have any suggestions?
Thanks!
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…
So I've got SData installed and working. I can ping AR_Customer to get a list of customers. However, attempting to post to this endpoint with the following body fails:
Of note, I've slimmed down the payload to only what is known to be the simplest required…
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…
Upgraded from Sage 100c Advanced v2019.2 to v2022.1 on new Win2022 ERP server and separate Win2019 Citrix server.
When we import EDI PO's from True Commerce Transaction Manager v2 integration into Sage 100 which become SO, of course, we get duplicate…
Using the BOI and trying to loop through all Sales Orders and, for each Sales Order, loop through all lines. Have it working however some orders are in a state such that, if opened from the Sage UI, a popup is shown with text like:
In the UI, I can…
My team has been using desktop Sage 100 (2021) to enter purchase orders to generate sales orders, but we would like to do this via API.
https://help-sage100.na.sage.com/2021/FLOR/index.htm#Program_Listings/Program_Listings_Overview.htm?TocPath=Program…
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…
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'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…
Hello,
About a year ago we hired a 3rd party company to develop a Sales Order integration for us. Essentially what they are doing is extracting data from our Quotes & Sales Orders application (using Zoho Creator) and using POST functionality to create…
Hi everyone,
I have a phone number field in the Sales Order Entry task, which appears to be a customization someone added at some point. It’s not a default field, right? The text label looks a bit different than the other fields and sometimes it seems…
We are transitioning from Century Business Solutions to Paya Connect Merchant services
Objective: to see if there's a way to move the credit card tokens from CBS to Paya so we can continue to have access to the credit cards.
I understand that I need…
Sage 100 2020 (6.20) I have written a Power Shell script to import PO ROG. The script, when run stand alone works great. When the exact script is copied to a 3rd party program and run from there it fails. I think I might have a 32-bit vs 64-bit conflict…
Environment: IIS, .net CORE ASP.net web API, ProvideX.Script COM object (Sage 100/ MAS90 2018 v4.5), Server 2012 R2.
Starting with the workaround first: so far my workaround has been to allow my IIS identity pool ID full access to the DCOM computer…
Hello,
I have a client who currently generates ACH files from Sage to upload into Bank of America. Bank of America mentioned being able to integrate with Sage, however, after searching online on how this would would or if anyone has done this before…
Hello,
I am having difficulty getting some code to work. I have found examples, but translating it to C# is making it harder to solve the problem.
I am trying to export a sales order through the SO_SalesOrderPrinting_UI BOI.
the following settings…
We are going with SAGE 100, Starship and other integrated solution providers.
What Zebra printers, shipping label sizes are best for printing both UPS and Fed Ex shipping labels.
Michael