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 Period | Allows the user to select the reporting period from a list of options or set a custom date range. |
Layout | Set to the Default layout. Allows selection of saved layouts, if any. |
Save Layout As | Allows saving a layout for potential future use. |
Reset Layout | Resets 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 Number | Identifier for DEAR item |
Xero Number | Identifier for Xero item |
Sync date | Data of synchronization |
Sync status | Sync status, can be Failed, Pending, Skipped, Completed. |
Type | Type of item. Can be:
|
Consolidated Invoice/Credit Note # in Xero | Only for Xero consolidated invoices/credit notes if applicable. |
Payment Account | Payment account name in DEAR if applicable. Only applicable to payments, refunds, customer credits, and supplier deposits. |
Document Link | Link to document for which payment is applied. Only applicable to payments, refunds, customer credits, and supplier deposits. |
Effective Date | Date of transaction in DEAR |