BV Commerce Forum
»
BV Commerce Support
»
General Support
»
Order.AmountDue Calculation for Email Templates
Rank: Member
Joined: 1/23/2013(UTC)
Posts: 267
Location: Joliet, IL
Thanks: 64 times
|
It seems that the calculation for [[Order.AmountDue]] is not taking into account partial payments. An order for $1,000 with a $500 partial payment still shows $1,000 as the Amount Due line item. Also, is there a formula for Amount Paid? I don't see [[Order.AmountPaid]] as an option. I think it would be a good idea to have that in the subtotals to clarify the Amount Due.
|
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
Originally Posted by: TKatch  It seems that the calculation for [[Order.AmountDue]] is not taking into account partial payments. That's not how it works. It's intended to match the "Amount Due" shown on the One Page Checkout Plus. It is calculated like this: Code:[[Order.AmountDue]] = GrandTotal - SUM(All Gift Cards) - Loyalty Points Essentially it is showing the amount of out-of-pocket money the customer is paying for their order. Originally Posted by: TKatch Also, is there a formula for Amount Paid? I don't see [[Order.AmountPaid]] as an option. I think it would be a good idea to have that in the subtotals to clarify the Amount Due. No. Given my explanation above I think you probably understand why. |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Member
Joined: 1/23/2013(UTC)
Posts: 267
Location: Joliet, IL
Thanks: 64 times
|
Do you think maybe we could include formulas for Paid To-Date and Balance Due? These are not entirely uncommon for invoices. I have corporate clients that pay half up front and then want a separate invoice showing this. We currently have to construct one from scratch in MS Word.
|
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
I can certainly see how this would be useful. We'll consider this as a possible new feature. Thanks! |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.