Invoice Items Table Tracking Both Charges & Payments

[Dr. Evil]

:·) 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!!!

 

invoice_item_pmt_demo.fmp12.zip

[Dr. Evil]

An updated version of the demo file.

invoice_item_pmt_demoV3.fmp12.zip

[Josh Ormond]

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.

 

invoice_item_pmt_demoV4.fmp12.zip