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…

  • BM_GrossReqrmntReport_rpt

    I'm not finding a way to import several Bill Numbers into this report's parameters. Can you help me? It seems like i should be able to do this, however i'm not finding the right path yet. VI doesn't offer it and i'm having trouble finding clues to help…

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

  • How to create a production Entry but keep the lines that populate without adding or changing existing lines

    I'm trying to create a production entry. It works fine if I add lines but if I don't add any lines I get an error message saying I need at least one line. In the Sage UI you can select a Bill Number and it pre-populates the lines, I'd like to do the same…

  • Prevent Change to Different Division

    We use divisions and sometimes the users will copy a previous sales order and change the customer. The problem comes in that items on the sale order are coded to one division and if the new customer is in the different division it creates a problem with…

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

  • Import of AP Bills - random errors

    Hi Experts, I created an integration that pulls CSV files with AP Bills from an FTP server and imports those into Sage 100. Every time the script runs it imports 20 to 50 AP Bills. The bills are often for different company codes, so the integration…

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

  • Invoice total displaying as zero

    The total is displaying as zero in Invoice Data entry I've written the script for the extension amount as follows. Can you pls clarify which column should be used to store the total?

  • Invoices not showing in customer maintenance

    Hi Team, Can someone kindly help me with displaying the invoices in the customer maintenance section? It appears in the data entry for invoices but not in the section for customer maintenance.

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

  • Can't find the created UDT as a Data Source while adding a field to the AR Customer table

    Hello, I created an SY UDT, and then I tried to add the field from this UDT into the AR_Customer table. I don't see the UDF from that SY UDT as a Data Source under the AR_Customer_Bus. Is there one more step to link them before I'm able to select the…

  • PO Receipt of Goods EditKey EditLine

    I have a working Receipt of Goods Visual Studio VB console app. It's an integration project. I have a textfile that has the receiving data. It's easy enough to MoveFirst and MoveNext and match the text data to the PO Line using LineKey (or I could use…

  • Create Item on SO from Button Script

    Experts, I have a button script that generates an item code. The generated item code does not yet exist in CI_Item. The desired behavior is that I can populate the new ItemCode on a new line in SO Entry and from there default Sage logic takes over …

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

  • JobOps WT Template Modification Through BOI

    Hey everyone! I'm attempting to modify and create/remove work ticket templates via BOI (through C# and Entity Framework) and I'm not having much luck. I'm not sure what object the template table is a part of and I haven't been able to find anything…

  • Launch Sales Order Entry to create new order from Customer Maintenance and pass Customer Number

    Hi Sage City and Happy Friday! I have been working on a button script to launch Sales Order Entry from AR Customer Maintenance. The goal is to click on the button and open SO Entry, automatically select the next Order Number and pass the Customer Number…

  • Is it possible to create records in AR_CustomerDocuments and AR_CustomerDocumentContacts via BOI?

    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…

  • Open Item Customer Sales History By Period UI from Button Script - pass Customer

    Experts, I am using the button script below to open Customer History by Period from a Sales Order line (Sage has this button in Item Maintenance on the History tab). It works. It opens properly for the item. But there is a secondary selection criterion…

  • DCOM permissions and BOI

    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…

  • Customer integration issue after update to 2020

    We have a customer that just upgraded their Sage 100 product to the 2020 version and are seeing some issues with integrating to our product. They migrating from Sage 2016. Below is a code snippet of where the issue is coming from. The error is “CI_NOF…

  • Show/Hide buttons not working

    Hi Forum, i have buttons in AP Invoice custom panel that i have hidden and depending on the company code they will Show but buttons stay hidden. The UI Script Event is "POST LOAD" Here is the code I am using which i copied from the forum. …

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

  • Create Purchase Order Invoice via BOI

    Experts, I am able to create Sales Order, Sales Order Invoices, and AP Invoices via BOI without any issues. I am missing something about the order of things for PO Receipt of Invoice. Here is an excerpt of my code (it's in Powershell, but the methods…

*Community Hub is the new name for Sage City