Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

script on SO Invoice Qty shipped after "Ship Complete"

Posted By KathyW over 5 years ago

running Sage 2018 sp3.

I have this script running on quantity shipped in SO Invoice Data Entry.

tmpQtyShip=0
tmpGrWt=0

retVal = oBusObj.GetValue("QuantityShiped", tmpQtyShip)

retVal = oBusObj.GetValue("UDF_GROSS_WEIGHT", tmpGrWt)

retVal = oBusObj.SetValue("UDF_EXT_GRWT",tmpQtyShip*tmpGrWt)

It works great unless you select the prompt to "ship complete" when moving to the Lines tab in Invoice Data Entry.

Then nothing calculates.?

How do I set this to calculate after the quantity has been populated by "ship complete"?

Thanks in Advance

Top Replies

Alnoor over 5 years ago +1

Kathy - When you answer Yes or No to Ship Complete, the CopyLinesFromSalesOrder() method/function runs. It does not itself do a SetValue on Quantity Shipped ergo your script doesn't fire off. But I…

0 Alnoor over 5 years ago

Kathy - When you answer Yes or No to Ship Complete, the CopyLinesFromSalesOrder() method/function runs. It does not itself do a SetValue on Quantity Shipped ergo your script doesn't fire off. But I believe it writes the line using the Write() method/function of the object, ergo a PreWrite or PostWrite script on the line would fire off. I'm pretty sure same is true with PO ROG / ROI Entry.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 David Speck over 4 years ago in reply to Alnoor

I can confirm that in that scenario, you will also need the script to be triggered on the detail pre-write event.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

script on SO Invoice Qty shipped after "Ship Complete"

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING