• From: Caloocan City, Philippines
  • Registered: 08/21/2014
  • Posts: 18

Topic: Subsidiary Ledger Report

Hi all,

Is it possible to make a subsidiary ledger report in fa? For example:
       
                                                             
          ACCOUNTS PAYABLE                     
                                                             
SUPPLIER A                   SUPPLIER B
---------------                ----------------
DR    |    CR                 DR     |     CR
           

I am trying to make a query to show something like this. But when I checked the tables I am not sure how to connect the supplier/supplier_transaction OR customer/customer_transaction to gl_trans table.

I saw some post about this topic but I can't find any answer. Thank you.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Subsidiary Ledger Report

Is it the supplier version of this that you are looking for?

apmuthu's Website

  • From: Caloocan City, Philippines
  • Registered: 08/21/2014
  • Posts: 18

Re: Subsidiary Ledger Report

Yes that one. I wanted to have a detailed information on each account. For example if the total of A/P is 3000, then I want a report that could breakdown this amount like

Supplier/Customer A = 1000
Supplier/Customer B = 1500
Supplier/Customer C =   500

I couldn't figure out how to query this.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Subsidiary Ledger Report

The Reports and Analysis Wiki Page lists all the reports and quite a lot of their screenshots are available - see what suits your need.

In particular Reports 101, 102, 201, 202 may be of interest.

apmuthu's Website