Language:


Key Financial Ratios - Example - Objects

This page describes adding two- and three-dimensional Object analysis to a Key Financial Ratios report definition. Please refer here for descriptions of the commands you can include in a Key Ratios report definition.

---

The first step is to use the OBJRESULT command in Key Ratio definitions. This command will print the net change over the report period for a specified Account or Accounts, only including postings with a particular Object. In this example in which Accounts 100:199 are Sales Accounts, we have created Key Ratios to compare the sales figures of various product types. Each product type has its own Object:

The second step is to create columns to provide a second level of analysis. For example, you might want to analyse sales of the various product types by salesman, or by the business types of the customers. To do this, add the columns as described here and then go to flip B of the 'Column Definition' window to specify the Objects for each column. In this example, we have created columns for each salesperson. Each salesperson also has their own Object:

If necessary, you can add a third level of Object analysis. For example, in addition to the breakdown by product type and salesperson, you might want to see the type of customers being sold to (e.g. business type or area). In the specification window for the Key Financial Ratios report, you can specify an Object Type. In this example, we have specified BUS (i.e. business types):

The report will contain separate sections for each Object belonging to the BUS Object Type:

---

Pages describing the Key Financial Ratios report:

---

Reports in the Nominal Ledger:

---

Go back to: