Prepayment in Aging Report

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi Dynamics Community,

We are trying to prepare the customer ageing report but prepayments from customers are included in the report. Is there are a way to remove the prepayments (negative) in the ageing so we can have a clean receivable only balance in the ageing? Any help will be highly appreciated.

Eugene

*This post is locked for comments

All responses (3)

Answers (0)

John_Joyce 1,040 on at

Like (0)

Report

RE: Prepayment in Aging Report

Ahhh, apologies EugeneJohn. I didn't notice that your post went to the Dynamics 365 community page, as my answer would be relevant for Dynamics SL only. Sorry about the confusion - I do not have an answer for you.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Prepayment in Aging Report

Hi John Joyce,

Thank you for your reply. We are new in dynamics and i don't understand much yet on the terms. We are preparing the ageing report through the below screenshot:
Suggested answer

John_Joyce 1,040 on at

Like (1)

Report

RE: Prepayment in Aging Report

Yes, you should be able to go to the SELECT tab and filter the report to exclude the "PP" DocType.