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
 To: BZ Dusk
  
 
 
 BZ Dusk
 Tags
Subject: Additional Question - Help
Thread ID: 21829 Message ID: 21894 # Views: 19 # Ratings: 0
Version: Visual FoxPro 6 Category: General VFP Topics
Date: Thursday, April 03, 2003 7:39:54 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
> >
> > Following Dale's recommended approach, write once and read many, you may not need another journal table to record your entries. SQL statements can gather your rows from various tables with ease. Since POs and the like are sources of Journal Entries to be journalized to a particular journal book, a technique to display them as such (Journal Book) could be used with the rows prepared by SQL statements.
> > Adding a field to child table, my assumption is that your Raw Materials Inventory has sub-accounts, each row representing the cost of a particular raw material. If not,
> > you the total amount for material should be also recorded in the parent.
> >
> > Rene-PCSO
>
> Hi! Thanks. Therefore, all i have to do is to create sql statements from my purchases parent&child, payments parent&child and etc.
>
> If I want to present a purchase journal entry in this format, is this possible?
>
> Raw Materials Inventory - Resins 5000
> Accounts Payable 5000
>
> And not, (i think this is similar to the sql result, right?)
> Raw Materials Inventory - Resins 5000 Accounts Payable 5000
>
> Thanks again.
>
> BZ.

Hello again!
In addition to my question above, how should i design the beginning balances of my accounts?
I already have a chart of accounts table, I'm confuse on how to insert beginning balances for each account. Should I only have a field for begbal? or should I have another table to record the beginning balances of each account in every year?

Please help.
Thanks again 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