Datto Autotask PSA: QuickBooks Desktop - Can I remove items from inventory when I transfer to QuickBooks?

Follow

Question

Can I remove items from inventory when I transfer to QuickBooks?

Environment

  • Datto Autotask PSA: QuickBooks Desktop

Answer

Yes, you can remove items from inventory when transferring to QuickBooks.

If you track inventory in QuickBooks only and would like to update the On Hand count when an Inventory Part is transferred on an Autotask invoice, you must do the following:

  1. Enable the Decrement from Inventory when transferring invoices containing ticket/project/contract charges to QuickBooks system setting
    • Leave Decrement checked/on if you are not using the Autotask to QuickBooks Synchronize Inventory feature.
  2. When transferring an invoice that contains items from Inventory Part in QuickBooks, the inventory is decremented in QuickBooks.
  3. Do not clear the check box unless:
    • Your company tracks inventory and uses the Autotask to QuickBooks Synchronize Inventory feature to synchronize the Autotask inventory counts to QuickBooks.

Note: When this check box is unchecked, the integration will transfer items to QuickBooks based on item description instead of the associated billing code used in QuickBooks mapping."

Map the Autotask Product to an existing QuickBooks Inventory Part before the item is transferred from Autotask for the first time. To map products to an Inventory Part, do the following:

  1. Open the QuickBooks Item List and set up an Inventory Part with a name identical to the product name in Autotask. The QuickBooks Item List will show the new Inventory Part.
    • When transferring an item on to an invoice, Autotask checks if another object with the exact name already exists within the QuickBooks Item List.
      • Autotask does not check for the QuickBooks Item Type. The transferred billing item will become an Inventory item if the object exists within QuickBooks but as an Inventory Part. The inventory item is assigned the same name, and any inventory on hand reduces by the item quantity.
    • When running an updated Inventory Valuation Detail report, the number of units on hand is reduced by one.

When running an updated Inventory Valuation Detail report, the number of units on hand is reduced by one.

Important to remember: It is not possible to push Quickbooks inventory into Autotask. If you are counting Inventory in both and syncing the numbers, Autotask will have to be your master System of Record. You will need to update Quickbooks Inventory On Hand Counts using the Purchase Order Transfer and the Inventory Sync. Both of which will always overwrite the Quickbooks number with the Autotask number.

Additional Resources


Was this article helpful?

0 out of 0 found this helpful

You must sign in before voting on this article.

Want to talk about it? Have a feature request?

Head on over to our Community Forum or get live help.

For more Business Management resources, see the Datto RMM Online Help and the Autotask PSA Online Help .

Datto Homepage