Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The sequence range is used to put in ATL, BTL/Post and Other Totals into groupings on your Financial Reports. It is also very useful for consolidating many different non-sequential accounts into the one report, which you can read on how to do that here: Financial Reports - Merging Sequence Ranges

...

  • Above the Line

  • Below the Line - Production

  • Below the Line - Post

  • Below the Line - Other Costs

1. Go to General Ledger > Financial Reports. Select your Report in Report Defaults, then select report type in Report Layout.

...

2. Click on the Sequence Range tab

...

3. Right-click in blank space and select Insert. Enter in a 3 digit number to identify the sequence. The numbers in Seq should be ascending. 

  • Click tab. Next Eclipse will automatically generate an ID.

  • Click tab. Enter in ABOVE THE LINE in the the header.

  • Click tab.  Enter in TOTAL ABOVE THE LINE in the footer.

  • Click tab multiple times to move to the Prod, Detl and Set (above lines)Enter in the From range for the sequence (account start).

  • Click tab multiple times to move to the Prod, Detl and Set (below lines). Enter in the To range for the sequence (account end).

  • Press Enter

...

4. Continue entering all the sequence lines, like below.

...

5. Return to the Report Details tab. Click Save. Run the report (you may also choose to save this report under a new name so that you may save the sequence details for another occasion)

...