Query for all un receipted orders against a supplier

[former_member1259812]

I am wanting a query that will give me a list of all orders that haven't been receipted against a particular supplier. The issue is we have a supplier who is behind on a lot of orders and i want a full list to try and pull everything together.

[former_member287017]

Hi Robert Heywood,

In case if only summary is required,then Use Open Items List report.

If Pending PO with Item details required, then Use this Query

SELECT T0.[DocNum], T0.[CardName], T1.[ItemCode], T1.[Dscription], T1.[OpenQty], T1.[ShipDate],
DATEDIFF(DD,T1.[ShipDate],GETDATE()) 'Days Exceeded' FROM OPOR T0
INNER JOIN POR1 T1 ON T0.[DocEntry] = T1.[DocEntry] LEFT OUTER JOIN OITM I ON I.ItemCode = T1.ItemCode where T1.[OpenQty] > 0
AND T0.[CardName] = '[%0]'
ORDER BY [Days Exceeded] DESC, DocNum ASC, T1.LineNum ASC

Regards,

Chella

[agustin_marcoscividanes]

Hi

in the orders form you can do this query.

Open the form in search mode, select the supplier and only open documents. Search, and you Will obtain a list with the documents.

You can customice the grid with the results and export to Excel.

Kind regards

Agustin