A sell to several buyers.

[Enigma20xx]

Hello to all.

 

What I’m trying to accomplish is to make an invoice that reflects the payment from several buyers.

My problem is that I don’t know how to calculate the quantity remaining to keep on with the payments.

 

I.e. Selling a house/cellphone whatever.

 

Price: $40,000. There are 3 buyers. 1 wants to pay an exactly amount and the other 2 want to pay the 50% of the quantity remaining.

 

Peter $10,000. 40,000-10,000=$30,000

Paul 50% of the price remaining. 30,000*50%=$15,000

 

Now here is another problem:

 

Mary 50% of the price remaining. 15,000*50%=$7,500

 

I attach the file I’m working with so you can see my little progress.

 

As always, thanks for your advice and help .

SellToSeveral.zip

[Matthew F]

Something like this?

 

SellToSeveral.fmp12.zip

[Enigma20xx]

Dear Matthew F, no words.

Thank you for the great work. Awesome.

Just what I was trying to accomplish. I could never get there,specially the relationship part.

Thanks again and I'm sure your sample file will help others too.