Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) Aged AP report and ove...

Aged AP report and override tab

(0) Share

Report

Posted on by Community Member Microsoft Employee

We have just come across a weird issue with the report 03680s which is the Aged AP report format = past due - summary. We have found that if a document is created and the value on the override tab on the voucher and adjustment entry screen is changed this report will show this vendor twice. The same vendor is listed 2x on the report. In the help files it says that this report 'The report is a summary of all open accounts payable documents (vouchers and

adjustments) by vendor and days past due based on Aging Date and the aging categories on the Other Options tab of AP Setup (03.950.00) but this is not the case

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Aged AP report and override tab

This report groups not only on the vendor id but also the AP trade account and sub-account used on the documents. So, if you override the default AP Trade account, you will get this vendor more than once on the report but each line is limited to the documents falling under that AP trade account.

I suspect the report was built this way so that it could be used to tie out to a particular AP Trade account though the AP Trade account is not shown anywhere on the report. However, this design does allow you to limit the report to a particular AP Trade account by using the filter capabilities of the ROI.

The report has been this way for as long as I have been supporting Solomon / Dynamics SL.