Customizing Report Layouts in Microsoft Dynamics 365 Business Central
![Image](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-h-MdI77qRU8G-vn0pKdCLkWMlx9tC8HdNd82u6RxFyQREs-rDS-_jysjJg7u1iLP7PGLG-tFvLo8Uuwsp0MDJZ6Hq4bTG2ffz-jpLPM8FPItYa8FzGw05M2tlXvpkKAil-pCGT89BHQRqWePQWVc9-JjzzrGc_mrc-mZFzF1y7UAyw7_HiKqGglX/s16000/image002.png)
I had a client ask me if the Aged Accounts Receivable report could be modified a bit since he was having to modify it manually and it was taking him around 6 minutes each time. As I started discovery on what he wanted I asked him what his requirements were. Aged by = Document Date Length of Aging Periods = 45D Print Detail = Yes Print to Excel = Yes Include a Pivot Table with the following information: Customer name Total balance due Total over 45D due Top 3 customers Percentage of 45D due vs total balance due To get started I asked him to send me a screen shot of the Aged Accounts Receivable options window to verify how he is running the report. I also asked him to send me a copy of the Excel file with his changes in it for me to review. Next Steps Next step was for me to figure out if I was going to have a developer create a custom report or if I was brave enough to try something I've never done before. I went the brave route and started searching through Microsoft Docs for Rep