Skip to Content

Incoming payment on account reconciled with AR Invoice

Hi all

How to exclude from this Query not to show advance payment on account amount when it has been reconciled with AR Invoice and no longer showing in Aging report?

Select T5."DocDate", T5."DocNum",T5."DocType",T5."NoDocSum" *-1 as "OpenAmount"
from ORCT t5
where T5."PayNoDoc" = 'Y' and T5."DocType" = 'C' and T5."NoDocSum" >0
)

Kedalene
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 07, 2017 at 05:48 AM

    Hi,

    Include the table OITR and ITR1 as it contains the reconciliation records which will give you the transactions reconciled with the Payment on Account.

    Regards,

    Jitin

    Add comment
    10|10000 characters needed characters exceeded