Product Sales Quantities by Week for 24 Months

gadzilla1
gadzilla1 Member Posts: 316
edited 2009-07-02 in NAV/Navision Classic Client
Hello all,

I'm looking for a Navision report that would provide data for product sales quantity by week for 24 months. Is there a report available in Navision that is close that I could modify? I use many of the Navision reports but am not aware if something like this exists (or close to it).

I just need the report name, I can copy and modify as needed.

Thanks, Chris

Comments

  • kapil4dynamics
    kapil4dynamics Member Posts: 591
    I think u can use Sales Analysis, there is no need to modify anything. :)

    <EDIT> Oh yeah but applicable from 4.0 onwards
    Kapil Khanna
  • Savatage
    Savatage Member Posts: 7,142
    Do you have form 158? Item Turnover - it will show you sales of an item by day/week/month/Quarter/Year.

    Perhaps that form can guide you onto a useful report, or maybe that form gives you the quick info you've been looking for?
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • gadzilla1
    gadzilla1 Member Posts: 316
    Thank you all for your help. Here is the solution I am pursuing...

    A developer friend suggested using Report 10047 as a model which I did. That report references the Customer table so I had to redevelop using the Item table. It works very well and now I'm now attempting to incorporate Production Forecast Entry data as well. I will post when complete in a week or so.

    Thanks, Chris

Categories