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<
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
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
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
Comments
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
Did you try this?
this vl do what you want
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
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
http://www.BiloBeauty.com
http://www.autismspeaks.org