Contributions

The "Taxes Collected" column is a list of popup links and for some reason this was broken. I have only changed a few lines to repair this.

Around line 518 you will see
// make this a link to the detail popup if nonzero
I changed the lines
echo "<a href="#" onClick="window.open('" . $_SERVER['PHP_SELF'] . "?&show=ot_tax&year=" . $sales['row_year'] . "&month=" . $sales['i_month'];
if ($sel_month<>0) echo "&day=" . $sales['row_day'];
if ($status<>'') echo "&status=" . $status;
echo "','detail',config='height=200,width=400,scrollbars=1, resizable=1')" title="Show detail">";

to

if ($sel_month<>0) $taxpopup = "&day=" . $sales['row_day'];
if ($status<>'') $taxpopup .= "&status=" . $status;
echo "<a href="#" onClick="window.open('" . tep_href_link(basename($PHP_SELF), "&show=ot_tax&year=" . $sales['row_year'] . "&month=" . $sales['i_month'] . $taxpopup);
echo "','detail',config='height=200,width=400,scrollbars=1, resizable=1')" title="Show detail">";

Not much of a change but it makes it work.

This file is also the latest one listed here with my change.
/admin/stats_monthly_sales.php

After sending several reports (form this contribution) to may accountant, a resulting conversation led us to rename the columns for more accurate accounting.

Made a mistake in the date selection, a month contains max 31 day instead of 30 :-)

Thanks braathwaate for the tip!

- SQL query upgrade

When you have allot of order and order products in your DB then this report becomes very slow. In my case it took more then 3 hours!!! Now for me its a little more then 10 seconds. It still can be done better but for me its fine now.

just added the french translation of the english package.

Note the Help stays in english, I think the report is self explanatory.

Cheers
Herve

This is based on version 2.1.1

The assumptions made in v 2.1.1 are rather sweeping and will result in incorrect values in many cases (there is a warning about this in the 2.1.1 installation notes).

This version does not rely on these assumptions and now reports correct figures.

Other changes:-

* There is now an extra column for shipping tax.
* I have removed some rounding errors

I have used this for a while and as far as I can tell it works ok. However, don't come winging to me if it doesn't work for you because I don't care - it's YOUR problem - fix it.

CMOTD

This contribution is based on MonthlySales&Tax2.1.1b but instead of the columns
- subtotals of orders not taxed and
- subtotals of orders taxed

it calculates a commission incl. and excl. shipping and handling fees.

You can set in your oscommerce admin menue (minimum values) or the language file a minimum income after that your commission is calculated. It´s also possible to set the percentage rate of your commission.

----------------------------------------------

Diese contribution basiert auf MonthlySales&Tax2.1.1b aber anstelle der Spalten
- subtotals of orders not taxed and
- subtotals of orders taxed

wird eine Webshop Umsatzbeteiligung mit und ohne Versandkosten errechnet.

Im Adminmenü (Minimum Values) oder über das Sprachfile der Contribution ist es möglich einen Mindestumsatz festzulegen, ab welchem durch einen frei wählbaren Prozentsatz die Umsatzbeteiligung errechnet wird.

Updated with the version v 2.1.1a and 2 small thing
Made a comparison

THX

Mise à jour avec la version v 2.1.1a et 2 petit chose
Faite une comparaison
Bonne suite


http://ieuflr2000.dyndns.org

Bonjour,
La contrib MonthlySales$Tax2.1.1pour MS2 propose un affichage détaillé par mois ou par jour des ventes et des taxes collectées, mais il y a un bug dans la requete SQL qui concerne l'affichage détaillé par jour, et les données affichées sont fausses (colonnes ventes taxées et ventes non taxées)
.
(Le problème ne concerne pas la vue par mois)

Pour corriger le problème :

dans le fichier admin/stats_monthly_sales.php

trouver la ligne (vers la ligne 458 )

$taxed_query_raw .= " and dayofmonth(o.date_purchased) = '" . $sales['row_day'] . "' group by o.date_purchased";
et la remplacer par
$taxed_query_raw .= " and dayofmonth(o.date_purchased) = '" . $sales['row_day'] . "' group by dayofmonth(o.date_purchased)";

Notez que la contrib installée sur la CReload 6 est antérieure à la version 2.1.1, et ne propose pas l'affichage détaillé par jour, elle n'est pas concernée par le pb.

Pour ceux que cela interresse, je prépare une version française de cette contrib ...

@++

This version restores the columns that summarize nontaxed and taxed order subtotals.
THE ASSUMPTIONS MADE FOR THIS FEATURE MAY MAKE IT NOT BE APPROPRIATE FOR ALL STORES.
The taxed column summarizes subtotals for orders in which tax was charged; the nontaxed column is the subtotal for the row less the taxed column value.
(Refer to the support thread for more information.)

New popup window for detail of tax collected, useful for stores with more than one tax class.

Fixed rounding problem which is caused by orders_total entries with four decimals.

Columns for "nontaxed" and "taxed" product sales have been removed (explained in the support thread).

corrections to row calculations;
add language files for german, espanol

Major revision to report for MS1 or MS2 stores:

now provides daily summaries as well as monthly;
rows of report can be inverted (top to bottom);
CSV download not inhibited by server restrictions.

Only made a few minor changes to this mod for install and use on MS2.

Modified install.txt to reflect the needed changes for use under MS2

Enjoy!

Same as version 1.55, but with CSV capability disabled for systems lacking file save permission. Use this if you get "Warning: fopen(temp.csv) ..."

Revised to call array_merge instead of tep_array_merge, due to standards update.

Same as version 1.54, but with CSV capability disabled for systems lacking file save permission. Use this if you get "Warning: fopen(temp.csv) ..."

Revision for MS1, corrects bug in 1.53.

Revised for MS1 compatibility (addl parameter in call to tep_get_zone_name), and csv option automatically omitted if no file save permission.

Corrects errors in previous version and allows easy disabling of csv capability.

Monthly Sales & Tax Report 1.4a (bug fix)
This basic admin report provides a summary by month of the following totals for the history of the store:
gross income
product sales (exempt + taxable)
product sales exempt
product sales taxable
sales tax collected
shipping/handling charges
low order fees
gift vouchers
Data for report are extacted from the orders total table, either for all orders or by order status by dropdown list, and presented in descending chronological sequence. Footer rows are inserted for each calendar year.
** added in this version:
** printer friendly screen
** save report data as CVS file
** help screen
** columns for loworder fee and gift voucher omitted if these features not enabled
Note: future extensions of this report will probably be called Income Summary Reports

Monthly Sales & Tax Report 1.4 (bug fix)
This basic admin report provides a summary by month of the following totals for the history of the store:
gross income
product sales (exempt + taxable)
product sales exempt
product sales taxable
sales tax collected
shipping/handling charges
low order fees
gift vouchers
Data for report are extacted from the orders total table, either for all orders or by order status by dropdown list, and presented in descending chronological sequence. Footer rows are inserted for each calendar year.
** added in this version:
** printer friendly screen
** save report data as CVS file
** help screen
** columns for loworder fee and gift voucher omitted if these features not enabled
Note: future extensions of this report will probably be called Income Summary Reports

Monthly Sales & Tax Report 1.3
This basic admin report provides a summary by month of the following totals for the history of the store:
gross income
product sales (exempt + taxable)
product sales exempt
product sales taxable
sales tax collected
shipping/handling charges
low order fees
gift vouchers

Data for report are extacted from the orders total table, either for all orders or by order status by dropdown list, and presented in descending chronological sequence. Footer rows are inserted for each calendar year.

** added in this version:
** printer friendly screen
** save report data as CVS file
** help screen
** columns for loworder fee and gift voucher omitted if these features not enabled

Note: future extensions of this report will probably be called Income Summary Reports

Monthly Sales & Tax Report 1.1
This basic admin report provides a summary by month of the following totals for the history of the store:
gross income
product sales (exempt + taxable)
product sales exempt
product sales taxable
sales tax collected
shipping/handling charges
low order fees

Data for report are extacted from the orders total table, either for all orders or by order status by dropdown list, and presented in descending chronological sequence. Footer rows are inserted for each calendar year.

Monthly Sales & Tax Report 1.0
This basic admin report provides a summary by month of the following totals for the history of the store:
gross income
product sales (exempt + taxable)
product sales exempt
product sales taxable
sales tax collected
shipping/handling charges
low order fees
Data for report are extacted from orders with Shipped status, and basis for sales tax is assumed to be store zone.