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: Rene Relucio
  Where is Rene Relucio?
 Quezon City
 Philippines
 Rene Relucio
 Tags
Subject: Thank you Sir Dale and Sir Rene
Thread ID: 21829 Message ID: 21974 # Views: 8 # Ratings: 0
Version: Visual FoxPro 6 Category: General VFP Topics
Date: Sunday, April 06, 2003 2:00:15 PM         
   


> > > 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
>
> What is important is that the rows returned to you by SQL have all the data you need. If you use this with report forms, you may need to process these rows to come up with new table, organized in such a way suited for displaying or printing purposes only using Report form.
> Ex.
> DATE, PARTICULAR, ACCTCODE, DEBIT, CREDIT
>
> If you organize your SQL statement that can return rows ready for report form, so much the better.
>
> If you want to print a ledger,
> You may need to ORDER BY your statement for instance,
> a returned rows with redundancies and ORDER BY GLNAME, DATE:
>
> GLNAME BEGBAL DATE PARTICULAR AMOUNT
> RMI-RESINS 10000 03-01-03 Replishment 4000
> RMI-RESINS 10000 03-02-03 Emergency purchase 5000
> RMI-RESINS 10000 03-03-03 whatever 2000
> RMI-RESINS 10000 03-04-03 whatever 1000
> RMI-RESINS 10000 03-05-03 whatever 4000
> RMI-RESINS 10000 03-06-03 whatever 3000
> RMI-RESINS 10000 03-07-03 whatever 6000
>
> Create a Group band in Report form and place the GLNAME, BEGBAL under this band.
> Put the date, particular, amount under the Detail band.
>
> Rene-PCSO


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