search-icon

During synchronization with Xero, items could be imported to Xero but ultimately have status skipped, pending, or failed. This will cause an information discrepancy between DEAR and Xero. This report allows the user to see discrepancies where data in DEAR has not been imported to Xero. 


The report contains the following data types with Failed, Pending, Skipped, or Completed status:

  • Attachments
  • Contacts
  • Credit notes
  • Customer credits
  • Invoices
  • Payments (payments and refunds)
  • Supplier deposit
  • Manual journals
  • Money tasks
  • Products


NOTE: Payments for consolidated invoices cannot be imported to DEAR. You will need to manually apply a payment in DEAR to the imported consolidated invoice. 


This report is only available to users with Financial Reporting permissions. 


Prerequisite

Input:

Reporting PeriodAllows the user to select the reporting period from a list of options or set a custom date range.
LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving a layout for potential future use.
Reset LayoutResets the layout to the default layout or selected saved layout.


Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing DEAR Reports - Filtering Reports for more detailed information about using filters. 


Output:

The following output fields are available for this report. 


Fields
DEAR NumberIdentifier for DEAR item
Xero NumberIdentifier for Xero item
Sync dateData of synchronization
Sync statusSync status, can be Failed, Pending, Skipped, Completed.
TypeType of item. Can be:
  • Credit note
  • Customer credits
  • Invoices
  • Payment 
  • Refund 
  • Supplier deposits
Consolidated Invoice/Credit Note # in XeroOnly for Xero consolidated invoices/credit notes if applicable.
Payment AccountPayment account name in DEAR if applicable. Only applicable to payments, refunds, customer credits, and supplier deposits.
Document LinkLink to document for which payment is applied. Only applicable to payments, refunds, customer credits, and supplier deposits.
Effective DateDate of transaction in DEAR


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.