Reporting & Reconciliation: Difference between revisions

From HelpWiki Highnix
Jump to navigation Jump to search
No edit summary
 
(3 intermediate revisions by the same user not shown)
Line 4: Line 4:


# Analytic Report
# Analytic Report
# On-screen Inquiry
== Analytic Report == 
# 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). 
# 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'''. 
# A report will be generated (See Fig 2). This report can be exported in both '''PDF''' and '''Excel''' formats. 
# The report displays various transaction details, including a '''C5 UUID''' column, which contains the C5 Acknowledgement UUIDs. 
# 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. 


==Analytic Report==
# Under the Analytic Report module, user can find a '''"C5 Report"''' option.  In this option, user can click on a report called '''"C5 Reconsiliation Report".''' (Fig 1)
# User can select the date range option to list down the Invoices and Credit Notes with the transaction dates fall within the date range selected. And click on "'''Display: C5 Reconsiliation Report'''".
# A report will be generated. A sample of the report is shown as follows (Fig 2).  Note that besides PDF, this report can also be exported to an '''Excel''' file.
# In the report, it shows the different types of transactions details and a C5 UUID column which shows the C5 Acknowledgement UUIDs.
# If the C5 UUID shows "Failed or not submitted", this will mean that the invoice is either not sent or failed to reach C5.  User therefore need to go to Sales or Purchase management modules to inquire for the invoice, review and resend.




Line 16: Line 19:
[[File:C5 Recon report sample.png|center|thumb|800x800px|Fig 2]]
[[File:C5 Recon report sample.png|center|thumb|800x800px|Fig 2]]


== On Screen Inquiry ==
== On-Screen Inquiry ==
 
# This is an effective way to reconcile C5 report submissions. 
# Under the '''Sales''' and '''Purchase Management''' modules, click on the '''C5 Sales/Supp Trans Reconciliation''' option. 
# Select a customer (or '''All Customers'''), specify the date range, and click on '''Refresh Search'''. The transaction details will be displayed (See Fig 3). 
# 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. 
# To view more details, click on the transaction number under the '''#''' column. The full invoice details will be displayed (See Fig 3A). 
 


# This is another effective way of reconcile C5 report submission.
# Under the sales and purchase management, click on the '''C5 Sales/Supp Trans Reconciliation''' option.
# Select a customer (or All Customers), the date range and click on the Refresh Search.  The details of the transactions will be shown (Fig 3).  On the C5 Ack UUID column, if it is blank, it means that there is no C5 Acknowledgement UUID from C5 which indicates that this invoice/credit note is not successfully transmitted to C5.
# If user desire to find out more details, the user can click on the number under the "#" column and the detail of the invoice will be shown. (Fig 3A).
[[File:C5 recon onscreen.png|thumb|800x800px|center|Fig 3]]
[[File:C5 recon onscreen.png|thumb|800x800px|center|Fig 3]]
[[File:C5 recon details.png|center|thumb|800x800px|Fig 3A]]
[[File:C5 recon details.png|center|thumb|800x800px|Fig 3A]]

Latest revision as of 19:16, 24 March 2025


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