Hello,

We have been using these sessions for 3 + years now and have encountered a problem today with a new financial statement that I am working on.

The session max's out at 99 seq #, our problem is that I have 104 seq #'s on the statement and it will continue to grow over time.

My only workaround thus far is to break the one statement up into multiple statements then print them out and assemble the pages manually and distribute them. This is not the best workaround but I was hoping that someone has come up with a better one.

The major problem with this is it is a problem for users to print them out and assemble them.

Thank you for any help you can provide.

Regards,
Doug Jefferson

Doug,

These appear to be the sequence numbers in the layout. Are you using a new sequence for each line on the layout? You can use a sequence that will work for multiple lines. For example if there are several lines without lines in between you can use one sequence for all of these lines.

If you'd like to discuss this further, one of my finance consultants would be happy to walk you through this - no charge. You have spoken w/ her already towards the end of last year.

Please email me directly if you'd like to speak with her.

Regards,
Kathy Barthelt
kbarthelt@rmcis.com

Hi Doug

Have you thought of using two or more statement accounts to fit in the number of lines you want print and then clubbing these under a parent statement account.

for example

if you have to print 104 lines under a particular head, you can divide the list into two components. Part 1 and part 2 . Under each you can fit in a max of 99 parts. These two can then be grouped under a separate head to get the final value in the same financial statement.

cheers.

sudarshan

I am unable to do what you sugest, we have to show all the detail on the statement. The statement that I have is very detailed for our owners in Germany and they need to see the data. I had even thought about using th annexure but it will not work either.

Doug

hello Doug,

you wrote that you need 104 sequences in your report.
Do you mean that you have 104 different line/ account layouts or you have 104 lines/ accounts in your report?

If it is the second one you can use the field sublevel to group accounts of similar hierarchie position. For example you have one kind of layout for all Titles in your statement (the layout is for example, before you have a blank line and behind the graphic line.
To all title accounts you give the same sublevel in the "Maintain Statement Account Session" tffst1103m000. In the layout session then you select all accounts in the field "statement account" but only one sublevel. In that case you only need one sequence number for a lot of lines.
Did I explain clearly?

Hope that helps.

Regards, Juli

Example:

BMC
Dept. Schedule
May 31, 2002

Finc Stmt Acct # 1 XXX.XX
Finc Stmt Acct # 2 XXX.XX
-----------
Finc Stmt Acct # 3 XXX.XX
======

Finc Stmt Acct # 4 XXX.XX
Finc Stmt Acct # 5 XXX.XX
Finc Stmt Acct # 6 XXX.XX

Finc Stmt Acct # 7 XXX.XX
Finc Stmt Acct # 8 XXX.XX
Finc Stmt Acct # 9 XXX.XX
----------
Finc Stmt Acct # 10 XXX.XX
======

Finc Stmt Acct # 11 XXX.XX
Finc Stmt Acct # 12 XXX.XX
Finc Stmt Acct # 13 XXX.XX

an so on.

Hi Doug,

for your example you need 2, maximum 3, sequence numbers.

Regards, Juli