Jump to content
Salesforce and other SMB Solutions are coming soon. ×

cumulative total


Marmot

Recommended Posts

Say I have 2 tables - invoices and payments_received.

 

Say I have agreed a fixed fee (F) for a job and choose to invoice it in 3 tranches i.e 3 separate invoices (inv1, inv2, inv3).

 

inv1+inv2+inv3 = F.

 

I'd like each invoice to show total previous payments.

 

inv1 shows no previous payments

inv2 shows payment against inv1

inv3 shows payment againts inv1 and inv2

 

How do I set up a culmulative total field to to do this ?

 

Marmot

Link to comment
Share on other sites

I'm using a repeating field to specify previous payments via id numbers.

 

But it isn't working. The relationship between income paid in and current invoice just shows one previous payment.

 

How can I make a field - presumably a calculation field - sum up previous payments referred to in a repeating field via payment id no.s.?

 

Anyone ?

 

Marmot

Link to comment
Share on other sites

  • 2 weeks later...

Archived

This topic is now archived and is closed to further replies.



×
×
  • Create New...

Important Information

Terms of Use