I would like to create an inventory report using Crystal Reports 2008 which looks exactly the same as Inventory Audit Report in SAP Business One 2007A
List down all the items with its Item Code, Description, Quantity and Item Cost (easy right?)
The only condition:
I would like to filter my report by FromDate and ToDate.
Current date 15.07.2009
If I run the report by putting in 01.01.2009 to 31.01.2009, the result will show me:
item, with its respective info and most importantly the Quantity and Item Cost as at 31.01.2009 (similar to closing stock)
Any query for above statement?