Quickbooks: How to Export Purchase Orders to Suppliers from DC

  • Updated

Follow these steps to export your Purchase Orders to Suppliers in a QuickBooks supported file format:

  1. Click Orders in the left side menu
    quickbooks-1.png

  2. Select QuickBooks File Export in the menu items that appear under Orders
    quickbooks-2a.png

    The Download Invoices / Purchase Orders to QuickBooks page will open:quickbooks-2b.png

  3. Configure the export settings as needed: 
    • Select "Invoices to Customers" in the Download menuquickbooks-3a.png
    • Next, define the invoices you'd like to export
      • if you'd like to export multiple Customer Invoices within a specific date range: Select the start date & end date you would like to export Customer Invoices from
        (You can only export one month at a time, so be sure to check these dates each time you export files to prevent duplicates in QuickBooks) quickbooks-3b.png
      • If you'd like to export just one Customer Invoices: Enter the DC Order Number in the Download Invoice / Purchase Order fieldquickbooks-3c.png
    • Select whether you'd like to use a Generic QuickBooks Item Number or the Original Item Number
      • We recommend you use "Yes - Uses 'DCITEM' as Item Number" to prevent QuickBooks from generating a new item number for each item shown on your invoices and to group all DC invoicesquickbooks-3d.png
      • If you'd like to use the exact DC item number, then select "No - Uses Original Item Number" and a new item will be created for each product within an imported invoice
        (Consequently your existing items could items be overwritten and you will eventually meet the limit for number of items that QuickBooks allows)quickbooks-3e.png
    • If needed, update the Accounts Receivable Account field to match your QuickBooks account (default is "ACCOUNTS RECEIVABLE")
      Note: This only needs changed if you use a different accounts receivable account within QuickBooksquickbooks-3f.png
    • If needed, update the Sales Account (Invoice line items) to match your QuickBooks account (default is "SALES")
      Note: This only needs changed if you use a different sales account within QuickBooksquickbooks-3g.png
    • If needed, update the Sales Account (Items added to item list) (default is "SALES")
      Note: This only needs changed if you use a different sales account within QuickBooks quickbooks-3h.png
  4. After configuring your export settings click Submit
    quickbooks-4.png

  5. On the next page, right click the QuickBooks icon
  6. Choose "Save Link As" 
  7. Save the .iif file to your computer so you can import it into your QuickBooks account later

quickbooks-7.gif

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request