Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    1

    Unanswered: line item payment posting

    There are times when clients do not pay the entire balance on an invoice but make monthly payments on it instead. How do I apply multiple payments to one invoice in my form/table?

    My tblCharges includes, amoung other fields, InvoiceID and Charges. My tblPmts includes InvoiceID, pmt1, pmt2, pmt3, date1, date2, date3 but this seems cumbersum and, on occasion, there may be more payment/date fields needed than just the three. My frmBookkeeping has all of the above displayed and is doable but am wondering if there is a better, more streamlined way of accomplishing this.

    Any suggestions?

    eft

  2. #2
    Join Date
    Oct 2001
    Location
    Chicago
    Posts
    440
    tblPmts: InvoiceID, pmt, date

    i.e.
    121,150,09-12-02
    121,125,10-12-02
    121,175,11-12-02
    121,124,12-12-02

    Use a submform to display the payments - linking on the InvoiceID.


    Matt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •