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
Remember that Eclipse runs in alphanumeric order, so it first starts at (blank), 0, 1, 2, 3, etc until all numbers are exhausted, then it starts from A, B, C, D, etc until it reaches Z. This is why you will see a grouping of ZZZ's in your ending fields.
The below guide will show you how to setup a basic sequence range for your financial reports with the following groupings:
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)
6. To save the report under a new name, Enter in a description in the Report Defaults field. Click save.
7. To Delete the report, Select the report in Report Defaults field. Click the scissors.
