Home » Developer & Programmer » Reports & Discoverer » please guide me
please guide me [message #517524] Tue, 26 July 2011 07:54 Go to next message
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

Re: please guide me [message #517526 is a reply to message #517524] Tue, 26 July 2011 08:01 Go to previous messageGo to next message
cookiemonster
Messages: 10998
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.
Re: please guide me [message #517528 is a reply to message #517524] Tue, 26 July 2011 08:02 Go to previous messageGo to next message
joy_division
Messages: 4520
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 Go to previous messageGo to next message
ranamirfan
Messages: 529
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Dear,

Profit
(Revenue - Expenses)>0


Loss
(Revenue - Expenses)<0


Regards,
Irfan
Re: please guide me [message #517573 is a reply to message #517537] Tue, 26 July 2011 11:55 Go to previous messageGo to next message
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
Re: please guide me [message #517712 is a reply to message #517573] Wed, 27 July 2011 10:01 Go to previous message
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.

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


Current Time: Thu Oct 02 07:45:36 CDT 2014

Total time taken to generate the page: 0.07159 seconds