O'Reilly logo

Real-world Business Intelligence with Microsoft Dynamics GP by Mark Polino, Belinda Allen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Items with quantities that are not available to sell and items that have not been sold within the last year

How many items are in your inventory that are either trapped in a status that makes them unavailable, or haven't been sold during the last 12 months? If an item is returned from a customer using SOP, the user is asked whether to make it reavailable for sale or unavailable by marking it as returned, in service, in use, or damaged. Any of these last four options will still make the item show in your inventory valuation and count, but the items are not reflected in the quantity available to either resell or allocate/fulfil. This report will show all of these problems in a super easy-to-read dashboard.

Tip

Note that this report contains two SQL ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required