Set up batch job for sending Approved Purchase orders to External Vendors - Only for vendors which have Vendor Collaboration active

(3) Share

Report

Posted on by Community Member

I intend to have a batch job set up for sending Approved purchase orders to external vendors putting them in "In external review" and sending them to Vendor portal for confirmation using late selection. Out of the box functionality does not have "Late Selection" option available. I extended class to make that visible and its working and batch job runs.

Selection criteria for batch job is given below

Issue: I have added Vendors table by using join but batch job does not run when I have join criteria added for Vendor collaboration field active. And if I don't add join criteria, batch job sends all purchase orders (whether vendor collaboration active or not) in to external review which I do not want.

Any idea whats wrong with the join ?

I have the same question (0)

All responses (9)

Answers (1)

WillWU 22,363 on at

Like (0)

Report

Hi Talbia,

I think you could debug the batch job to find out the issue, it seems that something is going to wrong in the query. Please make sure that the table join relationship is correct.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,158 Super User 2025 Season 2 on at

Like (0)

Report

Hi Talbia,

Does it use records when you set the filter on another field on the vendor table? If so, check what happens if you add the same filter value on e.g. a report with vendor base data or test the query range on a form query.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

I haven't tried the same filter value on anything else.. Can you please elaborate how do you want me to try it?

Also I have set up another batch job for Auto confirmation of approved POs for which vendor collaboration is = Not Active..For that, I have used the same join and filter value is set to vendor collaboration =Not Active but that batch job runs fine..

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,158 Super User 2025 Season 2 on at

Like (1)

Report

Hi Talbia,

It could be related to the brackets as part of the label. The value Active (PO is auto confirmed) and the second one do have the brackets which are usually considered to contain a SQL statement in query values. However, in this case it is the enumeration values. You can try to use double quotes around the option values like:

"Active (PO is auto confirmed)","Active (PO is not auto confirmed)"

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

[quote]
Hi Talbia,

It could be related to the brackets as part of the label. The value Active (PO is auto confirmed) and the second one do have the brackets which are usually considered to contain a SQL statement in query values. However, in this case it is the enumeration values. You can try to use double quotes around the option values like:

"Active (PO is auto confirmed)","Active (PO is not auto confirmed)"
[/quote]
Thank you so much for your response.
I also tried updating the query with double quotes as shown in the screenshot.

Batch job still doesn't work for "Send for Confirmation" to Vendor Collaboration. I wonder if its the join or the query or the batch itself. If I apply the same filters criteria as shown in the screenshot above for a single PO which does have Vendor Collaboration "Active" and meets the rest of the criteria as well and do not put it in batch job, it still does not work. Any idea why is it happening?

Was this reply helpful? Yes No
André Arnaud de Cal... 301,158 Super User 2025 Season 2 on at

Like (0)

Report

Hi Talbia,

Can you check what happens if you place the same filter values on the vendor form? On the option tab, there is an option to open the advanced query editor. Then you can add the range values and check if there are still vendors visible when you apply the filter.

Was this reply helpful? Yes No
heyitsvinhh 5 on at

Like (0)

Report

Hi Talbia,

Did you get a chance to figure this out? I am trying to accomplish the same task of setting a batch to send the PO's to vendors for confirmation, or auto-send for confirmation of approved PO's.

Was this reply helpful? Yes No
Wangwang Dui 66 on at

Like (0)

Report

Hi All.

Does any one solved this issue?

Was this reply helpful? Yes No
Verified answer

Wangwang Dui 66 on at

Like (1)

Report

Hi Every one,

I fix this issue. You need to select the 4th vendors when you join the table, means invoice vendor table.

Let me know if it works for you.

Was this reply helpful? Yes No