[atd80d]

Sorry – I cleared the error by writing off the small balance owing on that invoice. Hence the problem has gone away.
One thing I have noticed in the past with the 2011 version is I had a problem with small rounding errors when filling in the invoice amount in the amount paid rather than just accepting the pre-populated field and processing the payment (on invoices paid in full). It was a if the prepopulated field had some hidden decimals that were taken care of with a full payment.

So on this with the problematic invoice I entered the part payment and a similar problem occurred.

[atd80d]

Looking back at all the saved versions the localPrecision in config/custom.config.ini (and config/custom.config.php) has always been set to 2.

localLocale = en_UK
localCurrencyCode = GBP
localPrecision = 2

I tried opening the invoice and saving it and those decimals are still there. Bit of a strange one this! I guess part payment of invoices is a bit of an unusual situation…

• This reply was modified 2 years, 3 months ago by atd80d.

[atd80d]

Bit more info… In the data field the amount owing is stored to 6 decimal places, so non-zero decimals after that are spurious i.e. the 3 [20.450000000000003]

Attachments:

1. 

   owing.png
   

[atd80d]

Thanks again for your support with this.

Table now fills with all invoices.

It looks like there is a rounding error from a part payment of an invoice resulting in an balance and causing an overflow of decimal places?

Attachments:

1. 

   anomaly.png
   

[atd80d]

Thank you for your help with this.

(1) Language Settings
I have checked language settings on both system defaults and the default invoice and these look correct.

(2) intl and “gdt” extensions.
I can see an intl extension, but not a gdt – perhaps this was a typo?

——————-
intl
Internationalization support enabled
ICU version 63.1
ICU Data version 63.1
ICU Unicode version 11.0
——————–
gd
GD Support enabled
GD headers Version 2.2.5
GD library Version 2.2.5
———————

(3) Setting the following:
; Production site configuration data
[production]
debugLevel = All
debugErrorReporting = E_ERROR

Doesn’t add anything to tmp/log/si.log

Are there any other things I should check.

p.s. I should point out the reporting is working, e.g. total sales and Debtors by amount owed etc. So the database entries for the existing invoices seem to be being accessed correctly.

Only the Invoices summary grid in “Filter: All” shows “Loading…” and no entries.

With the list set to “Show All Entries” I get:
Showing 0 to 0 of 0 entries

With the list set to All

The Due category does show an entry.
Please see set of screenshots attached which might help.

Attachments:

1. 

   SimpleInvoices.png
   

[Author]

Posts