Hi,
I have a list of purchases with their posting data and amount. I'm looking to display this list in monthly groupings, so it would look something like:
Doc No. | Posting Date | Amount
ML0 | 24/01/2013 | 2000
ML1 | 25/01/2013 | 4500
ML1 | 25/01/2013 | 2000
—————————————
January Total: 8500
ML5 | 15/02/2013 | 2000
ML6 | 17/02/2013 | 4500
ML7 | 25/02/2013 | 2000
—————————————
February Total: 8500
But can't find a way to do this, as this list will change over time I can't sort it all manually..
Anyone have any ideas how to do this? :)
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi DWar,
Please take a look at the excelsheet to find an example. As we are not using purchases, I used another table within the month-replicator. Of course you can replace this with whatever you like.
Good luck, hope this helps.
Regards,
Gerard -
Jet Reports Historic Posts Hi DWar,
Please take a look at the excelsheet to find an example. As we are not using purchases, I used another table within the month-replicator. Of course you can replace this with whatever you like.
Good luck, hope this helps.
Regards,
Gerard
This worked perfectly, thank you :D
Please sign in to leave a comment.