Link to home
Create AccountLog in
Avatar of Glen Gibb
Glen GibbFlag for Canada

asked on

Running Balance

Experts,

I need to supply a running balance for my clients.

I have tables to track invoices and invoice items. I also track transactions and amounts received.

These work great to show what is owed and what is paid on a particular invoice over a period of time, but if a previous invoice had a $100 balance owing on it, how can I easily discover it and add the extra amount to the new balance?

Do I need to add a "balance" field to the invoice table?.

What is the best way to give the customer a current balance?

Capt
ASKER CERTIFIED SOLUTION
Avatar of Steve Tempest
Steve Tempest
Flag of Australia image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Glen Gibb

ASKER

Easy, peasy, lemon squeezy.

I got hung up on the individual invoice, where I should have been thinking client.
Tnx.