Help with Custom Layout

(0) Share

Report

Posted on by Tu-Vuong Le

How do you add discounted unit price for a sales quote in custom report layout. For example, my current table consists of
Quantity | MSRP | Discounted Price | Discount % | Total Price

4 | 3000 | | -25% | 9000

I cannot find the field with the discounted price of the item. Is there a way to add it on a sales quote?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (2)

Answers (1)

Tu-Vuong Le 10 on at

Like (0)

Report

EDIT: I am creating the reports with Word

Was this reply helpful? Yes No
Verified answer

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

Like (0)

Report
Hi, This requires a little customization.

You can use report extension to add a new colum.

For example: report 1304 "Standard Sales - Quote"

Sample Sales quote:

Report Extension

Word layout

Report:

reportextension 50102 MyExtension2 extends "Standard Sales - Quote" { dataset { add(Line) { column(DiscountedPrice; DiscountedPrice) { } } modify(Line) { trigger OnAfterAfterGetRecord() begin DiscountedPrice := "Unit Price" * (100 - "Line Discount %") / 100; end; } } var DiscountedPrice: Decimal; }

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No