Jump to content

Recommended Posts

I have a script that updates a Vendor record in QuickBooks Enterprise Solutions: Contractor 20.0.  When I developed the script I believe that they were on version 19.    I was doing some work on this yesterday and noticed that the update is now getting a 3190 Error.  Meaning: Cannot clear required Element  Explanation: Cannot clear the element in the fieldName field.

The script either re-writes the current value or updates the value in the VendorMod::Name field.   This was working.  The script step is PCQB_RqAddFieldWithValue( "Name" ; Vendor::VendorName ).

Should I be able to update this field?

This is not a show stopper.  We can edit the field if required in QuickBooks and update everything else via script.

 

Link to post
Share on other sites

Hello Bruce,

If you are trying to update the vendor's name, you should try updating the FirstName and LastName fields instead of setting the Name field. Name field changes likely will affect the way things connect via fully qualified FullName. 

Hope this helps!

-PCIPal

Link to post
Share on other sites

Hey Bruce–

You can update the "Name" value for a Vendor record, but cannot set it to empty (clear it) because it's effectively the Vendor record's primary key in QB. For the same reason, you cannot update it to a value that's already in use by another Vendor record.

The error message you cite implies that this record's Vendor::VendorName field was empty at the time you created the VendorModRq.

HTH!

Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC 28105
704.814.6852

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.