Report Structures (Alternate)

<< Click to Display Table of Contents >>

Navigation:  Modules > Financial Management > General Ledger > Alternate Ledger > Maintenance >

Report Structures (Alternate)

Overview

 

This application allows the user to create and maintain the structure of user defined reports like balance sheets and income statements.

 

A report structure consists of:

 

The report lines

Account range per line

Sub totals and totals

 

Function

 

This application consists of four tabs:

 

Report Types tab

Lines Per Report tab

Account Range per Line tab

Totals and Sub Totals tab

 

 

Report Type Tab

 

The user selects the type of report for use.

 

clip1919

 

Select the report type using the picker in the Report field.

 

The report will appear in the display screen on the right.

 

clip0815

 

 

Print The Details

 

Select the 'Report' button to generate a print preview of the report. The user can select print from the preview.

 

clip0816

 

 

Lines per Report Tab

 

All the lines from the report chosen will appear in the display screen to the left.

 

clip0817

 

 

Create a New Line

 

Select the 'New' button to create a new report line.

 

Use the picker to select the type of report the line will be created for.

 

Enter the following information:

 

Line Number - enter the number of the line for the report

Line Caption - enter the full name of the line for the report

Line Type - select the type of line you are creating using the drop down arrow:

oH - heading, this line will appear above the detail lines

oD - detail, the details lines form the body of the heading

oG - grand total, this is a line with a grand total figure

oS - sub total, this is a line with a sub-total figure

Print Line - check the selection box if the line created must appear on the report when printed

 

Select the 'Ok' button to save the new line. The system will prompt the user with the  following message to confirm that the new line was created successfully.

 

Select 'Ok' to continue.

 

image89535560

 

The new line will appear in the display screen on the left.

 

Amend an Existing Line

 

To change the details of an existing line, the user must click on the relevant line in the display grid, on the left, and select the 'Amend' button.

 

The following fields will be open for adjustments:

 

Line Caption

Line Type

Print Line

 

To save the changes made select the 'Ok' button.

 

The system will prompt the user with the following conformation message that the amendments were successfully saved.

 

Select 'Ok' to continue.

 

image398827181

 

 

Delete an Existing Line

 

To erase an existing line the user must click on the relevant line in the display grid, on the left, and select the 'Delete' button.

 

The system will prompt the user with the following confirmation message. Select 'Yes' to erase.

 

image1969152710

 

The following message will appear notifying the user that the line was deleted. Select 'Ok' to continue.

 

image275465530

 

 

Account Ranges per Line Tab

 

This tab allows the user to link a range of accounts to a single line.

 

clip0818

 

Create a New Account Range

 

To create a new account range, select the 'New' button.

 

Enter the following information:

 

Report  -select the report type using the picker:

oBalance Sheet

oIncome Statement

Line Number - select the number of the line you are creating the account range for

Account - select the account 'From' and 'To' using the picker

Account Profit - check the selection box to include this

Cost Center - select the cost center 'From' and 'To' using the picker

 

Select the 'Ok' button to save the record.

 

The system will prompt the user with the following message to confirm that the new record was saved. Select 'Ok' to continue.

 

image1730962496

 

 

Amend an Existing Account Range

 

To amend existing records click on the relevant line in the display grid and select the 'Amend' button.

 

The following fields will be open for amendments:

 

Account 'From' and 'To'

Account Profit

Cost Center 'From' and 'To'

 

To save the changes select he 'Ok' button.

 

The following message will appear to notify the user that the changes were saved successfully.

 

Select 'Ok' to continue.

 

image2072721146

 

 

Delete an Existing Account Range

 

To erase an existing record the user must click on the relevant line in the display grid and select the 'Delete' button.

 

The following message will appear to confirm that the user would like to delete the record.

 

Select 'Yes' to delete.

 

image889866135

 

The second message will confirm that the record was deleted. Select 'Ok' to continue.

 

image1496377341

 

 

Totals and Sub Totals Tab

 

This tab allows the user to maintain which lines are added up to form the total value for the Total or Sub Total lines.

 

clip0819

 

Assign New Lines to Total\Sub Total lines

 

Select the 'New' button.

 

Enter the following information:

 

Report - select the type of report using the picker

Line Number - select the line number you are going to assign other lines to

Line - select the lines 'From' and 'To' which will be added up to form part of the Total\Sub Total line using the picker

 

Select the 'Ok' button to save the details.

 

The following message will appear confirming that the new record was saved. Select 'Ok' to continue.

 

image2031024878

 

Amend Existing Information

 

Click on the line you want to change in the display grid on the right. Select the 'Amend' button.

 

The 'Line To' field will be active for any changes.

 

When complete select the 'Ok' button to save the changes.

 

The following message will appear to notify the user that the changes were saved. Select 'Ok' to continue.

 

image1348545931

 

Delete an Existing Record

 

Click on the line you want to erase in the display grid on the left and select the 'Delete' button.

 

The following message will appear to confirm that the user wants to erase the following record.

Select 'Yes' to continue.

 

image1243838889

 

The next message will appear to confirm that the record was deleted.

 

Select 'Ok' to continue.

 

image72578577

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Delta3DLogo