Batch Payments

Manager SE Reports & printing
Locked
User avatar
artadot
100 Club: Active Contributor
100 Club: Active Contributor
Posts: 122
Joined: Thu Apr 03, 2014 7:14 am
Location: Strathroy Ontario

Batch Payments

Post by artadot »

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
User avatar
Johnny5
500 Club: Champion Contributor
500 Club: Champion Contributor
Posts: 654
Joined: Wed May 26, 2004 2:03 pm
Location: John Dwulet

Re: Batch Payments

Post by Johnny5 »

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
John Dwulet AKA: Johnny5
Retired - Mitchell1
User avatar
Rich
4K Ultra Amazing Contributor
4K Ultra Amazing Contributor
Posts: 4049
Joined: Tue Sep 06, 2005 10:16 am
Location: Somewhere in Michigan
Contact:

Re: Batch Payments

Post by Rich »

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
Ok, crazy question maybe, but just why does it calculate like 0.001? I have yet to charge a customer $129.994.

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.
User avatar
Johnny5
500 Club: Champion Contributor
500 Club: Champion Contributor
Posts: 654
Joined: Wed May 26, 2004 2:03 pm
Location: John Dwulet

Re: Batch Payments

Post by Johnny5 »

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
John Dwulet AKA: Johnny5
Retired - Mitchell1
User avatar
Rich
4K Ultra Amazing Contributor
4K Ultra Amazing Contributor
Posts: 4049
Joined: Tue Sep 06, 2005 10:16 am
Location: Somewhere in Michigan
Contact:

Re: Batch Payments

Post by Rich »

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.
Jeff @ Able Auto
1500 Club Master Plus Contributor
1500 Club Master Plus Contributor
Posts: 1705
Joined: Thu Mar 01, 2007 12:19 pm

Re: Batch Payments

Post by Jeff @ Able Auto »

Rich did you pose the first question with that in mind or did that come in a flash after JC responded? :lol:
Jeff Fitzgerald - retired
Treasure Coast of Florida
"there will be enough time to sleep when we're dead"
User avatar
Rich
4K Ultra Amazing Contributor
4K Ultra Amazing Contributor
Posts: 4049
Joined: Tue Sep 06, 2005 10:16 am
Location: Somewhere in Michigan
Contact:

Re: Batch Payments

Post by Rich »

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. <- :twisted: 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#"
Rich Hays
Work 9-11 or 616-696-0020
Being able to get CAPE off a Skew T chart is important in this hobby.
User avatar
ricmorin
5K Holy Smokes Contributor
5K Holy Smokes Contributor
Posts: 5997
Joined: Mon Jul 25, 2005 10:11 am
Location: New Hampshire
Contact:

Re: Batch Payments

Post by ricmorin »

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.

:D
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
User avatar
Rich
4K Ultra Amazing Contributor
4K Ultra Amazing Contributor
Posts: 4049
Joined: Tue Sep 06, 2005 10:16 am
Location: Somewhere in Michigan
Contact:

Re: Batch Payments

Post by Rich »

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.

:D
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.
Rich Hays
Work 9-11 or 616-696-0020
Being able to get CAPE off a Skew T chart is important in this hobby.
User avatar
Silky7
System Guru / Moderator
System Guru / Moderator
Posts: 1114
Joined: Mon Dec 31, 2007 10:07 am

Re: Batch Payments

Post by Silky7 »

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.
:D Ric's that guy...
M1 Product Manager
User avatar
Rich
4K Ultra Amazing Contributor
4K Ultra Amazing Contributor
Posts: 4049
Joined: Tue Sep 06, 2005 10:16 am
Location: Somewhere in Michigan
Contact:

Re: Batch Payments

Post by Rich »

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.
:D Ric's that guy...
Does the East Coast do anything "normal"?
Rich Hays
Work 9-11 or 616-696-0020
Being able to get CAPE off a Skew T chart is important in this hobby.
User avatar
ricmorin
5K Holy Smokes Contributor
5K Holy Smokes Contributor
Posts: 5997
Joined: Mon Jul 25, 2005 10:11 am
Location: New Hampshire
Contact:

Re: Batch Payments

Post by ricmorin »

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
Jeff @ Able Auto
1500 Club Master Plus Contributor
1500 Club Master Plus Contributor
Posts: 1705
Joined: Thu Mar 01, 2007 12:19 pm

Re: Batch Payments

Post by Jeff @ Able Auto »

I am considered normal in certain crowds! :shock:
Jeff Fitzgerald - retired
Treasure Coast of Florida
"there will be enough time to sleep when we're dead"
Locked

Return to “Reports + Printing”