Sage 100

I am new to this so please bear with me. I have the following script ( i can only post a portion of the code. The SPAM blocker flagged it as malicious) that is used to update two UDF fields from a .csv file. It is called via a custom application. I am…

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…

We have no issues creating AR invoices in the ProvideX library with Sage 100 Advanced. We have several clients using our integration (all with Advanced). We were told our code would not need to change to support Premium (SQL). After setting up Premium…

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…

We have no issues loading the ProvideX library with Sage 100 Advanced, however we're having an issue with Sage 100 Premium (SQL). We use the following c# code. It appears we're getting an error when it tries to invoke the Init method. Stack trace is…

Hi All, I am having an issue running PO_ReceiptRegister_upd. I am trying to run the Receipt of Goods Register from BOI. oSS.InvokeMethod("nSetDate", "P/O", date); oSS.InvokeMethod("nSetModule", "P/O"); //DispatchObject security = new DispatchObject…

HI All! We've put together a netcore API hosted on IIS for integrating with other tools we have. All of our services on the API are scoped to give the requests their own instances and dependencies. public static void AppServices(this IServiceCollection…

Can anyone please help me with the business object for Credit card information and the tables in which it is stored.

Can anyone please help me in creating purchase order in sage. I tried creating it but the line items are not getting inserted and getting the following error "This Purchase Order has no lines and has zero total amounts". ARDivisionNo = WScript…

Hi Team, Can anyone please help me in getting the business object interface for creating Vendor purchase order in sage. Thanks

I am tring to write multiline extended description of product but not able to write it using description. i used \r\n and \n for carrige return or line break but it ignored and description come with single line.

Hi, I'm trying to use vbs script to insert an entry into the AR_InvoiceHistory table using AR_InvoiceHistoryInquiry_bus object but I'm getting the following error: Can anybody please help.

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/.../

We have a python (3.10) application that we want to use to create a sales order in Sage 100. I have installed pywin32 so the python script can access win32/COM. This code works up to the point where I try to call a method on the SY_Session object…

Wondering if there are some flags/properties in the BOI object that can be used to determine if an update (CI_Item in this case) are coming from a Sage Application user or from a BOI program within a Pre-Write script. psuedo=allow spaces when coming…

var sessionLogon = new SessionLogon { CompanyCode = companyCode, UserLogon = new NetworkCredential { UserName = userName, Password = password }, ModuleCode = ModuleNames.AccountsReceivable, ModuleDate = DateTime.Today }; using (var…

I am on Sage 100c Standard 2016 (Version 5.30.5.0) (yes, I know it is very old, and have plans to upgrade to a supported version). I am attempting to create a program in C# that creates a sales invoice from a sales order. When my program executes the…

I have a C# code that integrates with Sage 100 2021 Standard. After performing some action I want to clean and close the session I opened. for this I'm using: session.nCleanup(); session.DropObject(); for some reason the nCleanup() returns null…

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 Forum, I need to write a BOI script to update a PO Line UDF from an external Data Source. My question is, how can i get the line to update the UDF, i wrote a little script to update the line but i get the message that the o.oLines is in read…

Hi Forum, I am importing SO Invoices with a BOI script, imports fine but i cannot get the Sales Order Number to update. I have 2 scripts, one to import invoices (I cannot set the SO # here, no error just no SO value in the Invoice Header). the second…

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

Hi all I am trying to create AR cash receipt in sage100c 2021 version by using the below script. I have added all the possible/required fields but still getting error "Missing or invalid header". int taskID = (int)oSS.InvokeMethod("nLookupTask"…

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…