Sage 100

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…

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…

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…

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…

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…

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…

When viewing a multi-line field within DFDM I noticed that one of the UDF fields within the current table (AR_Customer) had a Nomads Tag that suggested I may be able to possibly manipulate a different multiline field to perform a lookup within a UDT.…

Experts, I created BOI script that pulls picked orders from a SQL server and creates Shipping Data Entries for these orders. The data originates from the Sage Sales Orders and I have all necessary information available. Here is the issue that I am running…

I created a button on the Vendor Maintenance screen that runs the AP Aging report. I pass in the AP Division and Vendor numbers, but I can't get the report to filter by those values. (Want to run the Aging for the Vendor displayed, like the Sage button…

Hi All, I am very new to VB Scripting and BOI in Sage scripting, Is there any training material or certification which is recommended for the newbies, please advise and recommend. Thanks AJ

Hi I have a business requirement, where we have a Date Field1 and Date Field2 , while entry of the details data, Field1 will get the date auto defaulted from the header date field. And Field2 will be blank . Later when there is an update on the Date…

Is it possible to write data into different company within some Sage 100 company. For Example add a button on Sales Order Entry to copy order to secondary company. I know how to do it outside of Sage with a script but not sure if session to different…

Hello all, I have a button script on repetitive invoice header which will pulls out a UDT. But what I want to do is not just pulls out the UDT, (cause it will show all the datas) but also filter the UDT values that shows only for this particular customer…

Hello, I have a script on cash receipt header table, post-write, will bring cash receipt header and detail to a UDT. It is working fine, EXCEPT, If there is more than one lines in the detail, it will only return the last line to the UDT. Only showing…

I have created a script, and it does not seem to work. Do I put it under column validation, or some other mode. Here is the script. Retval=0 rExtcost rExtamount=0 rQtyship=0 rUnitcost=0 rLineGM=0 Set oLines = oBusObj.AsObject(oBusObj.Lines) oLines…