Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: BZ Dusk
  
 
 
 BZ Dusk
 Tags
Subject: Help - Please read
Thread ID: 21829 Message ID: 21829 # Views: 44 # Ratings: 0
Version: Visual FoxPro 6 Category: General VFP Topics
Date: Wednesday, April 02, 2003 5:29:36 PM         
   


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

COMPLETE THREAD

Help - Please read Posted by BZ Dusk @ 4/2/2003 5:29:36 PM
This is an Accounting System Question Posted by BZ Dusk @ 4/2/2003 8:52:15 PM
RE: This is an Accounting System Question Posted by Rene Relucio @ 4/3/2003 1:50:29 AM
RE: This is an Accounting System Question Posted by BZ Dusk @ 4/3/2003 9:00:10 AM
Additional Question - Help Posted by BZ Dusk @ 4/3/2003 7:39:54 PM
RE: Additional Question - Help Posted by Dale Dedoroy @ 4/4/2003 11:35:42 AM
RE: Additional Question - Help Posted by Rene Relucio @ 4/5/2003 12:03:15 PM
Thank you Sir Dale and Sir Rene Posted by BZ Dusk @ 4/6/2003 2:00:15 PM