Post a question

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Report Business Central

Small and medium business | Business Central, N...

Suggested answer

Report Business Central

Like (4) Share

Report

Report

Posted on 26 Mar 2025 06:20:27 by CU26030612-0

9

Hello Everyone i have a query regarding Business Central Report Enhancement

I am working on a Business Central report and facing an issue with conditional formatting.
Whenever the inventory is about to reach zero, then the corresponding inventory column should turn red before the inventory reaches zero, based on the lead time.

For example:

Suppose the inventory is expected to be zero on 01/01/2026.

If the lead time is 2 weeks, the column should turn red on 18/12/2025 (two weeks before the zero-inventory date).

Currently, in my code, the entire row turns red, which is incorrect.
Instead, only the specific column where the inventory is expected to be zero should turn red.

I need guidance to correct this behavior so that only the relevant column turns red.
Any insights or suggestions would be highly appreciated.

Categories:

Dynamics 365 Business Central

All responses Img

All responses (2)

Answers Img

Answers (0)

gdrenteria 16,284 Most Valuable Professional on 26 Mar 2025 at 09:15:30

Like (2)

Report

Report Business Central

Hi

You could also use queries and list-type pages in BC that allow you to format using this.

Style property - Business Central | Microsoft Learn

Change field color based on field value in Dynamics 365 Business Central | Dynamics 365 Lab

Dynamics 365 Business Central: Using the query as a data source for a page (Query.Open Method) | Dynamics 365 Lab

Best

GR
Suggested answer

Jainam M. Kothari 3,007 on 26 Mar 2025 at 07:06:13

Like (1)

Report

Report Business Central

Hello,

I am not technical person but may be following resources can be useful.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-format-report-field-data

https://community.dynamics.com/blogs/post/?postid=361c3e30-e4d7-ee11-92bd-002248527d3d

https://learn.microsoft.com/en-us/dynamics365/business-central/purchasing-date-calculation-for-purchases

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge 🌸

Quick Links

Leaderboard

#1

André Arnaud de Cal... 293,325 Super User 2025 Season 1

#2

Martin Dráb 232,223 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans