Skip to Content
0

Backdate Inventory in Warehouse Report

Jun 20, 2017 at 05:03 PM

33

avatar image

I am trying to create the Inventory in Warehouse Report with a date parameter, but I cannot get the query to work. I also cannot get the In Stock quantity from the OINM table and the InQty and OutQty fields don't seem to correspond to the Item Master Data. And I am trying it on HANA.

SELECT T1."WhsName", T0."ItemCode", MAX(T0."Dscription") AS "Item Name", SUM(T0."InQty" - T0."OutQty") AS "On Hand", T0."DocDate"

FROM OINM T0 INNER JOIN OWHS T1 ON T1."WhsCode" = T0."Warehouse"

WHERE T0."DocDate" <= '[%0]'

GROUP BY T1."WhsName", T0."ItemCode", T0."DocDate"

HAVING SUM(T0."InQty" - T0."OutQty") > 0

Any help is greatly appreciated.

Kind regards,

Vinolan Pillay

10 |10000 characters needed characters left characters exceeded
Former Member

Were you ever able to get an answer on this? I would love this report!

Thank you

0

Hi There,

Unfortunately not, I am still working on this report whenever I get a chance to.

Regards,

1
* Please Login or Register to Answer, Follow or Comment.

0 Answers