Report 718 Inventory - Sales Back Orders
src/Layers/W1/BaseApp/Inventory/Reports/InventorySalesBackOrders.Report.al333 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.Inventory.Reports;using Microsoft.Inventory.Item;using Microsoft.Sales.Customer;using Microsoft.Sales.Document;using System.Utilities;report 718 "Inventory - Sales Back Orders"{ AdditionalSearchTerms = 'delayed order,unfulfilled demand'; ApplicationArea = Basic, Suite; Caption = 'Inventory - Sales Back Orders'; ToolTip = 'View a list with the order lines whose shipment date has been exceeded. The following information is shown for the individual orders for each item: number, customer name, customer''s telephone number, shipment date, order quantity and quantity on back order. The report also shows whether there are other items for the customer on back order.'; UsageCategory = ReportsAndAnalysis; DefaultRenderingLayout = Excel; dataset { dataitem(Item; Item) { PrintOnlyIfDetail = true; RequestFilterFields = "No.", "Search Description", "Assembly BOM", "Inventory Posting Group", "Statistics Group", "Bin Filter";#if not CLEAN27 column(CompanyName; COMPANYPROPERTY.DisplayName()) { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '27.0'; } column(ItemTableCaptItemFilter; TableCaption + ': ' + ItemFilter) { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '27.0'; } column(StrSubStNoSalesLineFltr; StrSubstNo(Text000, SalesLineFilter)) { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '27.0'; }#endif column(ItemFilter; ItemFilter) { } column(ItemFilterTxt; ItemFilterTxt) { } column(SalesLineFilter; SalesLineFilter) { } column(SalesLineFilterTxt; SalesLineFilterTxt) { } column(No_Item; "No.") { IncludeCaption = true; } column(Description_Item; Description) { IncludeCaption = true; }#if not CLEAN27 column(VariantFilter_Item; "Variant Filter") { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '27.0'; } column(LocationFilter_Item; "Location Filter") { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '27.0'; } column(BinFilter_Item; "Bin Filter") { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '27.0'; } column(GlobalDim1Filter_Item; "Global Dimension 1 Filter") { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '27.0'; } column(GlobalDim2Filter_Item; "Global Dimension 2 Filter") { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '27.0'; } column(InvSalesBackOrdersCaption; InvSalesBackOrdersCaptionLbl) { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '27.0'; } column(CurrReportPageNoCaption; CurrReportPageNoCaptionLbl) { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '27.0'; } column(CustNameCaption; CustNameCaptionLbl) { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '27.0'; } column(CustPhoneNoCaption; CustPhoneNoCaptionLbl) { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '27.0'; } column(SalesLineShipDateCaption; SalesLineShipDateCaptionLbl) { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '27.0'; } column(OtherBackOrdersCaption; OtherBackOrdersCaptionLbl) { ObsoleteState = Pending; ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.'; ObsoleteTag = '27.0'; }#endif dataitem("Sales Line"; "Sales Line") { DataItemLink = "No." = field("No."), "Variant Code" = field("Variant Filter"), "Location Code" = field("Location Filter"), "Bin Code" = field("Bin Filter"), "Shortcut Dimension 1 Code" = field("Global Dimension 1 Filter"), "Shortcut Dimension 2 Code" = field("Global Dimension 2 Filter"); DataItemTableView = sorting("Document Type", Type, "No.", "Variant Code", "Drop Shipment", "Location Code", "Shipment Date") where(Type = const(Item), "Document Type" = const(Order), "Outstanding Quantity" = filter(<> 0)); RequestFilterFields = "Shipment Date"; RequestFilterHeading = 'Sales Order Line'; column(DocumentNo_SalesLine; "Document No.") { IncludeCaption = true; } column(CustName_SalesLine; Cust.Name) { IncludeCaption = true; } column(CustPhoneNo_SalesLine; Cust."Phone No.") { IncludeCaption = true; } column(ShipmentDate_SalesLine; Format("Shipment Date")) { } column(Quantity_SalesLine; Quantity) { IncludeCaption = true; } column(OutstandingQty_SalesLine; "Outstanding Quantity") { IncludeCaption = true; } column(OtherBackOrders_SalesLine; OtherBackOrdersText) { } trigger OnAfterGetRecord() begin if "Shipment Date" >= WorkDate() then CurrReport.Skip(); Cust.Get("Bill-to Customer No."); SalesOrderLine.SetRange("Bill-to Customer No.", Cust."No."); SalesOrderLine.SetFilter("No.", '<>' + Item."No."); OtherBackOrdersText := SalesOrderLine.FindFirst() ? 'Yes' : 'No'; SubtotalsOutstandingQty += "Sales Line"."Outstanding Quantity"; end; trigger OnPreDataItem() begin SalesOrderLine.SetCurrentKey("Document Type", "Bill-to Customer No."); SalesOrderLine.SetRange("Document Type", SalesOrderLine."Document Type"::Order); SalesOrderLine.SetRange(Type, SalesOrderLine.Type::Item); SalesOrderLine.SetRange("Shipment Date", 0D, WorkDate() - 1); SalesOrderLine.SetFilter("Outstanding Quantity", '<>0'); end; } dataitem(SubTotals; Integer) { DataItemTableView = sorting(Number) where(Number = const(1)); column(SubTotals_Outstanding_Qty; SubtotalsOutstandingQty) { DecimalPlaces = 0 : 5; } trigger OnPreDataItem() begin "Sales Line".SetFilter("Shipment Date", '<%1', WorkDate()); if "Sales Line".IsEmpty() then CurrReport.Break() end; } trigger OnAfterGetRecord() begin SubtotalsOutstandingQty := 0; end; } } requestpage { AboutTitle = 'About Inventory - Sales Back Orders'; AboutText = 'See an overview of sales orders that can''''t be fulfilled due to out-of-stock items. This report highlights sales lines that are overdue to be shipped and includes information on the document & customer the order is linked to.'; layout { area(content) { group(Options) { Visible = false; Caption = 'Options'; field(ShipmentDateFilter; ShipmentDateFilter) { ApplicationArea = Basic, Suite; Caption = 'Shipment Date Filter'; } } } } actions { } trigger OnQueryClosePage(CloseAction: Action): Boolean begin ShipmentDateFilter := "Sales Line".GetFilter("Shipment Date"); end; } rendering { layout(Excel) { Caption = 'Inventory - Sales Back Orders Excel'; LayoutFile = '.\Inventory\Reports\InventorySalesBackOrders.xlsx'; Type = Excel; Summary = 'Built in layout for the Inventory - Sales Back Orders report.'; } layout(Word) { Caption = 'Inventory - Sales Back Orders Word'; LayoutFile = '.\Inventory\Reports\InventorySalesBackOrders.docx'; Type = Word; Summary = 'Built in layout for the Inventory - Sales Back Orders word report.'; }#if not CLEAN27 layout(RDLC) { Caption = 'Inventory - Sales Back Orders RDLC'; Type = RDLC; LayoutFile = '.\Inventory\Reports\InventorySalesBackOrders.rdlc'; ObsoleteState = Pending; ObsoleteReason = 'The RDLC layout has been replaced by the Excel and Word layouts and will be removed in a future release.'; ObsoleteTag = '27.0'; Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.'; }#endif } labels { DataRetrieved = 'Data retrieved:'; InventorySalesBackOrders = 'Inventory - Sales Back Orders'; InventorySalesBackOrdersPrint = 'Inv. - S. Back Orders (Print)', MaxLength = 31, Comment = 'Excel worksheet name.'; InvSalesBackOrdersAnalysis = 'Inv. - S. Back Order (Analysis)', MaxLength = 31, Comment = 'Excel worksheet name.'; // About the report labels AboutTheReportLabel = 'About the report', MaxLength = 31, Comment = 'Excel worksheet name.'; EnvironmentLabel = 'Environment'; CompanyLabel = 'Company'; UserLabel = 'User'; RunOnLabel = 'Run on'; ReportNameLabel = 'Report name'; DocumentationLabel = 'Documentation'; ShipmentDateLabel = 'Shipment Date'; OtherBackOrdersLabel = 'Other Back Orders'; // Word layout field captions. To be replaced with the IncludeCaption property in a future release along with RDLC layout removal. ItemNoCaptionLbl = 'Item No.'; } trigger OnPreReport() begin ItemFilter := Item.GetFilters(); SalesLineFilter := "Sales Line".GetFilters(); if ItemFilter <> '' then ItemFilterTxt := Item.TableCaption + ': ' + ItemFilter; if SalesLineFilter <> '' then SalesLineFilterTxt := StrSubstNo(Text000, SalesLineFilter); end; var Cust: Record Customer; SalesOrderLine: Record "Sales Line"; OtherBackOrdersText: Text; ItemFilter: Text; ItemFilterTxt: Text; SalesLineFilter: Text; SalesLineFilterTxt: Text; ShipmentDateFilter: Text; SubtotalsOutstandingQty: Decimal;#pragma warning disable AA0074#pragma warning disable AA0470 Text000: Label 'Sales Order Line: %1';#pragma warning restore AA0470#pragma warning restore AA0074#if not CLEAN27 [Obsolete('RDLC Only layout field caption. To be removed along with the RDLC layout', '27.0')] InvSalesBackOrdersCaptionLbl: Label 'Inventory - Sales Back Orders'; [Obsolete('RDLC Only layout field caption. To be removed along with the RDLC layout', '27.0')] CurrReportPageNoCaptionLbl: Label 'Page'; [Obsolete('RDLC Only layout field caption. To be removed along with the RDLC layout', '27.0')] CustNameCaptionLbl: Label 'Customer'; [Obsolete('RDLC Only layout field caption. To be removed along with the RDLC layout', '27.0')] CustPhoneNoCaptionLbl: Label 'Phone No.'; [Obsolete('RDLC Only layout field caption. To be removed along with the RDLC layout', '27.0')] SalesLineShipDateCaptionLbl: Label 'Shipment Date'; [Obsolete('RDLC Only layout field caption. To be removed along with the RDLC layout', '27.0')] OtherBackOrdersCaptionLbl: Label 'Other Back Orders';#endif}