Reporting & Reconciliation

There are 2 methods of reporting and reconciliation of the Invoices for C5 reporting:

1. Analytic Report
2. On-screen Inquiry

Analytic Report

1. Under the Analytic Report module, users can find the C5 Report option. Within this option, users can select the C5 Reconciliation Report (See Fig 1).
2. Users can specify a date range to list all invoices and credit notes with transaction dates that fall within the selected range. Then, click on Display: C5 Reconciliation Report.
3. A report will be generated (See Fig 2). This report can be exported in both PDF and Excel formats.
4. The report displays various transaction details, including a C5 UUID column, which contains the C5 Acknowledgement UUIDs.
5. If the C5 UUID column shows "Failed or not submitted," it means that the invoice was either not sent or failed to reach C5. In such cases, users should navigate to the Sales Management or Purchase Management module to locate the invoice, review the details, and resend it.

Fig 1

Fig 2

On-Screen Inquiry

1. This is an effective way to reconcile C5 report submissions.
2. Under the Sales and Purchase Management modules, click on the C5 Sales/Supp Trans Reconciliation option.
3. Select a customer (or All Customers), specify the date range, and click on Refresh Search. The transaction details will be displayed (See Fig 3).
4. In the C5 Ack UUID column, if the field is blank, it indicates that no C5 Acknowledgement UUID has been received, meaning the invoice or credit note was not successfully transmitted to C5.
5. To view more details, click on the transaction number under the # column. The full invoice details will be displayed (See Fig 3A).

Fig 3

Fig 3A