Report 107 Customer - Order Summary

Base Application, Microsoft.Sales.Reports

src/Layers/W1/BaseApp/Sales/Reports/CustomerOrderSummary.Report.al683 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.Sales.Reports;/// <summary>/// Generates a summary of outstanding sales orders by customer showing order amounts grouped by expected shipment period./// </summary>using Microsoft.Finance.Currency;using Microsoft.Sales.Customer;using Microsoft.Sales.Document;using Microsoft.Utilities;using System.Utilities;report 107 "Customer - Order Summary"{    ApplicationArea = Basic, Suite;    Caption = 'Customer - Order Summary';    ToolTip = 'View the order detail (the quantity not yet shipped) for each customer in three periods of 30 days each, starting from a selected date. There are also columns with orders to be shipped before and after the three periods and a column with the total order detail for each customer. The report can be used to analyze a company''s expected sales volume.';    PreviewMode = PrintLayout;    UsageCategory = ReportsAndAnalysis;    DefaultRenderingLayout = Excel;    dataset    {        dataitem(Customer; Customer)        {            DataItemTableView = sorting("No.");            PrintOnlyIfDetail = true;            RequestFilterFields = "No.", "Search Name", "Customer Posting Group", "Currency 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';            }#endif            column(PrintAmountsInLCY; PrintAmountsInLCY)            {            }            column(CustFilter; CustFilterTxt)            {            }            column(CustFilter1; CustFilter)            {            }            column(PeriodStartDate1; Format(PeriodStartDate[1]))            {            }            column(PeriodStartDate2; Format(PeriodStartDate[2]))            {            }            column(PeriodStartDate3; Format(PeriodStartDate[3]))            {            }            column(PeriodStartDate21; Format(PeriodStartDate[2] - 1))            {            }            column(PeriodStartDate31; Format(PeriodStartDate[3] - 1))            {            }            column(PeriodStartDate41; Format(PeriodStartDate[4] - 1))            {            }            column(SalesAmtOnOrderLCY1; SalesAmtOnOrderLCY[1])            {                AutoFormatType = 1;            }            column(SalesAmtOnOrderLCY2; SalesAmtOnOrderLCY[2])            {                AutoFormatType = 1;            }            column(SalesAmtOnOrderLCY3; SalesAmtOnOrderLCY[3])            {                AutoFormatType = 1;            }            column(SalesAmtOnOrderLCY4; SalesAmtOnOrderLCY[4])            {                AutoFormatType = 1;            }            column(SalesAmtOnOrderLCY5; SalesAmtOnOrderLCY[5])            {                AutoFormatType = 1;            }            column(SalesOrderAmountLCY; SalesOrderAmountLCY)            {                AutoFormatType = 1;            }            column(No_Cust; "No.")            {            }            column(AllAmountsAreInLCYTxt; AllAmountsAreInLCYTxt)            {            }            column(TotalCaption; TotalCaptionLbl)            {            }#if not CLEAN27            column(CustomerOrderSummaryCaption; CustomerOrderSummaryCaptionLbl)            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '27.0';            }            column(PageNoCaption; PageNoCaptionLbl)            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '27.0';            }            column(AllamountsareinLCYCaption; AllamountsareinLCYCaptionLbl)            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '27.0';            }            column(OutstandingOrdersCaption; OutstandingOrdersCaptionLbl)            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '27.0';            }            column(CustomerNoCaption; CustomerNoCaptionLbl)            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '27.0';            }            column(CustomerNameCaption; CustomerNameCap)            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '27.0';            }            column(BeforeCaption; BeforeCaptionLbl)            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '27.0';            }            column(AfterCaption; AfterCaptionLbl)            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '27.0';            }            column(TotalLCYCaption; TotalLCYCaptionLbl)            {                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 = "Bill-to Customer No." = field("No."), "Shortcut Dimension 1 Code" = field("Global Dimension 1 Filter"), "Shortcut Dimension 2 Code" = field("Global Dimension 2 Filter"), "Currency Code" = field("Currency Filter");                DataItemTableView = sorting("Document Type", "Bill-to Customer No.", "Currency Code") where("Document Type" = const(Order), "Outstanding Quantity" = filter(<> 0));                column(SalesOrderAmount; SalesOrderAmount)                {                    AutoFormatExpression = "Currency Code";                    AutoFormatType = 1;                }                column(SalesAmtOnOrder5; SalesAmtOnOrder[5])                {                    AutoFormatExpression = "Currency Code";                    AutoFormatType = 1;                }                column(SalesAmtOnOrder4; SalesAmtOnOrder[4])                {                    AutoFormatExpression = "Currency Code";                    AutoFormatType = 1;                }                column(SalesAmtOnOrder3; SalesAmtOnOrder[3])                {                    AutoFormatExpression = "Currency Code";                    AutoFormatType = 1;                }                column(SalesAmtOnOrder2; SalesAmtOnOrder[2])                {                    AutoFormatExpression = "Currency Code";                    AutoFormatType = 1;                }                column(SalesAmtOnOrder1; SalesAmtOnOrder[1])                {                    AutoFormatExpression = "Currency Code";                    AutoFormatType = 1;                }                column(CurrencyCode_SalesLine; "Currency Code")                {                    IncludeCaption = true;                }                column(Name_Cust; Customer.Name)                {                    IncludeCaption = true;                }                column(SalesLineBilltoNo_Customer; "Bill-to Customer No.")                {                    IncludeCaption = true;                }                column(GroupNumber; GroupNumber)                {                }                trigger OnAfterGetRecord()                begin                    PeriodNo := 1;                    while "Shipment Date" >= PeriodStartDate[PeriodNo] do                        PeriodNo := PeriodNo + 1;                    Currency.InitRoundingPrecision();                    if "VAT Calculation Type" in ["VAT Calculation Type"::"Normal VAT", "VAT Calculation Type"::"Reverse Charge VAT"] then                        SalesOrderAmount :=                          Round(                            (Amount + "VAT Base Amount" * "VAT %" / 100) * "Outstanding Quantity" / Quantity / (1 + "VAT %" / 100),                            Currency."Amount Rounding Precision")                    else                        SalesOrderAmount :=                          Round(                            "Outstanding Amount" / (1 + "VAT %" / 100),                            Currency."Amount Rounding Precision");                    SalesOrderAmountLCY := SalesOrderAmount;                    for i := 1 to ArrayLen(SalesAmtOnOrder) do begin                        SalesAmtOnOrder[i] := 0;                        SalesAmtOnOrderLCY[i] := 0;                    end;                    if "Currency Code" <> '' then begin                        SalesHeader.Get(1, "Document No.");                        if SalesHeader."Currency Factor" <> 0 then                            SalesOrderAmountLCY :=                              Round(                                CurrExchRate.ExchangeAmtFCYToLCY(                                  WorkDate(), SalesHeader."Currency Code",                                  SalesOrderAmount, SalesHeader."Currency Factor"));                    end;                    SalesAmtOnOrder[PeriodNo] := SalesOrderAmount;                    SalesAmtOnOrderLCY[PeriodNo] := SalesOrderAmountLCY;                    if NewCustomer then begin                        GroupNumber += 1;                        GroupNumberChanged := true;                    end else                        if not PrintAmountsInLCY and ("Currency Code" <> LastCurrencyCode) then begin                            GroupNumber += 1;                            GroupNumberChanged := true;                        end;                    if GroupNumberChanged then begin                        SalesOrderAmountLCY1 := 0;                        clear(SalesAmtOnOrderLCY1);                        SalesOrderAmount1 := 0;                        clear(SalesAmtOnOrder1);                    end;                    SalesOrderAmount1 += SalesOrderAmount;                    SalesOrderAmountLCY1 += SalesOrderAmountLCY;                    SalesAmtOnOrder1[PeriodNo] += SalesAmtOnOrder[PeriodNo];                    SalesAmtOnOrderLCY1[PeriodNo] += SalesAmtOnOrderLCY[PeriodNo];                    if PrintAmountsInLCY then begin                        InsertModifyTempSalesLine(TempSalesLine, SalesAmtOnOrderLCY1, PrintAmountsInLCY);                        TotalText := TotalLCYCaptionLbl;                    end else begin                        InsertModifyTempSalesLine(TempSalesLine, SalesAmtOnOrder1, PrintAmountsInLCY);                        TotalText := TotalCaptionLbl;                    end;                    InsertModifyTempSalesLine(TempTotalSalesLine, SalesAmtOnOrderLCY1, true);                    NewCustomer := false;                    GroupNumberChanged := false;                    LastCurrencyCode := "Currency Code";                end;            }            trigger OnAfterGetRecord()            begin                NewCustomer := true;                GroupNumberChanged := true;                LineNo := 0;            end;            trigger OnPreDataItem()            begin                ClearAmounts();            end;        }        dataitem(SalesLineBuffer_Integer; Integer)        {            DataItemTableView = sorting(Number);            column(Number; Number)            {            }            column(SalesLineBuffer_BilltoCustomerNo; TempSalesLine."Bill-to Customer No.")            {            }            column(SalesLineBuffer_CustomerName; TempSalesLine.Description)            {            }            column(SalesLineBuffer_CurrencyCode; TempSalesLine."Currency Code")            {            }            column(SalesLineBuffer_SalesOrderAmount; TempSalesLine.Amount)            {                AutoFormatType = 1;            }            column(SalesLineBuffer_SalesAmtOnOrder1; TempSalesLine."Unit Price")            {                AutoFormatType = 1;            }            column(SalesLineBuffer_SalesAmtOnOrder2; TempSalesLine."Unit Cost")            {                AutoFormatType = 1;            }            column(SalesLineBuffer_SalesAmtOnOrder3; TempSalesLine."Outstanding Amount")            {                AutoFormatType = 1;            }            column(SalesLineBuffer_SalesAmtOnOrder4; TempSalesLine."Amount Including VAT")            {                AutoFormatType = 1;            }            column(SalesLineBuffer_SalesAmtOnOrder5; TempSalesLine."Line Amount")            {                AutoFormatType = 1;            }            trigger OnAfterGetRecord()            begin                if Number = 1 then                    TempSalesLine.FindFirst()                else                    TempSalesLine.Next();            end;            trigger OnPreDataItem()            begin                SetRange(Number, 1, TempSalesLine.Count());            end;        }        dataitem(Totals; Integer)        {            DataItemTableView = sorting(Number) where(Number = const(1));            column(Totals_Sales_Order_Amount; TotalSalesOrderAmount)            {                AutoFormatType = 1;            }            column(Totals_Sales_Amt_On_Order1; TotalSalesAmtOnOrder[1])            {                AutoFormatType = 1;            }            column(Totals_Sales_Amt_On_Order2; TotalSalesAmtOnOrder[2])            {                AutoFormatType = 1;            }            column(Totals_Sales_Amt_On_Order3; TotalSalesAmtOnOrder[3])            {                AutoFormatType = 1;            }            column(Totals_Sales_Amt_On_Order4; TotalSalesAmtOnOrder[4])            {                AutoFormatType = 1;            }            column(Totals_Sales_Amt_On_Order5; TotalSalesAmtOnOrder[5])            {                AutoFormatType = 1;            }            column(Totals_TotalText; TotalText)            {            }            trigger OnPreDataItem()            begin                TempTotalSalesLine.Reset();                TempTotalSalesLine.CalcSums(Amount, "Unit Price", "Unit Cost", "Outstanding Amount", "Amount Including VAT", "Line Amount");                TotalSalesOrderAmount := TempTotalSalesLine.Amount;                TotalSalesAmtOnOrder[1] := TempTotalSalesLine."Unit Price";                TotalSalesAmtOnOrder[2] := TempTotalSalesLine."Unit Cost";                TotalSalesAmtOnOrder[3] := TempTotalSalesLine."Outstanding Amount";                TotalSalesAmtOnOrder[4] := TempTotalSalesLine."Amount Including VAT";                TotalSalesAmtOnOrder[5] := TempTotalSalesLine."Line Amount";            end;        }    }    requestpage    {        SaveValues = true;        AboutTitle = 'About Customer - Order Summary';        AboutText = 'Analyse your nonshipped orders in order to understand your expected sales volume. See order details with the quantity not yet shipped for each customer in three periods of 30 days each, starting from the specified date.';        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(ShwAmtinLCY; PrintAmountsInLCY)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Show Amounts in LCY';                        ToolTip = 'Specifies if the reported amounts are shown in the local currency.';                    }                    field(StartingDate; PeriodStartDate[1])                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Starting Date';                        NotBlank = true;                        ToolTip = 'Specifies the date from which the report or batch job processes information.';                    }                    // Used to set the date filter on the report header across multiple languages                    field(RequestPeriod1Text; Period1Text)                    {                        ApplicationArea = All;                        Caption = 'Period 1';                        ToolTip = 'Specifies Period 1 on this report.';                        Visible = false;                    }                    field(RequestPeriod2Text; Period2Text)                    {                        ApplicationArea = All;                        Caption = 'Period 2';                        ToolTip = 'Specifies Period 2 on this report.';                        Visible = false;                    }                    field(RequestPeriod3Text; Period3Text)                    {                        ApplicationArea = All;                        Caption = 'Period 3';                        ToolTip = 'Specifies Period 3 on this report.';                        Visible = false;                    }                }            }        }        actions        {        }        trigger OnOpenPage()        begin            if PeriodStartDate[1] = 0D then                PeriodStartDate[1] := WorkDate();        end;        trigger OnClosePage()        begin            for i := 1 to 3 do                PeriodStartDate[i + 1] := CalcDate('<1M>', PeriodStartDate[i]);            PeriodStartDate[5] := DMY2Date(31, 12, 9999);            UpdateRequestPageFilterValues();        end;    }    rendering    {        layout(Excel)        {            Caption = 'Customer Order Summary Excel';            LayoutFile = '.\Sales\Reports\CustomerOrderSummary.xlsx';            Type = Excel;            Summary = 'Built in layout for the Customer Order Summary excel report.';        }        layout(Word)        {            Caption = 'Customer Order Summary Word';            LayoutFile = '.\Sales\Reports\CustomerOrderSummary.docx';            Type = Word;            Summary = 'Built in layout for the Customer Order Summary word report.';        }#if not CLEAN27        layout(RDLC)        {            Caption = 'Customer Order Summary RDLC';            Type = RDLC;            LayoutFile = '.\Sales\Reports\CustomerOrderSummary.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        layout(WordBody)        {            Type = Word;            Subtype = Body;            LayoutFile = '.\Sales\Reports\CustomerOrderSummaryBody.docx';            Caption = 'Body-only: Customer Order Summary Word';            Summary = 'Landscape orientated. Groups outstanding sales order amounts by customer and currency, split across the periods before, within, and after the date range. Shows a total for each line and overall totals, in LCY.';        }    }    labels    {        DataRetrieved = 'Data retrieved:';        CustomerOrderSummary = 'Customer Order Summary';        CustOrderSummaryLCYPrint = 'Cust. Order Summary LCY (Print)', MaxLength = 31, Comment = 'Excel worksheet name.';        CustomerOrderSummaryPrint = 'Customer Order Summary (Print)', MaxLength = 31, Comment = 'Excel worksheet name.';        CustomerOrderSummaryAnalysis = 'Cust. Order Summary (Analysis)', MaxLength = 31, Comment = 'Excel worksheet name.';        PostingDateFilterLabel = 'Posting Date Filter:';        // 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';        StartingDateLbl = 'Starting Date';        BeforeLbl = '...before (LCY)';        Before1Lbl = '...before';        AfterLbl = 'after (LCY)...';        After1Lbl = 'after...';        OutstandingOrdersLbl = 'Outstanding Orders';        CustomerNoLbl = 'Customer No.';        CustomerNameLbl = 'Customer Name';        Period2StartDateLbl = 'Period 2 Start Date';        Period2EndDateLbl = 'Period 2 End Date';        Period3StartDateLbl = 'Period 3 Start Date';        Period3EndDateLbl = 'Period 3 End Date';        Period4StartDateLbl = 'Period 4 Start Date';        Period4EndDateLbl = 'Period 4 End Date';        SalesAmtOnOrderLCY2Lbl = 'Sales Amt. on Order (LCY) for Period 2';        SalesAmtOnOrder2Lbl = 'Sales Amt. on Order for Period 2';        SalesAmtOnOrderLCY3Lbl = 'Sales Amt. on Order (LCY) for Period 3';        SalesAmtOnOrder3Lbl = 'Sales Amt. on Order for Period 3';        SalesAmtOnOrderLCY4Lbl = 'Sales Amt. on Order (LCY) for Period 4';        SalesAmtOnOrder4Lbl = 'Sales Amt. on Order for Period 4';        TotalCaptionLbl = 'Total';        TotalLCYCaptionLbl = 'Total (LCY)';    }    trigger OnPreReport()    var        FormatDocument: Codeunit "Format Document";    begin        CustFilter := FormatDocument.GetRecordFiltersWithCaptions(Customer);        if CustFilter <> '' then            CustFilterTxt := Customer.TableCaption + ': ' + CustFilter;        if not PrintAmountsInLCY then begin            AllAmountsAreInLCYTxt := '';            Currency.SetFilter(Code, Customer.GetFilter("Currency Filter"));            if Currency.Count = 1 then                Currency.FindFirst();        end else            AllAmountsAreInLCYTxt := AllAmountsAreInLCYCaptionLbl;        if PeriodStartDate[1] = 0D then            PeriodStartDate[1] := WorkDate();        for i := 1 to 3 do            PeriodStartDate[i + 1] := CalcDate('<1M>', PeriodStartDate[i]);        PeriodStartDate[5] := DMY2Date(31, 12, 9999);        UpdateRequestPageFilterValues();    end;    var        CurrExchRate: Record "Currency Exchange Rate";        SalesHeader: Record "Sales Header";        Currency: Record Currency;        TempSalesLine: Record "Sales Line" temporary;        TempTotalSalesLine: Record "Sales Line" temporary;        CustFilter: Text;        CustFilterTxt: Text;        SalesOrderAmount: Decimal;        SalesOrderAmountLCY: Decimal;        SalesOrderAmount1: Decimal;        SalesOrderAmountLCY1: Decimal;        TotalSalesOrderAmount: Decimal;        TotalSalesAmtOnOrder: array[5] of Decimal;        PeriodStartDate: array[5] of Date;        PrintAmountsInLCY: Boolean;        AllAmountsAreInLCYTxt: Text;        Period1Text: Text;        Period2Text: Text;        Period3Text: Text;        TotalText: Text;        i: Integer;        GroupNumber: Integer;        LineNo: Integer;        NewCustomer: Boolean;        GroupNumberChanged: Boolean;        LastCurrencyCode: Code[10];        AllAmountsAreInLCYCaptionLbl: Label 'All amounts are in LCY';        TotalCaptionLbl: Label 'Total';        TotalLCYCaptionLbl: Label 'Total (LCY)';    protected var        SalesAmtOnOrderLCY: array[5] of Decimal;        SalesAmtOnOrderLCY1: array[5] of Decimal;        PeriodNo: Integer;        SalesAmtOnOrder: array[5] of Decimal;        SalesAmtOnOrder1: array[5] of Decimal;#if not CLEAN27            [Obsolete('RDLC Only layout field caption. To be removed along with the RDLC layout', '27.0')]        CustomerOrderSummaryCaptionLbl: Label 'Customer - Order Summary';        [Obsolete('RDLC Only layout field caption. To be removed along with the RDLC layout', '27.0')]        PageNoCaptionLbl: Label 'Page';        [Obsolete('RDLC Only layout field caption. To be removed along with the RDLC layout', '27.0')]        OutstandingOrdersCaptionLbl: Label 'Outstanding Orders';        [Obsolete('RDLC Only layout field caption. To be removed along with the RDLC layout', '27.0')]        CustomerNoCaptionLbl: Label 'Customer No.';#pragma warning disable AA0074        [Obsolete('RDLC Only layout field caption. To be removed along with the RDLC layout', '27.0')]        CustomerNameCap: Label 'Name';#pragma warning restore AA0074        [Obsolete('RDLC Only layout field caption. To be removed along with the RDLC layout', '27.0')]        BeforeCaptionLbl: Label '...before';        [Obsolete('RDLC Only layout field caption. To be removed along with the RDLC layout', '27.0')]        AfterCaptionLbl: Label 'after...';#endif    /// <summary>    /// Initializes the report request options for the Customer Order Summary report.    /// </summary>    /// <param name="StartingDate">The starting date for the summary periods.</param>    /// <param name="ShowAmountInLCY">True to show amounts in local currency.</param>    procedure InitializeRequest(StartingDate: Date; ShowAmountInLCY: Boolean)    begin        PeriodStartDate[1] := StartingDate;        PrintAmountsInLCY := ShowAmountInLCY;    end;    local procedure ClearAmounts()    begin        Clear(SalesOrderAmountLCY);        Clear(SalesAmtOnOrderLCY);        Clear(SalesOrderAmount);        Clear(SalesAmtOnOrder);    end;    // Ensures Layout Filter Headings are up to date    local procedure UpdateRequestPageFilterValues()    begin        Period1Text := Format(PeriodStartDate[1]) + '..' + Format(PeriodStartDate[2] - 1);        Period2Text := Format(PeriodStartDate[2]) + '..' + Format(PeriodStartDate[3] - 1);        Period3Text := Format(PeriodStartDate[3]) + '..' + Format(PeriodStartDate[4] - 1);    end;    local procedure InsertModifyTempSalesLine(var SalesLineTemp: Record "Sales Line" temporary; SalesAmtOnOrderArr: array[5] of Decimal; PrintAmountsInLCYIn: Boolean)    begin        if GroupNumberChanged then begin            SalesLineTemp.Init();            SalesLineTemp."Document Type" := SalesLineTemp."Document Type"::Quote;            SalesLineTemp."Document No." := Customer."No.";            SalesLineTemp."Line No." := LineNo;            SalesLineTemp."Bill-to Customer No." := "Sales Line"."Bill-to Customer No.";            SalesLineTemp.Description := Customer.Name;            if PrintAmountsInLCYIn then                SalesLineTemp.Amount := SalesOrderAmountLCY1            else begin                SalesLineTemp."Currency Code" := "Sales Line"."Currency Code";                SalesLineTemp.Amount := SalesOrderAmount1;            end;            if PeriodNo = 1 then                SalesLineTemp."Unit Price" := SalesAmtOnOrderArr[1];            if PeriodNo = 2 then                SalesLineTemp."Unit Cost" := SalesAmtOnOrderArr[2];            if PeriodNo = 3 then                SalesLineTemp."Outstanding Amount" := SalesAmtOnOrderArr[3];            if PeriodNo = 4 then                SalesLineTemp."Amount Including VAT" := SalesAmtOnOrderArr[4];            if PeriodNo = 5 then                SalesLineTemp."Line Amount" := SalesAmtOnOrderArr[5];            SalesLineTemp.Insert();            LineNo += 1;        end else begin            if PrintAmountsInLCYIn then                SalesLineTemp.Amount := SalesOrderAmountLCY1            else                SalesLineTemp.Amount := SalesOrderAmount1;            if PeriodNo = 1 then                SalesLineTemp."Unit Price" := SalesAmtOnOrderArr[1];            if PeriodNo = 2 then                SalesLineTemp."Unit Cost" := SalesAmtOnOrderArr[2];            if PeriodNo = 3 then                SalesLineTemp."Outstanding Amount" := SalesAmtOnOrderArr[3];            if PeriodNo = 4 then                SalesLineTemp."Amount Including VAT" := SalesAmtOnOrderArr[4];            if PeriodNo = 5 then                SalesLineTemp."Line Amount" := SalesAmtOnOrderArr[5];            SalesLineTemp.Modify();        end;    end;}