Tracking supplier Back orders

[Former Member]

Hi,

I use SAP Business One, Can anyone help me how to track my back orders from supplier?

[Former Member · Accepted solution]

Purchasing A/P -> Purchasing Reports -> Open Items List.

In this window, choose the Purchase Order in dropdown. This lists you the open POs.

[former_member187989]

Below query will enable to track back order for the supplier.

SELECT  T0.[CardName] AS 'Vendor Name', T0.[DocNum] AS 'Purchase Order No.', T0.[DocDate] as 'Date',T1.[ItemCode], T1.[Dscription] as 'Item Description', T1.[OpenQty] as 'Back Order Qty' FROM OPOR T0  INNER JOIN POR1 T1 ON T0.DocEntry = T1.DocEntry AND T1.LineStatus='O'
WHERE T0.[DocDate] 
BETWEEN '[%0]' AND '[%1]'  AND T0.[DocType] = 'I' 
ORDER BY T0.[CardName]

Jeyakanthan

[former_member187989]

Purchasing A/P>Purchase Reports>Open Item List------>Select Purchase Order

This will show our supplier back orders.

Jeyakanthan