web
You’re offline. This is a read only version of the page.
close
Skip to main content

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... / Block shipment when cu...
Small and medium business | Business Central, N...
Suggested Answer

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

(0) ShareShare
ReportReport
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)
  • Suggested answer
    JAngle Profile Picture
    JAngle 152 on at

    B01D1231_2D00_F8E0_2D00_4C08_2D00_9475_2D00_333F100DC98A.png
    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.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,946 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,177 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 555 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans