Page 85 of 86 FirstFirst ... 357583848586 LastLast
Results 841 to 850 of 859
  1. #841
    Join Date
    Jan 2010
    Posts
    48
    Plugin Contributions
    0

    Default Re: Sales report 2.0

    When I click Download Latest (or Download in the v4.0.0 area), I receive reviews_updated-2.0.0.zip.

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

    Default Re: Sales report 2.0

    Quote Originally Posted by dennisns7d View Post
    When I click Download Latest (or Download in the v4.0.0 area), I receive reviews_updated-2.0.0.zip.
    Note to self: Never do anything before you're coffeed-up.

    Should be all better now.

    P.S. Thanks for the report!

  3. #843
    Join Date
    Apr 2008
    Location
    Qld, Australia
    Posts
    250
    Plugin Contributions
    6

    Default Re: Sales report 2.0

    Zen cart 158a, php 8.2, Sales Report 2 and Sales Report II

    Sales report gives the order total as
    goods value + order rec tax + shipping - discounts - gift cert

    when the shipping included tax the total should be
    goods value + goods tax + shipping - discounts - gift cert

    In the example below the total should be $35.06

    Order ID [##############################]1[/COLOR] Customer Num Products Goods Value Goods Tax Order Rec. Tax Shipping Discounts Gift Cert. Sold Gift Cert. Used Order Total
    8536 McCartney, Paul 1 | -- $32.86 $3.29 $4.35 $11.70 $12.79 | Qty: 2 $0.00 | Qty: 0 $0.00 | Qty: 0 $36.12
    OldNGrey
    ZC158a PHP 8.2.15
    MySQL 10.6.16-MariaDB

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

    Default Re: Sales report 2.0

    Quote Originally Posted by OldNGrey View Post
    Zen cart 158a, php 8.2, Sales Report 2 and Sales Report II

    Sales report gives the order total as
    goods value + order rec tax + shipping - discounts - gift cert

    when the shipping included tax the total should be
    goods value + goods tax + shipping - discounts - gift cert

    In the example below the total should be $35.06

    Order ID [##############################]1[/COLOR] Customer Num Products Goods Value Goods Tax Order Rec. Tax Shipping Discounts Gift Cert. Sold Gift Cert. Used Order Total
    8536 McCartney, Paul 1 | -- $32.86 $3.29 $4.35 $11.70 $12.79 | Qty: 2 $0.00 | Qty: 0 $0.00 | Qty: 0 $36.12
    Would you give me a full example of the order's totals so that I get a "better picture".

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

    Default Re: Sales report 2.0

    Quote Originally Posted by lat9 View Post
    Would you give me a full example of the order's totals so that I get a "better picture".
    @OldNGrey, is this an issue when the prices "include tax" like they do in AU? I ask because for US-based pricing where the tax isn't included, I'm not seeing an issue when the shipping is taxed.

  6. #846
    Join Date
    Mar 2011
    Posts
    78
    Plugin Contributions
    0

    Default Re: Sales report 2.0

    It happens on my setup in UK too - for a domestic sale it adds the VAT from shipping to Order Rec. Tax but then adds the tax inclusive shipping cost to the total.

    EG order via admin (tax inclusive pricing @20% VAT)
    Sub-Total: £7.50 (net 6.25 - VAT 1.25)
    RM First Class (Shipping to GB): £1.44 (net 1.20 - tax 0.24)
    VAT 20% (included): £1.49
    Total: £8.94

    Sales report
    Goods value - £6.25
    Goods tax - £1.25
    Order Rec Tax - £1.49
    Shipping - £1.44
    Total - 9.18 - 0.24 more than actual order total.

  7. #847
    Join Date
    Apr 2008
    Location
    Qld, Australia
    Posts
    250
    Plugin Contributions
    6

    Default Re: Sales report 2.0

    Quote Originally Posted by lat9 View Post
    @OldNGrey, is this an issue when the prices "include tax" like they do in AU? I ask because for US-based pricing where the tax isn't included, I'm not seeing an issue when the shipping is taxed.
    Sorry for the delay in responding I posted a detailed explanation yesterday but it obviously disappeared into the ether.

    Yes, the issue is when tax is included in the postage. In Australia all local postage includes tax, all postage for overseas is tax free. All product prices listed include tax, and this remains for an Australian delivery address. the tax is removed for overseas delivery addresses.

    I can see the variation by selecting the "Total Validation" option and this is good enough for reconciling other reports.

    For me this is now a very low priority for possible future consideration as I now fully understand what is occurring.

    The first image is the sales report:
    Click image for larger version. 

Name:	order-8536-sales-report-totals.jpg 
Views:	25 
Size:	4.5 KB 
ID:	20293

    The second image is the order details amounts:
    Click image for larger version. 

Name:	order-8536-order-details.jpg 
Views:	22 
Size:	26.2 KB 
ID:	20294

    The third image is the "orders_total" table contents:
    Click image for larger version. 

Name:	order-8536-orders-total-table.jpg 
Views:	26 
Size:	24.7 KB 
ID:	20295
    OldNGrey
    ZC158a PHP 8.2.15
    MySQL 10.6.16-MariaDB

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

    Default Re: Sales report 2.0

    @gsh68 and @OldNGrey, thanks for the details. It appears that the report's handling of sites that "display prices with tax" has been incorrect for a while.

    One of the underlying issues is that, unlike products, the tax rate associated with an order-total's value (e.g. shipping) is not broken out in the order's recording in the database.

  9. #849
    Join Date
    Apr 2008
    Location
    Qld, Australia
    Posts
    250
    Plugin Contributions
    6

    Default Re: Sales report 2.0

    Not Sales Report but the way ZC displays totals is inconsistent.

    The order details subtotals may show discounts with or without a minus sign eg coupons.
    Coupon value is displayed without a minus sign but subtracted from the total then stored in "orders_total" text field with a minus sign but the "orders-total" value is positive whereas
    the payment module fee, to me is correct, as it displays the minus sign on the order, is deducted from the total , and is stored with the minus sign in both fields in "orders_total".
    OldNGrey
    ZC158a PHP 8.2.15
    MySQL 10.6.16-MariaDB

  10. #850
    Join Date
    Jul 2008
    Posts
    34
    Plugin Contributions
    0

    Default Re: Sales report 2.0

    I've just installed Sales Report 4.0.0 to a vanilla install of ZC 1.5.8a using PHP 7.3. I've uploaded the files and enabled the plugin from Modules > Plugin Manager. It said "Plugin enabled successfully", but I don't see the entry for Sales Report II in the Reports menu. I can't see what I could have done wrong! Any ideas, please?

 

 
Page 85 of 86 FirstFirst ... 357583848586 LastLast

Similar Threads

  1. v139b Sales Report
    By irishshopper in forum General Questions
    Replies: 1
    Last Post: 26 Jan 2014, 01:00 AM
  2. Sales Report
    By jgold723 in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 9 Nov 2011, 05:58 PM
  3. Sales report
    By tlahtine in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 27 Dec 2010, 10:01 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