
I need to create a custom report showing shortages...
Which tables would I use for this information??
Tami
*This post is locked for comments
I have the same question (0)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