Scripting

Have 3 UDFs that are populating in SO Entry & SO Invoice Entry. CVP comes from Item Maintenance & it is a value added to unit price. CVPADD is the combination of of Unit Price & CVP. CVEXT is CVPADD * Qty Shipped. I can get the CVPADD to calculate in SO Entry & then CVPADD & CVEXT to calculate in Shipping Data Entry. I have Column - Post-Validates on each field they can change to get it to recalculate. Works fine. Then, if changes are made to fields in SO Invoice Entry, calculates fine. Issue is with bringing the SO directly into SO Invoice Entry. The Column - Post-Validates don't work when the SO lines are brought in & they say ""Yes"" to ship all items. I tried a Table - Pre-Write on the SO Detail, but then I get a Grid Handler error. Error attached. I tried Table - Post-Read & Table - Set Default Values, they do nothing. Tried Column Post-Validate on Item Code, only works on new items added, not ones pulled from SO. Script attached.

Did you try a column post validate on the quantity shipped in invoice data entry ?

Yes, I have one there so when they ship in Shipping Data Entry it works. If they say ""No"" to ship all items in Invoice Data Entry & then manually enter the qty shipped, it works. Just doesn't work when saying ""Yes"" to ship all items.

I would probably throw some DebugPrints in there and see if the script is actually running or not when an SO is selected. I say that because I wonder if the script is running but the GetValues are getting 0 since the field hasn't been written to disk yet.

I used the same script as a table pre-write on the SO_Detail and it works fine. No error 81

Hmmm, my test system on my personal computer gives same error as the customer's system. Wonder what is different than yours?

Maybe its a version difference? I was testing it on 5.20 PU1

Nothing in your script should have involved the user interface (UI). Do you have programatic modifications to the custom office panel by a third party?

Not sure if you found a resolution to this but I noticed that an error 81 under custom office was referenced in the PU release notes today. Page 6 http://community.90minds.com/2015/06/29/sage-issues-product-updates-for-sage-100-erp-versions-2014-and-2015/

I haven't resolved yet but I will know I am running it on 2014 so this may help. Thanks Nicole

I installed PU6 on my test version & I no longer get Error 81. I am going to try on the client's as well, but seems to be the fix. If it is, glad to know it wasn't my script! Thanks for the help @NicoleRonchetti !