x Want to participate? Join the group to interact

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

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

  • Microsoft's Deprecation of VBScript

    Hello, I saw that Microsoft is moving to deprecate VBScript in Windows. Resources for deprecated features in the Windows client - What's new in Windows | Microsoft Learn I know it will be around for a while before this is done. However, I am curious…

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

  • Non-existent items

    We're currently using the Sage100 C# NuGet package noted below. We've run into a situation whereby a miscellaneous item (CI_Item) is visible in the UI and via OBDC connection however, we're unable to find the item using the MASRecordset utilities…

  • Has anyone been able to trigger a script on the Ar_CustomerMemo or other Memo tables?

    I'm trying to trigger a script that will set the "Auto Display" value to "Always" as a default on the AR_CustomerMemo. I've tested triggering a script with a simple message box on various events like, on Table Set Default Values, Table Pre-Write, and…

  • Upgrade from Sage 2016 to Sage 2023?

    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…

  • Sage 100 2022 BOI unhandled exception in 64-bit sales order entry

    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…

  • Error 88 on Sales Order Entry Lines

    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…

  • Copy UDF Values from AR_CUSTOMER.M4T to Equivalent UDFs on new Sales Orders

    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…

  • Not able to write using AR_InvoiceHistoryInquiry_bus object

    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.

  • C# Create Sales Invoice From Sales Order; nSetKey() fails, sLastErrorMsg = "The [InvoiceNo] is invalid"

    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…

  • How to get business object names for table from Sage 100 BOI

    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…

  • User Defined Scripts to populate a UDF

    I'm creating a script to auto-populate an SO_Detail UDF (UDF_SHIP_REF1) so that I can pass data to StarShip. The goal is to concatenate the item number with the Customer PO Number (i.e. "3131000 / 123456789" ) I have developed a more detailed script…

  • How do I enter account Partner_Account Number on Sage University as the website does not have an option to update it?

    Hi All, I have placed an order for a course on Sage university but the system is not allowing me make the payment. Hence, we reached sales customer service via email and they reset the same and asked us to try and purchase the course again to redirect…

  • User Defined Script - Problems Getting Child Handle

    I'm trying to accumulate the quantities of all the detail lines in an AR invoice, but only if the item is of a certain type. I defined a UDF for that checkbox, and put it in the Item Maintenance screen. I would like the total to update whenever a user…

  • Trying to set pricing, "The Price Code Record is Required" (even though it's set)

    {solved} The error was in my KeySet() line. Instead of: var retval = Core.SageObject.Process(pcObject.InvokeMethod("nSetKey", ""), pcObject).ReturnCode; It should have been: var retval = Core.SageObject.Process(pcObject.InvokeMethod("nSetKey"…

  • nProcessReport returns Nothing

    Hi, I have the code below for automatic registration/update of the inventory register transactions. In the nProcessReport part, my return is always Nothing. I'm encountering same issue on Sage 100 2018 and 2020 oSSRegister.nSetProgram(oSSRegister…

  • BOI Print PickingSheet resets form code to STANDARD

    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…

  • Sales Order lines

    I previously worked with Sage 500 and was able to run a query from Sales Order lines and dump that data into excel and then manipulate it for my presentations and create pivot tables.This would brake down the sales order to the line level and provide…

  • run script without admin (COM exception failed to initialize provideX library)

    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…

  • Sales Order Line UDF Update during Invoice Data Entry

    Hi, I am trying to write a script that zero's out a Sales Order UDF during Invoice Data Entry. This is what I have, but it is not zeroing in on the exact sales order in my lines and it doesn't seem to be writing back to the sales order, although I have…

  • Sage Alerts & Workflow Write back into Sage

    Looking to have Sage Alerts and Workflow create a PO in Sage 100. It's my understanding that the Sage Alerts Workflow module has collection of API's that can update a database but Sage 100 Providex is difficult to write to and that Sage 100 does not have…

  • How to access PR_TaxProfileLocation

    Hi Experts, We are working on a script that will bulk import TaxProfiles into Payroll. We are utilizing the PR_TaxProfile_bus. But we need to get to PR_TaxProfileLocation. The Sage Help states that this can be accessed as oTaxProfileLocation (similar…

*Community Hub is the new name for Sage City