Skip to Content
0

Query for AR Invoice and It's Bin Location

May 25, 2017 at 02:52 PM

60

avatar image

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

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

1 Answer

Best Answer
Danilo Kasparian May 25, 2017 at 06:12 PM
0

Hi,

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

Share
10 |10000 characters needed characters left characters exceeded