Item Sales History Report

I am relativaley new to Navision 3.70 and i have been asked to write a report that lists the last 3 months quantity sold by item (this is specified by the user) ie this would list June, July & August 2006 and for each period would total the quantitysold. Which table should i use and what if any C/SIDE code should i use within the report?
  • Just to add my bit here.

    What David suggests is the correct way to write this report (though I think you could easier use the Item Ledger Entry table). What Marq suggests is the easiest way to write the report.

    Maffy, from your point of view the issue will come down to how many items you have and how fast you want the report to run. Also you network speed will be an issue here.

    In the case of basing the report on Item card, the advantage is the simplicity of the design, but the issue is that you must scan every item in the database, even if you only want to print one item.

    In simple terms, for now do it the easy way, and if it is too slow, then plan to redo it the ledger way.
Reply Children
No Data