GNM_RCS_Delayed_Payments_Report_TS

• 1. .Introduction

     1. Purpose

The document GNM_RCS_Financial_Reporting_FS.docx is the functional specification that describes what business functions RCS supports in relation to financial reporting.

This document is one of a set of technical specifications that provide details of how those functions are implemented in RCS.

• 1. Scope

This document focusses on the delayed payments report in RCS. Separate documents deal with all other aspects of financial reporting in RCS including accruals, spend analysis, the transactions list, and prepayments.

This document is intended as a high-level technical document outlining how the relevant business functions are implemented in terms of software modules.

Importantly, this document does not aim to provide the level of detail that would be required in a programming specification in areas such as program structure, detailed business rules, data integrity, validation, locking considerations, data security, and calls to/from other software modules, performance considerations, and so forth.

For details of program logic and coding, the reader should refer to the program files themselves.

• 1. .Delayed payments report

     1. Requesting the report

The report is run from this menu option: Finance → Delayed payments report…

This menu option opens screen rcs_reports_080_pc.fmb.

When the screen opens the user optionally chooses the cost centre to report on. Leaving it blank will produce a report on all cost centres the use has access to.

Pressing “Finish” saves the request to the REPORT_REQUESTS table. The request is picked up by an asynchronous database job that processes the request and emails the report to the requestor.

• 1. Report process

The software that is executed to produce the report is a package procedure called:

rcs_ecla_010.run_report

This report lists all commission and expense payments that are due for payment but which have not yet been sent to Oracle AP or Oracle Payroll. The status of the payment, including the reason for the delay, is provided in the report.

If the user has entered a cost centre the report only includes payments for that cost centre. However, if the cost centre chosen is a parent of other cost centres then those cost centres are reported on too. If no cost centre was requested then all cost centres the user has access to are included in the report.

• 1. Report output

The report output file lists the data in comma separated values (csv) format and is emailed to the requestor of the report. The file contains these columns:

Cost centre, Account, Product, Contributor, Supplier ID, Format, CRN/PRN, Agreed/Inv. date, Planned pub. date, Period, Fee, Currency, Description

End of Document