x Want to participate? Join the group to interact

  • Sage100.ObjectManagement .NET AR Invoice Sales Tax Object

    I'm working on an integration that will write AR invoices to Sage 100 from another system where the sales tax is already being calculated and managed. I'm using the Sage100.ObjectManagement library and some of the examples I found here ( RE: Sage100.ObjectManagement…

  • How can I make fields from Job Cost available to bring over to Sales Order?

    I'm trying to add a few fields into a Sales Order Entry screen - Job Address, Name, Country, Zip, City, State - from the Job Cost module. I remember there was a way to kind of "cheat" it by linking them as business objects into a UDF or something like…

  • Trying to Open Sage 100 UI with Scripting

    Hey Guys, I am currently trying to automatically create Sales Orders via a different application and that application after creating the Sales Order opens the Sales Order Entry UI. I Am successfull in opening the UI, But What Problem i face is it opens…

  • SO Line Item Not writing

    retVal = oSS.nSetProgram(oSS.nLookupTask("SO_SalesOrder_ui")) set soOrder = oPVX.NewObject("SO_SalesOrder_bus", oSS) Set soLine = soOrder.oLines retVal = soOrder.nSetKeyValue("SalesOrderNo$","0001000") retVal = soOrder.nSetKey() retVal = soOrder.nSetValue…

  • Sage 100 V2022 Std Customizer -Custom Screens

    We have several customized screens for sales order, customer inquiry, invoice history inquiry, and inventory inquiry. The other day I went in looking at one of the screens and I noticed my settings had changed. We had hidden any sections that showed unit…

  • How to add a change order to a job in the Job Cost module?

    Hello, I am trying to add a change order to a job in the Job Cost module using the BOI in the C#. I have taken the BOI course and understand the basics of how to interact with Sage using the BOI, and have been using the Object Reference documentation…

  • External Script to Loop Through Deposits in Batch

    I am attempting to create an external script that will update all deposits in a Cash Receipts batch in the event something was entered incorrectly during data entry (i.e. BankCodes, DepositDates, etc). It would appear that the script is working fine until…

  • Installation of the business object interface in a docker container

    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…

  • Sage BOI SO_PackageTrackingByItem_bus

    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…

  • Create Sales Order Lines Object from MS Access Module

    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…

  • Sales Order Invoices don't get emailed from BOI script when run with Windows Task Scheduler.

    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…

  • Exit Table Updates Properly?

    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…

  • Work Ticket BOI Change QuantityOrdered and Rescale Labor and Materials

    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…

  • BOI Purchase order entry to Receipt of GoodsGuidance

    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…

  • Error while writing a Purchase Order Invoice using C# to Sage 100 US

    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…

  • Script to Loop through Invoice History Lines

    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…

  • Matching Receipt of Invoice Line with One of Multiple Receipts of Goods

    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…

  • Grabbing the Currently Selected Invoice from Listbox

    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…

  • How to Stop "Do you want to print Sales Journal?" prompt from happening in my script?

    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…

  • SO_SalesOrderHistoryDetail has records with a null SalesOrderNo

    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…

  • Sales Order Invoice Printing with Batches Enabled

    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…

  • Update UDT whenever Sales Orders are printed

    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…

  • BOI. Please, provide an example of a sample C# or VB code as a reference to write invoice using BOI which links to an Order

    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…

  • PO Receipt of Goods - Set OriginalOrderQty on existing item

    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…

  • PO Receipt of Goods - Receiving existing line and adding new line not writing new line quantity

    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…

*Community Hub is the new name for Sage City