Can't find what you're looking for? Still have questions? Contact customer support (smile)

Sequence Ranges

Owned by Jonathan Casse (Deactivated)
22 Nov 2022
3 min read

The sequence range is used to put 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.

 

  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 first entry in the main body and select Change.

 

  • Enter in a 3 digit number to identify the sequence and position in the report. The numbers in Seq should be ascending.

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

  • Click tab. Enter in group title in the the header.

  • Click tab.  Enter in the group summary description in the footer (This is normally a description labelled “Total xxxxxxxxxx” i.e. “Total Production” ) .

  • Click tab multiple times to move to the Prod, Detl and Set (above lines). Enter in the From range for the sequence (account start). Make sure the Detl and Set lines are blank for the starting range, unless you want to start the report at a specific Detl and Set codes.

  • Click tab multiple times to move to the Prod, Detl and Set (below lines). Enter in the To range for the sequence (account end). Make sure the Detl and Set lines are ZZZZ’s for the ending range unless you want the report to stop at a specific Detl or Set account.

  • Press Enter. Completed example below.

 

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

 

6. 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)

 

7. To save the report under a new name, Enter in a description in the Report Defaults field. Click save.

 

8. To Delete the report, Select the report in Report Defaults field. Click the scissors.