Have you ever thought about automating repetitive QuickBooks accounting tasks through Delphi or C++ Builder?
If yes, this post helps you to quickly get started with QuickBooks automation development.
As a reminder, QuickBooks is accounting software for businesses.
With the software QuickBooks components, you can easily connect to your QuickBooks and can automate accounting with your programming skills.
What is QuickBooks Connectivity Component?
The QuickBooks Integrator provides easy-to-use components for QuickBooks development, facilitating tasks such as adding, updating or retrieving customer information, vendor information, employee information, transactions, etc. The QuickBooks Integrator helps you access QuickBooks remotely with the included QBConnector Component or the free Remote Connector for QuickBooks utility.
QuickBooks Connectivity Component Features:
- Uniform & Extensible Design
- Fully Integrated Components
- Blazing Fast Performance
- Detailed documentation and hundreds of sample applications to start
- and more
Supported Platforms
- Delphi
- C++ Builder
- and more
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
procedure TFormBillpayment.btnPayBillsClick(Sender: TObject); var i: integer; begin iqbBillPayment1.Reset(); for i := 0 to lvwBillsToPay.Items.Count - 1 do begin if lvwBillsToPay.Items[i].Checked then begin iqbBillPayment1.AppliedToCount := iqbBillPayment1.AppliedToCount + 1; iqbBillPayment1.AppliedToRefId[iqbBillPayment1.AppliedToCount - 1] := lvwBillsToPay.Items[i].SubItems[4]; // For simplicity, pay the full amount iqbBillPayment1.AppliedToPaymentAmount[iqbBillPayment1.AppliedToCount - 1] := lvwBillsToPay.Items[i].SubItems[2]; end; end; iqbBillPayment1.QBConnectionString := qbConnectionString; iqbBillPayment1.PaymentMethod := TiqbbillpaymentPaymentMethods(cbMethod.ItemIndex); if (rbToBePrinted.Checked and rbToBePrinted.Visible) then iqbBillPayment1.IsToBePrinted := true; if (rbAssignNumber.Checked and rbAssignNumber.Visible) then iqbBillPayment1.RefNumber := txtCheckNumber.Text; // The references to accounts and vendors in Quickbooks use IDs in place of // names. Because these values are unique, Quickbooks can access them faster. iqbBillPayment1.PayeeId := vendorIDs[cbVendor.ItemIndex]; if iqbBillPayment1.PaymentMethod = pmCheck then iqbBillPayment1.BankAccountId := accountIDs[cbAccount.ItemIndex] else iqbBillPayment1.CreditCardId := accountIDs[cbAccount.ItemIndex]; try Screen.Cursor := crHourglass; iqbBillPayment1.Add(); ShowMessage('Bill payment ' + iqbBillPayment1.RefId + ' added successfully.'); RefreshBillsToPay(); except on ex:EiqbBillPayment do ShowMessage('Error entering bill payment: ' + ex.Message); end; Screen.Cursor := crDefault; end; |
With the use of Windows IDE, you can easily connect QuickBooks With Enterprise-Grade Integration in Delphi or C++ environments. Try your Free Trial here.
Design. Code. Compile. Deploy.
Start Free Trial Upgrade Today
Free Delphi Community Edition Free C++Builder Community Edition
Hi Muminjon,
I know this is a older post, but I’m very interested to know if the QuickBooks Integrator is still a viable solution? I can’t find it on Embarcadero’s sites, but wondered if your knew if the component still exits?
Hi Paul, unfortunately CDATA took the decision to stop providing FireDAC native connectors in their product line. They do however have ODBC connections which work fine with Delphi, C++ Builder and RAD Studio. You can find them here: https://www.cdata.com/odbc/