taxes

GPWEB
GPWEB
Offline
0
Hi,
it seems a bug, i didn't see before=

when i add taxe ( example 19.6% in france) and a discount: -10%
the amount of taxes is calculated on subtotal evreytime even if we make a discount!

see here please:

with taxe only

Sous total HT €1,714.00€
TVA: 19.6 €335.94€
Total €2,049.94€


without taxes:

Subtotal HT €1,714.00€
Geste commercial -10% €-171.40€
Total €1,542.60

with taxes + discount: it's wrong taxe tva should be calculated after -10%, not on subtotal

Sous total HT €1,714.00€
Geste commercial -10% €-171.40€
TVA: 19.6 €335.94€ !!!!!! ( wrong 1714 -10% = 1542.6 and 19.6% of 1542.6 is not 335.94 ! )
Total €1,878.54€

thanks a lot
Responses (8)
  • Accepted Answer

    Thursday, September 12 2013, 11:39 AM - #Permalink
    0
    it's not a bug ;) you have to define WHEN you want to apply the taxes.

    go to TAX MANAGER, and go to the discount tax, open it to edit. set it on "GROUP 1"

    then, on TVA, set it on "GROUP 2"

    this way TVA will be applied AFTER the discount :)

    let me know if it works.
    The reply is currently minimized Show
  • Accepted Answer

    GPWEB
    GPWEB
    Offline
    Friday, September 13 2013, 01:27 AM - #Permalink
    0
    Hi,
    probably i have an old version ( before you become joomlathat) ?

    i have not " group 1" or more....

    perhaps i should install you new soft, but i do not want to delete all my invoices already built....

    thanks
    The reply is currently minimized Show
  • Accepted Answer

    GPWEB
    GPWEB
    Offline
    Friday, September 13 2013, 01:34 AM - #Permalink
    0
    oh yes my actual version is 1.1.0

    yours actually 1.2.1

    i will try an update after backup
    The reply is currently minimized Show
  • Accepted Answer

    GPWEB
    GPWEB
    Offline
    Friday, September 13 2013, 02:07 AM - #Permalink
    0
    I updated to new version....but there is a big problem, after selected group2 and save here is what happen an bugs=

    TableTax Object ([id] => 0 [name] => TVA [type] => pour cent [value] => 19.6 [show_column] => 0 [commande] => 2 [_TBL: protected] => # __invoices_taxes [_tbl_key : protected] => id [_db: protected] => JDatabaseMySQLi Object ([name] => mysqli [nameQuote: protected] => `[nullDate: protected] => 0000-00-00 00:00:00 [dbMinimum: protected] => 5.0.4 [_database: JDatabase: private] => gpweb140_1 [connexion: protected] => mysqli Object ([affected_rows] => -1 [client_info] => 5.5.30 [client_version] => 50530 [connect_errno ] => 0 [connect_error] => [errno] => 1054 [error] => Unknown column 'commander' à 'liste des champs »[field_count] => 9 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.5.32-CLL [server_version] => 50532 [Stat] => Uptime: 3857700 Threads: 16 Questions: 2526251593 lentes requêtes: 92243 s'ouvre: 1399192 tables Flush: 1 tables ouvertes: 40960 requêtes par seconde en moyenne: 654,859 [SQLSTATE] => 00000 [protocol_version] => 10 [thread_id] => 30120362 [warning_count] => 0) [count: protected] => 0 [curseur: protected] => [debug: protected] => [limite: protected] => 0 [log: protected] => Array () [offset: protected] => 0 [sql: protected] => INSERT INTO `# __invoices_taxes` (`id`, `name `,` type `,` value `,` show_column `,` commande `) VALUES ('0 ',' TVA ',' pour cent ', '19 .6', '0 ', '2') [tablePrefix: protected] = > pklxd_ [utf: protected] => 1 [ErrorNum: protected] => 1054 [errorMsg: protected] => Unknown column 'commander' à 'liste de champ' SQL = INSERT INTO `pklxd_invoices_taxes` (`id`, `name` , `type`, `value`, `show_column`, `commande`) VALUES ('0 ',' TVA ',' pour cent ', '19 .6', '0 ', '2') [hasQuoted: protected] => [cité: protected] => Array ()) [_trackAssets: protected] => [_Rules: protected] => [_locked: protected] => [_errors: protected] => Array ([0] => JException Object ([ niveau: protected] => [code: protected] => 0 [message: protected] => TableTax :: magasin à © Choua © Unknown column 'commander' à 'liste de champ' SQL = INSERT INTO `pklxd_invoices_taxes` (`id` , `nom`, `type`, `value`, `show_column`, `commande`) VALUES ('0 ',' TVA ',' pour cent ', '19 .6', '0 ', '2') [info: protected] => [Fichier: protected] => / home/gpweb140/public_html/libraries/joomla/database/table.php [line: protected] => 621 [fonction: protected] => [classe: protected] => [ Type: protected] => [args: protected] => Array () [trace: protected] => [string: Exception: private] => [trace: Exception: private] => Array ([0] => Array ( [file] => / home/gpweb140/public_html/administrator/components/com_invoices/models/tax.php [en ligne] => 98 [fonction] => magasin [classe] => JTable [type] => -> [args ] => Array ()) [1] => Array ([file] => / home/gpweb140/public_html/administrator/components/com_invoices/controllers/tax.php [en ligne] => 41 [fonction] => magasin [ class] => TaxesModelTax [type] => -> [args] => Array ([0] =>)) [2] => Array ([file] => / home/gpweb140/public_html/libraries/joomla/application / component / controller.php [en ligne] => 761 [fonction] => save [classe] => TaxesControllerTax [type] => -> [args] => Array ()) [3] => Array ([fichier] => / home/gpweb140/public_html/administrator/components/com_invoices/invoices.php [en ligne] => 138 [fonction] => exécuter [classe] => JController [type] => -> [args] => Array ( [0] => save)) [4] => Array ([file] => / home/gpweb140/public_html/libraries/joomla/application/component/helper.php [en ligne] => 383 [args] => Array ([0] => / home/gpweb140/public_html/administrator/components/com_invoices/invoices.php) [fonction] => require_once) [5] => Array ([file] => / home/gpweb140/public_html/libraries / joomla / application / component / helper.php [en ligne] => 351 [fonction] => executeComponent [classe] => JComponentHelper [type] => :: [args] => Array ([0] => / home / gpweb140/public_html/administrator/components/com_invoices/invoices.php)) [6] => Array ([file] => / home/gpweb140/public_html/administrator/includes/application.php [en ligne] => 153 [fonction] => renderComponent [classe] => JComponentHelper [type] => :: [args] => Array ([0] => com_invoices)) [7] => Array ([file] => / home/gpweb140/public_html / administrator / index.php [line] => 46 [fonction] => envoi [classe] => JAdministrator [type] => -> [args] => Array ())) [précédent: Exception: private] =>) ))

    impossible to continue....

    please high priority
    The reply is currently minimized Show
  • Accepted Answer

    GPWEB
    GPWEB
    Offline
    Friday, September 13 2013, 02:11 AM - #Permalink
    0
    I lost all my invoices content.....grrrrrrr!!!!
    The reply is currently minimized Show
  • Accepted Answer

    Friday, September 13 2013, 08:37 AM - #Permalink
    0
    upgrading does not destroy any data, so don't panic.

    have you followed our upgrading instructions? http://www.joomlathat.com/documentation/invoice-manager/upgrading-from-1-1-0-to-1-2-0
    The reply is currently minimized Show
  • Accepted Answer

    GPWEB
    GPWEB
    Offline
    Saturday, September 14 2013, 10:41 AM - #Permalink
    0
    Hi, Thanks, ...it was working 90%.. But proucts are not now in the order.....!
    I suggestion you to developp an other version with products completely mobile on invoice...we should change the order ....

    Thanks
    Best regards
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, September 14 2013, 10:46 AM - #Permalink
    0
    that's also possible my friend! :) you can just "drag and drop" a product in the invoice to change it's order!

    have you tried it?
    The reply is currently minimized Show
Your Reply