Import sales orders into QuickBooks Enterprise

Overview

Cin7 Omni Sales Orders can be imported into QuickBooks Enterprise as Invoices, provided the following three conditions are fulfilled:

The total of the Sales Order is greater than 0, and
An invoice date has been entered in the Sales Order.
The invoice date is not more than 90 days old.

We recommend importing contacts before importing Orders. This means that any new contacts in Cin7 Omni can be matched to existing contacts in QuickBooks Enterprise correctly.

QuickBooks web connector

Before you can import anything into QuickBooks Enterprise you must first run the QuickBooks Web Connector, if you have not already done so recently.

Make sure you are logged into the correct QuickBooks Enterprise account.

NOTE: If you are logged into the wrong account Cin7 Omni will still write files to this account - so be careful!

In QuickBooks Web Connector, select Cin7 Omni from the list of connections, then select Update Selected.
In Cin7 Omni, from the left navigation, select Accounting, then QuickBooks Enterprise app.
Select Refresh After Running QuickBooks Connector.

Import sales orders

There are two ways to import Sales Orders into QuickBooks Enterprise: Importing all orders at the same time, and importing individual transactions.

All orders at once

This method will import all Sales Orders at the same time. This is the quickest way to import all orders.

From the left navigation, select Accounting then QuickBooks Enterprise.
Select Import Contacts to update or import any new contacts.
For more information, see Importing Contacts and Vendors to QuickBooks Enterprise.
Select Import Orders.
A confirmation will notify you if all orders have been imported successfully.
Run QuickBooks Web Connector.

Imported Sales Orders will be available as Invoices in QuickBooks Enterprise.

Individual orders

You may wish to only import one Sales Order, or inspect the order, before importing. To do this:

From the left navigation, select Accounts then QuickBooks Enterprise.
Select Import Contacts to update or insert any new contacts.
For more information, see Importing Contacts and Vendors to QuickBooks Enterprise.
Select Choose, next to Import Orders.
The number in brackets represents the number of orders awaiting import.
Check the specific Sales Orders you would like to import.
Select Import/Update Orders.
Run QuickBooks Web Connector

Imported Sales Orders will be available as Invoices in QuickBooks Enterprise.

FAQs

Is it possible to automate order imports?

Automatically importing orders is not currently supported. Manually selecting the button for each order(s) adds a level of scrutiny that encourages good accounting practice.