The QuickBooks Node in n8n functions adequately but lacks several essential features.
Each QuickBooks component should support basic CRUD operations—Create, Retrieve, Update, and Delete.
Bills:
While the Bills feature is functional, it lacks the ability to assign a Bill Number during creation. In our workflow, the Bill Number corresponds to the invoice to be paid. Currently, we must create the bill and then update the Bill Number separately. Since the Bill Number is accessible via the QuickBooks API and retrievable through n8n, this functionality should be integrated.
Customers and Vendors:
The current setup does not permit deleting customers, which is understandable. However, it should allow toggling customers’ active status. The same applies to vendors. The ability to delete would be beneficial for testing purposes; without it, databases become cluttered with inactive vendors and customers.
Invoices and Payments:
These functions operate correctly. However, there is a need to upload Credit Memos, not just Invoices. Since negative invoices are not permitted, issuing a Credit Memo against a customer is necessary. Similarly, issuing a Vendor Credit, akin to a negative bill, is required. Although QuickBooks supports these features, the n8n node does not currently accommodate them. In our system, we create a negative Purchase Order, but since QuickBooks doesn’t accept negatives, this functionality is essential.
Current Testing Workflow:
We are transferring sales data from our MySQL databases into QuickBooks Online using n8n to manage General Ledger, Accounts Payable, and Accounts Receivable. We can then update Mysql once someone pays or is paid in QB. However, the process is incomplete due to the absence of the four functionalities mentioned above.
These basic features are crucial for anyone utilizing the QuickBooks Online API. The system is efficient once you adapt to creating a customer or vendor, retrieving the ID, adding it to an invoice, and then uploading it.
Willingness to Contribute:
I am prepared to work on enhancing these features. With initial guidance, I can take over the development. I require documentation to get started. My attempts to understand the process have been challenging, and previous modifications yielded no results. Is there comprehensive documentation available on creating nodes from scratch and understanding the overall system architecture?
Your assistance in this matter would be greatly appreciated.