Codeunit 1901 Report Selection Mgt.

Base Application, Microsoft.Foundation.Reporting

src/Layers/W1/BaseApp/Foundation/Reporting/ReportSelectionMgt.Codeunit.al495 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.Foundation.Reporting;using Microsoft.Assembly.Document;using Microsoft.Assembly.History;using Microsoft.Bank.Check;using Microsoft.Bank.Reports;using Microsoft.Inventory.Counting.Reports;using Microsoft.Inventory.Reports;using Microsoft.Inventory.Transfer;using Microsoft.Projects.Project.Reports;using Microsoft.Purchases.Archive;using Microsoft.Purchases.Document;using Microsoft.Purchases.History;using Microsoft.Purchases.Reports;using Microsoft.Sales.Archive;using Microsoft.Sales.Customer;using Microsoft.Sales.Document;using Microsoft.Sales.FinanceCharge;using Microsoft.Sales.History;using Microsoft.Sales.Reminder;using Microsoft.Sales.Reports;using Microsoft.Warehouse.Document;using Microsoft.Warehouse.History;using Microsoft.Warehouse.Reports;using Microsoft.Warehouse.Setup;codeunit 1901 "Report Selection Mgt."{    trigger OnRun()    begin    end;    procedure InitReportSelectionSales()    begin        OnBeforeInitReportSelectionSales();        InitReportSelection("Report Selection Usage"::"Pro Forma S. Invoice");        InitReportSelection("Report Selection Usage"::"S.Invoice Draft");        InitReportSelection("Report Selection Usage"::"S.Quote");        InitReportSelection("Report Selection Usage"::"S.Blanket");        InitReportSelection("Report Selection Usage"::"S.Order");        InitReportSelection("Report Selection Usage"::"S.Work Order");        InitReportSelection("Report Selection Usage"::"S.Invoice");        InitReportSelection("Report Selection Usage"::"S.Return");        InitReportSelection("Report Selection Usage"::"S.Cr.Memo");        InitReportSelection("Report Selection Usage"::"S.Shipment");        InitReportSelection("Report Selection Usage"::"S.Ret.Rcpt.");        InitReportSelection("Report Selection Usage"::"S.Test");        InitReportSelection("Report Selection Usage"::"S.Test Prepmt.");        InitReportSelection("Report Selection Usage"::"S.Arch.Quote");        InitReportSelection("Report Selection Usage"::"S.Arch.Order");        InitReportSelection("Report Selection Usage"::"S.Arch.Return");        InitReportSelection("Report Selection Usage"::"S.Arch.Blanket");        InitReportSelection("Report Selection Usage"::"S.Order Pick Instruction");        OnAfterInitReportSelectionSales();    end;    procedure InitReportSelectionPurch()    begin        OnBeforeInitReportSelectionPurch();        InitReportSelection("Report Selection Usage"::"P.Quote");        InitReportSelection("Report Selection Usage"::"P.Blanket");        InitReportSelection("Report Selection Usage"::"P.Order");        InitReportSelection("Report Selection Usage"::"P.Invoice");        InitReportSelection("Report Selection Usage"::"P.Self Billing Invoice");        InitReportSelection("Report Selection Usage"::"P.Return");        InitReportSelection("Report Selection Usage"::"P.Cr.Memo");        InitReportSelection("Report Selection Usage"::"P.Receipt");        InitReportSelection("Report Selection Usage"::"P.Ret.Shpt.");        InitReportSelection("Report Selection Usage"::"P.Test");        InitReportSelection("Report Selection Usage"::"P.Test Prepmt.");        InitReportSelection("Report Selection Usage"::"P.Arch.Quote");        InitReportSelection("Report Selection Usage"::"P.Arch.Order");        InitReportSelection("Report Selection Usage"::"P.Arch.Return");        InitReportSelection("Report Selection Usage"::"P.Arch.Blanket");        InitReportSelection("Report Selection Usage"::"V.Remittance");        InitReportSelection("Report Selection Usage"::"P.V.Remit.");        OnAfterInitReportSelectionPurch();    end;    procedure InitReportSelectionInvt()    begin        OnBeforeInitReportSelectionInvt();        InitReportSelection("Report Selection Usage"::Inv1);        InitReportSelection("Report Selection Usage"::Inv2);        InitReportSelection("Report Selection Usage"::Inv3);        InitReportSelection("Report Selection Usage"::"Invt.Period Test");        InitReportSelection("Report Selection Usage"::"Phys.Invt.Order Test");        InitReportSelection("Report Selection Usage"::"Phys.Invt.Order");        InitReportSelection("Report Selection Usage"::"P.Phys.Invt.Order");        InitReportSelection("Report Selection Usage"::"Phys.Invt.Rec.");        InitReportSelection("Report Selection Usage"::"P.Phys.Invt.Rec.");        InitReportSelection("Report Selection Usage"::"Asm.Order");        InitReportSelection("Report Selection Usage"::"P.Asm.Order");        OnAfterInitReportSelectionInvt();    end;    procedure InitReportSelectionBank()    begin        OnBeforeInitReportSelectionBank();        InitReportSelection("Report Selection Usage"::"B.Stmt");        InitReportSelection("Report Selection Usage"::"B.Recon.Test");        InitReportSelection("Report Selection Usage"::"B.Check");        InitReportSelection("Report Selection Usage"::"Posted Payment Reconciliation");        OnAfterInitReportSelectionBank();    end;    procedure InitReportSelectionCust()    begin        OnBeforeInitReportSelectionCust();        InitReportSelection("Report Selection Usage"::Reminder);        InitReportSelection("Report Selection Usage"::"Fin.Charge");        InitReportSelection("Report Selection Usage"::"Rem.Test");        InitReportSelection("Report Selection Usage"::"F.C.Test");        InitReportSelection("Report Selection Usage"::"C.Statement");        OnAfterInitReportSelectionCust();    end;    procedure InitReportSelectionServ()    begin        OnBeforeInitReportSelectionServ();        OnAfterInitReportSelectionServ();    end;    procedure InitReportSelectionProd()    begin        OnBeforeInitReportSelectionProd();        OnAfterInitReportSelectionProd();    end;    procedure InitReportSelectionWhse()    begin        OnBeforeInitReportSelectionWhse();        InitReportSelectionWhse("Report Selection Warehouse Usage"::Pick);        InitReportSelectionWhse("Report Selection Warehouse Usage"::"Put-away");        InitReportSelectionWhse("Report Selection Warehouse Usage"::Movement);        InitReportSelectionWhse("Report Selection Warehouse Usage"::"Invt. Pick");        InitReportSelectionWhse("Report Selection Warehouse Usage"::"Invt. Put-away");        InitReportSelectionWhse("Report Selection Warehouse Usage"::"Invt. Movement");        InitReportSelectionWhse("Report Selection Warehouse Usage"::Receipt);        InitReportSelectionWhse("Report Selection Warehouse Usage"::"Posted Receipt");        InitReportSelectionWhse("Report Selection Warehouse Usage"::Shipment);        InitReportSelectionWhse("Report Selection Warehouse Usage"::"Posted Shipment");        OnAfterInitReportSelectionWhse();    end;    procedure InitReportSelectionJob()    begin        OnBeforeInitReportSelectionJobs();        InitReportSelection("Report Selection Usage"::JQ);        InitReportSelection("Report Selection Usage"::"Job Task Quote");        OnAfterInitReportSelectionJobs();    end;    procedure InitReportSelection(ReportUsage: Enum "Report Selection Usage")    begin        case ReportUsage of            "Report Selection Usage"::"Pro Forma S. Invoice":                InsertRepSelection("Report Selection Usage"::"Pro Forma S. Invoice", '1', REPORT::"Standard Sales - Pro Forma Inv");            "Report Selection Usage"::"S.Invoice Draft":                InsertRepSelection("Report Selection Usage"::"S.Invoice Draft", '1', REPORT::"Standard Sales - Draft Invoice");            "Report Selection Usage"::"S.Quote":                InsertRepSelection("Report Selection Usage"::"S.Quote", '1', REPORT::"Standard Sales - Quote");            "Report Selection Usage"::"S.Blanket":                InsertRepSelection("Report Selection Usage"::"S.Blanket", '1', REPORT::"Blanket Sales Order");            "Report Selection Usage"::"S.Order":                InsertRepSelection("Report Selection Usage"::"S.Order", '1', REPORT::"Standard Sales - Order Conf.");            "Report Selection Usage"::"S.Work Order":                InsertRepSelection("Report Selection Usage"::"S.Work Order", '1', REPORT::"Work Order");            "Report Selection Usage"::"S.Invoice":                InsertRepSelection("Report Selection Usage"::"S.Invoice", '1', REPORT::"Standard Sales - Invoice");            "Report Selection Usage"::"S.Return":                InsertRepSelection("Report Selection Usage"::"S.Return", '1', REPORT::"Return Order Confirmation");            "Report Selection Usage"::"S.Cr.Memo":                InsertRepSelection("Report Selection Usage"::"S.Cr.Memo", '1', REPORT::"Standard Sales - Credit Memo");            "Report Selection Usage"::"S.Shipment":                InsertRepSelection("Report Selection Usage"::"S.Shipment", '1', REPORT::"Sales - Shipment");            "Report Selection Usage"::"S.Ret.Rcpt.":                InsertRepSelection("Report Selection Usage"::"S.Ret.Rcpt.", '1', REPORT::"Sales - Return Receipt");            "Report Selection Usage"::"S.Test":                InsertRepSelection("Report Selection Usage"::"S.Test", '1', REPORT::"Sales Document - Test");            "Report Selection Usage"::"P.Quote":                InsertRepSelection("Report Selection Usage"::"P.Quote", '1', REPORT::"Purchase - Quote");            "Report Selection Usage"::"P.Blanket":                InsertRepSelection("Report Selection Usage"::"P.Blanket", '1', REPORT::"Blanket Purchase Order");            "Report Selection Usage"::"P.Order":                InsertRepSelection("Report Selection Usage"::"P.Order", '1', REPORT::Order);            "Report Selection Usage"::"P.Invoice":                InsertRepSelection("Report Selection Usage"::"P.Invoice", '1', REPORT::"Purchase - Invoice");            "Report Selection Usage"::"P.Self Billing Invoice":                InsertRepSelection("Report Selection Usage"::"P.Self Billing Invoice", '1', REPORT::"Self Billing Invoice");            "Report Selection Usage"::"P.Return":                InsertRepSelection("Report Selection Usage"::"P.Return", '1', REPORT::"Return Order");            "Report Selection Usage"::"P.Cr.Memo":                InsertRepSelection("Report Selection Usage"::"P.Cr.Memo", '1', REPORT::"Purchase - Credit Memo");            "Report Selection Usage"::"P.Receipt":                InsertRepSelection("Report Selection Usage"::"P.Receipt", '1', REPORT::"Purchase - Receipt");            "Report Selection Usage"::"P.Ret.Shpt.":                InsertRepSelection("Report Selection Usage"::"P.Ret.Shpt.", '1', REPORT::"Purchase - Return Shipment");            "Report Selection Usage"::"P.Test":                InsertRepSelection("Report Selection Usage"::"P.Test", '1', REPORT::"Purchase Document - Test");            "Report Selection Usage"::"B.Stmt":                InsertRepSelection("Report Selection Usage"::"B.Stmt", '1', REPORT::"Bank Account Statement");            "Report Selection Usage"::"B.Recon.Test":                InsertRepSelection("Report Selection Usage"::"B.Recon.Test", '1', REPORT::"Bank Acc. Recon. - Test");            "Report Selection Usage"::"B.Check":                InsertRepSelection("Report Selection Usage"::"B.Check", '1', REPORT::Check);            "Report Selection Usage"::Reminder:                InsertRepSelection("Report Selection Usage"::Reminder, '1', REPORT::Reminder);            "Report Selection Usage"::"Fin.Charge":                InsertRepSelection("Report Selection Usage"::"Fin.Charge", '1', REPORT::"Finance Charge Memo");            "Report Selection Usage"::"Rem.Test":                InsertRepSelection("Report Selection Usage"::"Rem.Test", '1', REPORT::"Reminder - Test");            "Report Selection Usage"::"F.C.Test":                InsertRepSelection("Report Selection Usage"::"F.C.Test", '1', REPORT::"Finance Charge Memo - Test");            "Report Selection Usage"::Inv1:                InsertRepSelection("Report Selection Usage"::Inv1, '1', REPORT::"Transfer Order");            "Report Selection Usage"::Inv2:                InsertRepSelection("Report Selection Usage"::Inv2, '1', REPORT::"Transfer Shipment");            "Report Selection Usage"::Inv3:                InsertRepSelection("Report Selection Usage"::Inv3, '1', REPORT::"Transfer Receipt");            "Report Selection Usage"::"Invt.Period Test":                InsertRepSelection("Report Selection Usage"::"Invt.Period Test", '1', REPORT::"Close Inventory Period - Test");            "Report Selection Usage"::"Phys.Invt.Order Test":                InsertRepSelection("Report Selection Usage"::"Phys.Invt.Order Test", '1', REPORT::"Phys. Invt. Order - Test");            "Report Selection Usage"::"Phys.Invt.Order":                InsertRepSelection("Report Selection Usage"::"Phys.Invt.Order", '1', REPORT::"Phys. Invt. Order Diff. List");            "Report Selection Usage"::"P.Phys.Invt.Order":                InsertRepSelection("Report Selection Usage"::"P.Phys.Invt.Order", '1', REPORT::"Posted Phys. Invt. Order Diff.");            "Report Selection Usage"::"Phys.Invt.Rec.":                InsertRepSelection("Report Selection Usage"::"Phys.Invt.Rec.", '1', REPORT::"Phys. Invt. Recording");            "Report Selection Usage"::"P.Phys.Invt.Rec.":                InsertRepSelection("Report Selection Usage"::"P.Phys.Invt.Rec.", '1', REPORT::"Posted Phys. Invt. Recording");            "Report Selection Usage"::"Asm.Order":                InsertRepSelection("Report Selection Usage"::"Asm.Order", '1', REPORT::"Assembly Order");            "Report Selection Usage"::"P.Asm.Order":                InsertRepSelection("Report Selection Usage"::"P.Asm.Order", '1', REPORT::"Posted Assembly Order");            "Report Selection Usage"::"S.Test Prepmt.":                InsertRepSelection("Report Selection Usage"::"S.Test Prepmt.", '1', REPORT::"Sales Prepmt. Document Test");            "Report Selection Usage"::"P.Test Prepmt.":                InsertRepSelection("Report Selection Usage"::"P.Test Prepmt.", '1', REPORT::"Purchase Prepmt. Doc. - Test");            "Report Selection Usage"::"S.Arch.Quote":                InsertRepSelection("Report Selection Usage"::"S.Arch.Quote", '1', REPORT::"Archived Sales Quote");            "Report Selection Usage"::"S.Arch.Order":                InsertRepSelection("Report Selection Usage"::"S.Arch.Order", '1', REPORT::"Archived Sales Order");            "Report Selection Usage"::"P.Arch.Quote":                InsertRepSelection("Report Selection Usage"::"P.Arch.Quote", '1', REPORT::"Archived Purchase Quote");            "Report Selection Usage"::"P.Arch.Order":                InsertRepSelection("Report Selection Usage"::"P.Arch.Order", '1', REPORT::"Archived Purchase Order");            "Report Selection Usage"::"P.Arch.Return":                InsertRepSelection("Report Selection Usage"::"P.Arch.Return", '1', REPORT::"Arch.Purch. Return Order");            "Report Selection Usage"::"S.Arch.Return":                InsertRepSelection("Report Selection Usage"::"S.Arch.Return", '1', REPORT::"Arch. Sales Return Order");            "Report Selection Usage"::"S.Arch.Blanket":                InsertRepSelection("Report Selection Usage"::"S.Arch.Blanket", '1', REPORT::"Archived Blanket Sales Order");            "Report Selection Usage"::"P.Arch.Blanket":                InsertRepSelection("Report Selection Usage"::"P.Arch.Blanket", '1', REPORT::"Archived Blanket Purch. Order");            "Report Selection Usage"::"V.Remittance":                InsertRepSelectionForEmailAttachment("Report Selection Usage"::"V.Remittance", '1', REPORT::"Remittance Advice - Journal");            "Report Selection Usage"::"P.V.Remit.":                InsertRepSelectionForEmailAttachment("Report Selection Usage"::"P.V.Remit.", '1', REPORT::"Remittance Advice - Entries");            "Report Selection Usage"::"S.Order Pick Instruction":                InsertRepSelection("Report Selection Usage"::"S.Order Pick Instruction", '1', REPORT::"Pick Instruction");            "Report Selection Usage"::"C.Statement":                InsertRepSelection("Report Selection Usage"::"C.Statement", '1', REPORT::"Standard Statement");            "Report Selection Usage"::"Posted Payment Reconciliation":                InsertRepSelection("Report Selection Usage"::"Posted Payment Reconciliation", '1', REPORT::"Posted Payment Reconciliation");            "Report Selection Usage"::JQ:                InsertRepSelection("Report Selection Usage"::JQ, '1', Report::"Job Quote");            "Report Selection Usage"::"Job Task Quote":                InsertRepSelection("Report Selection Usage"::"Job Task Quote", '1', Report::"Job Task Quote");            else                OnInitReportUsage(ReportUsage.AsInteger());        end;    end;    procedure InitReportSelectionWhse(ReportUsage: Enum "Report Selection Warehouse Usage")    begin        case ReportUsage of            "Report Selection Warehouse Usage"::Pick:                InsertReportSelectionWhse("Report Selection Warehouse Usage"::Pick, '1', REPORT::"Picking List");            "Report Selection Warehouse Usage"::"Put-away":                InsertReportSelectionWhse("Report Selection Warehouse Usage"::"Put-away", '1', REPORT::"Put-away List");            "Report Selection Warehouse Usage"::Movement:                InsertReportSelectionWhse("Report Selection Warehouse Usage"::Movement, '1', REPORT::"Movement List");            "Report Selection Warehouse Usage"::"Invt. Pick":                InsertReportSelectionWhse("Report Selection Warehouse Usage"::"Invt. Pick", '1', REPORT::"Picking List");            "Report Selection Warehouse Usage"::"Invt. Put-away":                InsertReportSelectionWhse("Report Selection Warehouse Usage"::"Invt. Put-away", '1', REPORT::"Put-away List");            "Report Selection Warehouse Usage"::"Invt. Movement":                InsertReportSelectionWhse("Report Selection Warehouse Usage"::"Invt. Movement", '1', REPORT::"Movement List");            "Report Selection Warehouse Usage"::Receipt:                InsertReportSelectionWhse("Report Selection Warehouse Usage"::Receipt, '1', REPORT::"Whse. - Receipt");            "Report Selection Warehouse Usage"::"Posted Receipt":                InsertReportSelectionWhse("Report Selection Warehouse Usage"::"Posted Receipt", '1', REPORT::"Whse. - Posted Receipt");            "Report Selection Warehouse Usage"::Shipment:                InsertReportSelectionWhse("Report Selection Warehouse Usage"::Shipment, '1', REPORT::"Whse. - Shipment");            "Report Selection Warehouse Usage"::"Posted Shipment":                InsertReportSelectionWhse("Report Selection Warehouse Usage"::"Posted Shipment", '1', REPORT::"Whse. - Posted Shipment");            else                OnInitReportUsageWhse(ReportUsage.AsInteger());        end;    end;    local procedure InsertRepSelection(ReportUsage: Enum "Report Selection Usage"; Sequence: Code[10]; ReportID: Integer)    var        ReportSelections: Record "Report Selections";    begin        if not ReportSelections.Get(ReportUsage, Sequence) then begin            ReportSelections.Init();            ReportSelections.Usage := ReportUsage;            ReportSelections.Sequence := Sequence;            ReportSelections."Report ID" := ReportID;            ReportSelections.Insert();        end;    end;    local procedure InsertRepSelectionForEmailAttachment(ReportUsage: Enum "Report Selection Usage"; Sequence: Code[10]; ReportID: Integer)    var        ReportSelections: Record "Report Selections";    begin        if ReportSelections.Get(ReportUsage, Sequence) then            exit;        InsertRepSelection(ReportUsage, Sequence, ReportID);        if ReportSelections.Get(ReportUsage, Sequence) then begin            ReportSelections."Use for Email Attachment" := true;            ReportSelections."Use for Email Body" := false;            ReportSelections.Modify();        end;    end;    procedure ReportSelectionsExist(ReportSelectionUsage: Enum "Report Selection Usage"; ReportID: Integer): Boolean    var        ReportSelections: Record "Report Selections";    begin        if ReportSelections.Get(ReportSelectionUsage, '1') then            exit(ReportSelections."Report ID" = ReportID);        exit(false);    end;    procedure UpdateReportSelection(ReportUsage: Enum "Report Selection Usage"; Sequence: Code[10]; ReportID: Integer)    var        ReportSelections: Record "Report Selections";    begin        if ReportSelections.Get(ReportUsage, Sequence) then begin            ReportSelections.Validate("Report ID", ReportID);            ReportSelections.Modify();        end;    end;    procedure InsertReportSelectionWhse(ReportUsage: Enum "Report Selection Warehouse Usage"; Sequence: Code[10]; ReportID: Integer)    var        ReportSelectionWhse: Record "Report Selection Warehouse";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeInsertRepSelectionWhse(ReportUsage, Sequence, ReportID, IsHandled);        if IsHandled then            exit;        if not ReportSelectionWhse.Get(ReportUsage, Sequence) then begin            ReportSelectionWhse.Init();            ReportSelectionWhse.Usage := ReportUsage;            ReportSelectionWhse.Sequence := Sequence;            ReportSelectionWhse."Report ID" := ReportID;            ReportSelectionWhse.Insert();        end;    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInitReportSelectionSales()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInitReportSelectionPurch()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInitReportSelectionInvt()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInitReportSelectionBank()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInitReportSelectionCust()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInitReportSelectionServ()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInitReportSelectionProd()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInitReportSelectionWhse()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInitReportSelectionJobs()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterInitReportSelectionSales()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterInitReportSelectionPurch()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterInitReportSelectionInvt()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterInitReportSelectionBank()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterInitReportSelectionCust()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterInitReportSelectionServ()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterInitReportSelectionProd()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterInitReportSelectionWhse()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterInitReportSelectionJobs()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInitReportUsage(ReportUsage: Integer)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInitReportUsageWhse(ReportUsage: Integer)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInsertRepSelectionWhse(ReportUsage: Enum "Report Selection Warehouse Usage"; Sequence: Code[10]; ReportID: Integer; var IsHandled: Boolean)    begin    end;}