Looking for help tweaking a reporting module...

[jeffoo]

Is anyone interested in helping me tweak the Monthly Sales and Tax Report? I can send you $50 USD using Paypal?

 

I am using version 2.3.1 found here:

 

http://www.oscommerce.com/community/contributions,539/category,all/search,monthly+sales

 

Here's what I would like to do:

 

Modify Nontaxed Sales Column:

 

1.) Change a column from "Nontaxed Sales" to "Cost Price"

2.) I would like this column to be similar to the "Product Sales" column but instead of getting the information from the "products.products_price" I would like it to grab the price from a newly created column called "products.products_cost" for the corresponding order ID.

 

Modify Taxed Sales Column:

 

1.) Change a column from "Taxed Sales" to "Taxes Paid"

2.) I would like the "Taxes Paid" column to calculate the taxes I paid on the cost of the items. This calculation is "Taxes Paid" amount multiplied by 0.13. Therefore, if the cost of an item was $100 I would like the Taxes Paid column to show $13.00.

 

Modify the Tax on Shipping column

 

1.) Change a column from "Tax on shipping" to "Total Profits"

2.) I would like this column to calculate the following for each month:

 

"Cost Price" minus "Shipping & Handling" equals "Total Profits"