Skip to Content
avatar image
Former Member

Connect between IGN1 and IGE1 table in SAP B1

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

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

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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 15 at 10:42 AM

    What was the answer Monther? Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 15 at 10:43 AM

    Hi,

    Any common field between Goods Receipt and Goods issue documents?

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 15 at 11:51 AM

    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

    Add comment
    10|10000 characters needed characters exceeded