Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 8262 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

I have a portal for inputing checks and when we make a partial payment we input that into the portal. Paid date, check number, amt. paid & running total that subtracts each time we input a check. so when we totally pay up. The running total reaches 0. Can anyone help me with this.

Thanks

Posted

I'd be glad to help. What's the problem?

  • Newbies
Posted

Hi! Here's my problem.

I have 2 db's

A 'Master db'

A 2

The 2 db's are Linked by Ivoice#.

In the 'a db' I want to type in Co Name, Invoice # and then in a portal 'a 2 db' I want to type in Partial payment or the enire amount that is owed. I have 1 field in 'a db'that contains the 'totalamountdue' field. I would like to keep a running subtracting total for that invoice #. This seems simple to do until i tried it.

Scott

Posted

1) Make sure your relationship is set to "allow creation of related records."

2) In your portal, make sure the fields are from the related (payments) file, not the current (invoice) file.

3) In the invoice file, calculate the TotalPaid:

Sum(payments::amount)

... and the balance:

InvoiceAmtDue - TotalPaid

This topic is 8262 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.