Skip to Content
avatar image
Former Member

Purchase Order not GR paid without invoice

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Mar 17, 2017 at 09:20 AM

    Hi Harry Pramana,

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

    Regards:

    Balaji.S

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 17, 2017 at 12:21 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 17, 2017 at 02:05 PM

    Hi,

    Query below tables,

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

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 17, 2017 at 02:12 PM
    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

    Add comment
    10|10000 characters needed characters exceeded