I need to create a custom report showing shortages...
Which tables would I use for this information??
Tami
*This post is locked for comments
We built a SSRS PickList Summary the shows shortages.
The one we built is using EXPV1003 (PickList File) joined on IV00101, IV00102, WO010032.
The Picklist shows what's required, what's been issued, allocated and looks at Inventory to display definite shortages. We looked at the current Picklist in GP and expanded.
Tim
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156