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

Rounding to whole numbers after applying a discount to a line item or customer invoice

(7) Share

Report

Posted on by PD-11070952-0

when applying a discount, is it possible for the resulting invoice calculation to display the result rounded to nearest whole number?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Kamal Khakhkhar 1,341 on at

Like (4)

Report

Hii There,

as per Its Based On Setup You can update the General Ledger Setup> Inv. Rounding Precision as per your requirement It will add the system generated amount to add it to nearest .

If You found answer Mark it answered.

Thank You.

Kamal Khakhkhar

Was this reply helpful? Yes No
Suggested answer

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

Like (2)

Report

May this can help : https://learn.microsoft.com/en-us/dynamics365/business-central/finance-set-up-invoice-rounding

https://github.com/MicrosoftDocs/dynamics365smb-docs/blob/main/business-central/finance-set-up-invoice-rounding.md

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,202 Super User 2025 Season 2 on at

Like (3)

Report

As mentioned you could set up the rounding from the general ledger setup, and all invoices will be rounded to whole numbers.

For reference

https://learn.microsoft.com/en-ca/dynamics365/business-central/finance-set-up-invoice-rounding

Was this reply helpful? Yes No
Suggested answer

Jeffrey Bulanadi 8,760 on at

Like (3)

Report
Hi,

Yes, it’s possible to round invoice totals to the nearest whole number after applying discounts, but it depends on how your invoice rounding is configured in BC.

Let’s break it down:

1. How invoice rounding works
BC supports automatic invoice rounding, which adds a system-generated line to adjust the total amount. This is useful when discounts result in fractional totals.

The rounding amount is posted along with other invoice lines

You can round to any precision (e.g., 0.01, 0.05, 1.00) depending on your setup

Rounding applies to both sales and purchase invoices

2. Where to configure rounding precision
To round to the nearest whole number, update the following fields:

Go to General Ledger Setup

Set Inv. Rounding Precision to 1.00

Set Inv. Rounding Type to Nearest

Then go to Sales & Receivables Setup or Purchases & Payables Setup

Enable the Invoice Rounding checkbox

This ensures that after discounts are applied, the final invoice amount is rounded to the nearest whole number.

3. Optional: Rounding for foreign currencies
If you issue invoices in other currencies:

Go to Currencies

Set Invoice Rounding Precision and Invoice Rounding Type on the Currency Card

This allows you to control rounding behavior per currency.

Helpful references:

Set up invoice rounding – Microsoft Learn
Why BC Posts Rounding Entries – Valentin Castravet
Amount Rounding Precision in BC – BC Insight

If you find this helpful, feel free to mark this as the suggested or verified answer.

Cheers
Jeffrey

Was this reply helpful? Yes No
Suggested answer

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

Like (2)

Report

Hope the following helps.

For local currency:

For other currencies:

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Mansi Soni 8,911 Super User 2025 Season 2 on at

Like (4)

Report

Hello @PD-11070952-0,

You will be able to configure it by setting up Invoice Rounding Type field value to Nearest on General Ledger Setup and Currency Card.

Hope this answer will help you as well!

Regards,
Mansi Soni

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,150 Super User 2025 Season 2 on at

Like (2)

Report

Yes, you can control rounding of invoice amounts using the Invoice Rounding Type field in the General Ledger Setup.

Go to:

Search > General Ledger Setup > Under the Rounding section, set the Invoice Rounding Type to Nearest and define the Invoice Rounding Precision (e.g., 1 for whole numbers).

This will round the total invoice amount after discounts to the nearest whole number.

Mark this as the verified answer if helpful. ✅

Was this reply helpful? Yes No