News

Wednesday 21 October 2009

Update to AR queries SUARQ075 & SUARQ077

As part of ongoing improvement initiatives in the Accounts Receivable function, Financial Operations and Systems have undertaken a review of the accounts receivable reporting tree within PeopleSoft Financials. This initiative focused on implementing and delivering the following improvements to the wider University community:

• Enhanced granularity of reporting layers in AR PeopleSoft tree;
• Streamlined and consolidated Bill Sources to reflect agreed reporting layers;
• Streamlined reporting areas in alignment with faculty structures;
• Improved self-service capability to produce query output at Cluster, Faculty or School/Department/Discipline/Centre levels.

The review process was conducted through a series of consultative phases involving faculty stakeholder representatives. Subsequent phases of this project lifecycle included the re-design, re-build and testing of the revised AR management tree and query outputs.

Critical to the success and integrity of this data is the reliance on the University billing community to ensure all invoices generated through PeopleSoft are assigned an appropriate active bill source code in accordance with the revised AR tree structure.

To assist users in identifying the appropriate bill source code(s) relevant to their respective areas of responsibility, two reference matrices have been developed as follows:

• The Detailed Mapping Matrix comprises of a listing of all active bill source codes aligned to a single Responsibility Centre (RC) code or range of Responsibility Centre’s.
  Click here to download the matrix (Updated 4 November 2009).
• The Faculty Summary Matrix comprises of all active bill source codes by Faculty.
  Click here to download the matrix.

These reference listings will be maintained by Revenue Services on a regular basis to coincide with any structural changes to the Chart of Accounts initiated through the Office of Chief Accountant.

The release of enhanced versions to SUARQ075 and SUARQ077 through Hyperion is scheduled for Monday, 26 October 2009. Access to these queries will be defined and assigned according to the following criteria:

• SUARQ075 – Faculty Finance Directors, Associate Finance Directors, Finance Managers or equivalent;
• SUARQ077 – General Use.

We encourage users to optimise usage of these queries through Hyperion as it delivers a number of standard and additional functionalities to assist with your reporting requirements.

Before you commence use of these queries through Hyperion, it is advisable that you check your existing user preferences settings are set to AUSTRALIA formatting as follows:

Should you require any assistance or further information in relation to the AR queries please contact the Revenue Services Team who will be happy to assist you.

Contacts:
- 02 9351 4022
- 0404 970 477
- 02 9351 3422

Level 2, Margaret Telfer Building (K07)
The University of Sydney, Glebe | NSW | 2006