Setting up revenue report layout

  1. Access SunSystems.
  2. Specify RLS in the search field and select Revenue Report Layout Setup (RLS).
  3. Specify the Report Code and click OK.
  4. Specify this information:
    Report Layout Code
    An identifying code for report layout.
    Description 1-2
    Up to 50 characters of descriptions used to identify reports.
    Document Format Code
    The document format code of the report to be printed. You can the RIRR document format code or create you own document format.
    Source Reference
    The source reference.
    Status
    Each static data record contains a status code that determines the current processing status of the record:

    • Open - this status is set automatically when you add a new record, for example, if you create a new account. Open items are available for input, inquiry, processing and reporting.

    • Hidden - a record with a hidden status does not appear on any inquiries but is available for input, processing and reporting.

    • Suspended/Held - a suspended record.

    • Closed/Completed - a closed record cannot be used for input or processing. For example, you cannot post transactions to a closed account or analysis code.

    A status is assigned to each static reference record, for example to every account, asset, customer and supplier. It determines the current processing status of the record. You can alter the status of a record at any time. You must use the options on the Action menu to change the status.
    Report Layout Short Heading
    The report layout short heading, which is used where space is limited. If this is blank it defaults to the first characters of the description.
    Lookup Code
    The lookup code can be used to find a record, as an alternative to the record code. It is often set to a shortened version of the description. It is particularly useful if a record is often referred to using different codes. For example, the Chart of Accounts code for Fuel Expenses is 75201 and the Lookup Code is set to FUELEXP.
    Data Access Group (DAG) Code
    The DAG code to be applied to restrict operator from accessing this data.
  5. Specify this information from the Dates tab:
    Report From Option
    Select the date to report from:
    • Not Set
    • Current
    • First Day of Month
    • Last Day of Month
    • Start of Accounting Period
    • End of Accounting Period
    • Start of Year
    • End of Year
    Report From Offset
    Specify +n or -n
    Report From Calculation Unit
    Select days, months or years as the offset unit. as an offset to be applied to the date.
    Posting Period Option
    Select the posting period:
    • Not Set
    • Current
    • First Day of Month
    • Last Day of Month
    • Last Amended Date
    • Start Date
    • End Date
    • Review Date
    • Misc Date 1
    • Misc Date 2
    • Billing Period Start
    • Billing Period End
    • Billing Period
    • Start of Accounting Period
    • End of Accounting Period
    • Start of Year
    • End of Year
    Posting Period Offset
    Specify +n or -n as an as an offset to be applied to the date.
    Posting Period Calculation Unit
    Select days, months or years as the offset unit.
    Report To Option
    Select the date to report from:
    • Not Set
    • Current
    • First Day of Month
    • Last Day of Month
    • Start of Accounting Period
    • End of Accounting Period
    • Start of Year
    • End of Year
    Report To Offset
    Specify +n or -n as an offset to be applied to the date.
    Report To Calculation Unit
    Select days, months or years as the offset unit.
    Consolidate Prior Period
    The Consolidate Prior Period option, along with the ability to set a period, consolidates any postings made prior to Consolidate To period to Consolidate To period (including any reversed postings). Select the check box to stop the reporting module from posting to periods before the Consolidate To periods. You can close particular periods and exclude them from the reporting module. Any postings made to a closed period are moved to the next open period instead.
    Billing Indicator
    Select the check box to request a report based on the billings generated between the requested dates. It shows the full amount for any invoice generated within given dates. If the check box is cleared, only the amount of the invoice related to that particular period is displayed. For example, if a contract is billed annually and a billing report is requested for the period from 1st January to 31st March, then the full annual value is reported. However, without the billing report option, only three months of the annual value are reported.
  6. Specify this information from the Options tab:
    Filter Name
    Specify the filter previously set up in the Filter Designer (FLD) (this must be the RIRR type filter.
    Ledger Interface Definition Code
    Specify the ledger interface definition code used to post transactions to the ledger if the results of the report are posted.
    Budget Ledger
    Select a single character representing the ledger used if the results of the report are posted. For each business unit there is one actuals ledger and up to ten budget ledgers. These ledgers are identified by the letters from A to K, where A refers to the actuals ledger and B to K refer to the budget ledgers.
    Period Offset
    Specify +n or -n as an offset to be applied to the period.
    By Accounting Period
    Select the check box to split report (and posting) amounts by accounting period instead of calculating a single value to cover the entire reporting period from start to end of the report date.
    Post Transactions
    Select what is required in the process:
    • Report
    • Report and Post
    Journal Control
    If selected, the last Journal Number posted to each Ledger code is maintained against the Contract Line. This will enable the system to reverse the correct entries from the specified ledger if required.
    Reversal Flag
    Select the check box to determine the last journal number used to post the original transaction and use this to reverse the posting (for each contract line which is processed by the report).
    Print Options Summary
    Select the check box to print options used for the report as first page of the report.
    Suppress Blank Lines
    Select the check box to suppress black lines on the final report.
  7. Specify this information form the Dates tab:
    Value Label Code
    An identifying code for value label.
    Contract Flag
    Select a contract flag.
    Value Type
    The Value Type with the start and end report date determine which dates are used for processing. The dates are adjusted according to the selected value for Value Type.
    Value Flag
    Select the unit of value for the selected value label:
    • Without Units - a value without a unit of measure (for example, a percentage).
    • With Units - a value with a unit of measure (for example, a quantity).
    • Corresponds to Base, Reporting or Transaction Currency - a value that is a currency.
  8. Specify this information the Report Details tab:
    Prorate Method
    Select the prorate method:
    • Annual Prorate
    • Daily Prorate
    • Monthly Prorate
    • Normalised Prorate
    • Not Set
    • Simple Monthly
    • Traditional Quarter Prorate
    • Weekly Prorate
    Accrue/Defer
    Select the accrue/defer.
  9. Click Run to run the revenue reporting process.
  10. Click OK.