Form to collect data

[Erictsang]

Dear all

I need a quick advice

I have a master table with all record of customer purchase

I have to also collect the payment received from them on a separate form.

I should build table with the following field , and convert into a form for input

Client ID


Amount
Receipt

Then link with this Payment form withh the master table/form?

Eric

[June7]

Not necessarily.

Client has an account. Account balance is determined by difference of total purchases and total payments. This does not require a direct link between invoice and payment. Each table links to tblClients.

What can get complicated is if you have to calculate amount past due and you receive partial payments. And do you allow discounts for quick payment?

Instead of reinventing the wheel, I suggest an OTS app like QuickBooks for accounting.

[Erictsang]

June

In fact, i have to handle the partial payment

Invoice amount say, 100 and client pay via bank transfer, there is a bank charge which we have to absorb.

For example, bank transfer is 2. Hence, have to record this actual received is 8. balance is 2
I have to chase this with customer

Currently, i make a table and form to handle this transaction record and link it back to the master file by the client ID.

I hope i did it correctly.

[June7]

Did you mean 10 instead of 100?

Nothing there seems to require altering my comments.

Record receiving the 10 but also enter an adjusting transaction for the 2 fee. Client owes 2.