FrontAccounting forum — Subsidiary Ledger Report

Re: Subsidiary Ledger Report

null@example.com (apmuthu) — Mon, 10 Nov 2014 15:18:25 +0000

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.

Re: Subsidiary Ledger Report

null@example.com (knjy24) — Mon, 10 Nov 2014 01:24:44 +0000

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.

Re: Subsidiary Ledger Report

null@example.com (apmuthu) — Sun, 09 Nov 2014 13:19:16 +0000

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

Subsidiary Ledger Report

null@example.com (knjy24) — Fri, 07 Nov 2014 09:07:26 +0000

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.