Inventory Table for Period End Balances

(0) Share

Report

Posted on by maman

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

All responses (1)

Answers (0)

Rashid Farooq 1,000 on at

Like (0)

Report

Re: Inventory Table for Period End Balances

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