Skip to Content
avatar image
Former Member

Query for AR Invoice and It's Bin Location

Hi guys

how can I make this query? I tried using the INV19 table

but seems that table is empty how can i do this?

like this

DocNum,Docdate,BP Code, BP Name, ref#,item,qnty,whs,bin location

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 25, 2017 at 06:12 PM

    Hi,

    You should query the B1_OinmWithBinTransfer for TransType = 13 and join the InvPLMessageID to OBTL.MessageId then BinAbs to OBIN.AbsEntry

    Add comment
    10|10000 characters needed characters exceeded