Initiating data transfers

NAVIGATION   > Contracts > Invoices & Adjustments > Invoicing / Items to Invoice

1. On the Process Selected Invoices page, invoice transfer to QuickBooks is initiated by selecting Mark the invoices as ready to transfer to QuickBooks as the processing option.

NOTE  Any Invoice Notes you enter will not be transferred to QuickBooks.

2. Click Process Invoice. A dialog box will open.
   
   You can wait until the processing is complete and the Autotask invoices will appear, or open each batch later from the Invoice History. Refer to Managing invoices from Invoice History.

The invoices are ready to transfer anytime after the invoice batch has finished processing.

NOTE   Invoices will be transferred even if the customer is inactive in QuickBooks.

IMPORTANT  If an invoice was set to be emailed, but the QuickBooks customer record did not have an email address configured, the legacy integration used to prompt you for an email address. The Web Connector integration is automated, not interactive, and we are unable to prompt you for an email address. The invoice will fail to transfer. The reason for the failure can be viewed in the Transfer history pages.
The email settings are configured on the View Invoice Settings page for an organization. Refer to Invoice Emailing. Make sure that the corresponding QuickBooks customer has a valid email address.

• If you transfer an invoice from Autotask and a duplicate QuickBooks invoice number exists for the same customer, the Invoice Paid Date is not updated in Autotask, since the transferred invoice is considered a duplicate.
• If you transfer an invoice from Autotask and a duplicate QuickBooks invoice number exists for a different customer, the Invoice Paid Date is successfully updated in Autotask, because we can check the QuickBooks customer ID to identify the correct invoice.

To be eligible for transfer, the following item statuses are required:

• Invoices cannot have been voided, have caused a transfer error before, or have a negative invoice total.
• Timesheets must have a status of Approved.
• Expense reports must have a status of Approved for Payment, and not have been transferred previously.
• Purchase orders must have any status except Canceled.

NOTE  If an invoice is paid via Payment Processing in Autotask, it can be transferred, but the Paid Date is locked in QuickBooks.

Items that can be transferred to QuickBooks are managed using the QuickBooks Transfer Status and the QuickBooks Transfer Date fields. The following QuickBooks Transfer Statuses are available:

To find items to transfer to QuickBooks, do the following:

1. In the Search Filter section, select the QuickBooks Transfer Status and the QuickBooks Transfer Date filters. In the table Column Chooser, select QuickBooks Transfer Date.
2. Select a QuickBooks Transfer Status of Not Transferred.
3. Use the context menu and select Set as Ready to Transfer to QuickBooks (for individual items), or check the boxes for selected rows and select Set Selected as Ready to Transfer to QuickBooks from the bulk menu.
   

IMPORTANT  Invoices with negative totals cannot be transferred to QuickBooks. The Set as Ready to Transfer to QuickBooks is not available.

4. To keep pending records from being transferred, you select Set as Not Ready to Transfer to QuickBooks.
   
5. For items that have not yet been transferred to QuickBooks, select Set as Ready to Transfer to QuickBooks from the context menu.

The selected items will show Pending in the QuickBooks Transfer Date column. These, and any that have a status of Pending/Failed, will be transferred the next time the web connector is run.

QuickBooks will terminate a transfer if either of the following conditions occur:

• The purchase order contains items that have already been manually received in QuickBooks.
• The purchase order contains multiple items that have the same product name.

When QuickBooks encounters either of these situations, it fails to process additional transfer items. All items processed previous to the problem items will transfer successfully.

As best practice, do not attempt to transfer purchase orders with these conditions. If your transfer should terminate, and the Purchase Order Transfer History log indicates the "field has an invalid value", please check for these conditions before contacting Kaseya Helpdesk.

If you transfer a purchase order to QuickBooks and then receive PO items against the purchase order in Autotask, the PO QuickBooks Transfer Status is automatically updated to Pending. Any inventory received against the PO is synced to QuickBooks during the next purchase order sync.

You can display two columns that help you manage updated POs:

• QuickBooks Transfer Date. This column shows both the original transfer time stamp and a Pending status.
• QuickBooks Needs Resync. This column shows a check mark when the inventory was received against the PO that needs to be synced to QuickBooks.

If you need to edit (other than receive inventory) and resend a PO that was already transferred to QuickBooks, do the following:

1. Delete the purchase order in QuickBooks
2. In Autotask, open the purchase order and delete the External P.O. # value.
3. Re-transfer the purchase order.

When a purchase order is canceled in Autotask after it has been transferred to QuickBooks, the corresponding QuickBooks PO will be deleted the next time purchase orders are updated or transferred.