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

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Alert when Inventory Amount = 0 for an item

(0) ShareShare
ReportReport
Posted on by

Hello,

Is anyone aware of a way to have Business Central automatically send an e-mail alert when the stock for an item hits 0?

I am aware the system will warn users on Sales documents but was moreso hoping for a solution using Power Automate or something similar - I've had little luck so far with the limited triggers available on Automate. Any help is appreciated, thank you very much.

I have the same question (0)
  • Suggested answer
    Madest Profile Picture
    15 on at
    RE: Alert when Inventory Amount = 0 for an item

    Surely the simplest thing you can do is the following:

    do a codeunit, in it do a function that is subscribed to the event of insertion of item movements (Item ledger Entry [T32]) , or in the validation Event of the Quantity field of that table (most likely OnBefore Events). Just at that moment when you have the quantity, you calculate the inventory of the product and subtract the amount of that movement, if it becomes zero or negative you call the functions of the Codeunit 400 to generate emails, as long as before the inventory has been positive and the movement negative.

    All this is theory, the important thing is to which event you subscribe, since it will depend on how NAV generates the item movement.

    I hope you find it useful.

    Regards

  • Community Member Profile Picture
    on at
    RE: Alert when Inventory Amount = 0 for an item

    Madest, 

    I really appreciate the response - unfortunately I'm not a technically minded enough person to know how to implement your suggested solution - that's why I was trying to use Power Automate or some other similar software geared towards Luddites. 

    I'll pass it along to a dev though. Thanks very much for taking the time. 

  • Suggested answer
    Mohana Yadav Profile Picture
    60,967 Super User 2025 Season 2 on at
    RE: Alert when Inventory Amount = 0 for an item

    please check this blog

    suvidhablogpost.wordpress.com/.../

  • Community Member Profile Picture
    on at
    RE: Alert when Inventory Amount = 0 for an item

    Thank you Mohana! This has gotten me very close to exactly what I need. I appreciate it.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,330

#2
Sumit Singh Profile Picture

Sumit Singh 2,738

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,546

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans