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

(0) Share

Report

Posted on by Joseph.Candava

156

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.

All responses (5)

Answers (1)

Inge M. Bruvik 1,021 Moderator on at

Like (0)

Report

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

[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.
Charlie W 10 on at

Like (0)

Report

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

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

Joseph.Candava 156 on at

Like (0)

Report

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

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.
DAnny3211 9,276 Moderator on at

Like (0)

Report

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

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
Bilal Haider 248 on at

Like (0)

Report

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

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