Can't send email using AL due to filtering error

(0) Share

Report

Posted on by jdrco

481

I am trying to send an email with a report as an attachment through AL when the report is run (Report 329 - Vendor trial balance). I am having trouble when I try to save the same report that was ran. This is the error I get when running the report (it prevents BC from sending the email too): It was not possible to find a Starting Date in Accounting Period.

I believe the error stems from when I try to get a record with the same Vendor No. and Date filter as specified from the report request page:

Here is my code (a codeunit to send the email and a report extension)

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

JAngle 133 on at

Like (1)

Report

Have you reviewed the code of the report? Do you actually have accounting periods setup? I’d check those things first as the code has no immediate concerns

Was this reply helpful? Yes No
jdrco 481 on at

Like (0)

Report

JAngle How do I setup accounting periods? Do I do this through code?

Was this reply helpful? Yes No
Suggested answer

JAngle 133 on at

Like (0)

Report

In the app. Follow this: docs.microsoft.com/.../finance-accounting-periods-and-fiscal-years

Was this reply helpful? Yes No
Verified answer

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

Like (0)

Report

Hi, as Josh mentioned, please check the Accounting Period settings.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No