Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
Ok, this time i want to talk about some “special” thing that almost all customer asks for in Business Central and I don’t understand why Microsoft doesn’t supply by standard, the Vendor, Item Price, leadtime comparison view.
In the Item Card we have the Item Vendor relation with a table of the vendors which can sell the item and the lead time.
Also, we have the Purchase Price table by Vendor/item with the required info about price and unit of measure.
So, why Microsoft doesn’t give a page, a simple pagepart with this information? IDK.
The first thing that comes to my mind is create a pagepart from item vendor information and merge that with the purchase price table linked with the Item No in the selected page, easy don’t you think?
But remember, sales price and purchase price with the related discount tables are marked for removal from the application this year.
So, let’s start with the app definition.
First, we need to define if we start with the Item Vendor table or the price table, let´s check the new table and definitions.
The new price functionality has 2 principal tables called Price List Header and Price List Line, also we have in the Purchase and Payables setup new fields
So, is important to know which is the active price list.
The new purchase price list has the next presentation
If you can see, we can define a vendor, campaign, or even contact (applies to type field). The important thing here is the lines and the fields
Meanwhile, the item vendor table has only:
So, I decided to start with the price list lines.
First we need to create a new pagepart based on the Price List Line adding some fields and 2 triggers
/// Page ItemVendorComp (ID XXXXX).
page XXXXX ItemVendorComp
Caption = 'ItemVendorComp';
PageType = ListPart;
SourceTable = "Price List Line";
field("Source No."; Rec."Source No.")
ToolTip = 'Specifies the value of the Applies-to No. field';
ApplicationArea = All;
field("Asset No."; Rec."Asset No.")
ToolTip = 'Specifies the value of the Product No. field';
field("Unit of Measure Code"; Rec."Unit of Measure Code")
ToolTip = 'Specifies the value of the Unit of Measure Code field';
field("Direct Unit Cost"; Rec."Direct Unit Cost")
ToolTip = 'Specifies the value of the Direct Unit Cost field';
ItmVendor: Record "Item Vendor";
PurchPay: Record "Purchases & Payables Setup";
ActiveList := PurchPay."Default Price List Code";
Rec.SetRange("Price List Code",ActiveList);
ItmVendor.SetRange("Item No.", Rec."Asset No.");
ItmVendor.SetRange("Vendor No.", Rec."Source No.");
ItmVendor.SetRange("Variant Code", Rec."Variant Code");
if ItmVendor.FindSet() then
LeadTimCalc := ItmVendor."Lead Time Calculation";
Then we can add the page part to other pages
/// PageExtension ItemVendorComparPart (ID XXXXX) extends Record Item List.
pageextension 67165 ItemVendorComparPart extends "Item List"
Caption = 'Item Vendor Comparison';
ApplicationArea = All;
SubPageLink = "Asset No." = field("No.");
/// PageExtension ItemVendComparItemCard (ID XXXXX)extends Record Item Card.
pageextension XXXXX ItemVendComparItemCard extends "Item Card"
/// PageExtension ItemVendComparReqWkst (ID XXXXX) extends Record Req. Worksheet.
pageextension XXXXX ItemVendComparReqWkst extends "Req. Worksheet"
Finally we can check the results
Business Applications communities