Skip to Content
0

Approval Query when adding an AP Invoice with Base Document

Sep 20, 2017 at 10:55 AM

98

avatar image
Former Member

Good day Experts!

I need help with the creation of an approval query every time an AP Invoice is added from a base document (Sales Order, Delivery, AR DP Invoice etc).

I have created a sample query SELECT DISTINCT 'TRUE' FROM OPCH A INNER JOIN PCH1 B ON A.DocEntry = B.DocEntry WHERE NOT B.BaseType = -1

Thanks!

10 |10000 characters needed characters left characters exceeded

Hi Nikka,

What you want to validate? Are you want to do an approval procedure for documents without base documents?

Kind Regards,

Diego Lother

0
Former Member

Hi Diego, I want to have an approval process for A/P invoice with base documents, either Sales Order, Delivery, ARDP documents. Thank you.

0
Former Member

Hi Nikka and Diego,

I am new in sap so can you please tell me where to apply this query.

When I copy from Delivery to A/R invoice Document Date not copied from delivery to invoice.

Can you please tell me path to set the query for this.

Regards,

Sapna

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Nagarajan K Sep 23, 2017 at 03:01 PM
0

Hi,

Try this query for AP Invoice approval,

SELECT Distinct 'True' FROM OPCH T0 INNER JOIN PCH1 T1 ON T0.[DocEntry] = T1.[DocEntry] WHERE $[$38.43.0] = '-1'

Regards,

Nagarajan

Share
10 |10000 characters needed characters left characters exceeded
DIEGO LOTHER Sep 25, 2017 at 12:07 PM
0

Hi Nikka,

Try this:

SELECT CASE WHEN $[$38.43] <> -1 THEN 'TRUE' ELSE 'FALSE' END

Hope it helps.

Kind Regards,

Diego Lother

Share
10 |10000 characters needed characters left characters exceeded