Block shipment when customer has overdue payments (Power Automate) in Business Central

(0) Share

Report

Posted on by Community Member

Hi all,

I am looking a way to create a request for approval when the user tries to create a 'Warehouse Shipment' from Sales Order in case the customer has overdue payments (guess is when 'Balance Due (LCY)' field from Customer Card is greater than 0).

I thought on using Power Automate for that. I am trying to avoid updating manually 'Blocked' to 'Ship' value when Balance Due (LCY) > 0. Another option could be to update 'Blocked' to 'Ship' automatically when Balance Due (LCY) > 0. How could I do that?

Thanks in advance.

Marti Dou

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

JAngle 133 on at

Like (0)

Report

rough guide above. Limitation of the standard connector being that balance due isn’t available so you will want to use the http connector if you want that exactly. Also wondering if the initial trigger is any good given balance due is a flowfield. You need a pattern which is more like this: https://joshanglesea.wordpress.com/2020/07/22/power-automate-purchase-order-alerts-to-vendor/

I think a recurring type flow will be easier to get going with this. Have it run every few hours for example. This way you can definitely pass the balance due value and assess that directly in a condition or a odata filter up front.

Was this reply helpful? Yes No