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 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…
I am trying to check to see if a sales order has been completed from an external VbScript. I'm guessing I'm not hitting the right object. Any suggestions would be appreciated.
Public Function IsSalesOrderComplete(strOrderNo) Dim so, rtnVal, status…
I am working on planning an upgrade and see the SPM for v2020 doesn't officially show support for MS SQL version 2019 yet. Is there a timeline on when that will be added to the SPM?
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!
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…
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 =…
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 (…
We are running an old version of MAS200, version 4.40. I had to upgrade my laptop due to it's untimely death. I am currently on Windows 10, Office 2019 (32-bit). For some reason, the Export to Excel button that was available on my old laptop is "grayed…
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#?
Has anyone had success sending emails from BI tools with 64 bit Outlook installed?
When I run a report, and clicking the "Send Now" button, or try to edit the address book in BI Tools results in this error:
The reason this error makes…
I am working on a C# .net desktop application that needs to be able to connect to Sage 100 2017 and retrieve available inventory quantities for all products. I've run into a complete brick wall trying to figure out how to do this. I have several questions…
I am working on a C# .net desktop application that needs to be able to connect to Sage 100 2017 and retrieve available inventory quantities for all products. I've run into a complete brick wall trying to figure out how to do this. I have several questions…
Hoping an old timer might have a c programming example to open the sage boi. I use CodeBlocks
Have working VB, VB.Net and Lazarus (Delphi) programs working.
Go ahead MAKE MY DAY!!!
Happy holidays
Hello
I am writing script to create invoice using BOI,but it gives error when writing Line items "Missing or Invalid Header".Can someone help on this.
My code snippet
int TaskID = (int) oSS.InvokeMethod("nLookupTask", "SO_Invoice_Ui"); oSS.InvokeMethod…
We are using sage 100 2019 and developing c# code for creating invoice in sage.i am able to create sales orders in sage with BOI but whenever i am creating invoice it is throwing error
{"Exception has been thrown by the target of an invocation."}…
I am Tying to setup BOI but when i try running any script i get this error.
here is the vb scrip that i am trying to run.
Set oPVX = CreateObject( "ProvideX.Script" )
oPVX.Init( "C:\Sage\Sage 100 Workstation\MAS90\Home" )
Set oSS = oPVX.NewObject…
Hi All,
I have a custom module installed in Sage 100, I need to do insert in it using BOI script. Is anyone has any Idea how I can achieve it?
your reply will be Appreciated
Thanks,
SF
Can someone form Sage provide an API technical roadmap for Sage 100cloud. I'm particularly interested in any future strategies that move away from a COM/ODBC interface to a more gerenric service based interface using REST, SOAP or whatever technologies…
