Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Answered

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

Posted on by 90

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.

Categories:
  • Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,718 Super User 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 90 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,184 Super User 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 41 Super User 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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans