web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / How to get the item pr...
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

How to get the item price list display the unit price based on the customer discount group?

(1) ShareShare
ReportReport
Posted on by LLEV 73
I'm trying to customize the /./Pricing/ItemPriceList.rdlc/ report so that it displays the /unit price/ AND the /unit price discounted/ column that would represent the /unit price/ minus the discount given by the /Customer Discount Group/ value.
Here are my options:
 
If my item with a unit price of 100 belongs to the Item Disc. Group: /DISCOUNT4/, I would like to display in my /unit price discounted/ column the value 68 (=100-32%).
Any help would be greatly appreciated.
 
I have the same question (0)
  • Verified answer
    LLEV Profile Picture
    LLEV 73 on at
    I actually was able to make this work by creating a record of a "Price List Line" and creating a new column based on it.
    Here is my code:
    reportextension 50107 ReportItemListExtension extends "Item Price List"
{
    RDLCLayout = 'StandardItemPriceList-extended.rdlc';

    dataset
    {
        add(Item)
        {
            column(SearchDesc_Lbl; SearchDesc_Lbl) { }
            column(Search_Description; "Search Description") { }
            column(Description2_Item; "Description 2") { }
            column(IdentifierCode_Item; "Identifier Code") { }
            column(ItemCategoryCode_Lbl; ItemCategoryCode_Lbl) { }
            column(ItemCategoryCode_Item; "Item Category Code") { }
            column(ItemDiscGroup_Item; "Item Disc. Group") { }
            column(PriceIncludesVAT_Item; "Price Includes VAT") { }
            column(StandardCost_Item; "Standard Cost") { }
            column(UnitListPrice_Item; "Unit List Price") { }
            column(DecGPrixUnitaireNet_Lbl; DecGPrixUnitaireNet_Lbl) { }
            column(DecGPrixUnitaireNetHT_Item; DecGPrixUnitaireNetHT) { }
            column(DecGPrixUnitaireNetHT_Txt_Item; DecGPrixUnitaireNetHT_Txt) { }
        }
        modify(Item)
        {
            trigger OnAfterAfterGetRecord()
            begin
                if not ItemRec.get(Item."No.") then
                    Clear(ItemRec);

                // Calculate the PU with discount
                if (ItemRec."Unit Price" > 0) then begin
                    Clear(PriceListLineRec);
                    if (PriceSource."Source No." <> '') then begin
                        PriceListLineRec.SetFilter("Source No.", PriceSource."Source No.");
                    end;
                    if (ItemRec."Item Disc. Group" <> '') then begin
                        PriceListLineRec.SetFilter("Asset No.", ItemRec."Item Disc. Group");
                    end;
                    if (PriceListLineRec.FindSet() and (PriceListLineRec."Line Discount %" <> 0)) then begin
                        DecGPrixUnitaireNetHT := Round(ItemRec."Unit Price" * (100 - PriceListLineRec."Line Discount %") / 100, 0.01);
                    end
                    else
                        DecGPrixUnitaireNetHT := Round(ItemRec."Unit Price", 0.01);
                end
                else
                    DecGPrixUnitaireNetHT := 0.00;
                DecGPrixUnitaireNetHT_Txt := Format(DecGPrixUnitaireNetHT, 0, '<Precision,2:3><Standard Format,0>');
            end;
        }
    }

    trigger OnPreReport()
    var
    begin
        IntGBlocCounter := 0;
    end;

    var
        IntGBlocCounter : Integer;
        ItemCategoryCode_Lbl: Label 'Category', Comment = 'Foo', MaxLength = 999, Locked = false;
        SearchDesc_Lbl: Label 'Search Description', Comment = 'Foo', MaxLength = 999, Locked = false;
        DecGPrixUnitaireNet_Lbl: Label 'Discounted Unit Price', Comment = 'Foo', MaxLength = 999, Locked = false;
        DecGPrixUnitaireNetHT: Decimal;
        DecGPrixUnitaireNetHT_Txt: Text[30];
        ItemRec: Record "Item";
        PriceListLineRec: Record "Price List Line";
}
     
     
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
11manish Profile Picture

11manish 107

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 53 Super User 2026 Season 1

#3
sannavajjala87 Profile Picture

sannavajjala87 29

Last 30 days Overall leaderboard

Featured topics

Welcome to the Microsoft Dynamics 365 forum!
Identifying an Org as CDS or Dynamics
Get batch job history log from D365 FO to Power Automate
Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans