QuickBooks Integration Complexities

Overview
The linkages between QuickBooks objects are typically complex. The Following explains one of those scenarios.

The objects are:

1. Bill
2. Vendor Credit (termed as “Bill Credit” in QuickBooks)
3. BillPaymentCheck
4. BillPaymentCreditCard

The Process
For testing purposes, a vendor named “New Vendor” is created in QuickBooks. Bill (99119911 of amount $1000) and Vendor Credit (11991199 for amount $400) are created for this vendor. Then a payment is made for this bill vendor based on the vendor credit.

This is how it looks it QuickBooks.

Now, let us see what is returned from the QuickBooks SDK for this data for each of the object calls.

The above XML is a part of the response that is received in the Bill request. It has the Vendor Credit and the BillPaymentCheck information.

This XML is a part of the Vendor Credit information received from the QuickBooks. It has the information about the bill with which it is linked and the affected amount.

This is the original BillPaymentCheck information that shows the bill, bill’s reference number and the check amount.

This object behaves exactly like BillPaymentCheck. As there is not Credit card payment made now, this is not shown.

Conclusion:
Bill behaves as the master object that has all the information pertaining to the bill and its applied transactions.

Following can be inferred:

1. Bill has Vendor Credit and BillPaymentCheck Information.
2. Vendor Credit has the related bill information.
3. BillPaymentCheck has only the Bill Payment information.