Stock Report to Include Released Quantities in Pick & Pack Manager

Advertisement

Hi,
I have the following Stock Report that has been written to include various other information I need to look at regularly, but I am looking to include what quantity per stock code is released in Pick & Pack Manager.
Is anyone able to help me on this, it would be appreciated?
Kind Regards
David
SELECT     T0.ItemCode, T0.ItemName, T0.SalPackMsr as 'Pack Size', T0.SWW as 'Size', T0.OnHand, T0.OnOrder,T0.IsCommited,
(SELECT     SUM(T1.Quantity)
FROM         QUT1 T1 INNER JOIN
                      OQUT T2 ON T1.DocEntry = T2.DocEntry
GROUP BY T1.ItemCode, T2.DocStatus
HAVING      (T2.DocStatus = 'O') AND T1.itemcode = T0.itemcode) as QuoteQty,
T0.[OnHand]-T0.[IsCommited]+T0.[OnOrder]- isnull((SELECT     SUM(T1.Quantity)
FROM         QUT1 T1 INNER JOIN
                      OQUT T2 ON T1.DocEntry = T2.DocEntry
GROUP BY T1.ItemCode,  T2.DocStatus
HAVING      (T2.DocStatus = 'O') AND T1.itemcode = T0.itemcode),0) as Available,
(SELECT     SUM(T3.Quantity) AS SoldQuantity
FROM         OINV T4 INNER JOIN
                      INV1 T3 ON T4.DocEntry = T3.DocEntry
WHERE     (T4.DocDate >= CONVERT(DATETIME, '2011-01-01 00:00:00', 102))
GROUP BY T3.ItemCode
HAVING      (SUM(T3.Quantity) > 1) and (T3.ItemCode = T0.ItemCode))as QuantitySold,
(SELECT     SUM(T5.Quantity) AS CreditedQuantity
FROM         ORIN T6 INNER JOIN
                      RIN1 T5 ON T6.DocEntry = T5.DocEntry
WHERE     (T6.DocDate >= CONVERT(DATETIME, '2011-01-01 00:00:00', 102))
GROUP BY T5.ItemCode
HAVING      (SUM(T5.Quantity) > 1) and (T5.ItemCode = T0.ItemCode))as QuantityReturned
FROM         OITM T0
WHERE T0.[OnHand]T0.[IsCommited]T0.[OnOrder]  + isnull((SELECT     SUM(T1.Quantity)
FROM         QUT1 T1 INNER JOIN
                      OQUT T2 ON T1.DocEntry = T2.DocEntry
GROUP BY T1.ItemCode, T2.DocStatus
HAVING      (T2.DocStatus = 'O') AND T1.itemcode = T0.itemcode),0) <> 0

Advertisement

Dear Ashish,
If your Pick List status is open, it will not lock anything. You need release them.
Thanks,
Gordon

October 11, 2015

Stock Report to Include Released Quantities in Pick & Pack Manager

Hi, I have the following Stock Report that has been written to include various other information I need to look at regularly, but I am looking to include what quantity per stock code is released in Pick & Pack Manager. Is anyone able to help me on th

Stock report for cross-company sales

Dear all, We are using for our Saudi Arabia company the cross-company sales process with sourcing unit in another country. There is a Legal requirement in Saudi to provide a Stock report (with "stock in", "stock out" quantities and val

Reconciliation fo stock report at stock type level

Hi gurus, I want to compare the stock quantities in a stock report with ECC when I drill down the report at Stock type level. I have tried to do it through MB5B but I found it not appropriate as the stock type calculation in BW as based on some LIS l

BOM wise stock report.

Dear Gurus, Good Morning !! My user' requirement is, he wants a BOM wise stock report. He will just enter the Header Item, Plant and the storage location, and system should list all its sub-items with the stock available in that plant & the storage l

CRM 5.0 ATP check to ECC not including pick / pack time in ECC 6.0

Been searching SDN & OSS, our ATP check in 5.0 is reading the proper inventory in ECC but when no inventory is available the date being returned is the total replenishment leadtime in the ECC material master. (good) When the order is entered in ECC i

Consingment stock report with values

Hello guys, I need one standard report, which includes amounts (values in money) of consignment stock. Could you please help ? Thanks guys ! Best regards, LaimonasHi, In the transection code MB52 select the Special Stock Indicator W in the selection

Crystal reports server XI release 2 installation problem

Hello, everybody, got 2 of crystal reports server XI release 2 packages back in 2006 since then only crystal reports designer were used (great software) and it works fine. but now trying install the server version included in the package, installatio

RunTime Termination Error in SAP BI stock report

Hi, We are executing organization level stock report. organization have around 90 plants and 13000 material. Report is getting terminated due page allocation failure. Report is running fine with smaller selection. Please help us to resolve the issue.

Stock Report, Batch Wise

Hi Gurus, I have to prepare "Stock Report Batch Wise" in BI for SD module. May be for the finished goods. For this in BI which data Cubes/ data sources I can use? Do Std MM BI content Cubes/data sources help? My question do MM business contain i

Daily Stock Report for a trading industry

Hi, I want a daily stock report for a trading industry. In this i want date wise opening stock, closing stock, outward quantity and inward quantity. How to get it? Thanks, NiranjanHi, This is not easy as you think you have to develop this report by u

Does refreshing a report that includes Scope and Entity require elevated rights / permissions?

This relates to the following thread: Why does refreshing a report in the EPM Add-In need to edit the Ownership Manager? Since I've received no responses on the above thread, I thought I might approach this from a different angle. If we have a report

Profit Centre wise Stock Report

Hi folks!! Is there any report available, through which we can retrive profit centre wise stock report. Best regardsHi You cannot check profit centre wise inventory (of materials) directly. But you can get profit center wise inventory GL accounts dat

Stock report( closing of today opening of tomorrow)

Dear Experts can anybody help me in getting a stock report the parameters are: Opening Ballance - ( Qty -Value ) , Issue during a period -(Qty- Value ) , Rceipt during a period( Qty-Value) Closing Stock(Qty-Value) my one of the  client requriment   c

Dead stock report - tables regarding

hi , i need the name of the table and the key field which used to take the dead stock report. i.e. 6 months non moving materials list i want with stock values. kindly forward your suggestions. GiriHi , The tcode which you have provided is useful.....

Tables req to get date wise stock report

Hi Pls advise, what are the tables req to get date wise stock report??? i don't want any t codes... i have to do with age analysis ,?? Anyone has answer? pls provide it. Edited by: UJ on Mar 3, 2010 8:54 AMYou can take below details which help you to

Stock Report with Batch Number

Hi , My Client requires stock report with Batch numbers .required report format is Item Code,BatchNumber,OpenQty,OpenVal,PurchaseQty,PurchaseVal,SalesQty,SalesVal,ClosQty,CloseVal I tried using query on wiki for stock report but that query is written

Stock Report with batch number and its Charactristc values

Our material are batch managed and Char values are entered at the time of GR. We need to prepare stock report showing batches for the material, their stock and characteristics values. Like to know what tables we should use to find the char values. I

How to get Opening Balance for Stock Report in Crystal Report?

Dear Experts, I am using SAP B1 8.82. I am new to crystal report and now trying to do a monthly stock report with the following format: Species  BatchNum   OpeningBal   QtyInKD    QtyInRD    QtyInCD   Adj    ClosingBal ABC       T1234          17.43 

Report  for  PO  Release

Dear All, Is there any report available that gives me the list of PO's release by  auser or by some release code on specific date. PrashantHello Prashant, Check if you can use ME28 (with flag cancle release) to meet your requirement. if not then you

Massive Stock Report

Dear all, I would like to know if there is in SAP a Massive Stock Report in which you can see the stock in different units of measure at the same time. MMBE and MB52 don't satisfy my requirement, because MMBE is not for massive stock, you can only se