Building Chart of Accounts report
Posted: 15 Jun 2012, 06:04
I am trying to build a simple report that shows the Chart of Accounts grouped by:
Level 1: CAT_TITLE.TITLE (e.g. Sales)
Level 2: CATEGORY.NAME (e.g. Product Sales)
Detail: NOMINAL_LEDGER.ACCOUNT_REF (e.g. 4000) + NOMINAL_LEDGER.NAME
How do I link the NOMINAL_LEDGER.ACCOUNT_REF field to the LOW and HIGH fields within the CATEGORY table?
Any help would be gratefully appreciated.
Level 1: CAT_TITLE.TITLE (e.g. Sales)
Level 2: CATEGORY.NAME (e.g. Product Sales)
Detail: NOMINAL_LEDGER.ACCOUNT_REF (e.g. 4000) + NOMINAL_LEDGER.NAME
How do I link the NOMINAL_LEDGER.ACCOUNT_REF field to the LOW and HIGH fields within the CATEGORY table?
Any help would be gratefully appreciated.