Report 902 Assembly Order
- App
- Base Application
- Namespace
- Microsoft.Assembly.Document
- Versions
- 17-28
Versions171819202122232425262728
Source29
Source in 29
src/Layers/W1/BaseApp/Assembly/Document/AssemblyOrder.Report.al167 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------
// Copyright (c) Microsoft Corporation. All rights reserved.
// Licensed under the MIT License. See License.txt in the project root for license information.
// ------------------------------------------------------------------------------------------------
namespace Microsoft.Assembly.Document;
report 902 "Assembly Order"
{
Caption = 'Assembly Order';
WordMergeDataItem = "Assembly Header";
DefaultRenderingLayout = RDLCLayout;
dataset
{
dataitem("Assembly Header"; "Assembly Header")
{
DataItemTableView = sorting("Document Type", "No.");
RequestFilterFields = "No.", "Item No.", "Due Date";
column(No_AssemblyHeader; "No.")
{
}
column(ItemNo_AssemblyHeader; "Item No.")
{
IncludeCaption = true;
}
column(Description_AssemblyHeader; Description)
{
IncludeCaption = true;
}
column(Quantity_AssemblyHeader; Quantity)
{
IncludeCaption = true;
}
column(QuantityToAssemble_AssemblyHeader; "Quantity to Assemble")
{
IncludeCaption = true;
}
column(UnitOfMeasureCode_AssemblyHeader; "Unit of Measure Code")
{
}
column(DueDate_AssemblyHeader; Format("Due Date"))
{
}
column(StartingDate_AssemblyHeader; Format("Starting Date"))
{
}
column(EndingDate_AssemblyHeader; Format("Ending Date"))
{
}
column(LocationCode_AssemblyHeader; "Location Code")
{
IncludeCaption = true;
}
column(BinCode_AssemblyHeader; "Bin Code")
{
IncludeCaption = true;
}
column(SalesDocNo; SalesDocNo)
{
}
column(COMPANYNAME; COMPANYPROPERTY.DisplayName())
{
}
dataitem("Assembly Line"; "Assembly Line")
{
DataItemLink = "Document Type" = field("Document Type"), "Document No." = field("No.");
DataItemTableView = sorting("Document Type", "Document No.", "Line No.");
column(Type_AssemblyLine; Type)
{
IncludeCaption = true;
}
column(No_AssemblyLine; "No.")
{
IncludeCaption = true;
}
column(Description_AssemblyLine; Description)
{
IncludeCaption = true;
}
column(VariantCode_AssemblyLine; "Variant Code")
{
}
column(DueDate_AssemblyLine; Format("Due Date"))
{
}
column(QuantityPer_AssemblyLine; "Quantity per")
{
IncludeCaption = true;
}
column(Quantity_AssemblyLine; Quantity)
{
IncludeCaption = true;
}
column(UnitOfMeasureCode_AssemblyLine; "Unit of Measure Code")
{
}
column(LocationCode_AssemblyLine; "Location Code")
{
IncludeCaption = true;
}
column(BinCode_AssemblyLine; "Bin Code")
{
IncludeCaption = true;
}
column(QuantityToConsume_AssemblyLine; "Quantity to Consume")
{
IncludeCaption = true;
}
}
trigger OnAfterGetRecord()
var
ATOLink: Record "Assemble-to-Order Link";
begin
Clear(SalesDocNo);
if ATOLink.Get("Document Type", "No.") then
SalesDocNo := ATOLink."Document No.";
end;
}
}
requestpage
{
layout
{
}
actions
{
}
}
rendering
{
layout(RDLCLayout)
{
Type = RDLC;
LayoutFile = './Assembly/Document/AssemblyOrder.rdlc';
Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';
}
}
labels
{
AssemblyOrderHeading = 'Assembly Order';
AssemblyItemHeading = 'Assembly Item';
BillOfMaterialHeading = 'Bill of Material';
PageCaption = 'Page';
OfCaption = 'of';
OrderNoCaption = 'Order No.';
QuantityAssembledCaption = 'Quantity Assembled';
QuantityPickedCaption = 'Quantity Picked';
QuantityConsumedCaption = 'Quantity Consumed';
AssembleToOrderNoCaption = 'Asm. to Order No.';
UnitOfMeasureCaption = 'Unit of Measure';
VariantCaption = 'Variant';
DueDateCaption = 'Due Date';
StartingDateCaption = 'Starting Date';
EndingDateCaption = 'Ending Date';
}
var
SalesDocNo: Code[20];
}