Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 11, 2017 at 11:19 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 21, 2017 at 12:06 PM

    Thanks Mr. Nagarjan.

    Add comment
    10|10000 characters needed characters exceeded