Small and medium business | Business Central, N...

Aged Accounts Payable and Aged Accounts Receivable Reports

(1) Share

Report

Posted on by Imari

148

Hi. We have job queues created for Aged AP and Aged AR. It's currently working however, we noticed that the report is not updated. It shows that the summary or the report is as of the date when the job queue was created.

How do we set this to the recent date when the report is generated or scheduled to be generated in the Reports inbox? Thank you.

The report is scheduled every day at 10:30 AM however the summary, aged as of section is showing March 05, 2024.

Categories:

Business Central

All responses (5)

Answers (0)

Imari 148 on at

Like (0)

Report

Aged Accounts Payable and Aged Accounts Receivable Reports

Hi, Philippe.

Good day! I removed the previous message here as it's not related to this inquiry. Regarding this, I followed the instructions however, it didn't give me the expected date which is the work date. I came across another report id which is 322 for Aged AP and the date of the aged as of field changes everyday when I used the instructions below. Could you please assist with the difference between the 2 reports? Can we use the 322 instead of the 10085 report?
Philippe P 120 on at

Like (0)

Report

Aged Accounts Payable and Aged Accounts Receivable Reports

Hi Imari,

Yes, by default if you leave the aged as field date empty then it will take the current day at the moment the report is run. If you run your report at 8 PM every night than tonight, it would take the 12th of march while running the report.

When it comes to running it in a job queue, by default Business Central takes the last setting you used while running the report. If you want it to take the current date (field being empty) then run it manually one time with the field being empty before setting it in the job queue.

I presumed you ran that report manually on the 5th of march which caused it to take that same setting every single time afterward.

Hope this helps,
Imari 148 on at

Like (1)

Report

Aged Accounts Payable and Aged Accounts Receivable Reports

Hi. Thank you both for your responses. @Jun Wang, I tried to remove the aged as of field date however, it's going back to today's date. Is that how it should work? Would this be the aged as of date for tomorrow's report?
Suggested answer

Jun Wang 7,443 Super User 2024 Season 2 on at

Like (1)

Report

Aged Accounts Payable and Aged Accounts Receivable Reports

you need to leave the aged as of field open so it pulls in all record up to the work day.

also I don't think this is something you need to run daily, it need to be run periodically depending on needs.
Suggested answer

YUN ZHU 73,647 Super User 2024 Season 2 on at

Like (0)

Report

Aged Accounts Payable and Aged Accounts Receivable Reports

Hi, as far as I know, this is determined based on the Aged As Of option in the report, but when you set it in the Job Queue, this field cannot set a formula.
I don't think there's any way to do it other than customizing it.

More details: Dynamics 365 Business Central: Can we change default options/filters on the request page of Report???

https://yzhums.com/40072/

Hopefully other experts can give you better advice.

Thanks.

ZHU