Small and medium business | Business Central, N...

Flow field on Purchase Line Table

(1) Share

Report

Posted on by CU09081641-3

Hi,

I have the following code to extend the item page to display the last purchased date, it works fine:

My question is what is the easiest way for this field to also be available to the 'Purchased Line (39)' Table so I can display it on the Purchase Order Subform (54, ListPart) when creating a purchase order without having to go to the item page...

tableextension 53023 "Item Extension last purchased" extends Item
{
fields
{
field(53023; "Last Purchase Date"; Date)
{
Caption = 'Last Purchase Date';
FieldClass = FlowField;
CalcFormula = Max("Item Ledger Entry"."Posting Date" WHERE ("Item No." = FIELD("No."),
"Entry Type" = FILTER(Purchase),
Quantity = FILTER(>0)));
}
}
}

pageextension 53023 "Item Card Extension Purchased" extends "Item Card"
{
layout
{
addlast(Item)
{
field("Last Purchase Date"; Rec."Last Purchase Date")
{
ApplicationArea = All;
Caption = 'Last Purchase Date';
}
}
}
}

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 74,115 Super User 2024 Season 2 on at

Like (1)

Report

Flow field on Purchase Line Table

Hi, hope the following helps.

Dynamics 365 Business Central: FlowFields (Sum, Average, Exist, Count, Min, Max, Lookup)

https://yzhums.com/5802/

Dynamics 365 Business Central: A flow field is part of the query column list, this is not supported (Flowfield based on Flowfield)

https://yzhums.com/11400/

Thanks.

ZHU
Suggested answer

Ramesh Kumar 233 on at

Like (0)

Report

Flow field on Purchase Line Table

You can use flowfields and extend the table with tools like Simple Object Designer, requiring minimal coding
Suggested answer

Yi Yong 1,470 Super User 2024 Season 2 on at

Like (3)

Report
Flow field on Purchase Line Table

Hello,

You can use FlowField with Lookup.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-calcformula-property

tableextension 50000 Table1 extends "Purchase Line" { fields { field(50000; "Lookup Field"; Decimal) { FieldClass = FlowField; CalcFormula = lookup(Item."Last Direct Cost" where("No." = field("No."))); } } }