Idea in creating accounting system

[June7]

I also recommend not reinventing the wheel - QuickBooks is a solid accounting software - I have used it.



Journal entries are just a type of transaction record. In a double entry system, every transaction requires two entries - a debit and a credit. When I studied accounting, it was done in large ledger books with specialized columns (like spreadsheets). Translating this into a RDBMS is not a trivial exercise.

[emperor]

thanks for your reply, i got my own idea on how to do it.. i created another table for my purchase journal, and with my purchase entry form i used a code to record it to my purchase journal table. i also used an update query to update my purchase journal table everytime i changed data in my purchase entry form.

[emperor]

here's a look for my journal entry...

[Homegrownandy]

looks good to me.. although I didn't even know what one was a few days ago

[emperor]

thanks to laughingbull..