SO Invoice Entry - Default qty ordered and shipped to 1

Question

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 it returns an error 88 invalid/unknown property name every time I try it. 
 Here is the script: 
 ' bws 7/24/2020 ' Set Variables OrderQty=0 : ShipQty = 0 ' Set session object Set oUI = oSession.AsObject(oSession.UI) ' Get values from current object (SO_InvoiceDetail_Bus) retVal = oBusObj.GetValues ("QuantityOrdered", OrderQty, "QuantityShipped", ShipQty) ' Test for zero if OrderQty = 0 and ShipQty = 0 then retVal = oUIObj.SetValues ("QuantityOrdered", 1, "QuantityShipped", 1) end if

Kevin M · Answer

I've scripted a default quantity and had pop-up errors for charge lines and comments (so I had to add an ItemType filter). Interesting that Advanced Field Settings bypasses those checks.

David Speck · Answer

You should refer to the online File Layouts and Object Reference. 
 https://help-sage100.na.sage.com/2020/FLOR/ 
 Although there is a GetValues method that exists in the SY_Service class, it doesn't work the way you think. 
 https://help-sage100.na.sage.com/2019/FLOR/#Object_Reference/SY/SY_Service.html?Highlight=getvalues 
 It accepts two arguments. The first is a comma delimited string of columns, the second would be a variable initialized to a blank string. It will return the comma delimited values for each column passed in the first. This works on a single record. 
 SY_Maint does have a SetValues method which is similar but you pass the comma delimited columns in the first argument and the comma delimited values in the second argument. 
 https://help-sage100.na.sage.com/2020/FLOR/#Object_Reference/SY/SY_Maint.html?Highlight=setvalues

TomTarget · Answer

Go to custom office | user defined field and table maintenance and right click on the so_invoice_detail table and select advanced field settings. Click on the PLUS, select your quantity ordered field and set the default value to 1. 
 No scripting required.

Sage 100

SO Invoice Entry - Default qty ordered and shipped to 1

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING