Dynamics Community Forum Thread Details

Project Budget : Quantity-Based Check for Project Items (Not Amount)

We are currently implementing Dynamics 365 Finance and Operations for a project-centric organization, and we have a critical requirement regarding project budget control for project items.
Our standard project budget control, as configured, operates effectively on amounts, preventing or warning when financial expenditures exceed the budgeted monetary value.
However, we need to implement a budget check that specifically focuses on quantities for project items
Is there an out-of-the-box feature or configuration within D365 F&O that enables a direct quantity-based budget check (warn/prevent) for project item transactions (e.g., Purchase Orders, Item Consumption Journals)?
Any insights, guidance, or examples from your experience would be greatly appreciated. Thank you in advance for your help!
Best regards,

Categories:

Dynamics 365 Finance

Hi,

By default, the project budget control functionality in Dynamics 365 Finance and Operations is designed to operate on monetary amounts, not on quantities. This means it can warn or prevent transactions when the financial value exceeds the budget, but it does not natively support quantity-based budget checks for project items.

What you can do:

1. Use Forecasts for Quantity Tracking
While project budgets are amount-based, project forecasts allow you to enter and track quantities for items, workers, and categories. However, forecasts do not enforce hard controls — they are more for planning and reporting.

2. Customization or Extension
To implement a quantity-based budget check (e.g., warn or block when item quantities exceed a predefined limit), you would need to:

Extend the project budget control logic
Add a custom validation on transactions like Purchase Orders or Item Consumption Journals
Compare the cumulative quantity posted against a custom field or forecast quantity

3. Use Workflow or Alerts
As a workaround, you could:

Set up a workflow that triggers when a transaction exceeds a certain quantity
Use Power Automate or Business Events to monitor and notify when thresholds are breached

4. Consider ISV Solutions
Some third-party solutions offer enhanced project control features, including quantity-based validations. It may be worth exploring if this is a critical requirement.

Unfortunately, there is no out-of-the-box feature that enforces quantity-based budget control with warnings or prevention logic. It would require either a customization or a process-based workaround.

Let me know if you'd like help designing a possible extension or alert logic.

Best regards,
Daniele

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL