Getting Started

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.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.

Didn't find what you were looking for?

Submit a request