GNM_RCS_Prepayments_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 prepayments report in RCS. Separate documents deal with all other aspects of financial reporting in RCS including accruals, spend analysis, the transactions list, and delayed payments.

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. .Prepayments report

     1. Requesting the report

The report is run from this menu option: Finance → Accruals + prepayments → Prepayments report

This menu option opens screen rcs_reports_150_pc.fmb.

When the screen opens the user chooses the earliest commission agreed date to be included in the report.

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_ppay_020.run_report

This report lists all commission and expense payments that have been sent as payment instructions to either Oracle AP or Payroll where the payments relate to a future period. For example an advance maybe paid in one period for content that will be published in a future period.

Only commissions agreed on or after the date specified in the request are included – that date defaults to today’s date less one year.

The prepayment amount shown on the report is the entire amount of the fee paid.

• 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