Hello My Community Family, Am developing a report which will show item variant by location from Item ledger Entry. I have added the Available quantity column to filter the 'OPEN' quantity. My problem is I want to sum the Quantity of similar items instead of generating multiple lines of the same item.
this is my code side
dataset
{
dataitem("Item Ledger Entry"; "Item Ledger Entry")
{
RequestFilterFields = "Item No.", "Variant Code";
DataItemTableView = where("Open" = filter(true), "Remaining Quantity" = filter(>= 0));
column(Remaining_Quantity; "Remaining Quantity") { }
column(Location_Code; "Location Code") { }
dataitem("Item Variant"; "Item Variant")
{
DataItemLink = "Item No." = field("Item No."), Code = field("Variant Code");
column(Code; Code) { }
column(Description; Description) { }
}
trigger OnAfterGetRecord()
begin
// if "Location Code" = '' then
// CurrReport.Skip();
// Loc.get("Location Code");
if "Variant Code" = '' then
CurrReport.Skip();
end;
}
this is my output as we can see the same code but generating two-line instead of one line with a total of 150
thank you guys for your assistance
