Quickbooks UI

Duff made this app to do things to a Quickbooks files without using the craptastic Quickbooks Interface.

How to use the Quickbooks UI

Tip

Make sure you make a backup copy of the Quickbooks Company File before you begin

1. Make sure Quickbooks is logged in as an Administrator and in Multi-User Mode
2. Open Quickbooks UI
3. Select the correct company file
4. Hit the 'browse' button next to 'XML Definition', navigate to where you put the XML file, and select the XML file (qbxmlops[7-8]0.xml)
5. Hit the 'browse' button next to 'Quickbooks File', navigate to the customer's Quickbooks Company file, and select it

Search for things in Quickbooks

This is usually the first step in doing something useful with this utility.

1. Select the "single request" radio button.
2. Select the appropriate message to be sent from the dropdown.
   1. InvoiceQueryRq will give you information about Invoices in Quickbooks
   2. CustomerQueryRq will give you info about Customers in QB
   3. etc
3. Select the parameters in the bottom list that you want to use to search for items in Quickbooks. You don't have to select any - if there are none selected, Quickbooks will bring up all of them. In most company files, this will take forever (rounded up).
4. Fill in the parameter values that you want to use to search. Dates must be in the format YYYY-MM-DD. Some parameters can only accept certain predefined values. Sadly, to see what those values are, you must read the comments in the XML file.
5. Click on the 'Send to QB' button to send a query to Quickbooks and populate the top list.

Fiddle with things in Quickbooks

Generally, people use the Quickbooks UI tool to fiddle with a bunch of stuff in Quickbooks at once.

1. Select the "Respond to Checked Items" radio button
2. Select all of the quickbooks items that you want to do something to. A message will be sent for each checked item.
3. Select the message that is appropriate for the action you want to happen
   1. TxnDelRq deletes transactions
   2. CustomerModRq modifies a customer
   3. ...and so on. Some things are named more sensibly than others
4. Fill in the relevant parameters in the bottom list. You WILL need to fill in at least one parameter to let it know what object in Quickbooks you are talking about.
   1. You can refer to the value in the top list with the syntax {?FieldName} - for example {?ListID} or {?TxnId}
   2. As with some of the request messages, some of the parameters only take special values. Your options are described in the XML file comments.
5. Hit the "Send to QB" button and grab a cup of coffee while stuff happens.

Tip

If you get an IDispatch Error #512 that means something went wrong with the parameters you gave. Try to be less wrong!