Joseph H Posted August 23, 2019 Report Share Posted August 23, 2019 Besta 4.6.0, PHP 7.2 This is the second incident of the same nature. I think the screenshot can explain more Quote Link to comment Share on other sites More sharing options...
Blesta Addons Posted August 23, 2019 Report Share Posted August 23, 2019 are you sue the amount in the invoice is 120000, sometimes there are some value that is rounded by the currency formatter class. Quote Link to comment Share on other sites More sharing options...
Joseph H Posted August 23, 2019 Author Report Share Posted August 23, 2019 1 hour ago, Blesta Addons said: are you sue the amount in the invoice is 120000, sometimes there are some value that is rounded by the currency formatter class. I'm sure it's the same value all same currency Quote Link to comment Share on other sites More sharing options...
Tyson Posted August 23, 2019 Report Share Posted August 23, 2019 What is the precise invoice total? It says 120,000, but it sounds like there may be a non-zero decimal value added to it, e.g. 120000.0001. If the invoice was partially paid from a separate transaction then that could contribute to a total value that contains a non-zero decimal value that accounts for that discrepancy. In Blesta v4.7.0, we've updated amount rounding to use the currency's defined precision so issues like that shouldn't arise again. Quote Link to comment Share on other sites More sharing options...
Joseph H Posted August 23, 2019 Author Report Share Posted August 23, 2019 1 hour ago, Tyson said: What is the precise invoice total? It says 120,000, but it sounds like there may be a non-zero decimal value added to it, e.g. 120000.0001. If the invoice was partially paid from a separate transaction then that could contribute to a total value that contains a non-zero decimal value that accounts for that discrepancy. In Blesta v4.7.0, we've updated amount rounding to use the currency's defined precision so issues like that shouldn't arise again. The invoice total is 120000. We don't usually use decimals for our currency as so all prices are exact. And there is no credit remaining from any previous transactions. Quote Link to comment Share on other sites More sharing options...
Michael Posted August 23, 2019 Report Share Posted August 23, 2019 Don't you need to put the comma? Like for in my instances if it's £15.00 I don't put 1500 I put 15.00 Joseph H 1 Quote Link to comment Share on other sites More sharing options...
Blesta Addons Posted August 24, 2019 Report Share Posted August 24, 2019 21 hours ago, Joseph H said: The invoice total is 120000. We don't usually use decimals for our currency as so all prices are exact. And there is no credit remaining from any previous transactions. HAVE YOU CHECKED THE ENTRY IN DATABASE BY PHPMYADMIN FOR EXAMPLE ? Joseph H and Paul 2 Quote Link to comment Share on other sites More sharing options...
Paul Posted August 26, 2019 Report Share Posted August 26, 2019 Yeah I think you should check the database and see what the total actually is. As Tyson mentioned, there is a good chance that there is some hidden decimal value and the total is not adding up. You can also try editing the invoice, and statically enter the value. If you are using quantities, then remove the quantity and enter the total value as a single quantity and try to process. Quote Link to comment Share on other sites More sharing options...
Joseph H Posted September 3, 2019 Author Report Share Posted September 3, 2019 Sorry for the long delay on this from the mysql database. All values are the same. But the payment wont apply From transactions table From Invoices table Quote Link to comment Share on other sites More sharing options...
Tyson Posted September 3, 2019 Report Share Posted September 3, 2019 That's interesting, a transaction for 120000 won't apply to a total of 120000.. something I'll need to test myself. Quote Link to comment Share on other sites More sharing options...
Joseph H Posted September 4, 2019 Author Report Share Posted September 4, 2019 7 hours ago, Tyson said: That's interesting, a transaction for 120000 won't apply to a total of 120000.. something I'll need to test myself. I found the issue, but still it's a weird scenario. I checked and saw there was 0.22 of credit applied to the Profoma invoice, removing the credit allowed for the funds to be applied to the amount. But even if there was a small amount applied to the profoma, why is that preventing another transaction from being applied. Quote Link to comment Share on other sites More sharing options...
Tyson Posted September 4, 2019 Report Share Posted September 4, 2019 One case may be that you were trying to apply 120000 even though only 119999.78 was available to apply from the transaction, so you received the error about trying to apply more than was available. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.