Connect between IGN1 and IGE1 table in SAP B1

[Former Member]

hi all

I need to make the net qty for an item between good receipt and good issue. i tried to make query with IGN1&IGE1 as followed:

SELECT T0."ItemCode", T0."Dscription",Sum(T0."Quantity") "Good Receipt" , Sum(T1."Quantity") "Good Issue"
FROM IGN1 T0 , IGE1 T1
WHERE T0."ItemCode" = T1."ItemCode"
GROUP BY T0."ItemCode", T0."Dscription"

but the results not correct because it repeated the issue infront of recipet

pls anyone help

[matthewbowman85]

Yes I am wanting to report on Production Orders receipted on a specific day. The quantity of items good receipted (IGN1) and the time it took to do it from the goods issue (IGE1) but on the same line on the report. Thanks in advance

[kothandaraman_nagarajan]

Hi,

Any common field between Goods Receipt and Goods issue documents?

Regards,

Nagarajan

[matthewbowman85]

What was the answer Monther? Thanks

[Former Member]

Thanks alot and sorry for late in answer because I forgot the password for my account