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

How do I filter a batch posted sales invoice email using Job Queue Entries?

(0) Share

Report

Posted on by Joseph.Candava

183

I am attempting to create a job queue entry scheduled to run every day.

For Parameter String, I use this following code to filter out Posted Sales Invoices for a specific Customer No.(C31661) that has the Date Sent to Today.

Document Type=Posted Sales Invoice AND Customer No.=C31661 AND Date Sent=Today

When I attempted to run a test of this job queue entry in the foreground, I receive the error message:

Here is my current configuration of the Job Queue Entry.

Is there a different parameter string format that I need to enter to achieve the effect that I am looking for?

Your help is much appreciated.

I have the same question (0)

All responses (5)

Answers (0)

Bilal Haider 414 on at

Like (0)

Report

Hi,

I do not think it can be directly applied to report. You can create a codeunit and get the parameters inside and filter.

Step by step guide is here

www.sauravdhyani.com/.../how-to-use-job-queue-parameter-string.html

Was this reply helpful? Yes No
DAnny3211 11,397 on at

Like (0)

Report

HI

watch this

www.sauravdhyani.com/.../how-to-use-job-queue-parameter-string.html

refers to NAv but the logic is the same for BC

DAniele

Was this reply helpful? Yes No
Suggested answer

Joseph.Candava 183 on at

Like (0)

Report

Thanks for your input.
With this, I am able to remove the job queue entry since the parameters was not the correct field to use.

I was able to create a new job queue entry while being able to filter out the correct document, using the "Create Recurring Sales Invoice" task page, then schedule it, then set it to send out email invoices to the specific customer number in mind daily.

At this point, consider my question answered.

Was this reply helpful? Yes No
Charlie W 10 on at

Like (0)

Report

I am trying to accomplish similar task. How do you set it up to send out email invoices to the specific customer number daily.

Was this reply helpful? Yes No
Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

[quote user="Charlie W"]
I am trying to accomplish similar task. How do you set it up to send out email invoices to the specific customer number daily.
[/quote]
There is no standard functionality to do that.

But if you use the Post and Send function in Business Central the invoice will be sendt directly after it is posted.

If you want a daily routine you will need to either customize some code or try to use Power Automate to achieve want you want to do.

Was this reply helpful? Yes No