on 02-11-2017 6:15 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Mr. Nagarjan.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.