• Need help with UDS and GetChildObject method to access "AR_PaymentType_Bus"

    Here's my situation:

    The UDS is on the Pre-Totals event of S/O invoice header and I am trying to access a field in the "AR_PaymentType" table. I would appreciate if anyone could see by blunder in any of the 4 methods I describe here.

    Methods…

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

  • Changing Naming convention on save Paperless Office form PDFs

    Is it possible to modify the naming convention used by paperless office when storing forms? I have a customer who wants to add a UDF to track Revision Number on Sales Orders and Purchase Orders, and would like the Revision Number to be part of the PDF…

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

  • Script running a batch file from a button

    Hi Forum,

    I have a VB Script in a button.  The only thing it does is run a batch file to move files.

    the script runs manually but it doesn't do anything when i click on the button.

    I've tried the client & server options with no luck.

    The following…

  • Can I use table IM_ItemWarehouse to trigger script?

    Hello I was just wondering If  I can trigger a user defined script, with table IM Item Warehouse? I'm looking to trigger a script when there are changes on an item inventory. I see a field named Available on Item Maintenance > Quantity, I'm assuming…

  • SO Invoice Entry - Default qty ordered and shipped to 1

    I want to have all SO Invoice lines default to an order quantity of 1 and a ship quantity of 1 (currently the default is zero).  This is Sage 100 2019.  I wrote the following script and attached it as a post-validation event to the Item Code column, but…

  • Silent and Unassisted Removal and Deployment Sage 100v 2019

    Does Sage support silent removal and deployment for client installs? We are using Sage 100 v2016 and moving to a new server with Sage 100c v2019. Is there a way to deploy a script to uninstall the client on all the machines and reinstall a new client…

  • Script not working correctly.

    I have a script that is suppose to look at the date of last activity of a customer when a sales order is being written and if there is no activity for the last 720 days a message box is to pop up and let the salesperson know they are suppose to ask for…

  • Update GL_ActiveBatchComment Script Help

    Hello everyone, apologies if this has been asked before but I wasn't able to find something quite like this.

    We're on SAGE 100c 2018 v6.00.6.0

    I have a script I want to run on a table to update the batch comments based on a few conditions.  I…

  • Get to Lines object in PowerShell

    Hi Experts,

    am working on a data import into Sage 100 in PowerShell through BOI. It works fine. The one problem I have is to get to Lines Objects.

    In VBScript i used the following line to get a handle for the oLines object:

    Set oLines = oSession.AsObject…

  • CODE - Customer Maintenance

    I'm having issue trying to get into Customer Maintenance from Script.  This was working before, but has become an issue over the last week or so.  I don't remember changing anything.

    Maybe you can spot check me to see what i am doing wrong.

    Shell…

  • How to run two scripts after VI job across each invoice in batch?

    I have a VI Job that imports sales order invoices into a batch. I have scripting that does some zip code validations and then uses scripting to interact with 3rd party integration buttons that are installed (Vertex tax software). The scripts work perfectly…

  • Possible to use a lookup for a UDF validating against a UDT?

    Hello, 

    I have a UDF/script combo on sales order entry which requires the user to input a customer of type "A" into the UDF if the customer placing the order is of type "B". The values allowed are located on a UDT which I use the UDF to validate against…

  • Setting Fields Based on Checkbox Click

    Hello everyone, I'm trying to populate 3 UDFs based off a button click to approve a Receipt of Goods.  Here is the UI script I have linked to the button

    'Triggered to write the date/time/name to receiver UDFs
    approved=PO_ReceiptOfGoodsHeader_bus_UDF_RECEIVER_APPROVED…

  • Update the new UDF field for the existing Payment Header records with the CC last 4 digits

    Hi,

    We are working on a requirement, where we have to update the UDF field for the existing Credit Card Payment records with the last 4 digits of CC before the user clears off the CC details. I am trying to code the same in the VBScript, the Post Validate…

  • Scripting help - Contracting

    Forgive me if this is against the rules, but I'm trying to find resources to help create a script in SO_SalesOrder Entry. I used to reach out to a particular individual but they are not responding so I'm looking for other folks that could help.…

  • Print Sales Order with Button Script - Not Working for SO on Hold

    Scripting Experts,

    I am working on a SO Print Script that works fine for regular Sales Orders. But when I try to print a SO that is on hold, I get the following error message. Does anyone know if I have to (and how I would do it) set the Print Orders…

  • Copying the Date value into new date UDF on the Invoice Data Entry

    Hi 

    We have a requirement, where when a new invoice is getting entered in AP, using a VBScript copy the Invoice Date to a new UDF.

    I did try to put the same using the Post Validate event on the Invoice Date, but it's not copying the data into the new UDF…

  • Script to Generate Material Requisition

    I am having issues setting the Purchase Order lines with a GL Account code or key gathered from a SQL table. It doesn't matter what I try to pass, the system always defaults it to some obscure account code. All other fields I set work except for the GL…

  • Script to update child line

    I wrote a script sales order detail post write script that creates a child line that is a percentage of the parent line. If the updates the parent line quantity, unit price or extension the script updates the child line, BUT does not display the change…

  • Trying to set PO ROG batch as "Private" through scripting

    Hey all,


    I'm having a fun time trying to do a seemingly easy task.  We have a customer that would like to set all their PO batches to be private when they are entered, even when they are not selected to be when they are created.

    I figured I could set…

  • Script to check SalesOrder Detail & Update Salesorder Header

    Hello,
    I am using sage 2018 & am trying to create a script that works alongside scanforce. We received the oSalesOrder.nMBAutoAllocateSalesOrder() command from Scanforce to allocate orders with a VBS, but we're on our own in terms of creating the rest…

  • SO Line Script Not working

    Wrote a simple script for client that has a pop up if when entering SO, you forget to put in qty ordered on lines page and you try to go to the next line pop up says please enter qty ordered. The script works great on my install. Tried to install on client…

  • SO_InvoiceTracking Lines?

    I have a pre-write event script where I'm trying to loop through all  packages. When I try this I get an error that .Lines is not supported on that object

    Set oLines = oBusObj.AsObject(oBusObj.Lines)

    And because of what I just observed I guess I know…