Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How do I filter a batc...
Small and medium business | Business Central, N...
Answered

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

(0) ShareShare
ReportReport
Posted on by Joseph.Candava 101

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:

pastedimage1678246867324v2.png

Here is my current configuration of the Job Queue Entry.

pastedimage1678246528174v1.png

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.

  • Inge M. Bruvik Profile Picture
    Inge M. Bruvik 997 Moderator on at
    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 Profile Picture
    Charlie W 10 on at
    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 Profile Picture
    Joseph.Candava 101 on at
    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.
    pastedimage1678321689957v1.png

    At this point, consider my question answered.

  • DAnny3211 Profile Picture
    DAnny3211 9,274 Moderator on at
    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 Profile Picture
    Bilal Haider 232 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,307 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans