need stock details at BIN location

[former_member9041]

Hi

in SAP B1 8.8, we have OIBT where we have batch wise stock

we are using SAP B1 9.0 PL005

and we need Stock details in BIN

ie.

ItemCode     WhsCode     BIN#     Batch#     Quantity(OnHand)     Commited(Allocated)

We have OIBT table where we have stock at WhsCode-Batch level

but we want BIN level stock

can anyone help to get BIN level stock?

Nilesh Shah

91 937 613 6300

[kothandaraman_nagarajan]

Hi,

To find an  allocated quantity in sales order, you can try with below query.

SELECT
T1.[DocNum], T1.[CardName], T2.[ItemCode], T2.[Dscription],
T2.[Quantity], case when T0.[Direction] = '2' then 'Allocatedqty'
end, T0.[Quantity], T0.[BatchNum] FROM IBT1 T0 left join ORDR T1 on
T0.[BaseType] = T1.[ObjType] left JOIN RDR1 T2 ON T1.DocEntry =
T2.DocEntry WHERE T0.[Direction] = '2' and  T0.[BaseNum] =
T1.[DocNum] GROUP BY T1.[DocNum], T1.[CardName], T2.[ItemCode],
T2.[Dscription], T2.[Quantity], T0.[Direction], T0.[Quantity],
T0.[BatchNum] order by T1.[DocNum]

You may think the above query is not revelant to you. but you can refer relationship between IBT1 table.

I dont have 9.0 version to write query.

Thanks & Regards,

Nagarajan

[Former Member]

Hi

I looked at the following to give me a list of the item stock quantities in a bin.

				SELECT
				T0.WhsCode,
				T0.BinCode,
				T1.ItemCode,
				T2.ItemName,
				T1.OnHandQty
				FROM [OBIN] T0
				LEFT JOIN [OIBQ] T1 ON T0.WhsCode = T1.WhsCode AND T0.AbsEntry = T1.BinAbs
				LEFT JOIN [OITM] T2 ON T1.ItemCode = T2.ItemCode

[former_member9041]

Greg,

this shows quantity in BIN but I also need Allocated quantity in BIN

which we used when we picked material and not delivered

if you see, we have OIBT table where we have batch OnHand and Iscommited Quantity at batch level

same way, I need OnHand and Iscommited quantity in BIN

is there way to get allocated quantity from BIN

Nilesh Shah

[Former Member]

hi Nilesh,

you can use system report

Go to

Inventory--Inventory Reports--Batch Number Transactions Report

regards,

raviraj

[former_member9041]

Hi,

we are development some report and need allocated quantity in Batch and BIN#

[Former Member]

Try this:

Select * from OBTN a LEFT OUTER JOIN OBBQ b ON a.AbsEntry = b.SnBMDAbs

     LEFT OUTER JOIN OBIN c ON b.BinAbs = c.AbsEntry

Beni.

[former_member9041]

Hi Klein,

I used same tables but I did not find allocated quantity in bin

do you know where can we find allocated quantity in BIN Specially when we released pick list and material not picked

[Former Member]

Hi,

Qty of batch number in the BIN is OBBQ.OnHandQty.

Allocations for Pick List is in table PKL2.

Beni.