Page 99 of 179 FirstFirst ... 4989979899100101109149 ... LastLast
Results 981 to 990 of 1784
  1. #981
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,401
    Plugin Contributions
    87

    Default Re: Edit Orders v4.0 Support Thread

    @dharrison, would you set Configuration->Edit Orders->Debug Action Level to "TOTALS" and send me the file directly?

    Are you receiving the EO warning message that indicates that the store's two "Display Prices with Tax" settings are not the same?

  2. #982
    Join Date
    Mar 2009
    Location
    Essex, UK
    Posts
    446
    Plugin Contributions
    0

    Default Re: Edit Orders v4.0 Support Thread

    Hi @lat9

    I do get the warning messages:

    Success: Order has been successfully updated.
    Warning Warning: You have configured Zen Cart to display prices with tax. This page is currently displaying prices without tax.
    I have also set debug to TOTALS as requested and zipped the log and emailed to you.
    Debbie Harrison
    DVH Design | Web Design blog

  3. #983
    Join Date
    Mar 2009
    Location
    Essex, UK
    Posts
    446
    Plugin Contributions
    0

    Default Re: Edit Orders v4.0 Support Thread

    Quote Originally Posted by mc12345678 View Post
    Not sure why, but 36.90 is 20% * 184.50 which is both tax on the trade discount as well as the 20% tax on the total amount if delivery wasn't included in a sub-total.

    Might almost be interesting to see if upon re-edit if the value would go down again. Another would be to alter the trade discount as a general factor from the onset of a test purchase and see how the values change. Working with a 50% value somewhat means that the data could come from either the reduction or from the pre-total. Perhaps momentarily reduce the reduction (thus not losing out on some in process cash flow) or apply it to some test product, but do the same thing with that item as was done above and see how it changes.
    Hi mc

    I have tried that and after the initial adjustment, the final total remains the same. The VAT goes down to normal level if you click update again, but that total remains the same.

    There is a few components in the sub-total but it was accurate except for when the order is edited.

    Anyway I have tried with a 40% discount:

    Sub-Total: £459.00
    Free Shipping Options (Ex-Works): £0.00
    Trade Discount: -£183.60
    UK VAT @ 20%: £55.08
    Total: £330.48
    On clicking Update this changes to

    £459.00

    Add Product
    Sub-Total: £459.00

    Trade Discount: -£183.60
    UK VAT @ 20%: £55.08
    Total: £293.76
    Clicking Update again this time, the VAT remains the same.
    Debbie Harrison
    DVH Design | Web Design blog

  4. #984
    Join Date
    Jul 2012
    Posts
    16,718
    Plugin Contributions
    17

    Default Re: Edit Orders v4.0 Support Thread

    Quote Originally Posted by dharrison View Post
    Hi mc

    I have tried that and after the initial adjustment, the final total remains the same. The VAT goes down to normal level if you click update again, but that total remains the same.

    There is a few components in the sub-total but it was accurate except for when the order is edited.

    Anyway I have tried with a 40% discount:



    On clicking Update this changes to



    Clicking Update again this time, the VAT remains the same.
    Well, that does come out to reflect that on edit, the trade discount is taxed 20% and that tax is being subtracted from the bottom line total. So the two tests show that on update for some reason the final total is being reduced by an "unpublished" tax but it is all based on the above values and not on some "reuse" of the current final. Should help to figure out what's going on as one reviews the code. Not sure if more info than what has been provided is needed.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  5. #985
    Join Date
    Mar 2009
    Location
    Essex, UK
    Posts
    446
    Plugin Contributions
    0

    Default Re: Edit Orders v4.0 Support Thread

    Thanks mc

    Thanks for the insight. One of the Trade Discount (Group pricing) module settings is:

    Trade Discount

    This module is installed
    true

    Sort Order
    290

    Include Shipping
    false

    Include Tax
    false

    Re-calculate Tax
    Standard

    Tax Class
    --none--
    I will try without the re-calculate tax and go from there
    Last edited by dharrison; 22 Jun 2016 at 06:50 AM. Reason: I can't spell
    Debbie Harrison
    DVH Design | Web Design blog

  6. #986
    Join Date
    Mar 2009
    Location
    Essex, UK
    Posts
    446
    Plugin Contributions
    0

    Default Re: Edit Orders v4.0 Support Thread

    Nope it's made no difference.

    I can set up a test login if that would help.
    Last edited by dharrison; 22 Jun 2016 at 07:08 AM.
    Debbie Harrison
    DVH Design | Web Design blog

  7. #987
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,401
    Plugin Contributions
    87

    Default Re: Edit Orders v4.0 Support Thread

    Yes, unfortunately, those EO logs weren't particularly helpful. PM sent.

  8. #988
    Join Date
    Feb 2012
    Location
    mostly harmless
    Posts
    1,809
    Plugin Contributions
    8

    Default Re: Edit Orders v4.0 Support Thread

    Quote Originally Posted by dharrison View Post
    Hi Cindy

    Configuration->My Store->Display Prices with Tax False
    Configuration->My Store->Display Prices with Tax Admin True
    ...
    Things with taxes will NOT work correctly if these are different. Thus the warning printed at the top.

    This setting is used by various Zen Cart functions when calculating the tax, not just for "display". When enabled Zen Cart stores the product price in the order as (product price + tax). When disabled it stores just the product price.

    So with your settings when a customer places an order the product is saved without tax in the database. When you open the order for editing with your settings, you are telling the Zen Cart functions the tax is already included with the product price (so it removes it from the total).
    Last edited by lhungil; 23 Jun 2016 at 02:10 AM.

  9. #989
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,401
    Plugin Contributions
    87

    Default Re: Edit Orders v4.0 Support Thread

    Thanks, @lhungil (I was hoping that you'd chime in!), that's part of the conclusion I'd arrived at as well (although I didn't "see" where the storefront/admin discrepancy beween the two settings had bearing in this instance) ...

    The store's setting for Display Prices with Tax was changed from true to false, resulting in total-calculation issues when EO was then used to edit an order created while the setting was true.

    Part of EO's total-processing involves backing-out all product-price (and tax, if indicated) values from the order's subtotal, total and tax elements prior to any re-calculation. So, an order that was created when DPwT was set to true will not have the applicable taxes backed-out from this calculation, resulting in (as you've seen) an incorrect Total value being calculated for the order.

    I'm not sure why EO does that back-out, but perhaps @lhungil could fill in some of the EO history as to why the processing is as it is!

    In any case, I suggest to @dharrison that a procedure be defined for this store's admins such that they don't use EO on any orders that were created when the DPwT setting was true as a work-around to the display issue.

  10. #990
    Join Date
    Mar 2009
    Location
    Essex, UK
    Posts
    446
    Plugin Contributions
    0

    Default Re: Edit Orders v4.0 Support Thread

    Thanks all 3 of you for your help. I would be intrigued to get an insight into the EO history as well.

    Happy days (?)
    Debbie Harrison
    DVH Design | Web Design blog

 

 

Similar Threads

  1. v150 Super Orders v4.0 Support Thread for ZC v1.5.x
    By DivaVocals in forum Addon Admin Tools
    Replies: 797
    Last Post: 23 Mar 2024, 06:51 AM
  2. v150 Orders Status History -- Updated By [Support Thread]
    By lat9 in forum Addon Admin Tools
    Replies: 34
    Last Post: 29 Jul 2019, 07:05 PM
  3. Edit Orders v3.0 for ZC 1.3.9 [Support Thread]
    By DivaVocals in forum All Other Contributions/Addons
    Replies: 656
    Last Post: 18 Apr 2016, 06:28 PM
  4. v139h Super Orders v3.0 Support Thread (for ZC v1.3.9)
    By DivaVocals in forum All Other Contributions/Addons
    Replies: 1018
    Last Post: 28 Apr 2014, 11:38 PM
  5. RE: Super Orders v3.0 Support Thread
    By Johnnyd in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 22 Jun 2011, 09:28 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR