You can import A/R data from QuickBooks into X Dispatchthe Operations App. This is also used when setting up and using credit limits for customers. See How to Set Up and Use the Credit Limits Feature.

Exporting from QuickBooks

The configuration of the export done in QuickBooks is important for a successful import into X Dispatchthe Operations App.  Once a payment has been applied in QuickBooks to the customer(s) you are updating in X Dispatch the Operations App take the following steps to export the file: 

1. In QuickBooks navigate to Report > Customers & Receivables > AR Aging Detail.
2. Open Customize report and select the Filters tab.
3. From Filters select Account.
4. From the Filter choices select Paid Status.
5. From Paid Status click the Either radio button.
6. Select OK which will close the window.
7. From the menu select Memorize then enter in a name to save the filter with and click OK. 
8. With the A/R Aging Detail form is still open, click the Excel drop-down button.
9. Select Create New Worksheet.
10. Export the comma separated CSV file with a File Name of your choosing.

Use this memorized report with the set Filters to export each time for use in X Dispatchthe Operations App.    

Importing to

the Operations App

1. In the main X Dispatch menutop menu, go to Action > Import A/R Data.  

   DivImage Modified
2. Select the file to be imported and click Open. 

3. When the "Import complete" popup displays, click OK to close the window.

   div

   Image Modified
   

   
   

The newly imported A/R data will be queued to be updated according to the specific interval set in the Credit Calculations X Stream Definition. Once the X Stream Definition is run, the Outstanding Invoiced aging data is updated inside the customer record. 

For assistance updating the X Dispatch the Operations App queue interval, please contact Customer Support.