I need to develop an SSRS report to display period end inventory stock balances for each month. Can someone guide me to the correct table that will give me the required info for the query?
I tried table IV00102 but could not locate any relevant date/period column.
Thanks!
*This post is locked for comments
USER FOLLOWING QUERY:
MORE TABLES ARE:
IV00101
IV00102
IV10200
IV10201
IV30300
--------------------------------------------------------------------------------------------------------------------------------
SELECT M.ITEMNMBR ,
IV.ITEMDESC,
IV.ITMCLSCD Class,
M.TRXLOCTN Location,
sum(M.QTYRECVD - M.QTYSOLD) Quantity,
sum(M.UNITCOST * ( M.QTYRECVD - M.QTYSOLD )) TotalCost,
sum(M.UNITCOST * ( M.QTYRECVD - M.QTYSOLD )) / sum(M.QTYRECVD
- M.QTYSOLD) AvgUCost
FROM IV10200 M
INNER JOIN IV00101 IV ON IV.ITEMNMBR = M.ITEMNMBR
WHERE M.QTYRECVD <> M.QTYSOLD
GROUP BY M.ITEMNMBR,
M.TRXLOCTN,
IV.ITEMDESC,
IV.ITMCLSCD
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,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156