Can't Apply payment

[Joseph H]

Besta 4.6.0, PHP 7.2

This is the second incident of the same nature. I think the screenshot can explain more

[Blesta Addons]

are you sue the amount in the invoice is 120000, sometimes there are some value that is rounded by the currency formatter class.

[Joseph H]

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

[Tyson]

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.

[Joseph H]

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.

[Michael]

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

[Blesta Addons]

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 ?

 

[Paul]

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.

[Joseph H]

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

[Tyson]

That's interesting, a  transaction for 120000 won't apply to a total of 120000.. something I'll need to test myself.

[Joseph H]

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.

[Tyson]

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.