Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) Period Sensitive Aging...

Period Sensitive Aging Report - Days outstanding rather than days past due

(1) Share

Report

Posted on by Community Member Microsoft Employee

Does anyone know how to run a period sensitive Accounts Receivable aging report on a prior period to reflect days outstanding rather than days past due? Any advice would be greatly appreciated.

Thanks,

Denise Nix

*This post is locked for comments

All responses (2)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Period Sensitive Aging Report - Days outstanding rather than days past due

Thank you Mark!
Verified answer

Mark E 6,431 on at

Like (1)

Report

RE: Period Sensitive Aging Report - Days outstanding rather than days past due

You would need to:

-create a new sql view based on vr_08611.sql that uses the DocDate instead of the DueDate to calculate against the Report Date for determining the correct Aging column

-create a new Crystal report from the 08611.rpt, which points to the new sql view

-add the new Crystal report to the PS Aged AR formats

I have done this successfully at some of my clients.