Sage 100

When attempting to create line items for a Inventory Transaction Receipt batch I'm having issues when I attempt to update the distribution.  my code was working on Sage 2018 but they are upgrading to Sage 2021 and it now throws an

System.Runtime.InteropServices…

I'm using the identical code to nSetValue R/W fields that has worked for years, but I am finding that it fails for some tables even though they show a R/W Business Object. I am modifying a non-key field in GL_DetailPosting, but I cannot get past the nSetKeyValue…

Is there anyone that can help with providing an example of creating an AR Invoice with lines/details in C# using either BOI or the nuget package www.nuget.org/.../

   
           var sessionLogon = new SessionLogon
            {
                CompanyCode = companyCode,
                UserLogon = new NetworkCredential { UserName = userName, Password = password },
                ModuleCode = ModuleNames.AccountsReceivable…

Attempting to pull data into Excel from a UDT.

Raw data will pull, but,

when I try to edit Query, receive "Expression.Error: The key didn't match any rows in the table." in Power Query.

See screen shot : 

Any Thoughts?

I have used "syzcon…

Hi

I am looking for a script to update "Daily Sales Report/Updates"  in sales order (sage100 v2021). 

Could anyone suggest me what script i can use in BOI suing c# or VB?

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…

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…

All of the users in my company have separate SAGE 100 credentials and I wanted to see if there's a way to configure it so that they can authenticate through LDAP instead. I also wanted to see what other authentication methods there are out there for…

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…

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…

Hi All

I am facing this error while running BOI "Error 65 in program SO_commonentry detail.pvc". can anyone please help to solve it?

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…

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…

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…

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"…

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…

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…

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…

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#?

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