• From: Addis Ababa, Ethiopia
  • Registered: 11/28/2019
  • Posts: 109

Topic: How to create a subsidiary ledger for AR & AP

How do I create subsidiary ledger if the entry involves accounts receivable or accounts payable?
Because I need the report to only show a general ledger balance, not all the details?

eg. GL 1150
    Sub 1150 - 01
    Sub 1150 - 02
   etc ...

Any help?

Cedrick

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

Re: How to create a subsidiary ledger for AR & AP

Then why create subsidiary ledgers for them in the first place? If such a need is for reporting only, then write a custom one.

apmuthu's Website

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

Re: How to create a subsidiary ledger for AR & AP

You can also use the account types to decide which accounts shall be summarized in a special way.
I guess that there are some info in the Wiki about this.

Joe

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

Re: How to create a subsidiary ledger for AR & AP

Account Types appears in the bank_accounts table and in the menu Banking & GL => Bank Accounts and has the following values / choices:

0 => Savings Account
1 => Chequing Account
2 => Credit Account
3 => Cash Account

Expect these functionalities and choices to be hard coded in the php scripts. How do we use it to summarise them?

The wiki entry asks to allocate a single GL account to many Bank Entries at:
https://frontaccounting.com/fawiki/index.php?n=Help.BankAccounts

Also there is very little info on Account Tags in the wiki. at:
https://frontaccounting.com/fawiki/index.php?n=Help.AccountTags

apmuthu's Website