Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

I am trying to find a report that will tell me when all of my items were last entered on a SOP document.

Posted on by 60

I am trying to find a report that will tell me when all of my items were last entered on a SOP document. 

*This post is locked for comments

  • Verified answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: I am trying to find a report that will tell me when all of my items were last entered on a SOP document.

    Victoria is correct, this has to be created as a custom report.  I have done it for a few customers myself.  

    There is, however, a turnover report that comes close and may be better for you.  It tells you, based on the volumn of sales and the average quantity on hand how many times your inventory is turning.  This report addresses each item on hand individually.  It also rates the high/low turn items.  You can then look at the slow movers or "fast to sell out" items to adjust your stock plan.

  • Verified answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: I am trying to find a report that will tell me when all of my items were last entered on a SOP document.

    James,

    I don't believe there is such a report in GP, but I have some SQL scripts posted for this if you are open to creating a custom report:

    SQL view for last sale date of item

    SQL view for last sale by customer and item

    These will only look at posted invoices...if you're looking to see the last time something was entered on an order, you'd need to make some modifications.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,113 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans