Forums › Forums › OroCommerce › Wrong subtotal and tax total calculation
This topic contains 12 replies, has 4 voices, and was last updated by msulima 6 years, 7 months ago.
Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.
- CreatorTopic
- July 19, 2017 at 4:56 am #31920
Hello again,
I have another problem with totals calculation. It happens on front store and in admin panel. Look at the screenshots:
Front store:
Admin panel:
How to fix this?
- CreatorTopic
- AuthorReplies
- July 20, 2017 at 3:45 am #31921
Hi r.grabosz!
Are you still experiencing problems with this issue?
Have you tried to run app/console oro:price-lists:recalculate –all -vvv command ?
Do you have error messages in it?July 20, 2017 at 3:50 am #31922Hi Andrew!
Yes, I still have problem with wrong tax/totals displaying (probably wrong number formatting or wrong multiplies/divides by 100 or 10000).
Output of command is successfull, issue isn’t solved:
1234567php app/console oro:price-lists:recalculate --all -vvvStart processing of all Price rulesStart combining all Price ListsProcessing combined price list id: 8 - 35bd9d14efddde838aa2b0a8c9426964Processing price list: Domyślny cennik1/1 [============================] 100% < 1 sec/< 1 sec 102.0 MiB - Finished processing combined price list id: 8The cache is updated successfullyJuly 20, 2017 at 5:06 am #31923It seems here issue related to display formatting.
Can you check oro_shopping_list_total table, find there yours shopping list and check subtotal_value field? In front store subtotal correct – 6500, but in admin panel its multiplied by 1000 as i see.
– Can you create an order with different product and check total again please?
– Can you create same order with another currency (dollar) settings? May be some issues with yours currency settings.
– Which version of Commerce do you have?July 20, 2017 at 6:05 am #31924In <i>oro_shopping_list_total</i> table total is okay. Different products or currencies – does not change issue.
Total amount on order list in Sales -> Orders is okay. In order details it’s wrong, the same as tax amount.
On front there is problem only with tax amount.
OroCommerce packages version:
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230composer infoa2lix/translation-form-bundle 1.x-dev 5041f05akeneo/batch-bundle 0.4.2ass/xmlsecurity v1.1.1behat/behat v3.2.2behat/gherkin v4.4.5behat/mink v1.7.1behat/mink-extension v2.2behat/mink-selenium2-driver v1.3.1behat/symfony2-extension 2.1.1behat/transliterator v1.2.0besimple/soap-client v0.2.6besimple/soap-common v0.2.6bower-asset/autobahnjs v0.8.0bower-asset/autolinker.js 1.4.3bower-asset/backbone 1.2.3bower-asset/backbone-pageable 1.2.3bower-asset/backbone.paginator 2.0.5bower-asset/backgrid 0.3.7bower-asset/backgrid-paginator v0.3.8bower-asset/base64 1.0.1bower-asset/bean v1.0.6bower-asset/bootstrap v2.3.0bower-asset/chaplin 1.2.0bower-asset/crypto-js 3.1.7bower-asset/datepair 0.4.15bower-asset/elevatezoom3 3.0.8.1bower-asset/flotr2 dev-master df0ddedbower-asset/font-awesome v4.7.0bower-asset/fullcalendar v3.4.0bower-asset/jquery 3.1.1bower-asset/jquery-ajax-queue v0.0.1bower-asset/jquery-cookie v1.4.1bower-asset/jquery-creditcardvalidator v1.0.0bower-asset/jquery-form v4.2.1bower-asset/jquery-mousewheel 3.1.13bower-asset/jquery-ui-multiselect-widget v2.0.1bower-asset/jquery-validate 1.16.0bower-asset/jquery.numeric v1.5bower-asset/json2 dev-master e25ba46bower-asset/jsplumb 1.7.10bower-asset/less v2.5.3bower-asset/lightgallery 1.4.0bower-asset/malihu-custom-scrollbar-plugin 3.1.5bower-asset/moment 2.18.1bower-asset/moment-timezone 0.5.13bower-asset/numeral 2.0.6bower-asset/prism v1.6.0bower-asset/select2 3.4.1bower-asset/text 2.0.15bower-asset/timepicker 1.11.11bower-asset/underscore 1.8.3bower-asset/uniform v2.1.1bower-asset/when 2.4.0box/spout v2.3.2brick/math 0.5.4cboden/ratchet v0.2.8components/jquery 3.1.1components/jqueryui 1.12.1composer/ca-bundle 1.0.7composer/composer 1.4.2composer/semver 1.4.2composer/spdx-licenses 1.1.6doctrine/annotations v1.3.1doctrine/cache v1.6.1doctrine/collections v1.4.0doctrine/common v2.6.2doctrine/data-fixtures v1.2.2doctrine/dbal v2.5.5doctrine/doctrine-bundle 1.6.3doctrine/doctrine-cache-bundle 1.3.0doctrine/doctrine-fixtures-bundle 2.3.0doctrine/inflector v1.1.0doctrine/instantiator 1.0.5doctrine/lexer v1.0.1doctrine/orm v2.5.5escapestudios/wsse-authentication-bundle 1.0.2evenement/evenement v1.0.0ezyang/htmlpurifier v4.8.0friendsofphp/php-cs-fixer v2.1.3friendsofsymfony/jsrouting-bundle 1.6.0friendsofsymfony/rest-bundle 1.7.9fzaninotto/faker v1.6.0gedmo/doctrine-extensions v2.4.30genemu/form-bundle v2.3.0guzzle/guzzle v3.7.4hwi/oauth-bundle 0.5.3imagine/imagine v0.6.3incenteev/composer-parameter-handler v2.1.2instaclick/php-webdriver 1.4.5ircmaxell/password-compat v1.0.4jdare/clank-bundle 0.1.6jdorn/sql-formatter v1.2.17jms/cg 1.2.0jms/metadata 1.6.0jms/parser-lib 1.0.0jms/serializer 1.4.2jms/serializer-bundle 1.1.0johnkary/phpunit-speedtrap v1.0.3justinrainbow/json-schema 5.2.1knplabs/gaufrette v0.4.0knplabs/knp-gaufrette-bundle 0.3.0knplabs/knp-menu 2.2.0knplabs/knp-menu-bundle 2.1.3kriswallsmith/assetic v1.4.0kriswallsmith/buzz v0.15leafo/lessphp v0.4.0leafo/scssphp v0.6.3lexik/maintenance-bundle v2.1.1liip/imagine-bundle 1.7.4liuggio/ExcelBundle v2.1.0michelf/php-markdown 1.7.0monolog/monolog 1.22.1mtdowling/cron-expression v1.1.0mustangostang/spyc 0.6.2mybuilder/phpunit-accelerator 1.2.0myclabs/deep-copy 1.5.5nelmio/alice 2.2.2nelmio/api-doc-bundle 2.13.0nesbot/carbon 1.21.0npm-asset/bootbox v4.1.0npm-asset/bootstrap v3.0.3npm-asset/requirejs 2.3.3npm-asset/xregexp 3.2.0ocramius/proxy-manager 0.5.2oro/calendar-bundle dev-master 6daa813oro/commerce dev-master 21aa88doro/commerce-crm dev-master 3edd561oro/crm dev-master e30bed3oro/crm-abandoned-cart dev-master 9d6463aoro/crm-call-bundle dev-master d6650adoro/crm-dotmailer dev-master de8db40oro/crm-hangouts-call-bundle dev-master 0352f42oro/crm-magento-embedded-contact-us dev-master 182f9adoro/crm-mail-chimp dev-master 41ad8cforo/crm-task-bundle dev-master 1fc24c6oro/crm-zendesk dev-master 82f3305oro/customer-portal dev-master d0b9021oro/doctrine-extensions 1.1.1oro/marketing dev-master 035aac8oro/platform dev-master 50047c1oro/platform-serialised-fields dev-master bf1d577oro/redis-config 2.0.0-beta.1paragonie/random_compat v2.0.10pdepend/pdepend 2.5.0phpcollection/phpcollection 0.5.0phpdocumentor/reflection-common 1.0phpdocumentor/reflection-docblock 3.1.1phpdocumentor/type-resolver 0.2.1phpmd/phpmd 2.6.0phpoffice/phpexcel 1.8.1phpoption/phpoption 1.5.0phpspec/prophecy v1.7.0phpunit/php-code-coverage 4.0.8phpunit/php-file-iterator 1.4.2phpunit/php-text-template 1.2.1phpunit/php-timer 1.0.9phpunit/php-token-stream 1.4.11phpunit/phpcov 3.1.0phpunit/phpunit 5.7.21phpunit/phpunit-mock-objects 3.4.4phpunit/phpunit-selenium 3.0.3piwik/device-detector 3.7.8predis/predis v1.1.1psr/log 1.0.2react/event-loop v0.3.5react/socket v0.3.4react/stream v0.3.4robloach/component-installer 0.2.3romanpitak/dotmailer-api-v2-client v1.0.11romanpitak/php-rest-client v1.2.1sebastian/code-unit-reverse-lookup 1.0.1sebastian/comparator 1.2.4sebastian/diff 1.4.3sebastian/environment 2.0.0sebastian/exporter 2.0.0sebastian/finder-facade 1.2.1sebastian/global-state 1.1.1sebastian/object-enumerator 2.0.1sebastian/phpcpd dev-master cff7f36sebastian/recursion-context 2.0.0sebastian/resource-operations 1.0.0sebastian/version 2.0.1seld/cli-prompt 1.0.3seld/jsonlint 1.6.1seld/phar-utils 1.0.1sensio/distribution-bundle v4.0.38sensio/framework-extra-bundle v3.0.12sensio/generator-bundle v3.1.2sensiolabs/security-checker v3.0.7snc/redis-bundle 1.1.10squizlabs/php_codesniffer 2.8.1stof/doctrine-extensions-bundle v1.2.2swiftmailer/swiftmailer v5.4.8sylius/flow-bundle v0.19.0symfony/assetic-bundle v2.8.1symfony/monolog-bundle v3.0.3symfony/phpunit-bridge v3.2.11symfony/polyfill-apcu v1.4.0symfony/polyfill-intl-icu v1.4.0symfony/polyfill-mbstring v1.4.0symfony/polyfill-php54 v1.4.0symfony/polyfill-php55 v1.4.0symfony/polyfill-php56 v1.4.0symfony/polyfill-php70 v1.4.0symfony/polyfill-php72 v1.4.0symfony/polyfill-util v1.4.0symfony/polyfill-xml v1.4.0symfony/security-acl v3.0.0symfony/swiftmailer-bundle v2.4.3symfony/symfony v2.8.13theseer/fdomdocument 1.6.6tinymce/tinymce 4.6.4twig/extensions v1.4.1twig/twig v1.29.0vakata/jstree 3.3.4webmozart/assert 1.2.0willdurand/jsonp-callback-validator v1.1.0willdurand/negotiation 1.5.0zendframework/zend-code 2.6.3zendframework/zend-crypt 2.4.0zendframework/zend-eventmanager 3.1.0zendframework/zend-loader 2.4.0zendframework/zend-mail 2.4.0zendframework/zend-math 2.4.0zendframework/zend-mime 2.4.0zendframework/zend-servicemanager 2.4.0zendframework/zend-stdlib 2.4.0zendframework/zend-validator 2.4.0zfr/zfr-mailchimp v2.0.7July 20, 2017 at 7:33 am #31925I cant see problem with tax amount. It depends on yours own tax settings, both amounts on front an back are equal (149 779,00)
I just tried to create order and subtotal amount calculated correctly on the same version. Can you share the screenshots of the product view page in the admin please? It’s hard to guess what’s wrong without any details and steps to reproduce.July 20, 2017 at 7:48 am #31926I guess that order totals and taxes are calculated correctly, but displayed wrong.
In product view page in admin panel there’s nothing about tax. Tax is setted up to 23% rate, product price in price list is 1 qty = 1300.00 zł. Shipping includes 23% rate tax too. The only difference between product tax and shipping tax is that product prices does not include tax (net), but shipping price includes (gross).
July 20, 2017 at 8:37 am #31927Hi @r.grabosz.
Could you show screenshot of /admin/tax/ and /admin/tax/rule/ ?
Could you write steps to reproduce? It allows us to reproduce this issue locally.July 21, 2017 at 2:57 am #31928Hi @iantypenko,
Here are these screenshots:
/admin/tax
/admin/tax/rule
Steps to reproduce:
1. Create tax 23% rate
2. Create product tax code
3. Create customer tax code
4. Create tax jurisdiction
5. Create tax rule including 4 points above
6. Set product prices to not include tax
7. Set shipping prices to include tax created in step 1.
8. Create product with tax code from step 2.
9. Create customer account
10. Create customer group with tax code from step 3.
11. Create customer with tax code from step 3. and assign it into group from step 10.
12. Create customer user and assign it to customer from step 11.
13. Login into created customer user, add i.e. 5 pieces of product to shopping list
14. Go to checkout
15. Look at tax total
16. After order completion go to admin panel and check order totals in order detailsJuly 24, 2017 at 4:16 am #31929Hi, r.grabosz.
I created all described taxes. Added new product with new tax, new customer, customer group and customer user with new taxes. On front store I added new product with quantity 5 to shopping list and create product.
Totals calculated correct. Can’t reproduce this issue.
Please, tell me, what steps I missed?
July 24, 2017 at 4:18 am #31930Hi msulima,
Maybe try in “polish zloty” currency (PLN) with 2 decimal places :/
July 24, 2017 at 6:02 am #31931Sorry, but I still can’t reproduce issue.
I will try it on older version of application and let you know.
And you, please try to reproduce it on latest master.August 7, 2017 at 3:36 am #31932Hi, r.grabosz.
We recently release 1.3 LTS version application. Did you update to it or you still have described problem? - AuthorReplies
The forum ‘OroCommerce’ is closed to new topics and replies.