Answered

Can't send email using AL due to filtering error

(0) Share

Report

Posted on by jdrco

479

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)

Categories:

Reports and Business Intelligence

Other

All responses (4)

Answers (1)

Verified answer

YUN ZHU 70,333 Super User 2024 Season 2 on at

Like (0)

Report

RE: Can't send email using AL due to filtering error

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

Hope this helps.

Thanks.

ZHU
Suggested answer

JAngle 33,157 on at

Like (0)

Report

RE: Can't send email using AL due to filtering error

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

Like (0)

Report

RE: Can't send email using AL due to filtering error

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

JAngle 33,157 on at

Like (1)

Report

RE: Can't send email using AL due to filtering error

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