Forum

Dashboard not wotking and number problems

Posted in CategoryGeneral
  • Andrej
    Andrej Jovanovic   ( User ) 7 months ago

    Hi,

    I updated to last version of akaunting and tried to make new revenue income. I made new curency and set it default with curency rate of  1.00000000.

    I entered 4200 and it saved the amount as 420 000 000. Like it was multiplied with 10 000. It does the same when I make new expense. After I added income and expense my dashboard broke. Probably beacuse, and this is the weird part, my bank account shows my total of 4 100 which is supposed to be as my expense was 100.

    What could cause the problem and inconsistency?

  • Denis
    Denis Duliçi   ( Admin ) 7 months ago

    Hello Andrej. You should set the currency rate as 1, not 1.00000000.

  • Andrej
    Andrej Jovanovic   ( User ) 7 months ago

    Hello Denis,

    I set currency rate as 1 but this is what I get when I save the currency

    So I guess it is the same problem like when I add an expense or income.

     

     

     

  • Denis
    Denis Duliçi   ( Admin ) 7 months ago

    I just tried on a new installation but was not able to reproduce such a problem. You can try to delete it and create a new one:

  • Andrej
    Andrej Jovanovic   ( User ) 7 months ago

    Hi, i deleted db and akaunting and installed it again with fresh db. This is the default situation that I get with the curency settings

    I later added Hrvatska again. As you can see, by default my curencies have 8 decimal points. And after adding kuna I was still having the same problems. But then i tried with dollars and dollars were working fine.

    This is 4500 amount for dollars and 3501 for kn. Then I went to debug things and realized that something is wrong with the currency code for kuna (HRK). I am not sure what do you do with this but here is what I tested.

    Since dollar works I renamed dollar curency to kuna and left the dollar code and it still worked normal. It's rate was 1.00000000 so I realized that it should also work when I switch the code to HRK because I ment it was just suppose to add a currency prefix or postfix, but when I changed dollar curency to HRK the amounts again started to multiply and I got same reesult as from above picture. So this probably is the issue. Have you had similar problems before with currency codes? If not this should probably go on github issues.

  • APOSTOLOS
    APOSTOLOS STEFANIDES   ( User ) 7 months ago

    Same error here on invoice

    GUF 1 € 100.000,00 € 100.000,00

    Subtotal: € 100.000,00

    GR VAT: € 24.000,00

    Total: € 12,40

     

  • Stefan
    Stefan Ilivanov   ( User ) 6 months ago

    2 New installations on localhost with PHP 7.1 and on www.coolicehost.com (with PHP 7.0, Litespeed cache Off) - currency changes to 1.000000, and in products inventory operator should enter then as 0.0022 EURO, to get final price as 22 EURO. Invoices don't work with such prices, shows 0 everywhere.

     

    Detailed info for the enviroment:

     

    PHP Settings:

    Setting Value
     
    Safe Mode Off
    Open basedir None
    Display Errors Off
    Short Open Tags On
    File Uploads On
    Magic Quotes Off
    Register Globals Off
    Output Buffering On
    Session Save Path /tmp
    Session Auto Start 0
    XML Enabled Yes
    Zlib Enabled Yes
    Native ZIP Enabled Yes
    Disabled Functions show_source, system, shell_exec, passthru, exec, popen, proc_open
    Multibyte String (mbstring) Enabled Yes
    Iconv Available Yes
    Maximum Input Variables 1000

     

    Linux h27.coolice.host 3.10.0-614.10.2.lve1.4.55.el7.x86_64 #1 SMP Tue Jun 20 08:59:12 EDT 2017 x86_64
    Database Version 10.1.24-MariaDB-cll-lve
    Database Collation latin1_swedish_ci
    Database Connection Collation utf8mb4_general_ci
    PHP Version 7.0.26
    Web Server LiteSpeed
    WebServer to PHP Interface

    litespeed

     

     

  • Stefan
    Stefan Ilivanov   ( User ) 6 months ago

    Database structure is fucked up by the installer of 1.1.6

     

    Currency table on Rate record shows Double 15,7 instead of INT , Items table, Invoices.... everything is fucked up, changed those doubles to INT 11 and everything seems fine.... 

     

    Better release 1.1.6.1 asap as bug fix release of those

    Currency - RATE

    Items - 

    Invoice_Items

    Invoice_Totals

    or every table.....

    in Payments the same situation

    (yeah whole database - search, verify and replace)

    Finally good looking and properly calculated invoice - http://i65.tinypic.com/2r5yuyo.png

    Unfortunatelly, I should abandon translation and support forums for Bulgarian and Macedonian users... looks like no one watching those forums and have to look for another option or fork

     

  • Horia
    Horia Ungurean   ( User ) 1 month ago

    this issue is still not solved in 1.2.5. is to bad...the app is very good!

Please login or register to leave a response.