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.
I want to deploy my app in a docker container but for that I need to install the business object interface.
The problem that I'm facing is that the installation is blocked from installation in the container even with scripts that execute the .exe as…
I am attempting to write a Sage BOI VBS program to read and write to the SO Shipping Data Entry Package Tracking By Item object and am receiving the error <NewObject Error: 200>. I am using a Sage user that has full access to Sage and have the company…
Good Day,
I hope this message finds you well. I am currently facing an issue with a control I've created in MS Access that interacts with Sage100 (Standard 2020 v6.20.4). I'm reaching out to seek your assistance in resolving this matter.
The control…
I created a BOI script that selects a batch of invoices, PDF's them, emails them, updates and PDF's the sales register and updates and PDF's the DTR in 2022 Advanced. The script works fine when run manually from the desktop. When running it from Windows…
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…
Using Sage 100 Advanced 2023 and the Production Management Module, I am trying to use BOI to update the Quantity Ordered on a Work Ticket but want it to automatically trigger the rescaling of labor and materials like it asks when you change the quantity…
Hello I am currently entering a Purchase Order into a Receipt of goods using BOI but the issue is when we don't receive an order fully it is leaving our items on backorder... Is there a way to get rid of pending backorder through BOI? or is this a bad…
Sage 100 Code: CI_ValGrpPORequired,
Message: A purchase order number is required. when calling nSetValue with parameters InvoiceNo$, {InvoiceNumber}
Could anyone please help me with the meaning of the error code CI_ValGrpPORequired. I have made…
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…
I've got the following scenario:
I create a PO with qty 1000 of Item A on it.
I receive against the PO at two different times, so I make two Receipts of Goods against said PO.
The first receipt I receive 500 of Item A, and add a charge to the…
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…
I have my script working to select invoice batches in S/O Invoice Printing. Once the batch is selected the invoices are electronically delivered. This all works fine. It needs to run unattended with no UI. How do I stop the Sales Journal prompt after…
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…
Has anyone had any luck creating a BOI script to print and update invoices when batches are enabled? I keep getting a message stating that batching can't done in the current task. Here's a snippet of my code:
retVal = oSS.nSetProgram(oSS.nLookupTask…
Greetings all,
I was wondering if there is a way of updating a UDT whenever a Sales Order is printing via script.
I have a customer that would like to keep track of the time between when the SO is printed and when the order is shipped. I figured I…
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…
As a follow-up/refinement to my previous question, I am wondering how to set the OriginalOrderQty on a line on a Receipt of Goods that I have entered by hand. In an effort to isolate my issue, I have created this PO ( here ) and this Receipt of Goods…
I have a PO that I am receiving against. I want to receive part of the line that exists as well as add a new line.
The existing line is received as expected. However, when I try to add the new line, it creates a line with the item code and unit cost…
Hey does anyone know where to get the objectreference.chm file? In the object training and here in Sage City it is referenced quite a bit but I'm unable to find it anywhere incuding the portal.
Hello, I'm having rounding problem issue - in configuration I have decimal precision set to 4, in the Sage 100 (2022 version 7.10.0.0) my PO Item is stored correctly. Unit price for one of the items is 37.5950, but when I get date by PO_PurchaseOrderDetails_svc…
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 experiencing an error 88 on Sales Order Lines. The error occurs only on large orders with numerous lines, especially when adding inventory items to the order on the fly. The line prewrite script is failing and referencing different UDT objects…
We would like a Button Script on Customer Maintenance to open UDT maintenance UI for a particular AR_UDT.
The second step would be to pass the Customer Number to the CM_UDTMaintSelect_UI. This would work great as t here are multiple records in the UDT…
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…
