Financial report design question

Hi Rick,
The Net Income category is something similarly to the
retained earning! by default the COA should have a
default retained earning account to capture the
accumulated Net Income of the company! as Mario said
that instead of COA, we can managed the account thru
category & it is more organizable!

To check whether u have already setup the Net Income
Category, goto Financial Management -> GL -> Master
file maintenance -> Account Category -> check thru
'Balance Sheet type', & then check whether u have
created a default Retained earning or net income
account under the net income category! If u already
created the RE account; u must assigned the RE account
at the company configuration setup in order the FR to
run!

Hope this can help u with the error that prompt!

Good Day!
Best Regards,
BLing
PSB

--- Mario Aguirre <maguirre@...> wrote:
> I am not a being counter, but as if I was. I had to
> create reports with 13
> months columns, etc. and noticed that the wizard
> works with the account
> categories. The more organized the categories, the
> better. Also, if you do
> your financial statements with categories is very
> nice. Your controller or
> accountant can add accounts and they are
> automatically added to your
> financials because they are reading categories
> rather than accounts. I just
> finish removing security to all users but
> administrator to account category
> after it took the accountant and I about 3 months to
> organized all the
> categories.
>
> Good Luck!
>
> Mario Aguirre
> Lakin General
>
> -----Original Message-----
> From: Ludwig, Rick [mailto:RickL@...]
> Sent: Wednesday, May 12, 2004 8:24 AM
> To: Vantage@yahoogroups.com
> Subject: [Vantage] FINANCIAL REPORT DESIGN QUESTION
>
> Hopefully a fellow bean counter can help me...
>
> I am in the process of setting up a Balance Sheet
> and Income Statement
> on our new plant's database. I read about the
> Report Wizard, but
> couldn't find it. I have begun to manually set up
> the Balance Sheet
> when I stumbled across it. I'd like to try and use
> it rather than
> manually setting up each report (looks like an all
> day process and I'm
> already behind in closing the month!).
>
> QUESTION: I get an error message about needing to
> set up at least one
> Net Income category -- where is this done? I have
> established a Net
> Income account in my chart of accounts, but I'm lost
> as to where I need
> to "set up at least one Net Income Category".
>
> Any help would be appreciated!
>
> Sincerely,
>
> Rick Ludwig
>
> Vice President of Finance & Administration
> Metal Spinners, Inc.
> Angola, IN 46703
> DIRECT (260) 665-2158 x25
> FAX (260) 665-5327
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are:
> ( Note: You must have
> already linked your email address to a yahoo id to
> enable access. )
> (1) To access the Files Section of our Yahoo!Group
> for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage
> services goto:
> http://groups.yahoo.com/group/vantage/links
> <http://groups.yahoo.com/group/vantage/links>
>
>
>
>
>
> Yahoo! Groups Sponsor
>
>
> ADVERTISEMENT
>
>
<http://rd.yahoo.com/SIG=129qdg5h6/M=295196.4901138.6071305.3001176/D=groups
>
/S=1705007183:HM/EXP=1084454423/A=2128215/R=0/SIG=10se96mf6/*http:/companion
> .yahoo.com> click here
>
>
>
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
> :HM/A=2128215/rand=354530486>
>
> _____
>
> Yahoo! Groups Links
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
> <http://groups.yahoo.com/group/vantage/>
>
> * To unsubscribe from this group, send an
> email to:
> vantage-unsubscribe@yahoogroups.com
>
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to
> the Yahoo! Terms of
> <http://docs.yahoo.com/info/terms/> Service.
>
>
> [Non-text portions of this message have been
> removed]
>
>





__________________________________
Do you Yahoo!?
Yahoo! Movies - Buy advance tickets for 'Shrek 2'
http://movies.yahoo.com/showtimes/movie?mid=1808405861
Hopefully a fellow bean counter can help me...

I am in the process of setting up a Balance Sheet and Income Statement
on our new plant's database. I read about the Report Wizard, but
couldn't find it. I have begun to manually set up the Balance Sheet
when I stumbled across it. I'd like to try and use it rather than
manually setting up each report (looks like an all day process and I'm
already behind in closing the month!).

QUESTION: I get an error message about needing to set up at least one
Net Income category -- where is this done? I have established a Net
Income account in my chart of accounts, but I'm lost as to where I need
to "set up at least one Net Income Category".

Any help would be appreciated!

Sincerely,

Rick Ludwig

Vice President of Finance & Administration
Metal Spinners, Inc.
Angola, IN 46703
DIRECT (260) 665-2158 x25
FAX (260) 665-5327
Go to master file maint. Under g/l and you set up the categories there.

-----Original Message-----
From: Ludwig, Rick [mailto:RickL@...]
Sent: Wednesday, May 12, 2004 9:24 AM
To: Vantage@yahoogroups.com
Subject: [Vantage] FINANCIAL REPORT DESIGN QUESTION


Hopefully a fellow bean counter can help me...

I am in the process of setting up a Balance Sheet and Income Statement on
our new plant's database. I read about the Report Wizard, but couldn't find
it. I have begun to manually set up the Balance Sheet when I stumbled
across it. I'd like to try and use it rather than manually setting up each
report (looks like an all day process and I'm already behind in closing the
month!).

QUESTION: I get an error message about needing to set up at least one Net
Income category -- where is this done? I have established a Net Income
account in my chart of accounts, but I'm lost as to where I need to "set up
at least one Net Income Category".

Any help would be appreciated!

Sincerely,

Rick Ludwig

Vice President of Finance & Administration
Metal Spinners, Inc.
Angola, IN 46703
DIRECT (260) 665-2158 x25
FAX (260) 665-5327





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
I have a summary account line for net income on the balance sheet in the
Balance Sheet report. There are different line
types............Rick.........might be easier to explain on a call.

Deb Wilmoth
Controller
Reeder & Kline Machine Company, Inc.
Vantage 5.0


-----Original Message-----
From: Ludwig, Rick [mailto:RickL@...]
Sent: Wednesday, May 12, 2004 8:24 AM
To: Vantage@yahoogroups.com
Subject: [Vantage] FINANCIAL REPORT DESIGN QUESTION


Hopefully a fellow bean counter can help me...

I am in the process of setting up a Balance Sheet and Income Statement
on our new plant's database. I read about the Report Wizard, but
couldn't find it. I have begun to manually set up the Balance Sheet
when I stumbled across it. I'd like to try and use it rather than
manually setting up each report (looks like an all day process and I'm
already behind in closing the month!).

QUESTION: I get an error message about needing to set up at least one
Net Income category -- where is this done? I have established a Net
Income account in my chart of accounts, but I'm lost as to where I need
to "set up at least one Net Income Category".

Any help would be appreciated!

Sincerely,

Rick Ludwig

Vice President of Finance & Administration
Metal Spinners, Inc.
Angola, IN 46703
DIRECT (260) 665-2158 x25
FAX (260) 665-5327





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links






[Non-text portions of this message have been removed]
Thanks for your help. I had an EQUITY category set up, but found a "NET
INCOME" box that was not checked - that was the answer!

Thanks!



Rick Ludwig



-----Original Message-----
From: Edward F. Fox, Jr. [mailto:efox@...]
Sent: Wednesday, May 12, 2004 8:25 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] FINANCIAL REPORT DESIGN QUESTION


Go to master file maint. Under g/l and you set up the categories there.

-----Original Message-----
From: Ludwig, Rick [mailto:RickL@...]
Sent: Wednesday, May 12, 2004 9:24 AM
To: Vantage@yahoogroups.com
Subject: [Vantage] FINANCIAL REPORT DESIGN QUESTION


Hopefully a fellow bean counter can help me...

I am in the process of setting up a Balance Sheet and Income Statement
on
our new plant's database. I read about the Report Wizard, but couldn't
find
it. I have begun to manually set up the Balance Sheet when I stumbled
across it. I'd like to try and use it rather than manually setting up
each
report (looks like an all day process and I'm already behind in closing
the
month!).

QUESTION: I get an error message about needing to set up at least one
Net
Income category -- where is this done? I have established a Net Income
account in my chart of accounts, but I'm lost as to where I need to "set
up
at least one Net Income Category".

Any help would be appreciated!

Sincerely,

Rick Ludwig

Vice President of Finance & Administration
Metal Spinners, Inc.
Angola, IN 46703
DIRECT (260) 665-2158 x25
FAX (260) 665-5327





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links








Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=129jmeudm/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1084454749/A=2128215/R=0/SIG=10se96mf6/*http://
companion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=740558475>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
I am not a being counter, but as if I was. I had to create reports with 13
months columns, etc. and noticed that the wizard works with the account
categories. The more organized the categories, the better. Also, if you do
your financial statements with categories is very nice. Your controller or
accountant can add accounts and they are automatically added to your
financials because they are reading categories rather than accounts. I just
finish removing security to all users but administrator to account category
after it took the accountant and I about 3 months to organized all the
categories.

Good Luck!

Mario Aguirre
Lakin General

-----Original Message-----
From: Ludwig, Rick [mailto:RickL@...]
Sent: Wednesday, May 12, 2004 8:24 AM
To: Vantage@yahoogroups.com
Subject: [Vantage] FINANCIAL REPORT DESIGN QUESTION

Hopefully a fellow bean counter can help me...

I am in the process of setting up a Balance Sheet and Income Statement
on our new plant's database. I read about the Report Wizard, but
couldn't find it. I have begun to manually set up the Balance Sheet
when I stumbled across it. I'd like to try and use it rather than
manually setting up each report (looks like an all day process and I'm
already behind in closing the month!).

QUESTION: I get an error message about needing to set up at least one
Net Income category -- where is this done? I have established a Net
Income account in my chart of accounts, but I'm lost as to where I need
to "set up at least one Net Income Category".

Any help would be appreciated!

Sincerely,

Rick Ludwig

Vice President of Finance & Administration
Metal Spinners, Inc.
Angola, IN 46703
DIRECT (260) 665-2158 x25
FAX (260) 665-5327




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/SIG=129qdg5h6/M=295196.4901138.6071305.3001176/D=groups
/S=1705007183:HM/EXP=1084454423/A=2128215/R=0/SIG=10se96mf6/*http:/companion
.yahoo.com> click here


<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
:HM/A=2128215/rand=354530486>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.


[Non-text portions of this message have been removed]