Detailed Monthly Sell Thru Report
I need real help. For the past several months I have been trying to find a way to simply this process and creating queries to do it and I cant seem to make it work. Can anyone help with creating this:
|Item No.||Bar Code||Item Description||YTD Purchase||Cost||Retail Price||Jan Sale Unit Qty||Feb Sale Unit Qty||Mar Sale Unit Qty||Apr Sale Unit Qty||May Sale Unit Qty||Jun Sale Unit Qty||Jul Sale Unit Qty||Aug Sale Unit Qty||Sept Sale Unit Qty||Oct Sale Unit Qty||Nov Sale Unit Qty||Dec Sale Unit Qty||YTD Sale||In Stock|
I can get the sales but amount not units then but cant get the ytd or in stock correct. Please help.