Updating Database Values

You can use the Inspection Tool update values in the database. This example demonstrates how to alter the address1 property of a supplier:

1. Open the inspector from AP Supplier Maintenance, and select the property address1.
2. From the toolbar File menu, select Enter edit password.
3. Enter the edit password and click OK - the password changes daily - contact your Greentree partner for this password.
4. When the password is entered, a button will appear at the base of the form, which click to change the property value. Edit the value in the field, and click Save <property> to update.

Bulk Updating Database Values

You can bulk update objects by selecting the Edit all objects in data bucket option from the Inspector View menu, which opens the Edit Multiple Objects form.

Edit objects in data bucket

Select the data bucket that contains the objects you want to update.

that are of type

Select that type of object that you want to update. Objects not of this type are not updated.

Change property

Select the property you want to edit for selected objects.

to

Enter the property's new value.

Close and Edit Objects buttons

Click Edit Objects to perform the update, or Close to close the form without updating.

If any object fails to update, then none of the objects in the data bucket will be updated.