I hope this is something easy that I'm overlooking. I'm looking up an invoice in the AP_OpenInvoice table that I know exists. I have confirmed that I'm passing the correct vendor division, number, and invoice number. But I'm getting a 0 return value.…
I have encountered a strange issue with a button script that enters data into a UDT. I have been using this script in testing for about a month now and it hasn't had any issues until yesterday - even after a server restart.
The first time clicking this…
Hello,
I was hoping to get some advice on scripting the BOI via a Button script that was placed on S/O Invoice Data Entry that would act as a "Quick Tax Credit" button. We use a third party cloud vendor to calculate our taxes but that shouldn't affect…
In Customer Maintenance's Invoice tab I am wanting to allow accounting to have the ability to edit the Comment field from the AR_OpenInvoice table. Since this isn't the history table, it wouldn't affect the comment line for invoice history reprints, so…
Hello, getting an error: Invalid or missing header on the code below- can anyone provide a working example of creating a purchase order in BOI? using (var sySession = new MasSession(homePath))
{
sySession.InitSession(sessionLogon);
CI.ColumnNames…
I've noticed that we have just over 14,000 records in the SO_SalesOrderHistoryDetail table where the SalesOrderNo field is null. This is causing some issues with trying to do a copy into a MySQL database due to the Primary Key not accepting null values…
Salut l'équipe,
S'il vous plaît, aidez-moi avec ce scénario.
Scénario:
La commande est déjà créée dans l'ERP À l’aide de BOI, rédigez une facture dans l’ERP qui s’intègre dans une commande (la facture contiendra le numéro du document de commande…
Hi Team, Please, help me with this scenario.
Scenario:
Order is already created in the ERP
Using BOI, write an Invoice to ERP that Integrates into an Order (The invoice will contain the Order document number(DO_Piece)). a) This invoice can also…
I started working here 3 years ago, and there was an existing Sage 2016 installation. I've been meaning to upgrade it since I started here, but just haven't taken the time to do it. Yesterday I received a threatening email from Sage about TLS, and there…
I am writing an API in C#.net, that POSTs sales order entries to Sage 100, using BOI. I am using much of the same code that I've used for other integration projects with success. The client for this project is upgrading to Sage 100 2022 Premium- and testing…
We are encountering an issue where CIM Cloud web orders are successfully pushing to the ERP Driver but is failing to create a BOI session. Any suggestions on what other pieces we can troubleshoot before reinstalling the ERP Driver?
What we have tried…
New to this forum, and new to using the Business Object Interface.
Scenerio: I'm on Sage 100 2022 Standard, and am about to implement Sage Alerts & Workflow. One of the tasks I will be creating will periodically look at all open Sales Orders and automatically…
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…
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 trying to use Business Objects to create a completion transaction for a Work Ticket in Sage 100 2022. I can't seem to figure out how to add the work ticket to the actual transaction. Below is a slimmed down version at its simplest form of what I'm…
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, 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…
I'm working on a BOI script to create Manual Check entries from a CSV.
Everything can import successfully, except when the invoice was set with SeparateCheck = "Y". In regular UI, you get the popup message "The Invoice ____ is flagged for separate…
I have most of this script working but am hung up on the part reading from the line detail object. I have created a button on the AR Invoice History Inquiry panel so that the end user can find the invoice they want to copy, press the button, and the flat…
Experts,
I am looking for a way to retrieve the ExtendedItemDescription for a line item on a Sales Order before the SO is actually saved. The Extended Description gets put together by JobOps, and I need to grab it to extract some data from there.
…
Hi forum folks and Happy Friday! I have a customer that would like to CC a specific inbox any time we send SO Invoices and orders via Paperless Office. We have been doing this by adding this CC email to the "To Additional Email Addresses" Field under…
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…
I see that there are lots of questions about this in the past, but I can't seem to find a concrete answer on how to move forward with it. I realize it has something to do with DCOM, registering the DLL, running client side verse server side.... But I…
Our developers have written an interface to pull and push AR customer data. Invoices (IN) are not a problem, but prepaid invoices (PP) produce no results and no errors. I'm pasting the code below. Any ideas?
using System; using System.Collections.Generic;…
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…