Billing Schedule Calculation Help

Hi, Michele –

Tricky one. The TR_BILLING_SCHEDULE documentation states that “Percentages are always calculated based on the total contribution, invoice, or order amount. The value of the last payment does not matter as the last payment is always calculated as the remaining amount due, but a value is required so that the total number of payments is correct.”

This explains the behaviour you’re seeing, but I can’t think of a scheduled way around the issue. The syntax of the Bill amounts field won’t allow deeper calculation – so you can’t have, say, (30%-122) as a value.

Anybody else out there have a clever idea?

C.//

X.

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Michele Keutsch
Sent: 24 February 2015 21:23
To: Chris Campbell
Subject: [Tessitura Ticketing Forum] Billing Schedule Calculation Help

I'm trying to create a billing schedule that does the following:

Order Total    $1000

Payment 1     $122 - due now

Payment 2       30%  - this needs to be 30% of the balance AFTER the $122 has been paid, so 30% of $878 = $263.40

Payment 3       balance  - after payment 1 & 2 = $614.60

I have the schedule set up as 122,30%,70% but it's not calculating the way I need it to as above, it's taking 30% of $1000 and then the $122 comes off Payment 3.

Is there a way to have Payment 2 reflect the balance of the order after payment 1 has been paid?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Hi, Michele –

Tricky one. The TR_BILLING_SCHEDULE documentation states that “Percentages are always calculated based on the total contribution, invoice, or order amount. The value of the last payment does not matter as the last payment is always calculated as the remaining amount due, but a value is required so that the total number of payments is correct.”

This explains the behaviour you’re seeing, but I can’t think of a scheduled way around the issue. The syntax of the Bill amounts field won’t allow deeper calculation – so you can’t have, say, (30%-122) as a value.

Anybody else out there have a clever idea?

C.//

X.

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Michele Keutsch
Sent: 24 February 2015 21:23
To: Chris Campbell
Subject: [Tessitura Ticketing Forum] Billing Schedule Calculation Help

I'm trying to create a billing schedule that does the following:

Order Total    $1000

Payment 1     $122 - due now

Payment 2       30%  - this needs to be 30% of the balance AFTER the $122 has been paid, so 30% of $878 = $263.40

Payment 3       balance  - after payment 1 & 2 = $614.60

I have the schedule set up as 122,30%,70% but it's not calculating the way I need it to as above, it's taking 30% of $1000 and then the $122 comes off Payment 3.

Is there a way to have Payment 2 reflect the balance of the order after payment 1 has been paid?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!