@mfatehi, have you tried building a custom report? I just posted a sample query today that will give this information. (It actually gives more, but can be edited to limit it to what you want.) See Sales Invoice by Date Range with Details Items - #3 by Tut.