I have an existing “Purchases” module. I am now developing an accounting system. First, I need to have a purchase journal entry. But instead of presenting a debit / credit interface, I decided to make use of my existing Purchases module. In the parent table of my Purchases module, I added an additional field for “accounts payable”-this is a dropdown combo showing the list of accounts (we have 2 A/P account). In the child table, I added an additional field for “Account” – this is also a drop down combo showing the list of accounts example:Raw materials inventory. I don’t exactly remember where I saw this approach, but I think I saw it in PeachTree or quickbooks accounting software few years ago.

Anyway, my problem is how to present this in report:
Say: Raw Materials Inventory 5000
Accounts Payable 5000

Should I have a one table to hold “all” my journal entries (purchases,payments,etc) although I already have a parent and child table for my Purchases module which holds tha A/P account and Inventory account?

Thanks and more power

BZ