SBX - Search With Button

SBX - Forum Post Title

Prepayment in Aging Report

Microsoft Dynamics SL Forum

EugeneJohn asked a question on 19 Mar 2019 6:18 AM

Question Status

Suggested Answer

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

Reply
John Joyce responded on 19 Mar 2019 9:52 AM
My Badges
Suggested Answer

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

Reply
EugeneJohn responded on 20 Mar 2019 3:04 AM

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:

Reply
John Joyce responded on 20 Mar 2019 12:12 PM
My Badges

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.

Reply
John Joyce responded on 19 Mar 2019 9:52 AM
My Badges
Suggested Answer

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

Reply

SBX - Two Col Forum

SBX - Migrated JS