in reply to payroll, mysql and perl question

Perhaps just a matter of taste but I'd use separate tables for keeping track of your preissued and issued checks. It's basically like the common practice of separate accounts for debits and credits.

The advantage is that it's notably easier to group the preissues to match the combined checks. For example, it should make it easier to deal with special situations where the amount paid might (temporarily) not equal the amount owed.

Replies are listed 'Best First'.
Re^2: payroll, mysql and perl question
by powerhouse (Friar) on Jan 02, 2008 at 17:05 UTC
    Actually, that is a very good idea, I just was trying to keep the databases to a minimal, we already have over 350 tables in it, a little much... thx though
    thx,
    Richard