Codeunit 4810 IntrastatReportManagement

Intrastat Core

src/Apps/W1/Intrastat/app/src/Processing/IntrastatReportManagement.Codeunit.al1,216 lines, Copyright (c) Microsoft Corporation. MIT

#pragma warning disable AA0247codeunit 4810 IntrastatReportManagement{    Permissions = TableData "Intrastat Report Header" = imd,                  TableData "Intrastat Report Line" = imd,                  TableData "NAV App Installed App" = r;    var        AdvChecklistErr: Label 'There are one or more errors. For details, see the report error FactBox.';        UpdateSelectionQst: Label '&Weight,&Supplemental UOM Qty,&Both';        ExportSelectionQst: Label '&Receipts,&Shipments,&Both';        NoDataExchMappingErr: Label '%1 for %2 %3 does not exist.', Comment = '%1 - Data Exchange Mapping caption, %2 - Data Exchange Definition caption, %3 - Data Exchange Definition code';        PeriodAlreadyReportedQst: Label 'You''ve already submitted the report for this period.\Do you want to continue?';        ExternalContentErr: Label '%1 is empty.', Comment = '%1 - File Content';        DownloadFromStreamErr: Label 'The file has not been saved.';        FileNameLbl: Label 'Intrastat-%1.txt', Comment = '%1 - Statistics Period';        ReceptFileNameLbl: Label 'Receipt-%1.txt', Comment = '%1 - Statistics Period';        ShipmentFileNameLbl: Label 'Shipment-%1.txt', Comment = '%1 - Statistics Period';        ZipFileNameLbl: Label 'Intrastat-%1.zip', Comment = '%1 - Statistics Period';        DisableNotificationTxt: Label 'Disable this notification';        SupplementaryUnitUpdateNotificationNameTxt: Label 'Notify the user about the %1 update.', Comment = '%1 - Supplementary Unit of Measure caption';        SupplementaryUnitUpdateNotificationDescriptionTxt: Label 'Alert users about the update of %1 during %2 change.', Comment = '%1 - Supplementary Unit of Measure caption, %2 - Tariff Number caption';        SupplementaryUnitUpdateNotificationTxt: Label '%1 was updated, due to change of %2.', Comment = '%1 - Supplementary Unit of Measure caption, %2 - Tariff Number caption';        ImportDefaultIntrastatDataExchDefConfirmQst: Label 'This will create the default Intrastat %1 . \\All existing default Intrastat %1 will be overwritten.\\Do you want to continue?', Comment = '%1 - Data Exchange Definition caption';        AssistedSetupTxt: Label 'Set up Intrastat reporting';        AssistedSetupDescriptionTxt: Label 'The Intrastat reporting makes it easy to export the Intrastat report in the format that the authorities in your country require.';        SupplementaryUnitUpdateNotificationIdTok: Label '52f2c034-1857-4922-99cb-448c09e01474', Locked = true;        LearnMoreLinkTok: Label 'https://go.microsoft.com/fwlink/?linkid=2283605', Locked = true;        RangeCrossingErr: Label 'There is a conflict in checklist rules for ''%1'' in ''%2'' (field must be both blank and not blank). Please review filters in %3.', Comment = '%1=caption of a field, %2=key of record, %3=caption of report checklist page';        MaximumLinesErr: Label 'Split files functionality can only be used when the source record is using default sorting and fields are not grouped. Please contact the %1 administrator to adjust the settings in the related %2.', Comment = '%1=Data Exchange caption, %2=Data Exch Mapping Card caption';        DataExchangeXMLTxt: Label '<?xml version="1.0" encoding="UTF-8" standalone="no"?><root><DataExchDef Code="INTRA-2022" Name="Intrastat Report 2022" Type="5" ReadingWritingXMLport="1231" ExternalDataHandlingCodeunit="4813" ColumnSeparator="1" FileType="1" ReadingWritingCodeunit="1276"><DataExchLineDef LineType="1" Code="DEFAULT" Name="DEFAULT" ColumnCount="9"><DataExchColumnDef ColumnNo="1" Name="Tariff No." Show="false" DataType="0" Length="8" TextPaddingRequired="true" PadCharacter="0" Justification="0" UseNodeNameAsValue="false" /><DataExchColumnDef ColumnNo="2" Name="Country/Region Code" Show="false" DataType="0" Length="3" TextPaddingRequired="true" PadCharacter="&amp;#032;" Justification="1" UseNodeNameAsValue="false" /><DataExchColumnDef ColumnNo="3" Name="Transaction Type" Show="false" DataType="0" Length="2" TextPaddingRequired="true" Justification="1" UseNodeNameAsValue="false" /><DataExchColumnDef ColumnNo="4" Name="Quantity" Show="false" DataType="0" Length="11" TextPaddingRequired="true" PadCharacter="0" Justification="0" UseNodeNameAsValue="false" /><DataExchColumnDef ColumnNo="5" Name="Total Weight" Show="false" DataType="0" Length="10" TextPaddingRequired="true" PadCharacter="0" Justification="0" UseNodeNameAsValue="false" /><DataExchColumnDef ColumnNo="6" Name="Statistical Value" Show="false" DataType="0" Length="11" TextPaddingRequired="true" PadCharacter="0" Justification="0" UseNodeNameAsValue="false" /><DataExchColumnDef ColumnNo="7" Name="Internal Ref. No." Show="false" DataType="0" Length="30" TextPaddingRequired="true" PadCharacter="&amp;#032;" Justification="1" UseNodeNameAsValue="false" /><DataExchColumnDef ColumnNo="8" Name="Partner Tax ID" Show="false" DataType="0" Length="20" TextPaddingRequired="true" PadCharacter="&amp;#032;" Justification="1" UseNodeNameAsValue="false" /><DataExchColumnDef ColumnNo="9" Name="Country/Region of Origin Code" Show="false" DataType="0" Length="3" TextPaddingRequired="true" PadCharacter="&amp;#032;" Justification="1" UseNodeNameAsValue="false" /><DataExchMapping TableId="4812" Name="" KeyIndex="5" MappingCodeunit="1269"><DataExchFieldMapping ColumnNo="1" FieldID="5" Optional="true" TransformationRule="TRIMALL"><TransformationRules><Code>TRIMALL</Code><Description>Removes all spaces</Description><TransformationType>5</TransformationType><FindValue>&amp;#032;</FindValue><ReplaceValue /><StartPosition>0</StartPosition><Length>0</Length><DataFormat /><DataFormattingCulture /><NextTransformationRule /><TableID>0</TableID><SourceFieldID>0</SourceFieldID><TargetFieldID>0</TargetFieldID><FieldLookupRule>0</FieldLookupRule><Precision>0.00</Precision><Direction /></TransformationRules></DataExchFieldMapping><DataExchFieldMapping ColumnNo="2" FieldID="101" Optional="true" /><DataExchFieldMapping ColumnNo="3" FieldID="8" Optional="true" /><DataExchFieldMapping ColumnNo="4" FieldID="14" Optional="true" TransformationRule="ROUNDTOINT"><TransformationRules><Code>ALPHANUMERIC_ONLY</Code><Description>Alphanumeric Text Only</Description><TransformationType>7</TransformationType><FindValue /><ReplaceValue /><StartPosition>0</StartPosition><Length>0</Length><DataFormat /><DataFormattingCulture /><NextTransformationRule /><TableID>0</TableID><SourceFieldID>0</SourceFieldID><TargetFieldID>0</TargetFieldID><FieldLookupRule>0</FieldLookupRule><Precision>0.00</Precision><Direction /></TransformationRules><TransformationRules><Code>ROUNDTOINT</Code><Description>Round to integer</Description><TransformationType>14</TransformationType><FindValue>&amp;#032;</FindValue><ReplaceValue /><StartPosition>0</StartPosition><Length>0</Length><DataFormat /><DataFormattingCulture /><NextTransformationRule>ALPHANUMERIC_ONLY</NextTransformationRule><TableID>0</TableID><SourceFieldID>0</SourceFieldID><TargetFieldID>0</TargetFieldID><FieldLookupRule>0</FieldLookupRule><Precision>1.00</Precision><Direction>=</Direction></TransformationRules></DataExchFieldMapping><DataExchFieldMapping ColumnNo="5" FieldID="21" Optional="true" TransformationRule="ROUNDUPTOINT"><TransformationRules><Code>ALPHANUMERIC_ONLY</Code><Description>Alphanumeric Text Only</Description><TransformationType>7</TransformationType><FindValue /><ReplaceValue /><StartPosition>0</StartPosition><Length>0</Length><DataFormat /><DataFormattingCulture /><NextTransformationRule /><TableID>0</TableID><SourceFieldID>0</SourceFieldID><TargetFieldID>0</TargetFieldID><FieldLookupRule>0</FieldLookupRule><Precision>0.00</Precision><Direction /></TransformationRules><TransformationRules><Code>ROUNDUPTOINT</Code><Description>Round up to integer</Description><TransformationType>14</TransformationType><FindValue>&amp;#032;</FindValue><ReplaceValue /><StartPosition>0</StartPosition><Length>0</Length><DataFormat /><DataFormattingCulture /><NextTransformationRule>ALPHANUMERIC_ONLY</NextTransformationRule><TableID>0</TableID><SourceFieldID>0</SourceFieldID><TargetFieldID>0</TargetFieldID><FieldLookupRule>0</FieldLookupRule><Precision>1.00</Precision><Direction>&gt;</Direction></TransformationRules></DataExchFieldMapping><DataExchFieldMapping ColumnNo="6" FieldID="17" Optional="true" TransformationRule="ROUNDTOINT"><TransformationRules><Code>ALPHANUMERIC_ONLY</Code><Description>Alphanumeric Text Only</Description><TransformationType>7</TransformationType><FindValue /><ReplaceValue /><StartPosition>0</StartPosition><Length>0</Length><DataFormat /><DataFormattingCulture /><NextTransformationRule /><TableID>0</TableID><SourceFieldID>0</SourceFieldID><TargetFieldID>0</TargetFieldID><FieldLookupRule>0</FieldLookupRule><Precision>0.00</Precision><Direction /></TransformationRules><TransformationRules><Code>ROUNDTOINT</Code><Description>Round to integer</Description><TransformationType>14</TransformationType><FindValue>&amp;#032;</FindValue><ReplaceValue /><StartPosition>0</StartPosition><Length>0</Length><DataFormat /><DataFormattingCulture /><NextTransformationRule>ALPHANUMERIC_ONLY</NextTransformationRule><TableID>0</TableID><SourceFieldID>0</SourceFieldID><TargetFieldID>0</TargetFieldID><FieldLookupRule>0</FieldLookupRule><Precision>1.00</Precision><Direction>=</Direction></TransformationRules></DataExchFieldMapping><DataExchFieldMapping ColumnNo="7" FieldID="23" Optional="true" /><DataExchFieldMapping ColumnNo="8" FieldID="29" Optional="true" /><DataExchFieldMapping ColumnNo="9" FieldID="24" Optional="true" TransformationRule="EUCOUNTRYCODELOOKUP"><TransformationRules><Code>EUCOUNTRYCODELOOKUP</Code><Description>EU Country Lookup</Description><TransformationType>13</TransformationType><FindValue>&amp;#032;</FindValue><ReplaceValue /><StartPosition>0</StartPosition><Length>0</Length><DataFormat /><DataFormattingCulture /><NextTransformationRule /><TableID>9</TableID><SourceFieldID>1</SourceFieldID><TargetFieldID>7</TargetFieldID><FieldLookupRule>1</FieldLookupRule><Precision>0.00</Precision><Direction /></TransformationRules></DataExchFieldMapping><DataExchFieldGrouping FieldID="3" /><DataExchFieldGrouping FieldID="5" /><DataExchFieldGrouping FieldID="7" /><DataExchFieldGrouping FieldID="8" /><DataExchFieldGrouping FieldID="9" /><DataExchFieldGrouping FieldID="24" /><DataExchFieldGrouping FieldID="29" /></DataExchMapping></DataExchLineDef></DataExchDef></root>',                            Locked = true; // will be replaced with file import when available            procedure GetIntrastatBaseCountryCode(ItemLedgEntry: Record "Item Ledger Entry") CountryCode: Code[10]    var        IntrastatReportSetup: Record "Intrastat Report Setup";        SalesShptHeader: Record "Sales Shipment Header";        ReturnRcptHeader: Record "Return Receipt Header";        PurchRcptHeader: Record "Purch. Rcpt. Header";        ReturnShptHeader: Record "Return Shipment Header";        IsHandled: Boolean;    begin        IntrastatReportSetup.Get();        IsHandled := false;        OnBeforeGetIntrastatBaseCountryCode(ItemLedgEntry, IntrastatReportSetup, CountryCode, IsHandled);        if IsHandled then            exit(CountryCode);        CountryCode := ItemLedgEntry."Country/Region Code";        case ItemLedgEntry."Document Type" of            ItemLedgEntry."Document Type"::"Sales Shipment":                if SalesShptHeader.Get(ItemLedgEntry."Document No.") then                    case IntrastatReportSetup."Shipments Based On" of                        IntrastatReportSetup."Shipments Based On"::"Ship-to Country":                            CountryCode := SalesShptHeader."Ship-to Country/Region Code";                        IntrastatReportSetup."Shipments Based On"::"Sell-to Country":                            CountryCode := SalesShptHeader."Sell-to Country/Region Code";                        IntrastatReportSetup."Shipments Based On"::"Bill-to Country":                            CountryCode := SalesShptHeader."Bill-to Country/Region Code";                    end;            ItemLedgEntry."Document Type"::"Sales Return Receipt":                if ReturnRcptHeader.Get(ItemLedgEntry."Document No.") then                    case IntrastatReportSetup."Shipments Based On" of                        IntrastatReportSetup."Shipments Based On"::"Ship-to Country":                            if ReturnRcptHeader."Rcvd.-from Count./Region Code" <> '' then                                CountryCode := ReturnRcptHeader."Rcvd.-from Count./Region Code"                            else                                CountryCode := ReturnRcptHeader."Ship-to Country/Region Code";                        IntrastatReportSetup."Shipments Based On"::"Sell-to Country":                            CountryCode := ReturnRcptHeader."Sell-to Country/Region Code";                        IntrastatReportSetup."Shipments Based On"::"Bill-to Country":                            CountryCode := ReturnRcptHeader."Bill-to Country/Region Code";                    end;            ItemLedgEntry."Document Type"::"Purchase Receipt":                if PurchRcptHeader.Get(ItemLedgEntry."Document No.") then                    case IntrastatReportSetup."Shipments Based On" of                        IntrastatReportSetup."Shipments Based On"::"Ship-to Country":                            CountryCode := PurchRcptHeader."Buy-from Country/Region Code";                        IntrastatReportSetup."Shipments Based On"::"Sell-to Country":                            CountryCode := PurchRcptHeader."Buy-from Country/Region Code";                        IntrastatReportSetup."Shipments Based On"::"Bill-to Country":                            CountryCode := PurchRcptHeader."Pay-to Country/Region Code";                    end;            ItemLedgEntry."Document Type"::"Purchase Return Shipment":                if ReturnShptHeader.Get(ItemLedgEntry."Document No.") then                    case IntrastatReportSetup."Shipments Based On" of                        IntrastatReportSetup."Shipments Based On"::"Ship-to Country":                            CountryCode := ReturnShptHeader."Buy-from Country/Region Code";                        IntrastatReportSetup."Shipments Based On"::"Sell-to Country":                            CountryCode := ReturnShptHeader."Buy-from Country/Region Code";                        IntrastatReportSetup."Shipments Based On"::"Bill-to Country":                            CountryCode := ReturnShptHeader."Pay-to Country/Region Code";                    end;            else                OnGetIntrastatBaseCountryCodeFromItemLedgerElseCase(ItemLedgEntry, IntrastatReportSetup, CountryCode);        end;    end;    procedure GetIntrastatBaseCountryCode(JobLedgerEntry: Record "Job Ledger Entry") CountryCode: Code[10]    var        IntrastatReportSetup: Record "Intrastat Report Setup";        Job: Record Job;        IsHandled: Boolean;    begin        IntrastatReportSetup.Get();        IsHandled := false;        OnBeforeGetIntrastatBaseCountryCodeFromJLE(JobLedgerEntry, IntrastatReportSetup, CountryCode, IsHandled);        if IsHandled then            exit(CountryCode);        CountryCode := JobLedgerEntry."Country/Region Code";        if Job.Get(JobLedgerEntry."Job No.") then            case IntrastatReportSetup."Shipments Based On" of                IntrastatReportSetup."Shipments Based On"::"Ship-to Country":                    CountryCode := Job."Ship-to Country/Region Code";                IntrastatReportSetup."Shipments Based On"::"Sell-to Country":                    CountryCode := Job."Sell-to Country/Region Code";                IntrastatReportSetup."Shipments Based On"::"Bill-to Country":                    CountryCode := Job."Bill-to Country/Region Code";            end;    end;    procedure GetIntrastatBaseCountryCode(FALedgerEntry: Record "FA Ledger Entry") CountryCode: Code[10]    var        IntrastatReportSetup: Record "Intrastat Report Setup";        PurchInvHeader: Record "Purch. Inv. Header";        PurchCrMemoHdr: Record "Purch. Cr. Memo Hdr.";        SalesInvHeader: Record "Sales Invoice Header";        SalesCrMemoHeader: Record "Sales Cr.Memo Header";        IsHandled: Boolean;    begin        IntrastatReportSetup.Get();        IsHandled := false;        OnBeforeGetIntrastatBaseCountryCodeFromFALE(FALedgerEntry, IntrastatReportSetup, CountryCode, IsHandled);        if IsHandled then            exit(CountryCode);        CountryCode := '';        if FALedgerEntry."FA Posting Type" = FALedgerEntry."FA Posting Type"::"Acquisition Cost" then            case FALedgerEntry."Document Type" of                FALedgerEntry."Document Type"::Invoice:                    if PurchInvHeader.Get(FALedgerEntry."Document No.") then                        case IntrastatReportSetup."Shipments Based On" of                            IntrastatReportSetup."Shipments Based On"::"Ship-to Country":                                CountryCode := PurchInvHeader."Buy-from Country/Region Code";                            IntrastatReportSetup."Shipments Based On"::"Sell-to Country":                                CountryCode := PurchInvHeader."Buy-from Country/Region Code";                            IntrastatReportSetup."Shipments Based On"::"Bill-to Country":                                CountryCode := PurchInvHeader."Pay-to Country/Region Code";                        end;                FALedgerEntry."Document Type"::"Credit Memo":                    if PurchCrMemoHdr.Get(FALedgerEntry."Document No.") then                        case IntrastatReportSetup."Shipments Based On" of                            IntrastatReportSetup."Shipments Based On"::"Ship-to Country":                                CountryCode := PurchCrMemoHdr."Buy-from Country/Region Code";                            IntrastatReportSetup."Shipments Based On"::"Sell-to Country":                                CountryCode := PurchCrMemoHdr."Buy-from Country/Region Code";                            IntrastatReportSetup."Shipments Based On"::"Bill-to Country":                                CountryCode := PurchCrMemoHdr."Pay-to Country/Region Code";                        end;            end;        if FALedgerEntry."FA Posting Type" = FALedgerEntry."FA Posting Type"::"Proceeds on Disposal" then            case FALedgerEntry."Document Type" of                FALedgerEntry."Document Type"::Invoice:                    if SalesInvHeader.Get(FALedgerEntry."Document No.") then                        case IntrastatReportSetup."Shipments Based On" of                            IntrastatReportSetup."Shipments Based On"::"Ship-to Country":                                CountryCode := SalesInvHeader."Ship-to Country/Region Code";                            IntrastatReportSetup."Shipments Based On"::"Sell-to Country":                                CountryCode := SalesInvHeader."Sell-to Country/Region Code";                            IntrastatReportSetup."Shipments Based On"::"Bill-to Country":                                CountryCode := SalesInvHeader."Bill-to Country/Region Code";                        end;                FALedgerEntry."Document Type"::"Credit Memo":                    if SalesCrMemoHeader.Get(FALedgerEntry."Document No.") then                        case IntrastatReportSetup."Shipments Based On" of                            IntrastatReportSetup."Shipments Based On"::"Ship-to Country":                                CountryCode := SalesCrMemoHeader."Sell-to Country/Region Code";                            IntrastatReportSetup."Shipments Based On"::"Sell-to Country":                                CountryCode := SalesCrMemoHeader."Sell-to Country/Region Code";                            IntrastatReportSetup."Shipments Based On"::"Bill-to Country":                                CountryCode := SalesCrMemoHeader."Bill-to Country/Region Code";                        end;            end;        OnAfterGetIntrastatBaseCountryCodeFromFAEntry(FALedgerEntry, IntrastatReportSetup, CountryCode);    end;    procedure GetOriginalCurrency(FALedgerEntry: Record "FA Ledger Entry") CurrencyCode: Code[10]    var        PurchInvHeader: Record "Purch. Inv. Header";        PurchCrMemoHdr: Record "Purch. Cr. Memo Hdr.";    begin        case FALedgerEntry."Document Type" of            FALedgerEntry."Document Type"::Invoice:                if PurchInvHeader.Get(FALedgerEntry."Document No.") then                    CurrencyCode := PurchInvHeader."Currency Code";            FALedgerEntry."Document Type"::"Credit Memo":                if PurchCrMemoHdr.Get(FALedgerEntry."Document No.") then                    CurrencyCode := PurchCrMemoHdr."Currency Code";            else                CurrencyCode := '';        end;    end;    procedure GetOriginalCurrency(ItemLedgerEntry: Record "Item Ledger Entry") CurrencyCode: Code[10]    var        SalesShipmentHeader: Record "Sales Shipment Header";        SalesInvoiceHeader: Record "Sales Invoice Header";        SalesCrMemoHeader: Record "Sales Cr.Memo Header";        ReturnReceiptHeader: Record "Return Receipt Header";        PurchCrMemoHdr: Record "Purch. Cr. Memo Hdr.";        PurchInvHeader: Record "Purch. Inv. Header";        PurchRcptHeader: Record "Purch. Rcpt. Header";        ReturnShipmentHeader: Record "Return Shipment Header";        ServiceShipmentHeader: Record "Service Shipment Header";        ServiceInvoiceHeader: Record "Service Invoice Header";        ServiceCrMemoHeader: Record "Service Cr.Memo Header";    begin        case ItemLedgerEntry."Document Type" of            ItemLedgerEntry."Document Type"::"Sales Invoice":                if SalesInvoiceHeader.Get(ItemLedgerEntry."Document No.") then                    CurrencyCode := SalesInvoiceHeader."Currency Code";            ItemLedgerEntry."Document Type"::"Sales Credit Memo":                if SalesCrMemoHeader.Get(ItemLedgerEntry."Document No.") then                    CurrencyCode := SalesCrMemoHeader."Currency Code";            ItemLedgerEntry."Document Type"::"Sales Shipment":                if SalesShipmentHeader.Get(ItemLedgerEntry."Document No.") then                    CurrencyCode := SalesShipmentHeader."Currency Code";            ItemLedgerEntry."Document Type"::"Sales Return Receipt":                if ReturnReceiptHeader.Get(ItemLedgerEntry."Document No.") then                    CurrencyCode := ReturnReceiptHeader."Currency Code";            ItemLedgerEntry."Document Type"::"Purchase Credit Memo":                if PurchCrMemoHdr.Get(ItemLedgerEntry."Document No.") then                    CurrencyCode := PurchCrMemoHdr."Currency Code";            ItemLedgerEntry."Document Type"::"Purchase Return Shipment":                if ReturnShipmentHeader.Get(ItemLedgerEntry."Document No.") then                    CurrencyCode := ReturnShipmentHeader."Currency Code";            ItemLedgerEntry."Document Type"::"Purchase Invoice":                if PurchInvHeader.Get(ItemLedgerEntry."Document No.") then                    CurrencyCode := PurchInvHeader."Currency Code";            ItemLedgerEntry."Document Type"::"Purchase Receipt":                if PurchRcptHeader.Get(ItemLedgerEntry."Document No.") then                    CurrencyCode := PurchRcptHeader."Currency Code";            ItemLedgerEntry."Document Type"::"Service Shipment":                if ServiceShipmentHeader.Get(ItemLedgerEntry."Document No.") then                    CurrencyCode := ServiceShipmentHeader."Currency Code";            ItemLedgerEntry."Document Type"::"Service Invoice":                if ServiceInvoiceHeader.Get(ItemLedgerEntry."Document No.") then                    CurrencyCode := ServiceInvoiceHeader."Currency Code";            ItemLedgerEntry."Document Type"::"Service Credit Memo":                if ServiceCrMemoHeader.Get(ItemLedgerEntry."Document No.") then                    CurrencyCode := ServiceCrMemoHeader."Currency Code";            else                OnGetOriginalCurrencyFromItemLedgerElseCase(ItemLedgerEntry, CurrencyCode);        end;    end;    procedure CalcStatisticalValue(var IntrastatReportLine: Record "Intrastat Report Line"; LastIntrastatReportLine: Record "Intrastat Report Line"; var StatisticalValue: Decimal; var TotalStatisticalValue: Decimal; var ShowStatisticalValue: Boolean; var ShowTotalStatisticalValue: Boolean)    var        IntrastatReportLine2: Record "Intrastat Report Line";        IntrastatReportLine3: Record "Intrastat Report Line";    begin        IntrastatReportLine2.CopyFilters(IntrastatReportLine);        if IntrastatReportLine2.CalcSums("Statistical Value") then begin            if IntrastatReportLine."Line No." <> 0 then // 0 = New record                TotalStatisticalValue := IntrastatReportLine2."Statistical Value"            else                TotalStatisticalValue := IntrastatReportLine2."Statistical Value" + LastIntrastatReportLine."Statistical Value";            ShowTotalStatisticalValue := true;        end else            ShowTotalStatisticalValue := false;        if IntrastatReportLine."Line No." <> 0 then begin // 0 = New record            IntrastatReportLine2.SetFilter("Line No.", '<=%1', IntrastatReportLine."Line No.");            if IntrastatReportLine2.CalcSums("Statistical Value") then begin                StatisticalValue := IntrastatReportLine2."Statistical Value";                ShowStatisticalValue := true;            end else                ShowStatisticalValue := false;        end else begin            IntrastatReportLine2.SetFilter("Line No.", '<=%1', LastIntrastatReportLine."Line No.");            if IntrastatReportLine2.CalcSums("Statistical Value") then begin                IntrastatReportLine3.CopyFilters(IntrastatReportLine);                IntrastatReportLine3 := LastIntrastatReportLine;                if IntrastatReportLine3.Next() <> 0 then                    StatisticalValue := IntrastatReportLine2."Statistical Value"                else                    StatisticalValue := IntrastatReportLine2."Statistical Value" + LastIntrastatReportLine."Statistical Value";                ShowStatisticalValue := true;            end else                ShowStatisticalValue := false;        end;    end;    procedure ValidateReportWithAdvancedChecklist(IntrastatReportHeader: Record "Intrastat Report Header"; ThrowError: Boolean): Boolean    var        IntrastatReportLine: Record "Intrastat Report Line";    begin        ChecklistClearBatchErrors(IntrastatReportHeader);        IntrastatReportLine.SetRange("Intrastat No.", IntrastatReportHeader."No.");        OnBeforeValidateReportWithAdvancedChecklist(IntrastatReportLine, IntrastatReportHeader);        if IntrastatReportLine.FindSet() then            repeat                ValidateReportLineWithAdvancedChecklist(IntrastatReportLine, ThrowError);            until IntrastatReportLine.Next() = 0;    end;    procedure ValidateReportLineWithAdvancedChecklist(IntrastatReportLine: Record "Intrastat Report Line"; ThrowError: Boolean): Boolean    begin        exit(ValidateObjectWithAdvancedChecklist(IntrastatReportLine, ThrowError));    end;    local procedure ValidateObjectWithAdvancedChecklist(IntrastatReportLine: Record "Intrastat Report Line"; ThrowError: Boolean): Boolean    var        ErrorMessage: Record "Error Message";        IntrastatReportChecklist: Record "Intrastat Report Checklist";        IntrastatReportChecklistPage: Page "Intrastat Report Checklist";        AnyError, LinePassesNonBlank, LinePassesBlank : Boolean;    begin        ChecklistSetBatchContext(ErrorMessage, IntrastatReportLine);        if IntrastatReportChecklist.FindSet() then            repeat                LinePassesNonBlank := IntrastatReportChecklist.LinePassesFilterExpression(IntrastatReportLine);                LinePassesBlank := IntrastatReportChecklist.LinePassesFilterExpressionForMustBeBlank(IntrastatReportLine);                if LinePassesBlank and LinePassesNonBlank then begin                    IntrastatReportChecklist.CalcFields("Field Name");                    AnyError :=                      AnyError or                      (ErrorMessage.LogMessage(                         IntrastatReportLine, IntrastatReportChecklist."Field No.", ErrorMessage."Message Type"::Error, StrSubstNo(RangeCrossingErr, IntrastatReportChecklist."Field Name", Format(IntrastatReportLine.RecordId), IntrastatReportChecklistPage.Caption)) <> 0)                end else begin                    if LinePassesNonBlank then                        AnyError :=                          AnyError or                          (ErrorMessage.LogIfEmpty(                             IntrastatReportLine, IntrastatReportChecklist."Field No.", ErrorMessage."Message Type"::Error) <> 0);                    if LinePassesBlank then                        AnyError :=                          AnyError or                          (ErrorMessage.LogIfNotEmpty(                             IntrastatReportLine, IntrastatReportChecklist."Field No.", ErrorMessage."Message Type"::Error) <> 0);                end;            until IntrastatReportChecklist.Next() = 0;        if AnyError and ThrowError then            ThrowChecklistError();        exit(not AnyError);    end;    procedure ChecklistClearBatchErrors(IntrastatReportHeader: Record "Intrastat Report Header")    var        ErrorMessage: Record "Error Message";    begin        ErrorMessage.SetContext(IntrastatReportHeader);        ErrorMessage.ClearLog();    end;    local procedure ChecklistSetBatchContext(var ErrorMessage: Record "Error Message"; IntrastatReportLine: Record "Intrastat Report Line")    var        IntrastatReportHeader: Record "Intrastat Report Header";    begin        IntrastatReportHeader."No." := IntrastatReportLine."Intrastat No.";        ErrorMessage.SetContext(IntrastatReportHeader);    end;    local procedure ThrowChecklistError()    begin        Commit();        Error(AdvChecklistErr);    end;    procedure GetCompanyVATRegNo(): Text[50]    var        CompanyInformation: Record "Company Information";        IntrastatReportSetup: Record "Intrastat Report Setup";    begin        CompanyInformation.Get();        if not IntrastatReportSetup.Get() then            exit(CompanyInformation."VAT Registration No.");        OnGetCompanyVATRegNoOnAfterGetIntrastatReportSetup(CompanyInformation, IntrastatReportSetup);        exit(          GetVATRegNo(            CompanyInformation."Country/Region Code", CompanyInformation."VAT Registration No.",            IntrastatReportSetup."Company VAT No. on File"));    end;    procedure GetVATRegNo(CountryCode: Code[10]; VATRegNo: Text[20]; VATRegNoType: Enum "Intrastat Report VAT File Fmt") Result: Text[50]    var        IntrastatReportSetup: Record "Intrastat Report Setup";        CountryRegion: Record "Country/Region";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeGetVATRegNo(CountryCode, VATRegNo, VATRegNoType, Result, IsHandled);        if IsHandled then            exit(Result);        case VATRegNoType of            IntrastatReportSetup."Company VAT No. on File"::"VAT Reg. No.":                exit(VATRegNo);            IntrastatReportSetup."Company VAT No. on File"::"EU Country Code + VAT Reg. No":                begin                    CountryRegion.Get(CountryCode);                    if CountryRegion."EU Country/Region Code" <> '' then                        CountryCode := CountryRegion."EU Country/Region Code";                    exit(CountryCode + VATRegNo);                end;            IntrastatReportSetup."Company VAT No. on File"::"VAT Reg. No. Without EU Country Code":                begin                    CountryRegion.Get(CountryCode);                    if CountryRegion."EU Country/Region Code" <> '' then                        CountryCode := CountryRegion."EU Country/Region Code";                    if CopyStr(VATRegNo, 1, StrLen(DelChr(CountryCode, '<>'))) =                       DelChr(CountryCode, '<>')                    then                        exit(CopyStr(VATRegNo, StrLen(DelChr(CountryCode, '<>')) + 1, 50));                    exit(VATRegNo);                end;        end;    end;    procedure RecalculateWaightAndSupplUOMQty(IntrastatReportHeader: Record "Intrastat Report Header")    var        IntrastatReportLine: Record "Intrastat Report Line";        ItemUOM: Record "Item Unit of Measure";        FixedAsset: Record "Fixed Asset";        Item: Record Item;        Selection: Integer;        SupplUOMCode: Code[10];        SupplConversionFactor: Decimal;        NetWeight: Decimal;    begin        Selection := StrMenu(UpdateSelectionQst, 3);        if Selection = 0 then            exit;        IntrastatReportLine.SetRange("Intrastat No.", IntrastatReportHeader."No.");        if IntrastatReportLine.FindSet() then            repeat                if (IntrastatReportLine."Source Type" = IntrastatReportLine."Source Type"::"FA Entry") then begin                    if IntrastatReportLine."Item No." = '' then                        Clear(FixedAsset)                    else                        FixedAsset.Get(IntrastatReportLine."Item No.");                    SupplUOMCode := FixedAsset."Supplementary Unit of Measure";                    SupplConversionFactor := 1;                    NetWeight := FixedAsset."Net Weight";                end else begin                    if IntrastatReportLine."Item No." = '' then                        Clear(Item)                    else                        Item.Get(IntrastatReportLine."Item No.");                    SupplUOMCode := Item."Supplementary Unit of Measure";                    if ItemUOM.Get(Item."No.", Item."Supplementary Unit of Measure") and                        (ItemUOM."Qty. per Unit of Measure" <> 0)                    then                        SupplConversionFactor := 1 / ItemUOM."Qty. per Unit of Measure"                    else                        SupplConversionFactor := 0;                    NetWeight := Item."Net Weight";                    OnRecalculateWeightAndSupplUOMQtyOnAfterCalculateNetWeight(IntrastatReportLine, NetWeight);                end;                if Selection <> 1 then begin                    IntrastatReportLine."Suppl. Unit of Measure" := SupplUOMCode;                    IntrastatReportLine."Suppl. Conversion Factor" := SupplConversionFactor;                    IntrastatReportLine.Validate("Suppl. Conversion Factor");                end;                if Selection <> 2 then                    IntrastatReportLine.Validate("Net Weight", NetWeight);                IntrastatReportLine.Modify(true);            until IntrastatReportLine.Next() = 0;    end;    procedure ReleaseIntrastatReport(var IntrastatReportHeader: Record "Intrastat Report Header")    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeReleaseIntrastatHeader(IntrastatReportHeader, IsHandled);        if IsHandled then            exit;        IntrastatReportHeader.Status := IntrastatReportHeader.Status::Released;        IntrastatReportHeader.Modify();        OnAfterReleaseIntrastatHeader(IntrastatReportHeader);    end;    procedure ReopenIntrastatReport(var IntrastatReportHeader: Record "Intrastat Report Header")    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeReopenIntrastatHeader(IntrastatReportHeader, IsHandled);        if IsHandled then            exit;        if IntrastatReportHeader.Reported then            if not Confirm(PeriodAlreadyReportedQst) then                exit;        IntrastatReportHeader.Status := IntrastatReportHeader.Status::Open;        IntrastatReportHeader.Modify();        OnAfterReopenIntrastatHeader(IntrastatReportHeader);    end;    procedure ExportWithDataExch(IntrastatReportHeader: Record "Intrastat Report Header"; ExportType: Integer)    var        DataExch1: Record "Data Exch.";        DataExch2: Record "Data Exch.";        IntrastatReportSetup: Record "Intrastat Report Setup";        TempBlob: Codeunit "Temp Blob";        Selection: Integer;        IsHandled: Boolean;        FileName: Text;        ReceptFileName: Text;        ShipmentFileName: Text;        ZipFileName: Text;    begin        IsHandled := false;        OnBeforeExportIntrastatHeader(IntrastatReportHeader, IsHandled);        if IsHandled then            exit;        if IntrastatReportHeader.Reported then            if not Confirm(PeriodAlreadyReportedQst) then                exit;        OnBeforeDefineFileNames(IntrastatReportHeader, FileName, ReceptFileName, ShipmentFileName, ZipFileName, IsHandled);        if not IsHandled then begin            FileName := StrSubstNo(FileNameLbl, IntrastatReportHeader."Statistics Period");            ReceptFileName := StrSubstNo(ReceptFileNameLbl, IntrastatReportHeader."Statistics Period");            ShipmentFileName := StrSubstNo(ShipmentFileNameLbl, IntrastatReportHeader."Statistics Period");            ZipFileName := StrSubstNo(ZipFileNameLbl, IntrastatReportHeader."Statistics Period");        end;        IntrastatReportSetup.Get();        OnExportWithDataExchOnAfterGetIntrastatReportSetup(IntrastatReportSetup, IntrastatReportHeader);        if IntrastatReportSetup."Split Files" then begin            IntrastatReportSetup.TestField("Data Exch. Def. Code - Receipt");            IntrastatReportSetup.TestField("Data Exch. Def. Code - Shpt.");            FileName := ReceptFileName;            Selection := StrMenu(ExportSelectionQst, 3);            if Selection = 0 then                exit;            if Selection <> 2 then begin                ExportOneDataExchangeDef(IntrastatReportHeader, IntrastatReportSetup."Data Exch. Def. Code - Receipt", 1, DataExch1, IntrastatReportSetup."Max. No. of Lines in File");                DataExch1.CalcFields("File Content");                IntrastatReportHeader.Validate("Arrivals Reported", true);            end;            if Selection <> 1 then begin                ExportOneDataExchangeDef(IntrastatReportHeader, IntrastatReportSetup."Data Exch. Def. Code - Shpt.", 2, DataExch2, IntrastatReportSetup."Max. No. of Lines in File");                DataExch2.CalcFields("File Content");                IntrastatReportHeader.Validate("Dispatches Reported", true);            end;            if not (DataExch1."File Content".HasValue() or DataExch2."File Content".HasValue()) then                Error(ExternalContentErr, DataExch1.FieldCaption("File Content"));        end else begin            IntrastatReportSetup.TestField("Data Exch. Def. Code");            ExportOneDataExchangeDef(IntrastatReportHeader, IntrastatReportSetup."Data Exch. Def. Code", 0, DataExch1, IntrastatReportSetup."Max. No. of Lines in File");            DataExch1.CalcFields("File Content");            if not DataExch1."File Content".HasValue() then                Error(ExternalContentErr, DataExch1.FieldCaption("File Content"));            IntrastatReportHeader.Validate("Dispatches Reported", true);            IntrastatReportHeader.Validate("Arrivals Reported", true);        end;        if (Selection = 3) or IntrastatReportSetup."Zip Files" or (IntrastatReportSetup."Max. No. of Lines in File" > 0) then            ExportToZip(DataExch1, DataExch2, IntrastatReportHeader."Statistics Period", FileName, ReceptFileName, ShipmentFileName, ZipFileName)        else            if DataExch1."File Content".HasValue then begin                TempBlob.FromRecord(DataExch1, DataExch1.FieldNo("File Content"));                ExportToFile(DataExch1, TempBlob, FileName);            end else                if DataExch2."File Content".HasValue then begin                    TempBlob.FromRecord(DataExch2, DataExch2.FieldNo("File Content"));                    ExportToFile(DataExch2, TempBlob, ShipmentFileName);                end;        IsHandled := false;        OnAfterExportIntrastatHeader(IntrastatReportHeader, IsHandled);        if IsHandled then            exit;        IntrastatReportHeader."Export Date" := Today;        IntrastatReportHeader."Export Time" := Time;        IntrastatReportHeader.Modify();    end;#if not CLEAN27    [Obsolete('Use ExportOneDataExchangeDef(IntrastatReportHeader: Record "Intrastat Report Header"; DataExchDefCode: Code[20]; ExportType: Integer; var DataExch: Record "Data Exch."; MaxNoOfLines: Integer)', '27.0')]    procedure ExportOneDataExchangeDef(IntrastatReportHeader: Record "Intrastat Report Header"; DataExchDefCode: Code[20]; ExportType: Integer; var DataExch: Record "Data Exch.")    var        DataExchFieldGrouping: Record "Data Exch. Field Grouping";        IntrastatReportLine: Record "Intrastat Report Line";        DataExchMapping: Record "Data Exch. Mapping";        DataExchDef: Record "Data Exch. Def";        RecordRefSrc: RecordRef;        OutStreamFilters: OutStream;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeExportOneDataExchangeDef(IntrastatReportHeader, DataExchDefCode, ExportType, DataExch, IsHandled);        if not IsHandled then begin            DataExchMapping.SetRange("Data Exch. Def Code", DataExchDefCode);            DataExchMapping.SetRange("Table ID", Database::"Intrastat Report Line");            if not DataExchMapping.FindFirst() then                Error(NoDataExchMappingErr, DataExchMapping.TableCaption, DataExchDef.TableCaption, DataExchDefCode);            if DataExchMapping."Key Index" <> 0 then begin                RecordRefSrc.GetTable(IntrastatReportLine);                RecordRefSrc.CurrentKeyIndex(DataExchMapping."Key Index");                RecordRefSrc.SetTable(IntrastatReportLine);            end;            IntrastatReportLine.SetRange("Intrastat No.", IntrastatReportHeader."No.");            if ExportType = 1 then // Receipt                IntrastatReportLine.SetRange(Type, IntrastatReportLine.Type::Receipt);            if ExportType = 2 then // Shipment                IntrastatReportLine.SetRange(Type, IntrastatReportLine.Type::Shipment);            OnBeforeExportIntrastatReportLines(IntrastatReportLine, IntrastatReportHeader);            if not IntrastatReportLine.IsEmpty then begin                DataExchFieldGrouping.SetRange("Data Exch. Def Code", DataExchMapping."Data Exch. Def Code");                DataExchFieldGrouping.SetRange("Data Exch. Line Def Code", DataExchMapping."Data Exch. Line Def Code");                DataExchFieldGrouping.SetRange("Table ID", DataExchMapping."Table ID");                SetInternalRefNo(IntrastatReportLine, DataExchFieldGrouping, IntrastatReportHeader);                DataExch.Init();                DataExch."Data Exch. Def Code" := DataExchMapping."Data Exch. Def Code";                DataExch."Data Exch. Line Def Code" := DataExchMapping."Data Exch. Line Def Code";                DataExch."Table Filters".CreateOutStream(OutStreamFilters);                OutStreamFilters.WriteText(IntrastatReportLine.GetView(false));                if DataExch.Insert(true) then                    DataExch.ExportFromDataExch(DataExchMapping);                DataExch.Modify(true);            end;        end;    end;#endif        procedure ExportOneDataExchangeDef(IntrastatReportHeader: Record "Intrastat Report Header"; DataExchDefCode: Code[20]; ExportType: Integer; var DataExch: Record "Data Exch."; MaxNoOfLines: Integer)    var        DataExchFieldGrouping: Record "Data Exch. Field Grouping";        IntrastatReportLine: Record "Intrastat Report Line";        DataExchMapping: Record "Data Exch. Mapping";        DataExchDef: Record "Data Exch. Def";        DataExchMappingCard: Page "Data Exch Mapping Card";        RecordRefSrc: RecordRef;        OutStreamFilters: OutStream;        FirstLineNo, LastLineNo : Integer;        DataExchEntryNoFilter: Text;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeExportOneDataExchangeDef(IntrastatReportHeader, DataExchDefCode, ExportType, DataExch, IsHandled);        if not IsHandled then begin            DataExchMapping.SetRange("Data Exch. Def Code", DataExchDefCode);            DataExchMapping.SetRange("Table ID", Database::"Intrastat Report Line");            if not DataExchMapping.FindFirst() then                Error(NoDataExchMappingErr, DataExchMapping.TableCaption, DataExchDef.TableCaption, DataExchDefCode);            if MaxNoOfLines <> 0 then begin                if (DataExchMapping."Key Index" <> 1) then                    Error(MaximumLinesErr, DataExch.TableCaption(), DataExchMappingCard.Caption());                DataExchFieldGrouping.SetRange("Data Exch. Def Code", DataExchMapping."Data Exch. Def Code");                DataExchFieldGrouping.SetRange("Data Exch. Line Def Code", DataExchMapping."Data Exch. Line Def Code");                DataExchFieldGrouping.SetRange("Table ID", DataExchMapping."Table ID");                if not DataExchFieldGrouping.IsEmpty then                    Error(MaximumLinesErr, DataExch.TableCaption(), DataExchMappingCard.Caption());            end;            if DataExchMapping."Key Index" <> 0 then begin                RecordRefSrc.GetTable(IntrastatReportLine);                RecordRefSrc.CurrentKeyIndex(DataExchMapping."Key Index");                RecordRefSrc.SetTable(IntrastatReportLine);            end;            IntrastatReportLine.SetRange("Intrastat No.", IntrastatReportHeader."No.");            if ExportType = 1 then // Receipt                IntrastatReportLine.SetRange(Type, IntrastatReportLine.Type::Receipt);            if ExportType = 2 then // Shipment                IntrastatReportLine.SetRange(Type, IntrastatReportLine.Type::Shipment);            OnBeforeExportIntrastatReportLines(IntrastatReportLine, IntrastatReportHeader);            if IntrastatReportLine.FindSet() then begin                repeat                    if MaxNoOfLines > 0 then begin                        FirstLineNo := IntrastatReportLine."Line No.";                        if IntrastatReportLine.Next(MaxNoOfLines - 1) <> (MaxNoOfLines - 1) then                            IntrastatReportLine.FindLast();                        LastLineNo := IntrastatReportLine."Line No.";                        IntrastatReportLine.SetRange("Line No.", FirstLineNo, LastLineNo);                    end else                        IntrastatReportLine.FindLast();                    DataExchFieldGrouping.SetRange("Data Exch. Def Code", DataExchMapping."Data Exch. Def Code");                    DataExchFieldGrouping.SetRange("Data Exch. Line Def Code", DataExchMapping."Data Exch. Line Def Code");                    DataExchFieldGrouping.SetRange("Table ID", DataExchMapping."Table ID");                    SetInternalRefNo(IntrastatReportLine, DataExchFieldGrouping, IntrastatReportHeader);                    DataExch.Init();                    DataExch."Entry No." := 0;                    DataExch."Data Exch. Def Code" := DataExchMapping."Data Exch. Def Code";                    DataExch."Data Exch. Line Def Code" := DataExchMapping."Data Exch. Line Def Code";                    DataExch."Table Filters".CreateOutStream(OutStreamFilters);                    OutStreamFilters.WriteText(IntrastatReportLine.GetView(false));                    if DataExch.Insert(true) then                        DataExch.ExportFromDataExch(DataExchMapping);                    DataExch.Modify(true);                    if MaxNoOfLines > 0 then                        IntrastatReportLine.SetRange("Line No.");                    DataExchEntryNoFilter += Format(DataExch."Entry No.") + '|';                until IntrastatReportLine.Next() = 0;                DataExchEntryNoFilter := DataExchEntryNoFilter.Substring(1, StrLen(DataExchEntryNoFilter) - 1);                DataExch.SetFilter("Entry No.", DataExchEntryNoFilter);            end;        end;    end;    local procedure ExportToZip(var DataExch1: Record "Data Exch."; var DataExch2: Record "Data Exch."; StatisticsPeriod: Code[10]; FileName: Text; ReceiptFileName: Text; ShipmentFileName: Text; ZipFileName: Text)    var        DataCompression: Codeunit "Data Compression";        ZipTempBlob: Codeunit "Temp Blob";        ServerShipmentsInStream: InStream;        ServerReceiptsInStream: InStream;        ZipInStream: InStream;        ZipOutStream: OutStream;        IsHandled: Boolean;        I: Integer;    begin        IsHandled := false;        OnBeforeExportToZip(DataExch1, DataExch2, StatisticsPeriod, FileName, ReceiptFileName, ShipmentFileName, ZipFileName, IsHandled);        if IsHandled then            exit;        DataCompression.CreateZipArchive();        if DataExch2."File Content".HasValue() then            FileName := ReceiptFileName;        if DataExch1.GetFilter("Entry No.") <> '' then            if DataExch1.FindSet() then                repeat                    I += 1;                    DataExch1.CalcFields("File Content");                    if not DataExch1."File Content".HasValue() then                        Error(ExternalContentErr, DataExch1.FieldCaption("File Content"));                    DataExch1."File Content".CreateInStream(ServerReceiptsInStream);                    DataCompression.AddEntry(ServerReceiptsInStream, GetFileName(FileName, I, DataExch1.Count() > 1));                until DataExch1.Next() = 0;        I := 0;        if DataExch2.GetFilter("Entry No.") <> '' then            if DataExch2.FindSet() then                repeat                    I += 1;                    DataExch2.CalcFields("File Content");                    if not DataExch2."File Content".HasValue() then                        Error(ExternalContentErr, DataExch2.FieldCaption("File Content"));                    DataExch2."File Content".CreateInStream(ServerShipmentsInStream);                    DataCompression.AddEntry(ServerShipmentsInStream, GetFileName(ShipmentFileName, I, DataExch2.Count() > 1));                until DataExch2.Next() = 0;        ZipTempBlob.CreateOutStream(ZipOutStream);        DataCompression.SaveZipArchive(ZipOutStream);        DataCompression.CloseZipArchive();        ZipTempBlob.CreateInStream(ZipInStream);        DownloadFromStream(ZipInStream, '', '', '', ZipFileName);    end;    local procedure GetFileName(FileName: Text; I: Integer; SplitFiles: Boolean): Text    begin        if not SplitFiles then            exit(FileName);        exit(FileName.Substring(1, FileName.LastIndexOf('.') - 1) + '_' + Format(I) + FileName.Substring(FileName.LastIndexOf('.')));    end;    procedure ExportToFile(DataExch: Record "Data Exch."; var TempBlob: Codeunit "Temp Blob"; FileName: Text)    var        FileMgt: Codeunit "File Management";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeExportToFile(DataExch, FileName, IsHandled);        if IsHandled then            exit;        if FileMgt.BLOBExport(TempBlob, FileName, true) = '' then            Error(DownloadFromStreamErr);    end;    local procedure SetInternalRefNo(var IntrastatReportLine: Record "Intrastat Report Line"; var DataExchFieldGrouping: Record "Data Exch. Field Grouping"; IntrastatReportHeader: Record "Intrastat Report Header")    var        CompoundField: Text;        PrevCompoundField: Text;        IntraReferenceNo: Text[10];        PrevType: Enum "Intrastat Report Line Type";        ProgressiveNo: Integer;    begin        if not IntrastatReportLine.FindSet() then            exit;        ProgressiveNo := 0;        IntraReferenceNo := PadStr(IntrastatReportHeader."Statistics Period", MaxStrLen(IntraReferenceNo), '0');        repeat            CompoundField := GetCompound(DataExchFieldGrouping, IntrastatReportLine);            if CompoundField = '' then                CompoundField := Format(IntrastatReportLine."Line No.");            // IntraReferenceNo is a group identifier string, consisting of fields specified in data exchange field grouping            if (PrevType <> IntrastatReportLine.Type) or (StrLen(PrevCompoundField) = 0) then begin                PrevType := IntrastatReportLine.Type;                IntraReferenceNo := CopyStr(IntraReferenceNo, 1, 4) + Format(IntrastatReportLine.Type, 1, 2) + '01001';                ProgressiveNo += 1;            end else                if PrevCompoundField <> CompoundField then begin                    if CopyStr(IntraReferenceNo, 8, 3) = '999' then                        IntraReferenceNo := CopyStr(IncStr(CopyStr(IntraReferenceNo, 1, 7)), 1, 7) + '001'                    else                        IntraReferenceNo := IncStr(IntraReferenceNo);                    ProgressiveNo += 1;                end;            IntrastatReportLine."Progressive No." := Format(ProgressiveNo);            IntrastatReportLine."Internal Ref. No." := IntraReferenceNo;            OnBeforeUpdateInternalRefNo(IntrastatReportLine, CompoundField, PrevCompoundField);            IntrastatReportLine.Modify();            PrevCompoundField := CompoundField;        until IntrastatReportLine.Next() = 0;    end;    local procedure GetCompound(var DataExchFieldGrouping: Record "Data Exch. Field Grouping"; IntrastatReportLine: Record "Intrastat Report Line") Compound: Text    var        RecordRef: RecordRef;        FieldRef: FieldRef;    begin        RecordRef.GetTable(IntrastatReportLine);        if DataExchFieldGrouping.FindSet() then            repeat                FieldRef := RecordRef.Field(DataExchFieldGrouping."Field ID");                Compound += Format(FieldRef.Value, FieldRef.Length);            until DataExchFieldGrouping.Next() = 0;    end;    procedure InitSetup(var IntrastatReportSetup: Record "Intrastat Report Setup")    var        IntrastatReportChecklist: Record "Intrastat Report Checklist";        NoSeries: Record "No. Series";        NoSeriesLine: Record "No. Series Line";        IsHandled: Boolean;    begin        if IntrastatReportSetup.Get() then            IntrastatReportSetup.Delete(true);        if not NoSeries.Get('INTRA') then begin            NoSeries.Init();            NoSeries.Code := 'INTRA';            NoSeries.Description := 'Intrastat';            NoSeries.Validate("Default Nos.", true);            NoSeries.Validate("Manual Nos.", true);            NoSeries.Insert(true);            NoSeriesLine.Init();            NoSeriesLine."Series Code" := 'INTRA';            NoSeriesLine."Line No." := 10000;            NoSeriesLine.Validate("Starting No.", 'INTRA00001');            NoSeriesLine.Insert(true);            NoSeriesLine.Validate(Implementation, Enum::"No. Series Implementation"::Sequence);            NoSeriesLine.Modify(true);        end;        IntrastatReportSetup.Init();        IntrastatReportSetup.Validate("Intrastat Nos.", NoSeries.Code);        IntrastatReportSetup.Insert();        IsHandled := false;        OnBeforeInitSetup(IntrastatReportSetup, IsHandled);        if not IsHandled then begin            IntrastatReportSetup."Shipments Based On" := IntrastatReportSetup."Shipments Based On"::"Ship-to Country";            IntrastatReportSetup."Get Partner VAT For" := IntrastatReportSetup."Get Partner VAT For"::Shipment;            IntrastatReportSetup."Sales VAT No. Based On" := IntrastatReportSetup."Sales VAT No. Based On"::Document;            IntrastatReportSetup."Def. Private Person VAT No." := 'QV999999999999';            IntrastatReportSetup."Def. 3-Party Trade VAT No." := 'QV999999999999';            IntrastatReportSetup."Def. VAT for Unknown State" := 'QV999999999999';            IntrastatReportSetup.Modify();            CreateDefaultDataExchangeDef();        end;        IntrastatReportChecklist.DeleteAll(true);        IsHandled := false;        OnBeforeInitCheckList(IsHandled);        if not IsHandled then begin            IntrastatReportChecklist.Init();            IntrastatReportChecklist.Validate("Field No.", 5);            IntrastatReportChecklist.Insert(true);            IntrastatReportChecklist.Init();            IntrastatReportChecklist.Validate("Field No.", 7);            IntrastatReportChecklist.Insert(true);            IntrastatReportChecklist.Init();            IntrastatReportChecklist.Validate("Field No.", 8);            IntrastatReportChecklist.Insert(true);            IntrastatReportChecklist.Init();            IntrastatReportChecklist.Validate("Field No.", 14);            IntrastatReportChecklist.Validate("Filter Expression", 'Supplementary Units: True');            IntrastatReportChecklist.Insert(true);            IntrastatReportChecklist.Init();            IntrastatReportChecklist.Validate("Field No.", 21);            IntrastatReportChecklist.Validate("Filter Expression", 'Supplementary Units: False');            IntrastatReportChecklist.Insert(true);            IntrastatReportChecklist.Init();            IntrastatReportChecklist.Validate("Field No.", 24);            IntrastatReportChecklist.Validate("Filter Expression", 'Type: Shipment');            IntrastatReportChecklist.Insert(true);            IntrastatReportChecklist.Init();            IntrastatReportChecklist.Validate("Field No.", 29);            IntrastatReportChecklist.Validate("Filter Expression", 'Type: Shipment');            IntrastatReportChecklist.Insert(true);        end;    end;    internal procedure CreateDefaultDataExchangeDef()    var        IntrastatReportSetup: Record "Intrastat Report Setup";        DataExchDef: Record "Data Exch. Def";        TempBlob: Codeunit "Temp Blob";        IsHandled: Boolean;        XMLOutStream: OutStream;        XMLInStream: InStream;    begin        IsHandled := false;        OnBeforeCreateDefaultDataExchangeDef(IsHandled);        if IsHandled then            exit;        if DataExchDef.Get('INTRA-2022') then            DataExchDef.Delete(true);        TempBlob.CreateOutStream(XMLOutStream);        XMLOutStream.WriteText(DataExchangeXMLTxt);        TempBlob.CreateInStream(XMLInStream);        Xmlport.Import(Xmlport::"Imp / Exp Data Exch Def & Map", XMLInStream);        IntrastatReportSetup.Get();        IntrastatReportSetup."Data Exch. Def. Code" := 'INTRA-2022';        IntrastatReportSetup.Modify();    end;    internal procedure ReCreateDefaultDataExchangeDef()    var        DataExchDefCard: Page "Data Exch Def Card";    begin        if Confirm(StrSubstNo(ImportDefaultIntrastatDataExchDefConfirmQst, DataExchDefCard.Caption)) then            CreateDefaultDataExchangeDef();    end;    procedure UpdateItemUOM(var ItemUOM: Record "Item Unit of Measure"; TariffNumber: Record "Tariff Number")    var        Item: Record Item;        BaseItemUOM: Record "Item Unit of Measure";        RoundingPrecision: Decimal;    begin        Item.Get(ItemUOM."Item No.");        if BaseItemUOM.Get(Item."No.", Item."Base Unit of Measure") then            RoundingPrecision := BaseItemUOM."Qty. Rounding Precision";        if RoundingPrecision = 0 then            RoundingPrecision := 0.00001;        if TariffNumber."Suppl. Conversion Factor" <> 0 then            ItemUOM.Validate("Qty. per Unit of Measure", Round(1 / TariffNumber."Suppl. Conversion Factor", RoundingPrecision))        else            ItemUOM.Validate("Qty. per Unit of Measure", 1);        ItemUOM.Modify(true);    end;    internal procedure NotifyUserAboutSupplementaryUnitUpdate()    var        Item: Record Item;        MyNotifications: Record "My Notifications";        SupplementaryUnitUpdateNotification: Notification;    begin        if MyNotifications.IsEnabled(GetSupplementaryUnitUpdateNotificationId()) then begin            SupplementaryUnitUpdateNotification.Id(GetSupplementaryUnitUpdateNotificationId());            SupplementaryUnitUpdateNotification.SetData('NotificationId', GetSupplementaryUnitUpdateNotificationId());            SupplementaryUnitUpdateNotification.Message(StrSubstNo(SupplementaryUnitUpdateNotificationTxt, Item.FieldCaption("Supplementary Unit of Measure"), Item.FieldCaption("Tariff No.")));            SupplementaryUnitUpdateNotification.AddAction(DisableNotificationTxt, Codeunit::IntrastatReportManagement, 'DisableSupplementaryUnitUpdateNotification');            SupplementaryUnitUpdateNotification.Send();        end;    end;    internal procedure DisableSupplementaryUnitUpdateNotification(HostNotification: Notification)    var        Item: Record Item;        MyNotifications: Record "My Notifications";        NotificationId: Text;    begin        NotificationId := HostNotification.GetData('NotificationId');        if MyNotifications.Get(UserId(), NotificationId) then            MyNotifications.Disable(NotificationId)        else            MyNotifications.InsertDefault(NotificationId, StrSubstNo(SupplementaryUnitUpdateNotificationNameTxt, Item.FieldCaption("Supplementary Unit of Measure")),                StrSubstNo(SupplementaryUnitUpdateNotificationDescriptionTxt, Item.FieldCaption("Supplementary Unit of Measure"), Item.FieldCaption("Tariff No.")), false);    end;    procedure IsCustomerPrivatePerson(Customer: Record Customer): Boolean;    begin        if Customer."Intrastat Partner Type" <> "Partner Type"::" " then            exit(Customer."Intrastat Partner Type" = "Partner Type"::Person)        else            exit(Customer."Partner Type" = "Partner Type"::Person);    end;    procedure IsVendorPrivatePerson(Vendor: Record Vendor): Boolean    begin        if Vendor."Intrastat Partner Type" <> "Partner Type"::" " then            exit(Vendor."Intrastat Partner Type" = "Partner Type"::Person)        else            exit(Vendor."Partner Type" = "Partner Type"::Person);    end;    procedure GetIntrastatCodeFromCountryRegion(CountryRegionCode: Code[10]): Code[10]    var        CountryRegion: Record "Country/Region";    begin        CountryRegion.SetLoadFields("Intrastat Code");        if CountryRegion.Get(CountryRegionCode) then            if CountryRegion."Intrastat Code" <> '' then                exit(CountryRegion."Intrastat Code");        exit(CountryRegionCode);    end;    local procedure GetSupplementaryUnitUpdateNotificationId(): Guid;    begin        exit(SupplementaryUnitUpdateNotificationIdTok);    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Guided Experience", 'OnRegisterAssistedSetup', '', true, true)]    local procedure InsertIntoAssistedSetup()    var        GuidedExperience: Codeunit "Guided Experience";        AssistedSetupGroup: Enum "Assisted Setup Group";        VideoCategory: Enum "Video Category";    begin        GuidedExperience.InsertAssistedSetup(AssistedSetupTxt, CopyStr(AssistedSetupTxt, 1, 50), AssistedSetupDescriptionTxt, 5, ObjectType::Page, Page::"Intrastat Report Setup Wizard", AssistedSetupGroup::FinancialReporting,                                            '', VideoCategory::FinancialReporting, LearnMoreLinkTok);    end;    [IntegrationEvent(true, false)]    local procedure OnBeforeReleaseIntrastatHeader(var IntrastatReportHeader: Record "Intrastat Report Header"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(true, false)]    local procedure OnAfterReleaseIntrastatHeader(var IntrastatReportHeader: Record "Intrastat Report Header")    begin    end;    [IntegrationEvent(true, false)]    local procedure OnBeforeReopenIntrastatHeader(var IntrastatReportHeader: Record "Intrastat Report Header"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(true, false)]    local procedure OnAfterReopenIntrastatHeader(var IntrastatReportHeader: Record "Intrastat Report Header")    begin    end;    [IntegrationEvent(true, false)]    local procedure OnBeforeExportIntrastatHeader(var IntrastatReportHeader: Record "Intrastat Report Header"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(true, false)]    local procedure OnAfterExportIntrastatHeader(var IntrastatReportHeader: Record "Intrastat Report Header"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeExportToFile(DataExch: Record "Data Exch."; var FileName: Text; var Handled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeExportToZip(DataExch1: Record "Data Exch."; DataExch2: Record "Data Exch."; StatisticsPeriod: Text; var FileName: Text; var ReceptFileName: Text; var ShipmentFileName: Text; var ZipFileName: Text; var IsHandled: Boolean);    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInitSetup(var IntrastatReportSetup: Record "Intrastat Report Setup"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInitCheckList(var IsHandled: Boolean)    begin    end;    [IntegrationEvent(true, false)]    local procedure OnBeforeDefineFileNames(var IntrastatReportHeader: Record "Intrastat Report Header"; var FileName: Text; var ReceptFileName: Text; var ShipmentFileName: Text; var ZipFileName: Text; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(true, false)]    local procedure OnBeforeUpdateInternalRefNo(var IntrastatReportLine: Record "Intrastat Report Line"; var CompoundField: Text; var PrevCompoundField: Text);    begin    end;    [IntegrationEvent(true, false)]    local procedure OnBeforeExportOneDataExchangeDef(var IntrastatReportHeader: Record "Intrastat Report Header"; DataExchDefCode: Code[20]; ExportType: Integer; var DataExch: Record "Data Exch."; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(true, false)]    local procedure OnBeforeValidateReportWithAdvancedChecklist(var IntrastatReportLine: Record "Intrastat Report Line"; IntrastatReportHeader: Record "Intrastat Report Header");    begin    end;    [IntegrationEvent(true, false)]    local procedure OnBeforeExportIntrastatReportLines(var IntrastatReportLine: Record "Intrastat Report Line"; IntrastatReportHeader: Record "Intrastat Report Header");    begin    end;    [IntegrationEvent(true, false)]    local procedure OnBeforeCreateDefaultDataExchangeDef(var IsHandled: Boolean);    begin    end;    [IntegrationEvent(true, false)]    local procedure OnAfterGetIntrastatBaseCountryCodeFromFAEntry(var FALedgerEntry: Record "FA Ledger Entry"; var IntrastatReportSetup: Record "Intrastat Report Setup"; var CountryCode: Code[10]);    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeGetIntrastatBaseCountryCode(var ItemLedgerEntry: Record "Item Ledger Entry"; var IntrastatReportSetup: Record "Intrastat Report Setup"; var CountryCode: Code[10]; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeGetVATRegNo(CountryCode: Code[10]; VATRegNo: Text[20]; VATRegNoType: Enum "Intrastat Report VAT File Fmt"; var Result: Text[50]; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeGetIntrastatBaseCountryCodeFromJLE(var JobLedgerEntry: Record "Job Ledger Entry"; var IntrastatReportSetup: Record "Intrastat Report Setup"; var CountryCode: Code[10]; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeGetIntrastatBaseCountryCodeFromFALE(var FALedgerEntry: Record "FA Ledger Entry"; var IntrastatReportSetup: Record "Intrastat Report Setup"; var CountryCode: Code[10]; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnGetCompanyVATRegNoOnAfterGetIntrastatReportSetup(var CompanyInformation: Record "Company Information"; var IntrastatReportSetup: Record "Intrastat Report Setup")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnExportWithDataExchOnAfterGetIntrastatReportSetup(var IntrastatReportSetup: Record "Intrastat Report Setup"; var IntrastatReportHeader: Record "Intrastat Report Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnGetIntrastatBaseCountryCodeFromItemLedgerElseCase(ItemLedgerEntry: Record "Item Ledger Entry"; IntrastatReportSetup: Record "Intrastat Report Setup"; var CountryCode: Code[10])    begin    end;    [IntegrationEvent(false, false)]    local procedure OnGetOriginalCurrencyFromItemLedgerElseCase(ItemLedgerEntry: Record "Item Ledger Entry"; var CurrencyCode: Code[10])    begin    end;    [IntegrationEvent(false, false)]    local procedure OnRecalculateWeightAndSupplUOMQtyOnAfterCalculateNetWeight(var IntrastatReportLine: Record "Intrastat Report Line"; var NetWeight: Decimal)    begin    end;}