> > > 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