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,
We are looking for consultant to help in installation of Sage API into our sage 100 2020.
Please check below link for understanding:
www.sagecity.com/.../getting-started-with-the-sage-100cloud-custom-connector-for-the-microsoft-power-…
I created a receipt of invoice, applied PO to it, changed some info- and in the end I called
record.nWrite();
where record is the pvxDynamic representing PO_Receipt_bus. I know that after the write, I have a new receipt in Sage and it's valid
…
Hi,
I'm trying to write a code that gets all the invoices which were fully paid. My idea was to take all the invoice and remove all the open invoices from "AP_OpenInvoice".
But, I see invoices in that tables that have 0 balance. So probsbly it doesn…
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…
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…
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.
Hello, I have taken over an existing installation that does not have any documentation or support on it. Our website uses a custom sync tool to push orders into Sage. Everyone once in awhile (10% of orders or so), I will see an error, "The column is not…
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…
Experts,
I have a small app that writes to CI_Item. It has been working with no issues in Sage 100 v2017 Premium for my client in a Sage Server / Terminal Server setting. Now they are on v2020 Premium in the same setup (new servers), but we are running…
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…
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…
Earlier this year I created a mobile application for pulling orders. To integrate, I made a rather barbaric implementation: when the mobile application backorders an item, update SO_SalesOrderDetail.QuantityBackordered = External.QuantityBackordered.…
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…
Hi,
I've been working on automatic registration of transactions for Bill of materials.
but I've been encoutering this issue for a couple of days now.
its been throwing me an error that says "Invalid or missing posting date encountered"
I opted…
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…
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#?
Hi all,
I'm experiencing issues trying to new up a AR_Customer_bus object, my eventual aim is to be able to create a new customer using the BOI. The error I'm getting is a 200 error.
This is my code so far, also note that I've written this off the…
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…
Hi Forum,
I have a script that imports Sales orders from a SQL server, but because some of the lines are kits the components display at the end of the order.
Is there a way in BOI to refresh the Sales Order lines after is imported into Sage ?
…
