designing financial statement reports

[dunk02]

I have Peachtree Complete 2002. I am trying to design a financial statement report that will collect certain groups of expense accounts. The account number structure is xxxx-yyyy, where xxxx is the functional expense account number and yyyy is a project number. When I try to collect costs by project number, using a rollup like ****-5017, I get an error message saying that rollups can have only trailing asterisks. I can find no reference to this in the Peachtree manuals. On top of it all, I designed reports like this in earlier versions of Complete which are still in the report templates. I can use these now as they are, but if I try to alter these older reports to collect costs for new projects, I get this trailing asterisk error!! What is going on?

I do not have Crystal Reports. This is the Peactree report writer.

Peter Dunkelberger

[dringstrom]

It appears that you're trying to use the Roll Up functionality in a different format than it is intended. I've pasted an excerpt from the online help below. You may wish to consider using Peachtree's Job Cost functionality instead.

"Sometimes you may want to show balances by department. Other times, you may want to summarize department totals for the main or primary account. The Financial Statement Design window lets you do both.

First, you have to set up your chart of accounts for departments or locations as in the simplified example below.

Account ID Account Description

40000-11 Sales: Hardware

40000-12 Sales: Software

50000-11 Purchases: Hardware

50000-12 Purchases: Software


Using the above numbers, if you wanted a departmentalized income statement, you could set up a column definition with a department mask of *****-11, to show only totals for the Hardware department, and *****-12 to show the Software department totals.

But, if you wanted to combine totals for both departments into a single Sales and Purchase amount, you could use a Line Description with a Rollup Mask like 40000-** for Sales and 50000-** for Purchases."

[dunk02]

Thanks for the response.

[baseballmvp]

Sounds to me like you want to group certain accounts by project. This can probably be better done by grouping the accounts (one right after the other, row by row), but indicate in the properties formatting section under print "no". Then use the subtotal function to subtotal that group and label it as you want. As you view or print out the report only the subtotal will show and it will be labeled whatever project name you want to give it. The detailed account that make up that summary will not be visible. I think this will accomplish what you want to do.