Skip to Content
0

Purchase Order not GR paid without invoice

Mar 17, 2017 at 08:54 AM

119

avatar image
Former Member

Dear All Master,

I have the quetion, what query to get data for PO not GRPO n not invoice but have been paid ?

any gimme a hand ?

Thx b4

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Balaji Selvaraj Mar 17, 2017 at 09:20 AM
0

Hi Harry Pramana,

Have you paid through making advance payment entry or straight outgoing payment.

Regards:

Balaji.S

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 17, 2017 at 12:21 PM
0

Hi Balaji Selvaraj,

Yes i have, making user advance payment entry , our company would like to know all PO with Doctype Item but not received and invoice and payment use base doc APDP cause process business purchasing in our company : PO -> GRPO ->APDP->payment-> Invoice

I hope fully u can help guide me for build the query

Thx b4

Share
10 |10000 characters needed characters left characters exceeded
Nagarajan K Mar 17, 2017 at 02:05 PM
0

Hi,

Query below tables,

OPOR, POR1, ODPN, PDN1, OVPM, VPM2, ODPO, DPO1 and OPCH, PCH1.

Regards,

Nagarajan

Share
10 |10000 characters needed characters left characters exceeded
Balaji Selvaraj Mar 17, 2017 at 02:12 PM
0
Hi Harry Pramana,

Try the below query additional you can add fields and tables as per your demands. As per your initial question you need to know the PO with paid or not.

SELECT T0.[DocNum][Po No], T3.[DocNum][Down payment No],T0.[CardName],T0.DocTotal[Po Total], T3.[DocTotal][DownPayment Amt], T3.[PaidToDate] FROM [dbo].[OPOR] T0 INNER JOIN [dbo].[POR1] T1 ON T0.[DocEntry] = T1.[DocEntry] INNER JOIN DPO1 T2 ON T0.DocNum = T2.BaseRef INNER JOIN ODPO T3 ON T2.[DocEntry] = T3.[DocEntry]

Regards:

Balaji.S

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Balaji Selvaraj,

my leader would like to know , The doc.PO not GRPO yet has been paid without invoice masterr,

any addtion relation table n field for that ?

0

Hi Harry,

I am not getting it you are asking for PO without GRPO nor invoice right only downpayment in this case above query will work.

Regards:

Balaji.S

0
Former Member
Balaji Selvaraj

Hi Balaji Selvaraj,

Im sorry for my bad english grammar, Thanks b4 for your help.

Have good day

0