Sales report 2.0

[dennisns7d]

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

[lat9]

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!

[OldNGrey]

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

[lat9]

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".

[lat9]

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.

[gsh68]

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.

[OldNGrey]

@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:


The second image is the order details amounts:


The third image is the "orders_total" table contents:

[lat9]

@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.

[OldNGrey]

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".

[planetjune]

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?