Invoice Items Table Tracking Both Charges & Payments

October 31, 201312 yr

:Â·) Hoping for some experience, advice/tips on this topic...

How to properly set up an InvoiceTable with child of ItemTable. ItemTable would track both charges to client and payments from client.

Then Payments would be attached to the BankTable to track "real" money. Note; BankTable would also track expenses.

1) Should charges and payments share the same amount_field â or should there be a charge_field and a payment_field?

2) How to attached/create a bank record to a payment

I've attached screen shots and demo file to help illustrate my questions.

Â Super thanks to any insight on this one!!!

November 2, 201312 yr

An updated version of the demo file.

November 7, 201312 yr

Randy,

Here is a slightly adjusted file.

Notice a couple things:

Use of filtered portals to separate Charges from Payments.
Single line portals w/filters, to show aggregated summary field from item table.
Summary field in Items table instead of manual calcs. ( works well with small record sets ).
Enter charges from invoice layout.
You will need to create a similar function to enter payments, likely from the "Bank" layout.
When you enter a new charge, it will auto-fill the "type" as a Charge.