"Permission Denied" when attempting to set the value SO Header UDF

Posted By mkaney over 9 years ago

I am on 4.3 and am using BOI in Access VBA to update some fields on Sales Orders (headers only). I have a UDF field for Sales Order shipping priority. UDF_Priority is a drop box field with a length of 20 with 3 options: Staging, Expedited, and Normal (default).

All the other fields update properly, but when it gets to this line, it fails with "Permission Denied"

bSuccess = objPVXData.nsetvalue("UDF_PRIORITY", rstSOList!priority)

I have verified that the value in the field rstSOList!priority is appropriate ('Normal'). What am I missing?

Parents

0 mkaney over 9 years ago

I am going to bump this post up because I really need to find an answer for this. We have an external custom interface for shipping and until I can prepare everything for a 4.5 upgrade where I can use event-based scripting to prevent people from getting around my post order entry script, I am dependent upon using BOI to update this field form outside the system.

Any ideas? anyone? Big Louie you must know!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 mkaney over 9 years ago

I am going to bump this post up because I really need to find an answer for this. We have an external custom interface for shipping and until I can prepare everything for a 4.5 upgrade where I can use event-based scripting to prevent people from getting around my post order entry script, I am dependent upon using BOI to update this field form outside the system.

Any ideas? anyone? Big Louie you must know!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Natasha Chang over 9 years ago in reply to mkaney

Try "UDF_PRIORITY$" since it is a string?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

"Permission Denied" when attempting to set the value SO Header UDF

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING