Find Open GRPOs in SAP B1

[sreesajs]

Hi All,

I want to see the list of open GRPOs in warehouse-wise in sap B1. If there any report available in B1 to find this?

Regards,

Sreesaj

[Johan_H · Accepted solution]

Hi Sreesaj,

Alternative 1:

Open the GRPO form: Purchasing - A/P > Goods Receipt PO

Change the form to 'Find' mode, by pressing CTRL + F on your keyboard, or clicking the 'Find' button on the toolbar, or clicking the 'Find' link at the top of the Data menu.

From the 'Status' field dropdown (upper-right corner of the form), select the 'Open' or 'Open - Printed' option.

In the Document Number field (above the status field), write *

Press the Find button at the bottom of the screen.

Alternative 2:

Go to: Purchasing - A/P > Purchasing Reports > Open Items List

Select 'Goods Receipt POs' from the 'Open Documents' dropdown.

Alternative 3:

Run the following query:

SELECT T1.[DocNum]
     , T1.[DocDate]
     , T1.[DocDueDate]
     , T1.[CardCode]
     , T1.[CardName]
     , T0.[WhsCode]
     , T2.[WhsName] 
FROM PDN1 T0
     INNER JOIN OPDN T1 ON T0.DocEntry = T1.DocEntry
     INNER JOIN OWHS T2 ON T0.WhsCode = T2.WhsCode 
WHERE T0.[LineStatus] <> 'C'
  AND T1.[DocStatus] <> 'C'
ORDER BY T2.[WhsCode]
       , T2.[WhsName]

Regards,

Johan

[sreesajs · Accepted solution]

Thank you very much...