Skip to Content
Former Member
May 26, 2014 at 12:30 PM

Inventory Aging Data, Duplication in SAP B1 8.81


Hello Everyone,

I have been working on Inventory Aging Report creation and has been facing with a problem. The data seems to get duplicated when i execute the

report. I have attached the screen shot below for your reference.

I have taken the following tables OPDN, PDN1, OITM and OITW for my report, and below is the query.

SELECT T0.[DocNum], T0.[DocDate], T1.[ItemCode], T1.[Dscription], T1.[WhsCode], T3.[OnHand] FROM OPDN T0 INNER JOIN PDN1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode INNER JOIN OITW T3 ON T2.ItemCode = T3.ItemCode WHERE T3.[OnHand] > 0

Please help me.. Thank You.


Untitled.jpg (180.2 kB)