QuickBooks Online is a cloud-based accounting software that aims to help businesses manage and track their finances. To learn more about their platform, you can visit their website.
Using the Logicbroker-QuickBooks Online connector, suppliers can track their orders and manage their invoices through QuickBooks Online.
Orders submitted through Logicbroker will be created as estimates in QuickBooks Online. Suppliers can then log onto their QuickBooks Online account and use this estimate to create an invoice. Invoices will then be pulled into Logicbroker on a schedule and matched to the appropriate order. If you set up your inventory in QuickBooks Online with SKUs, we will pull your inventory into Logicbroker.
Tip:
By default, we will pull all invoices/inventory items that have been created or modified within the past 12 hours. They will be pulled using scheduled jobs, which will run every hour. Either of these configurations can be adjusted as necessary to suit your business needs.
ShipStation
With the ShipStation-QuickBooks Online connector, you can use Logicbroker to connect to both ShipStation and QuickBooks Online. In this flow, orders submitted through Logicbroker will be pushed into ShipStation. Then in ShipStation, you can push your orders to QuickBooks Online as invoices. Logicbroker will pull these invoices and match them to your orders.
Order Fields
When we create the estimate in QuickBooks Online, the following fields will be included if provided on the order:
Order Field | Description |
---|---|
PartnerPO |
This field will map to the custom field you created for the Logicbroker PO Number. If you did not set up a custom field, this will not be mapped. |
OrderDate |
Date of the order |
TotalAmount |
Total amount on the order |
Note |
This is a header level note, which maps to the CustomerMemo.value field. |
ExtendedAttribute.InternalNote |
This is a header level KVP, which maps to the PrivateNote field. |
CustomerNumber |
This maps to CustomerRef.value. To populate this field, we will first try to look up this value based on the company name in BillToAddress. If no customer is found, we will try to match BillToAddress.FirstName and BillToAddress.LastName to GivenName and FamilyName, respectively. If we still don’t find a customer, a customer will be created in QuickBooks using the data provided. |
BillToAddress |
The following fields will be sent if provided: Address1, Address2, City, State, Zip, and Email. |
BillToAddress.CompanyName |
This will be used to look up the CustomerId in QuickBooks Online. |
ShipToAddress |
The following fields will be sent if provided: Address1, Address2, City, State, and Zip. |
OrderLine |
The following fields will be sent if provided: LineNumber, Description, Quantity, Unit Price, and QuickBooks Item Id, which we will look up based on SupplierSKU for each line. Total amount per line will be calculated based on Quantity and Unit Price. |
Note:
If a customer is not set up in QuickBooks Online or has been made inactive, we will create a new customer based on the information provided in the order.
Comments
Please sign in to leave a comment.