Skip to Content
0
Former Member
Feb 12, 2010 at 07:24 AM

Wants Combain query of GRPO -Return- AP Invoice

22 Views

Dear All,

Pls. help me for this query.

A) GRPO :

Vendor code

Vendor name

Doc Num

Doc status

Posting date

Total Before discount

Tax

Freight

Total Payment Due

B) IF GOODS RETURNS ARE DONE THEN:

Doc Num

Doc status

Posting date

Total Before discount

Tax

Freight

Total Payment Due

C) IF AFTER GRPO ,AP INVOICE DONE THEN:

Doc Num

Vendor referance Number.

Doc status

Posting date

Total Before discount

Tax

Freight

Total Payment Due

(A) ,(B),(C) should in a single query.

If possible pls. send me query.

Regards.

Mahesh.