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

Financial Report (-) Negative sign in Formula

(3) Share

Report

Posted on by Raja

156

Dear Members,

I have a requirement in financial reports. Here I enter (-) negative sign in formula and post one transaction but in financial reports not working. Please guide me in this issue.

Thanks in advance,

Raja.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Khushbu Rajvi. 20,601 Super User 2025 Season 2 on at

Like (1)

Report

Please check this: this will help you out. https://community.dynamics.com/forums/thread/details/?threadid=551423f0-0e39-ee11-bdf4-0022482447f6

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (1)

Report

May this can help : https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-reversesign-property

https://fundamentals.tangicloud.com/support/solutions/articles/151000208723-resolved-issue-with-show-opposite-sign-on-financial-reports

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,481 Super User 2025 Season 2 on at

Like (2)

Report

Have you selected the "Show Opposite Sign" boolean in the column definition?

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (1)

Report

Hi, Is there any error message or is it just that the negative sign is not displayed?

Try the following first:

If it is in the Totaling column, please refer to the following steps.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,236 Most Valuable Professional on at

Like (1)

Report

Hi, good day
I hope this can help you, and give you some hints.

Design your own financial reports - Business Central | Microsoft Learn

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,245 Super User 2025 Season 2 on at

Like (0)

Report

You have not clearly mentioned what exactly the issue was, anyhow check the below excerpt

If you want to control how negative numbers show in the report output (both on-screen and in PDF), you use the Negative Amount Format action on the Options FastTab to choose your preferred format. The format can be a minus sign or parentheses.

https://learn.microsoft.com/en-us/dynamics365/business-central/bi-how-work-account-schedule

Was this reply helpful? Yes No
Vahid Ghafarpour 12,166 Super User 2025 Season 2 on at

Like (1)

Report

If any of the responses helped resolve your issue, please take a moment to mark the best answer. This helps others in the community quickly find solutions to similar problems.

To do this, simply click the "Does this answer your question?" button on the most helpful response and like the helpful posts. If your issue is still unresolved, feel free to provide more details so the community can assist further!

Thanks for being an active part of the Dynamics 365 Community!

Was this reply helpful? Yes No