Batch Payments
- artadot
- 100 Club: Active Contributor
- Posts: 122
- Joined: Thu Apr 03, 2014 7:14 am
- Location: Strathroy Ontario
Batch Payments
I have had this happen a few times now. I am applying a cheque payment in the Batch Payments. The cheque amount is the exact amount owing, but when I apply the payment a box pops up saying " apply excess amount to customer 0.00" or something very close to that, even thought there isn't a balance left. I have to say yes or it will not apply the cheque. It doesn't happen every time and it isn't a big problem, just wondered if there is a fix for it
There are no mistakes only lessons to be learned. ~ Dot
- Johnny5
- 500 Club: Champion Contributor
- Posts: 654
- Joined: Wed May 26, 2004 2:03 pm
- Location: John Dwulet
Re: Batch Payments
There is something in Manager causes some balance due amounts to be fractional pennies ($0.001 for example). We have a development task to find out why it is doing that and fix it for our Q2 release .
JD
JD
John Dwulet AKA: Johnny5
Retired - Mitchell1
Retired - Mitchell1
- Rich
- 4K Ultra Amazing Contributor
- Posts: 4049
- Joined: Tue Sep 06, 2005 10:16 am
- Location: Somewhere in Michigan
- Contact:
Re: Batch Payments
Ok, crazy question maybe, but just why does it calculate like 0.001? I have yet to charge a customer $129.994.Johnny5 wrote:There is something in Manager causes some balance due amounts to be fractional pennies ($0.001 for example). We have a development task to find out why it is doing that and fix it for our Q2 release .
JD
Actually the only i have EVER seen anything like it is at a gas station where they say gas is $3.299. I have yet to be able to stop a gas pump with the .009 showing. So if a customer owes us $100.00 and pays us $100.00 how can it be 0.001 off?
Rich Hays
Work 9-11 or 616-696-0020
Being able to get CAPE off a Skew T chart is important in this hobby.
Work 9-11 or 616-696-0020
Being able to get CAPE off a Skew T chart is important in this hobby.
- Johnny5
- 500 Club: Champion Contributor
- Posts: 654
- Joined: Wed May 26, 2004 2:03 pm
- Location: John Dwulet
Re: Batch Payments
There is evidently a calculation we missed when we standardized all the rounding within Manager. The rounding results in numbers with several decimal places, thus it is greater than 0, but less than a penny. We have a fix in the works for this to be included in the Q2,
JD
JD
John Dwulet AKA: Johnny5
Retired - Mitchell1
Retired - Mitchell1
- Rich
- 4K Ultra Amazing Contributor
- Posts: 4049
- Joined: Tue Sep 06, 2005 10:16 am
- Location: Somewhere in Michigan
- Contact:
Re: Batch Payments
Well, that makes perfect.......Cents........
Rich Hays
Work 9-11 or 616-696-0020
Being able to get CAPE off a Skew T chart is important in this hobby.
Work 9-11 or 616-696-0020
Being able to get CAPE off a Skew T chart is important in this hobby.
-
- 1500 Club Master Plus Contributor
- Posts: 1705
- Joined: Thu Mar 01, 2007 12:19 pm
Re: Batch Payments
Rich did you pose the first question with that in mind or did that come in a flash after JC responded? 

Jeff Fitzgerald - retired
Treasure Coast of Florida
"there will be enough time to sleep when we're dead"
Treasure Coast of Florida
"there will be enough time to sleep when we're dead"
- Rich
- 4K Ultra Amazing Contributor
- Posts: 4049
- Joined: Tue Sep 06, 2005 10:16 am
- Location: Somewhere in Michigan
- Contact:
Re: Batch Payments
Well, it does appear that i did, and I am actually that brilliant, but no. But I am not brave enough to do that to "The Man', He and others like Tim could make my life hell. <-
In case that gets edited lol
I have often wondered this. Had seen it in the past, how a computer rounds and it comes out wrong. I guess if we entered a part for $1.999 and some other stuff as $2.016, but we only "see" them as $2.00 and $2.02, i could understand the rounding issue. However, to my knowledge no one uses M1 for factory or multi-part bidding. So I have always been baffled by this. To me $2.00+$2.02 is very simple, $4.02. So how can the system have a rounding error, unless it just makes up the "0.00#"

I have often wondered this. Had seen it in the past, how a computer rounds and it comes out wrong. I guess if we entered a part for $1.999 and some other stuff as $2.016, but we only "see" them as $2.00 and $2.02, i could understand the rounding issue. However, to my knowledge no one uses M1 for factory or multi-part bidding. So I have always been baffled by this. To me $2.00+$2.02 is very simple, $4.02. So how can the system have a rounding error, unless it just makes up the "0.00#"
Rich Hays
Work 9-11 or 616-696-0020
Being able to get CAPE off a Skew T chart is important in this hobby.
Work 9-11 or 616-696-0020
Being able to get CAPE off a Skew T chart is important in this hobby.
- ricmorin
- 5K Holy Smokes Contributor
- Posts: 5997
- Joined: Mon Jul 25, 2005 10:11 am
- Location: New Hampshire
- Contact:
Re: Batch Payments
It can occur when you have taxes. Consider an order that totals 55.23. There is a tax of 3.21%. The tax calculation goes 6 places after the decimal.
Consider simple labor. 2.34 hours times 83.23/hour. That equals 194.7582. This is going on in the background all the time but we don't see it.

Consider simple labor. 2.34 hours times 83.23/hour. That equals 194.7582. This is going on in the background all the time but we don't see it.

Ric Morin - Volunteer Forum Moderator, Shop Owner, ASE Master L1
Motorcar Alternatives, LLC
603-622-6434 x203
www.motorcaralternatives.com
I find my life is a lot easier when I use Special Orders
Motorcar Alternatives, LLC
603-622-6434 x203
www.motorcaralternatives.com
I find my life is a lot easier when I use Special Orders
- Rich
- 4K Ultra Amazing Contributor
- Posts: 4049
- Joined: Tue Sep 06, 2005 10:16 am
- Location: Somewhere in Michigan
- Contact:
Re: Batch Payments
The answer to that last one is simple, shoot the guy who set the labor rate at 83.23 per hour, then beat the SR that didn't bump that labor up to 2.4 or 2.5.ricmorin wrote:It can occur when you have taxes. Consider an order that totals 55.23. There is a tax of 3.21%. The tax calculation goes 6 places after the decimal.
Consider simple labor. 2.34 hours times 83.23/hour. That equals 194.7582. This is going on in the background all the time but we don't see it.
Who has tax of 3.21% for sales tax? I know we do for Payroll tax, but that isnt a M! issue.
Rich Hays
Work 9-11 or 616-696-0020
Being able to get CAPE off a Skew T chart is important in this hobby.
Work 9-11 or 616-696-0020
Being able to get CAPE off a Skew T chart is important in this hobby.
Re: Batch Payments
Rich wrote:
The answer to that last one is simple, shoot the guy who set the labor rate at 83.23 per hour, then beat the SR that didn't bump that labor up to 2.4 or 2.5.
Who has tax of 3.21% for sales tax? I know we do for Payroll tax, but that isnt a M! issue.

M1 Product Manager
- Rich
- 4K Ultra Amazing Contributor
- Posts: 4049
- Joined: Tue Sep 06, 2005 10:16 am
- Location: Somewhere in Michigan
- Contact:
Re: Batch Payments
Does the East Coast do anything "normal"?Silky7 wrote:Rich wrote:
The answer to that last one is simple, shoot the guy who set the labor rate at 83.23 per hour, then beat the SR that didn't bump that labor up to 2.4 or 2.5.
Who has tax of 3.21% for sales tax? I know we do for Payroll tax, but that isnt a M! issue.Ric's that guy...
Rich Hays
Work 9-11 or 616-696-0020
Being able to get CAPE off a Skew T chart is important in this hobby.
Work 9-11 or 616-696-0020
Being able to get CAPE off a Skew T chart is important in this hobby.
- ricmorin
- 5K Holy Smokes Contributor
- Posts: 5997
- Joined: Mon Jul 25, 2005 10:11 am
- Location: New Hampshire
- Contact:
Re: Batch Payments
LOL. Normal is so relative.
Ric Morin - Volunteer Forum Moderator, Shop Owner, ASE Master L1
Motorcar Alternatives, LLC
603-622-6434 x203
www.motorcaralternatives.com
I find my life is a lot easier when I use Special Orders
Motorcar Alternatives, LLC
603-622-6434 x203
www.motorcaralternatives.com
I find my life is a lot easier when I use Special Orders
-
- 1500 Club Master Plus Contributor
- Posts: 1705
- Joined: Thu Mar 01, 2007 12:19 pm
Re: Batch Payments
I am considered normal in certain crowds! 

Jeff Fitzgerald - retired
Treasure Coast of Florida
"there will be enough time to sleep when we're dead"
Treasure Coast of Florida
"there will be enough time to sleep when we're dead"