Idea in creating accounting system

[emperor]

I've my purchase entry form and i'd like to create a journal entry too.. please give me some idea on how to do it, i'm stuck with it..

[LaughingBull]

need to know more about what you have as far as tables, queries etc... and what you are wanting to do.

[emperor]

i have my tblAccounts,those are my chart of accounts,tblPurchase and tblPurchaseDetails. i want to create a journal entry with my table data..

[emperor]

i need to create a table for my journal entry?

[LaughingBull]

my suggestion is to create a able query. and in that query you can calculate your balance. under create query in design you can select make table and select the tables you want to take the info from and when you run the query it makes a table and stores the information in that table and every time you run the query it updates the info in the table. there may be other ways with code to load a table but I am not that good at the code thing. hope this helps and maybe someone with more experience has other suggestions.

[Homegrownandy]

When you say journal entry, do you mean you want to write notes about a specific record?

If so... have a form for picking the record.. (either from a list or a search function) then from that record you want to open a new form relating to the selected record.

just add a button on the form that opens your journal form on the related record. (the wizard will do it for you).

[ItsMe]

You will need many tables to support what you are trying to do. My suggestion is to purchase an off the shelf solution like QuickBooks. To create an application in Access to do what you are describing takes a solid understanding of RDBMS and VBA, as well as a solid understanding of accounting principles.

[orange]

emperor,
If the purpose of your post and proposed database is to support a viable business, then take ItsMe's advice and buy something "off the shelf". Such packages have support, user forums....

Do you have a list of requirements - things the software/application must do; things you would like it to do
Make a list. Compare with COTS (commercial off the shelf) packages. Isolate top candidate(s). Many offer a free trial.
Note: The database is part of the solution. But it is the interface, forms, modules, reports and all the inherent algorithms that make the package. If you aren't sure if you need a table for Journal Entry, are you really going to design a full blown application that your company's business depends on?

[LaughingBull]

Here is my idea, 3 tables with one to many relationships.
One Form to enter the data and then a report to show you all your data like a journal.

[orange]

emperor,

You may get some ideas from this free data model from Barry Williams.

[emperor]

thank for the reply..

here is my screen shot for my purchse entry

[emperor]

should i make another table for my journal entry..

sample..

inventory 23,058.50
trade payable 23,058.50

[Homegrownandy]

What is a journal entry? Would there be many journal entry's for one record? does the journal entry data change? (if so what is that dependant on).

Most likely you will need a new table for these.

[orange]

Journal Entry

[Homegrownandy]

cool, not a term I hear often here in the UK. Good video anyway,