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)

Sort by

Suggested answer

Khushbu Rajvi. 22,424 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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 16,520 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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 32,689 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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 100,974 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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... 26,790 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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,278 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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,262 on at

Like (1)

Report
Copy link

Link copied!

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