Sage 100

I've created a custom script to record changes made to the order status of a sales order through a generic shadow table format but I'm having issues getting the time to record properly in the UDF_TIME field specifically. I'm not sure what could be causing…

Hello, I am trying to update the vendor email address with a concatenation of some UDF email addresses that we have. I have used this same code to update UDFs, but I guess this is the incorrect syntax to update non-UDFs, but I can't figure out how to…

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…

Hello, I am a bit new to scripting on Sage and would like some assistance if anyone is willing. I am writing a script to update a UDF date field based on any change on the specifications Tab in Item Maintenance. I have attached my script below. I am…

Hi Forum, I cannot seem to find a way to update the AP_InvoiceRegisterWork table and AP_InvoiceRegister.upd. We have a Vendor that need to print checks to with different Names. One vendor hundreds of different Names the invoices need to be updated…

I created this script for sales order detail lines that works if I key a number into the backordered quantity field but does not work if I tab past the field with no entry. tmpQtyOrd = 0 tmpQtyBkOrd = 0 retVal = oBusObj.GetValue("QuantityOrdered…

I am trying to create a script that writes the current user key when the user prints the picking sheet. Has anyone done this before? My script doesn't appear to work and I am unsure which event I should use to accomplish. My code is below: retVal…

Hi Folks, my company has to changes prices on a number of items on a somewhat regular basis, every month or so. having someone open each sales order that those items are on to hit the "recalc" button is a huge time spend. is there a way to create…

Hello, I am trying to create a script to restrict users from entering a date too far into the future for invoice entries. I think I am close, but the date I am getting is in the wrong format, and is showing the date and the time. I have tried a few…

This script runs from a button on Sales Order DMAIN. The purpose is to update UDF values in SO Detail based on changes made in CI Item. I have tested the script with message boxes (not shown here) to verify that expected keys, line and Item Master values…

I have a UDF on JT_WORKTICKET that totals a UDF field for each item on the Parts tab of the Work Ticket. I would like to have that data populate a UDF on the Parent Item in the associated Sales Order. Screen shots attached. I can't find a means…

Hi All, Is there any way we can increase the decimal points from 2 to 4 of a numeric field or any standard field? Please help if anyone have an idea. Thanks,

Hi all, First script first post. Task is simple for one customer set freight amount field to negotiated amount that is based on the sales order total amount. Script is attached to pre-total event and it always works BUT only if sales order has more…

Not sure how to word this, but I'm trying to pull some values from PO_PurchaseOrderHistoryInqDetail_bus. The script runs with no errors (button script), but no data is returned. I have a working script that pulls from SO_SalesOrderHistoryInquiryDetail_bus…

I'm trying to write a button script that will copy a single line from a SO and "pull" it into the open PO. I've done this successfully for SO (copying from Invoice or SO/Quote History), but with PO, I'd like to be able to "tie" the SO and PO together…

I have the following script that pops up a message in Company Code HMC for users other than TAG when a certain UD is populated. Works fine.... retVal = 0 Set oUI = oSession.AsObject(oSession.UI) TRANS = "" USER = "" COMPANYCODE = "" retVal = oBusObj…

I have a script that works unless the field "UDF_EXCH_RATE" is zero. (default value is .000000) Where do I place the "if" statement to get it to work? tmpAmt = 0 : tmpExchange = 0 retVal = oBusObj.GetValue("ExtensionAmt",tmpAmt) retVal = oBusObj…

I've got a button script on Sales Order Entry that a user can enter an Invoice number and a line number, and the script will copy that line to the Sales Order. Everything is working great, except I can't seem to get "VendorNo" to set. I'm getting the…

I created a UDF on Salesorderhistoryheader table and need to populate it with the Payment type description form the AP_PaymentType Table. The payment type is a field on the SO_Salesorderhistoryheader table I know I have to write a script. I am quite…

HI I am new to scripting and am trying to create a script for a client that will bring in the extended item description into t

During our shipping process we scan all inventory from the pick sheet into shipping data entry. I like to create a process that using a UDF will track that the item the was scanned into shipping data entry. Example: Item A quantity 2 Item A we scan…

Here is what I am trying to do: basically UDF # 1 will have options A, B, and C. UDF # will have options A through Z. If opton A is selected in UDF #1 then the user will be able to select A-D in UDF #2, if option B is selected in UDF #1 then user will…

Hi, We have a script on Invoice detail which sets the Extension Amount on the line, the current trigger for this script is "Column-Post Validate" on "ItemCode". But when we generate invoices using AR Repetitive Invoice Selection, the script doesn't…

I have been using MAS since 1987, but have never used the above features. With the demands of customers lately I need to be able to email a variety of forms to multiple people within a company. Right now it is taking way too long to scan documents in…

Hi... I am trying to create a small message script that if I change a particular field in a customer maintenance task, a message will pop up that the customer does not have a record in the A/R repetitive invoice file and it cannot be changed. As it…