Purchase Docs - How to stop discounts from being calculated if line amount excluded vat is updated

(2) Share

Report

Posted on by AleAlonso

313

Hello all,

When adding an item to a purchase document, the Direct Unit Cost (DUC) will be automatically populated with the Item's Last Unit Cost, and once a qty is added, the Line Amount Excl. VAT will be calculated. See example below:

Now, if a user instead of updating the DUC, updates the Line Amount Excl. VAT, a discount will be automatically calculated, see screenshot below. How can I stop this? The Item has already been marked as not "allow discount invoice" and the Calc. Inv. Discount setting is off in the Purchases & Payables Setup.

Thanks

Alejandra

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Verified answer

Bilal Haider 485 on at

Like (3)

Report
Copy link

Link copied!

Hi,

To achieve this you need to subscribe to the event and set ishandled to true. Then it will not calculate discount amount and %.

OnValidateLineAmountBeforeValidateLineDiscountAmount(Rec, Currency, IsHandled);

Was this reply helpful? Yes No
Verified answer

YUN ZHU 101,995 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Unfortunately, as far as I know, only customization can do this.

PS: Missing a feature? Post or vote for ideas on: aka.ms/BCIdeas

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,800 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Can you clarify why you would want to do that? If the line amount is lower than the unit cost (adjusted to the quantity on the line), the system assumes you have a discount, which makes sense mathematically. Why and how do you want the line amount to be lower than the unit cost without applying a discount?

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
AleAlonso 313 on at

Like (0)

Report
Copy link

Link copied!

Hi Valentin

Business will never have discounts, users should be updating the DUC, not the Line Amount Excl VAT. This is why I wanted to see if there is a way to stop discounts from being calculated :)

Thanks

Alejandra

Was this reply helpful? Yes No
Suggested answer

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

Like (3)

Report
Copy link

Link copied!

I think it will require customization.

Was this reply helpful? Yes No