Forum Discussion

KellyLyons1's avatar
KellyLyons1
Qrew Cadet
4 years ago

Apply 1 payment to multiple invoices (records) at one time

I would like the option to apply 1 payment to multiple invoices at one time.  For example Client A has 2 separate invoices totally $5000.00.  I receive a check for this amount, but want to be able to choose which open invoices the payment applies to.  Any suggestions?

------------------------------
Kelly Lyons
------------------------------
App builders
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    4 years ago
    You'll need to have a setup that allows for splitting a payment. Typically, in a situation like this, I would suggest that you have a 3rd table that would act as a Child table to the other 2 tables, but that may not work for your use case. Instead, you may want to still create a new table - we'll call it Checks or possibly Transactions (depending on if you accept multiple forms of payment). This could be a child of Customers and a Parent to Payments. This would allow you to maintain your existing structure and not have to rebuild the current process significantly.

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quickbase Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------