Skip to Content
0

Connect between IGN1 and IGE1 table in SAP B1

Dec 17, 2017 at 11:50 AM

67

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

avatar image
Former Member Feb 11 at 05:31 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Matthew Bowman Feb 15 at 10:42 AM
0

What was the answer Monther? Thanks

Share
10 |10000 characters needed characters left characters exceeded
Nagarajan K Feb 15 at 10:43 AM
0

Hi,

Any common field between Goods Receipt and Goods issue documents?

Regards,

Nagarajan

Share
10 |10000 characters needed characters left characters exceeded
Matthew Bowman Feb 15 at 11:51 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded