Manager SE Reports & printing

Batch Payments

Batch Payments

Postby artadot » Thu Feb 16, 2017 8:40 am

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
artadot
100 Club: Active Contributor
100 Club: Active Contributor
 
Posts: 106
Joined: Thu Apr 03, 2014 7:14 am
Location: Strathroy Ontario

Re: Batch Payments

Postby Johnny5 » Thu Feb 16, 2017 8:57 am

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
Sr. Product Marketing Manager - Mitchell1
Tuck in behind me, I'll show you where to crash. 8)
User avatar
Johnny5
System Guru / Moderator
System Guru / Moderator
 
Posts: 669
Joined: Wed May 26, 2004 2:03 pm
Location: Mitchell 1 John Dwulet, Sr. Product Marketing Manager

Re: Batch Payments

Postby Rich » Thu Feb 16, 2017 10:53 am

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
Supporter of Project Semicolon
231-796-0550 work
http://share.garmin.com/RHAYS
User avatar
Rich
3K Time Lord Contributor
3K Time Lord Contributor
 
Posts: 3724
Joined: Tue Sep 06, 2005 10:16 am
Location: Gone hiking.

Re: Batch Payments

Postby Johnny5 » Thu Feb 16, 2017 12:26 pm

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
Sr. Product Marketing Manager - Mitchell1
Tuck in behind me, I'll show you where to crash. 8)
User avatar
Johnny5
System Guru / Moderator
System Guru / Moderator
 
Posts: 669
Joined: Wed May 26, 2004 2:03 pm
Location: Mitchell 1 John Dwulet, Sr. Product Marketing Manager

Re: Batch Payments

Postby Rich » Thu Feb 16, 2017 12:39 pm

Well, that makes perfect.......Cents........
Rich Hays
Supporter of Project Semicolon
231-796-0550 work
http://share.garmin.com/RHAYS
User avatar
Rich
3K Time Lord Contributor
3K Time Lord Contributor
 
Posts: 3724
Joined: Tue Sep 06, 2005 10:16 am
Location: Gone hiking.

Re: Batch Payments

Postby Jeff @ Able Auto » Thu Feb 16, 2017 12:54 pm

Rich did you pose the first question with that in mind or did that come in a flash after JC responded? :lol:
Jeff Fitzgerald owner
Able Auto Repair 772-462-0061
Treasure Coast of Florida
"there will be enough time to sleep when we're dead"
Jeff @ Able Auto
1500 Club Master Plus Contributor
1500 Club Master Plus Contributor
 
Posts: 1773
Joined: Thu Mar 01, 2007 12:19 pm
Location: Watch out for that cliff!!!

Re: Batch Payments

Postby Rich » Thu Feb 16, 2017 1:17 pm

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
Supporter of Project Semicolon
231-796-0550 work
http://share.garmin.com/RHAYS
User avatar
Rich
3K Time Lord Contributor
3K Time Lord Contributor
 
Posts: 3724
Joined: Tue Sep 06, 2005 10:16 am
Location: Gone hiking.

Re: Batch Payments

Postby ricmorin » Thu Feb 16, 2017 1:23 pm

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
https://www.facebook.com/motorcaralternatives

Reality continues to ruin my life.- Calvin
User avatar
ricmorin
5K Holy Smokes Contributor
5K Holy Smokes Contributor
 
Posts: 5268
Joined: Mon Jul 25, 2005 10:11 am
Location: New Hampshire

Re: Batch Payments

Postby Rich » Thu Feb 16, 2017 2:20 pm

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
Supporter of Project Semicolon
231-796-0550 work
http://share.garmin.com/RHAYS
User avatar
Rich
3K Time Lord Contributor
3K Time Lord Contributor
 
Posts: 3724
Joined: Tue Sep 06, 2005 10:16 am
Location: Gone hiking.

Re: Batch Payments

Postby Silky7 » Thu Feb 16, 2017 2:43 pm

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...
User avatar
Silky7
2nd Level Tech Support
2nd Level Tech Support
 
Posts: 685
Joined: Mon Dec 31, 2007 10:07 am

Re: Batch Payments

Postby Rich » Fri Feb 17, 2017 4:59 am

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
Supporter of Project Semicolon
231-796-0550 work
http://share.garmin.com/RHAYS
User avatar
Rich
3K Time Lord Contributor
3K Time Lord Contributor
 
Posts: 3724
Joined: Tue Sep 06, 2005 10:16 am
Location: Gone hiking.

Re: Batch Payments

Postby ricmorin » Fri Feb 17, 2017 5:03 am

LOL. Normal is so relative.
Ric Morin - Volunteer Forum Moderator, Shop Owner, ASE Master L1
Motorcar Alternatives, LLC
603-622-6434
https://www.facebook.com/motorcaralternatives

Reality continues to ruin my life.- Calvin
User avatar
ricmorin
5K Holy Smokes Contributor
5K Holy Smokes Contributor
 
Posts: 5268
Joined: Mon Jul 25, 2005 10:11 am
Location: New Hampshire

Re: Batch Payments

Postby Jeff @ Able Auto » Fri Feb 17, 2017 5:45 am

I am considered normal in certain crowds! :shock:
Jeff Fitzgerald owner
Able Auto Repair 772-462-0061
Treasure Coast of Florida
"there will be enough time to sleep when we're dead"
Jeff @ Able Auto
1500 Club Master Plus Contributor
1500 Club Master Plus Contributor
 
Posts: 1773
Joined: Thu Mar 01, 2007 12:19 pm
Location: Watch out for that cliff!!!

Return to Reports / Printing

Who is online

Users browsing this forum: No registered users and 1 guest