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

(2) Share

Report

Posted on by AleAlonso

305

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)

Verified answer

Bilal Haider 412 on at

Like (3)

Report

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 95,331 Super User 2025 Season 2 on at

Like (2)

Report

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 31,340 Super User 2025 Season 2 on at

Like (0)

Report

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 305 on at

Like (0)

Report

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. 20,275 Super User 2025 Season 2 on at

Like (3)

Report

I think it will require customization.

Was this reply helpful? Yes No