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

Aged Accounts Payable and Aged Accounts Receivable Reports

(2) Share

Report

Posted on by Imari

164

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:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,200 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Imari 164 on at

Like (1)

Report

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?

Was this reply helpful? Yes No
Philippe P 55 on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Imari 164 on at

Like (0)

Report

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?

Was this reply helpful? Yes No