OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » please guide me

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

please guide me [message #517524]

Tue, 26 July 2011 07:54

rockybuilder2010
Messages: 4
Registered: September 2010
Location: Pakistan

Junior Member

please any body guide me that how do i create PROFIT AND LOSS report in oracle 6i

please send me the detail tips

thanks

Report message to a moderator

Re: please guide me [message #517526 is a reply to message #517524]

Tue, 26 July 2011 08:01

cookiemonster
Messages: 9284
Registered: September 2008
Location: Rainy Manchester

Senior Member

By writing a query. What that query would look like would depend entirely on what database tables you have to store that information.
Since you haven't told us what tables you have or what data they store we really can't help you further.

Report message to a moderator

Re: please guide me [message #517528 is a reply to message #517524]

Tue, 26 July 2011 08:02

joy_division
Messages: 4286
Registered: February 2005
Location: East Coast USA

Senior Member

Do you really expect a useful answer with such a generic question?

How about >0 = profit, <0 = loss?

[Updated on: Tue, 26 July 2011 08:03]

Report message to a moderator

Re: please guide me [message #517537 is a reply to message #517528]

Tue, 26 July 2011 09:06

ranamirfan
Messages: 506
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear,

Profit

(Revenue - Expenses)>0

Loss

(Revenue - Expenses)<0

Regards,
Irfan

Report message to a moderator

Re: please guide me [message #517573 is a reply to message #517537]

Tue, 26 July 2011 11:55

rockybuilder2010
Messages: 4
Registered: September 2010
Location: Pakistan

Junior Member

i request u that how could i design this report because i design the database of accounts module three levels and there are three tables used in with relational database.

table name are

1) Chart_of_account_main
2) Chart_of_account_sub
3) transactions_account

voucher tables is

1) payment_master/detail
2) recived_master/detail

So understand my problem and help me if u have any format of the profit and loss report and form that please mail me this is better that i understand to design the report

mail address: fahad_aijaz81@hotmail.com

Report message to a moderator

Re: please guide me [message #517712 is a reply to message #517573]

Wed, 27 July 2011 10:01

averion
Messages: 42
Registered: January 2009
Location: US

Member

There is no one waiting to do your task. Do it yourself and ask if you face difficulty.

Report message to a moderator

Previous Topic:	Issue to connect to remote database
Next Topic:	Report Excel Output issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 19 02:15:51 CDT 2013

Total time taken to generate the page: 0.14621 seconds