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.
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…
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…
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 Team, I have an application and want to integrate it with Sage 100 cloud. I found the following specification:
help-sage100.na.sage.com/.../index.htm
As I understood, this API allows receiving all Account Receivables documents from Sage 100…
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…
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…
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…
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.
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…
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…
Fairly new to most of Sage.
From what I've heard it's not possible to migrate MAS 200 into Sage 100 because of different tax structure setups.
We run MAS 200 v4.40 (listed in install as C:\M200cs\V44\MAS90), Sage CRM 200, and Sage 100 2017 v5.40.0…
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…
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?
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…
After Job Cost was updated to the Business Objects Interface Sage confirms but has not corrected two major problems (for us). When Sales Order is integrated with Job Cost there is the ability to create a new job from Sales Order Entry. When entering the…
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 (…
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#?