Skip to Content
0

Incoming payment on account reconciled with AR Invoice

Sep 07, 2017 at 01:52 AM

51

avatar image

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
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jitin Chawla
Sep 07, 2017 at 05:48 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Jitin, will try it out.

0