Query for AR Invoice and It's Bin Location

[Former Member]

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

[former_member233854 · Accepted solution]

Hi,

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