Calculating total amount in the basis of month

lina11

How can I calculate The total amount in the basis of month. Like how much amount transferred in the month of august.i want to do this in report.will anyone help me plz [-o<

mohana_cse06

From which table you want to calculate? and can you explain more?

lina11

From Sales Invoice header table.

mohana_cse06

You can use Date table with Date type as Month and filter the posting date field with start date and end date fields of date table and calculate the amount total

lina11

I want to do thi in report...Like u have 4date in august and 2is same date and 2 is different date.i want to do the total of the amount which will be done with group by month

mohana_cse06

mohana_cse06 wrote:

You can use Date table with Date type as Month and filter the posting date field with start date and end date fields of date table and calculate the amount total

Did you try this?
this vl do what you want

Savatage

you can check this out....

There is a post that does sales by customer by month
viewtopic.php?f=5&t=10082

It Looks Like This:
http://savatage99.googlepages.com/Custo ... yMonth.pdf

It could easily be changed to do weeks instead of months - but 20 columns is going to have been real small print.

Here's a copy of the .fob
http://savatage99.googlepages.com/Repor ... yMonth.fob

Note: once done it's also easily changed to show purchases by vendor by month
or a number of other fields.

*best to use customer ledger entries than sales invoice header