Require Query to Send Auto Email for Pending Purchase Order Qty.

[vijaychavda9]

Dear Experts,

We are looking for Query to Send Auto Email to all vendor for pending purchase order qty. through SAP B1. If you have such query kindly provide the same.

Tons of thanks in advance.

Warm Regards,

Vijay N. Chavda

[kothandaraman_nagarajan · Accepted solution]

Hi,

Try this query for open purchase order,

SELECT T0.[DocNum], T0.[DocDate], T0.[CardName], T0.[NumAtCard], T1.[ItemCode], T1.[Dscription], T1.[Quantity], T1.[ShipDate] FROM OPOR T0 INNER JOIN POR1 T1 ON T0.[DocEntry] = T1.[DocEntry] WHERE T1.[LineStatus] ='o' ORDER BY T1.[ShipDate]

Regards,

Nagarajan

[vijaychavda9 · Accepted solution]

Thanks for your response.

[vijaychavda9]

Thanks Mr. Nagarjan.

[kothandaraman_nagarajan]

Please choose best answer to close discussion. Thanks