report 50100 "Jons item export"
{
ApplicationArea = All;
Caption = 'Jons item export';
UsageCategory = ReportsAndAnalysis;
DefaultRenderingLayout = Jonsitemexport;
dataset
{
dataitem(Item; Item)
{
column(Description; Description) { }
column(ItemCategoryCode; "Item Category Code") { }
column(K3PFBrandCode; "K3PFBrand Code") { }
column(K3PFCollectionCode; "K3PFCollection Code") { }
column(K3PFGenderCode; "K3PFGender Code") { }
column(K3PFSeasonCode; "K3PFSeason Code") { }
column(K3PFSizeRangeCode; "K3PFSize Range Code") { }
column(LastDirectCost; "Last Direct Cost") { }
column(No; "No.") { }
column(colordescription; colordescription) { }
column(vendoritemref; vendoritemref) { }
column(variantcode; variantcode) { }
trigger OnAfterGetRecord();
var
K3Color: Record "K3PF Color";
ItemVariant: Record "Item Variant";
ItemRef: Record Microsoft.Inventory.Item.Catalog."Item Reference";
begin
colordescription := K3color.Description;
variantcode := ItemVariant.Code;
vendoritemref := ItemRef."Reference No.";
end;
}
}
requestpage
{
layout
{
area(Content)
{
group(GroupName)
{
}
}
}
actions
{
area(Processing)
{
}
}
}
rendering
{
Layout(Jonsitemexport)
{
type = Excel;
LayoutFile = 'Jonsitemexport.xlsx';
}
}
var
colordescription: Text[50];
vendoritemref: Text[50];
variantcode: Text[50];
}
