Sage 100

On apparel items sizes XS-XL are usually one price and XXL and up are another price. I am trying to visualize a script that could handle updating the "standard cost" based on the "lot/serial" selected, that way the PO cost will automatically match the…

Since the default customer price level is only 1character, I'm considering making a UDF and then having SO and SOI reference that column to populate the price instead of the default column. I haven't played with Custom Office since I haven't really…

Trying to add a UDF to the PO Header and make it available to export to an Access DB. I added the UDF but having a hard time figuring out which other table I need to add it to to make visible in the DB.

I added a UDF in the Transaction Entry Header but its not really showing in the History file. Is there a way I can get that in the History? Thanks,

I've done a little work with User-Defined Tables (UDTs), but I've read they have limitations: Single-column primary keys and no support for indexes. If I want to use tables that don't have these limitations, what is the correct approach? I come from…

Are we able to write on the Production table from the Sales Order Entry UI? I have items that based on the S/O Entry need to be put on a Production Entry so was wondering if after they are entered in the SO and the Picking Sheet is printed, I can write…

Are we able to make a UDF that is a dropdown list for the Lines Entry? I have some in the Header and they work fine but in the Lines it just shows as a Multiline field except if you type something that is not in the validation list a popup shows up…

Having added a UDF to the AR Invoice history Called Enhatch order Id. When trying to print a copy of an invoice from this record the UDF does not print and it has been added to the form. Any ideas as to what link I am missing? To see the invoice printout…

Hi Forum, I added a Qty UDF to calculate the QTY Ordered. The price shows correctly but the Extension Amount doesn't get added to the Total Amount of the Lines. Any idea of what i am missing, do i have to do some kind of refresh for the Total to…

I have a button script running in Item Maintenance which is querying extended description text successfully, but the SetValue doesn't work (in v2017 and v2020). I'd expect the business object to automatically create the extended description key / record…

I have a UDF on SO_Detail table I'm attempting to populate with a BOI script (written in C#). This field is set to datetime type, the data I'm sending is being parsed from string to datetime format in the script. I'm sending the SalesOrderNo, user credentials…

Hi, Below is my script to Prompt user a warning that when user entering invoice data entry, it will check a udt for blanket PO is out of fund. I've create User Define Table to keep track of a listed PO and Billed Amount. The script is reading invoice…

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…

1. Is there a way to delete all the Rollup Codes from the Rollup code table all at once so that I don't need to delete them one by one? 2. Is there a way to delete all the codes from a User Defined Table all at once so that I don't need to delete them…

Hi Forum, I need to create a UDS to update a UDF in the M Item Warehouse table. I am having trouble looping thru the warehouses. It works fine with the default warehouse. Any ideas ? Here is the script that i am using for the one warehouse. …

I would like a field in the AR Customer file to be updated when the Cash Receipts Journal updates that customer. I set my script to trigger on update of "Last Payment Date" which I know gets updated when you update the cash receipts journal. If I…

I have created the same udf in sales order detail and SO invoice detail entities. Both same type - string - and same size (20). In the data source from SO invoice detail I have selected "copy from sales order and for data source I have selected SO_SalesOrderDetail…

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…

I am trying to add some UDF's to the PO Receipt of Goods Multi-Bin Distribution panel. I added the fields to the proper areas. When on the PO Receit of Goods Entry screen I enter the batch and entry #. Then select the PO. On the Lines tab I enter the…

I'm using "sage 100 Standard 2019" and Version "6.10.0.0" In Miscellaneous Item is there "Qty On Hand", "Qty On Po" and "Qty On So" option?

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…

I'm running into an issue that seems to only happen after selecting BM Options for an Item. I have a UDF in SO Details that I would like to save a value. I am firing the script on Table-Post-Write. Here is the setValue part of the script: retVal = oBusObj…

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…

Hi Forum, I have a script that is updating a AR_Salesperson table UDF when a UDT field is updated. The process fails when updating the AR_Salesperson table. I am getting a "Module P?R not in file" message. I've seen this message before but I…

Hi Forum, I have a script that populates a UDF in sales order lines from 2 UDFs in the lines after the lines are entered... if I trigger the event as Pre-Write it doesn't do anything.. but the same script I can trigger in a field as column post…