Announcements
No record found.
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
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.
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.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
