<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Subsidiary Ledger Report]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=5295&amp;type=atom" />
	<updated>2014-11-10T15:18:25Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=5295</id>
		<entry>
			<title type="html"><![CDATA[Re: Subsidiary Ledger Report]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=21424#p21424" />
			<content type="html"><![CDATA[<p>The <a href="https://frontaccounting.com/fawiki/index.php?n=Help.ReportsAndAnalysis">Reports and Analysis Wiki Page</a> lists all the reports and quite a lot of their screenshots are available - see what suits your need.</p><p>In particular Reports 101, 102, 201, 202 may be of interest.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2014-11-10T15:18:25Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=21424#p21424</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Subsidiary Ledger Report]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=21412#p21412" />
			<content type="html"><![CDATA[<p>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 </p><p>Supplier/Customer A = 1000<br />Supplier/Customer B = 1500<br />Supplier/Customer C =&nbsp; &nbsp;500</p><p>I couldn&#039;t figure out how to query this.</p>]]></content>
			<author>
				<name><![CDATA[knjy24]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19566</uri>
			</author>
			<updated>2014-11-10T01:24:44Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=21412#p21412</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Subsidiary Ledger Report]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=21406#p21406" />
			<content type="html"><![CDATA[<p>Is it the supplier version of <a href="https://frontaccounting.com/fawiki/index.php?n=Devel.ERDiagram23">this</a> that you are looking for?</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2014-11-09T13:19:16Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=21406#p21406</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Subsidiary Ledger Report]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=21381#p21381" />
			<content type="html"><![CDATA[<p>Hi all,</p><p>Is it possible to make a subsidiary ledger report in fa? For example:<br />&nbsp; &nbsp; &nbsp; &nbsp;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ACCOUNTS PAYABLE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />SUPPLIER A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SUPPLIER B<br />---------------&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ----------------<br />DR&nbsp; &nbsp; |&nbsp; &nbsp; CR&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DR&nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp;CR<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </p><p>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.</p><p>I saw some post about this topic but I can&#039;t find any answer. Thank you.</p>]]></content>
			<author>
				<name><![CDATA[knjy24]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19566</uri>
			</author>
			<updated>2014-11-07T09:07:26Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=21381#p21381</id>
		</entry>
</feed>
