I'm trying to create a billing schedule that I thought was easy, but has now become more difficult. We want a schedule that is $120 up front, 30% (less $120) in 30 days and the balance 30 days prior to the show.
The issue I have is with the 30% (less $120). I can't figure out how to write that in the bill amount. Any suggestions?
Hi Kayleb,
Yes, I think you have misunderstood. There should be 3 payments:
1. $120
2. 30% less $120
3. Remainder
I had the schedule working, until they threw in payment #2 requiring that it be less the $120 already paid.
Michele
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Kayleb McKelvain Sent: Tuesday, May 14, 2013 3:59 PM To: Michele Keutsch Subject: Re: [Tessitura Technical Forum] Billing Schedule
Hi Michele,
After paying $120, you should be able to manually schedule the payment plan with 3 payments for the remaining balance. Unfortunately it looks like you will have to do a little math but setting the billing schedule shouldn't be too difficult. Did I misunderstand your request?
Cheers,
KMK
From: Michele Keutsch <bounce-michelekeutsch5100@tessituranetwork.com> Sent: 5/8/2013 12:36:12 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!
Did you ever figure out a solution to this? We're trying to implement something similar. $125 deposit, then quarterly payments of 25% of remaining balance (less the deposit) or $125 with nine monthly payments of 11.11% of remaining balance (less the deposit).
Hi Sara - no, still a pain point here.
Sara,
Would invoices work for this? You can put a payment schedule on an invoice and it will deduct the value of any deposit/initial payment made to the order before calculating the value of the invoice payment. And invoices can be automatically billed like order payment schedules.
Jonathan Smillie
How would that work - wouldn't it still use the billing schedule?
Michele Keutsch- For Sara's situation, I was thinking along the lines of paying off the order with two payments: making the $125 deposit /first/, then paying the order off with an invoice payment (so two payments on the original order), so that the balance being invoiced is the original value of the order less the $125 deposit. The schedule in question would live on the invoice, not the order, so would calculate only from the value invoiced. In your case, the closest this could come to resolving the issue is: making the $120 down payment, paying the order off with an invoice, making a billing schedule on the invoice for 30% and 70% of the remainder respectively. It wouldn't be exact to your formula (the reduction of the $120 down payment would be spread across the remaining installments) but it would at least calculate from a total that reflected that initial payment.
The core of the issue is twofold: first, that schedules on the order will always calculate on the full value of the order, and will only adjust to the degree that installments for which payment has been received will be marked paid. Secondly, the documentation is somewhat unclear when it says that the Bill Amounts field can contain "fixed amounts, percentages or a combination of the two" - this only means that some values in the field can be percentages, some can be fixed amounts, and that not all values in the same billing schedule have to be of the same kind. What it doesn't mean, unfortunately, is that you can do math like "120,(30%-120),100%" to schedule your installments.