235
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
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
