• riyaz
  • New member
  • Offline
  • Registered: 01/23/2013
  • Posts: 9

Topic: Profit and Loss Statement

Could i show the report of profit and loss statement with their accounts levels and their sub total of corresponding parent account.

Revenue

like -> 601 Sale
           60101 -------
               -
               -
               -
Total of 601 Sale :______.
             602 Rental Income
             60201 ---------
                 -
                 -
                 -
Total of 602 Rental Income : _____
             603
          and so on
Total Revenue : ______

kindly please help me out .

Regards
Riyaz Ahmed

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,089

Re: Profit and Loss Statement

Yes you can, but you have to setup the group parents correctly.

Joe

  • riyaz
  • New member
  • Offline
  • Registered: 01/23/2013
  • Posts: 9

Re: Profit and Loss Statement

Thanks dear admin i already setup the group parents correctly my question is that how is that become possible? through SQL query?or through loop? . please guide me step by step i can't make a logic for this situation.


Riyaz

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,089

Re: Profit and Loss Statement

No, this is not fully sql based. We use recursivity to achieve this. Look into the balance sheet and profit and loss statements.

/Joe