Codeunit 8059 Sub. Contracts General Mgt.
src/Apps/W1/Subscription Billing/App/Base/Codeunits/SubContractsGeneralMgt.Codeunit.al528 lines, Copyright (c) Microsoft Corporation. MIT
namespace Microsoft.SubscriptionBilling;using Microsoft.Foundation.Attachment;using Microsoft.Purchases.Document;using Microsoft.Purchases.History;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using Microsoft.Sales.Document;using Microsoft.Sales.History;codeunit 8059 "Sub. Contracts General Mgt."{ SingleInstance = true; procedure OpenContractCard(Partner: Enum "Service Partner"; ContractNo: Code[20]) var CustomerContract: Record "Customer Subscription Contract"; VendorContract: Record "Vendor Subscription Contract"; begin if ContractNo = '' then exit; case Partner of Partner::Customer: begin CustomerContract.Get(ContractNo); CustomerContract.SetRecFilter(); Page.Run(Page::"Customer Contract", CustomerContract); end; Partner::Vendor: begin VendorContract.Get(ContractNo); VendorContract.SetRecFilter(); Page.Run(Page::"Vendor Contract", VendorContract); end; end; end; procedure OpenPartnerCard(Partner: Enum "Service Partner"; PartnerNo: Code[20]) var Customer: Record Customer; Vendor: Record Vendor; begin if PartnerNo = '' then exit; case Partner of Partner::Customer: begin Customer.Get(PartnerNo); Page.RunModal(Page::"Customer Card", Customer); end; Partner::Vendor: begin Vendor.Get(PartnerNo); Page.RunModal(Page::"Vendor Card", Vendor); end; end; end; procedure GetContractDescription(Partner: Enum "Service Partner"; ContractNo: Code[20]): Text var CustomerContract: Record "Customer Subscription Contract"; VendorContract: Record "Vendor Subscription Contract"; begin if ContractNo = '' then exit; case Partner of Partner::Customer: if CustomerContract.Get(ContractNo) then exit(CustomerContract.GetDescription()); Partner::Vendor: if VendorContract.Get(ContractNo) then exit(VendorContract.GetDescription()); end; end; procedure GetPartnerName(Partner: Enum "Service Partner"; PartnerNo: Code[20]): Text var Customer: Record Customer; Vendor: Record Vendor; begin if PartnerNo = '' then exit; case Partner of Partner::Customer: if Customer.Get(PartnerNo) then exit(Customer.Name); Partner::Vendor: if Vendor.Get(PartnerNo) then exit(Vendor.Name); end; end; procedure HasConnectionToContractLine(ContractNo: Code[20]; ContractLineNo: Integer): Boolean begin exit((ContractNo <> '') and (ContractLineNo <> 0)); end; internal procedure ShowBillingLines(ContractNo: Code[20]; ContractLineNo: Integer; ServicePartner: Enum "Service Partner") var BillingLine: Record "Billing Line"; begin BillingLine.FilterBillingLineOnContractLine(ServicePartner, ContractNo, ContractLineNo); Page.Run(0, BillingLine); end; procedure ShowBillingLinesForDocumentLine(DocumentType: Enum "Sales Document Type"; DocumentNo: Code[20]; DocumentNoLineNo: Integer) var BillingLine: Record "Billing Line"; begin BillingLine.FilterBillingLineOnDocumentLine(BillingLine.GetBillingDocumentTypeFromSalesDocumentType(DocumentType), DocumentNo, DocumentNoLineNo); Page.Run(0, BillingLine); end; internal procedure ShowArchivedBillingLinesForServiceCommitment(ServiceCommitmentEntryNo: Integer) var BillingLineArchive: Record "Billing Line Archive"; begin BillingLineArchive.FilterBillingLineArchiveOnServiceCommitment(ServiceCommitmentEntryNo); Page.Run(0, BillingLineArchive); end; internal procedure ShowArchivedBillingLines(ContractNo: Code[20]; ContractLineNo: Integer; ServicePartner: Enum "Service Partner"; RecurringBillingDocumentType: Enum "Rec. Billing Document Type"; DocumentNo: Code[20]) var BillingLineArchive: Record "Billing Line Archive"; begin BillingLineArchive.FilterBillingLineArchiveOnDocument(RecurringBillingDocumentType, DocumentNo); BillingLineArchive.FilterBillingLineArchiveOnContractLine(ServicePartner, ContractNo, ContractLineNo); Page.Run(0, BillingLineArchive); end; [EventSubscriber(ObjectType::Table, Database::"Sales Invoice Line", OnAfterDeleteEvent, '', false, false)] local procedure SalesInvoiceLineDeleteArchivedBillingLines(var Rec: Record "Sales Invoice Line") var BillingLineArchive: Record "Billing Line Archive"; CustomerContactLine: Record "Cust. Sub. Contract Line"; begin if Rec.IsTemporary() then exit; BillingLineArchive.SetRange(Partner, Enum::"Service Partner"::Customer); BillingLineArchive.SetRange("Document Type", Enum::"Rec. Billing Document Type"::Invoice); BillingLineArchive.SetRange("Document No.", Rec."Document No."); if BillingLineArchive.FindSet() then repeat if not CustomerContactLine.Get(BillingLineArchive."Subscription Contract No.", BillingLineArchive."Subscription Contract Line No.") then BillingLineArchive.Delete(false); until BillingLineArchive.Next() = 0; end; [EventSubscriber(ObjectType::Table, Database::"Purch. Inv. Line", OnAfterDeleteEvent, '', false, false)] local procedure PurchaseInvoiceLineDeleteArchivedBillingLines(var Rec: Record "Purch. Inv. Line") var BillingLineArchive: Record "Billing Line Archive"; VendorContactLine: Record "Vend. Sub. Contract Line"; begin if Rec.IsTemporary() then exit; BillingLineArchive.SetRange(Partner, Enum::"Service Partner"::Vendor); BillingLineArchive.SetRange("Document Type", Enum::"Rec. Billing Document Type"::Invoice); BillingLineArchive.SetRange("Document No.", Rec."Document No."); if BillingLineArchive.FindSet() then repeat if not VendorContactLine.Get(BillingLineArchive."Subscription Contract No.", BillingLineArchive."Subscription Contract Line No.") then BillingLineArchive.Delete(false); until BillingLineArchive.Next() = 0; end; [EventSubscriber(ObjectType::Table, Database::"Sales Cr.Memo Line", OnAfterDeleteEvent, '', false, false)] local procedure SalesCrMemoLineDeleteArchivedBillingLines(var Rec: Record "Sales Cr.Memo Line") var BillingLineArchive: Record "Billing Line Archive"; CustomerContactLine: Record "Cust. Sub. Contract Line"; begin if Rec.IsTemporary() then exit; BillingLineArchive.SetRange(Partner, Enum::"Service Partner"::Customer); BillingLineArchive.SetRange("Document Type", Enum::"Rec. Billing Document Type"::"Credit Memo"); BillingLineArchive.SetRange("Document No.", Rec."Document No."); if BillingLineArchive.FindSet() then repeat if not CustomerContactLine.Get(BillingLineArchive."Subscription Contract No.", BillingLineArchive."Subscription Contract Line No.") then BillingLineArchive.Delete(false); until BillingLineArchive.Next() = 0; end; [EventSubscriber(ObjectType::Table, Database::"Purch. Cr. Memo Line", OnAfterDeleteEvent, '', false, false)] local procedure PurchCrMemoLineDeleteArchivedBillingLines(var Rec: Record "Purch. Cr. Memo Line") var BillingLineArchive: Record "Billing Line Archive"; VendorContactLine: Record "Vend. Sub. Contract Line"; begin if Rec.IsTemporary() then exit; BillingLineArchive.SetRange(Partner, Enum::"Service Partner"::Vendor); BillingLineArchive.SetRange("Document Type", Enum::"Rec. Billing Document Type"::"Credit Memo"); BillingLineArchive.SetRange("Document No.", Rec."Document No."); if BillingLineArchive.FindSet() then repeat if not VendorContactLine.Get(BillingLineArchive."Subscription Contract No.", BillingLineArchive."Subscription Contract Line No.") then BillingLineArchive.Delete(false); until BillingLineArchive.Next() = 0; end; internal procedure ShowUnpostedSalesDocument(SalesDocumentType: Enum "Sales Document Type"; CustomerContract: Record "Customer Subscription Contract") var SalesHeader: Record "Sales Header"; begin MarkSalesHeaderFromBillingLine(SalesHeader, SalesDocumentType, CustomerContract."No."); case SalesDocumentType of SalesDocumentType::Invoice: Page.Run(Page::"Sales Invoice List", SalesHeader); SalesDocumentType::"Credit Memo": Page.Run(Page::"Sales Credit Memos", SalesHeader); end; end; local procedure MarkSalesHeaderFromBillingLine(var SalesHeader: Record "Sales Header"; SalesDocumentType: Enum "Sales Document Type"; CustomerContractNo: Code[20]) var TempSalesHeader: Record "Sales Header" temporary; BillingLine: Record "Billing Line"; begin BillingLine.SetRange("Document Type", BillingLine.GetBillingDocumentTypeFromSalesDocumentType(SalesDocumentType)); BillingLine.SetRange(Partner, Enum::"Service Partner"::Customer); BillingLine.SetRange("Subscription Contract No.", CustomerContractNo); if BillingLine.FindSet() then repeat if not TempSalesHeader.Get(SalesDocumentType, BillingLine."Document No.") then begin SalesHeader.Get(SalesDocumentType, BillingLine."Document No."); SalesHeader.Mark(true); TempSalesHeader := SalesHeader; TempSalesHeader.Insert(false); end; until BillingLine.Next() = 0; SalesHeader.MarkedOnly(true); end; internal procedure ShowPostedSalesInvoices(CustomerContract: Record "Customer Subscription Contract") var SalesInvoiceLine: Record "Sales Invoice Line"; SalesInvoiceHeader: Record "Sales Invoice Header"; TempSalesInvoiceHeader: Record "Sales Invoice Header" temporary; begin SalesInvoiceLine.SetRange("Subscription Contract No.", CustomerContract."No."); if SalesInvoiceLine.FindSet() then repeat if not TempSalesInvoiceHeader.Get(SalesInvoiceLine."Document No.") then begin SalesInvoiceHeader.Get(SalesInvoiceLine."Document No."); SalesInvoiceHeader.Mark(true); TempSalesInvoiceHeader := SalesInvoiceHeader; TempSalesInvoiceHeader.Insert(false); end; until SalesInvoiceLine.Next() = 0; SalesInvoiceHeader.MarkedOnly(true); Page.Run(Page::"Posted Sales Invoices", SalesInvoiceHeader); end; internal procedure ShowPostedSalesCreditMemos(CustomerContract: Record "Customer Subscription Contract") var SalesCrMemoLine: Record "Sales Cr.Memo Line"; SalesCrMemoHeader: Record "Sales Cr.Memo Header"; TempSalesCrMemoHeader: Record "Sales Cr.Memo Header" temporary; begin SalesCrMemoLine.SetRange("Subscription Contract No.", CustomerContract."No."); if SalesCrMemoLine.FindSet() then repeat if not TempSalesCrMemoHeader.Get(SalesCrMemoLine."Document No.") then begin SalesCrMemoHeader.Get(SalesCrMemoLine."Document No."); SalesCrMemoHeader.Mark(true); TempSalesCrMemoHeader := SalesCrMemoHeader; TempSalesCrMemoHeader.Insert(false); end; until SalesCrMemoLine.Next() = 0; SalesCrMemoHeader.MarkedOnly(true); Page.Run(Page::"Posted Sales Credit Memos", TempSalesCrMemoHeader); end; internal procedure ShowPostedPurchaseInvoices(VendorContract: Record "Vendor Subscription Contract") var PurchaseInvoiceLine: Record "Purch. Inv. Line"; PurchaseInvoiceHeader: Record "Purch. Inv. Header"; TempPurchaseInvoiceHeader: Record "Purch. Inv. Header" temporary; begin PurchaseInvoiceLine.SetRange("Subscription Contract No.", VendorContract."No."); if PurchaseInvoiceLine.FindSet() then repeat if not TempPurchaseInvoiceHeader.Get(PurchaseInvoiceLine."Document No.") then begin PurchaseInvoiceHeader.Get(PurchaseInvoiceLine."Document No."); PurchaseInvoiceHeader.Mark(true); TempPurchaseInvoiceHeader := PurchaseInvoiceHeader; TempPurchaseInvoiceHeader.Insert(false); end; until PurchaseInvoiceLine.Next() = 0; PurchaseInvoiceHeader.MarkedOnly(true); Page.Run(Page::"Posted Purchase Invoices", PurchaseInvoiceHeader); end; internal procedure ShowPostedPurchaseCreditMemos(VendorContract: Record "Vendor Subscription Contract") var PurchCrMemoLine: Record "Purch. Cr. Memo Line"; PurchCrMemoHeader: Record "Purch. Cr. Memo Hdr."; TempPurchCrMemoHeader: Record "Purch. Cr. Memo Hdr." temporary; begin PurchCrMemoLine.SetRange("Subscription Contract No.", VendorContract."No."); if PurchCrMemoLine.FindSet() then repeat if not TempPurchCrMemoHeader.Get(PurchCrMemoLine."Document No.") then begin PurchCrMemoHeader.Get(PurchCrMemoLine."Document No."); PurchCrMemoHeader.Mark(true); TempPurchCrMemoHeader := PurchCrMemoHeader; TempPurchCrMemoHeader.Insert(false); end; until PurchCrMemoLine.Next() = 0; PurchCrMemoHeader.MarkedOnly(true); Page.Run(Page::"Posted Purchase Credit Memos", TempPurchCrMemoHeader); end; internal procedure ShowUnpostedPurchDocument(PurchDocumentType: Enum "Purchase Document Type"; VendorContract: Record "Vendor Subscription Contract") var PurchaseHeader: Record "Purchase Header"; begin MarkPurchaseHeaderFromBillingLine(PurchaseHeader, PurchDocumentType, VendorContract."No."); case PurchDocumentType of PurchDocumentType::Invoice: Page.Run(Page::"Purchase Invoices", PurchaseHeader); PurchDocumentType::"Credit Memo": Page.Run(Page::"Purchase Credit Memos", PurchaseHeader); end; end; local procedure MarkPurchaseHeaderFromBillingLine(var PurchaseHeader: Record "Purchase Header"; PurchDocumentType: Enum "Purchase Document Type"; VendorContractNo: Code[20]) var TempPurchaseHeader: Record "Purchase Header" temporary; BillingLine: Record "Billing Line"; begin BillingLine.SetRange("Document Type", BillingLine.GetBillingDocumentTypeFromPurchaseDocumentType(PurchDocumentType)); BillingLine.SetRange(Partner, Enum::"Service Partner"::Vendor); BillingLine.SetRange("Subscription Contract No.", VendorContractNo); if BillingLine.FindSet() then repeat if not TempPurchaseHeader.Get(PurchDocumentType, BillingLine."Document No.") then begin PurchaseHeader.Get(PurchDocumentType, BillingLine."Document No."); PurchaseHeader.Mark(true); TempPurchaseHeader := PurchaseHeader; TempPurchaseHeader.Insert(false); end; until BillingLine.Next() = 0; PurchaseHeader.MarkedOnly(true); end; internal procedure BillingLineExists(ServicePartner: Enum "Service Partner"; ContractNo: Code[20]; ContractLineNo: Integer): Boolean var BillingLine: Record "Billing Line"; begin FilterBillingLineOnContractLine(BillingLine, ServicePartner, ContractNo, ContractLineNo); exit(not BillingLine.IsEmpty); end; local procedure FilterBillingLineOnContractLine(var BillingLine: Record "Billing Line"; ServicePartner: Enum "Service Partner"; ContractNo: Code[20]; ContractLineNo: Integer): Boolean begin BillingLine.SetRange(Partner, ServicePartner); BillingLine.SetRange("Subscription Contract No.", ContractNo); BillingLine.SetRange("Subscription Contract Line No.", ContractLineNo); end; internal procedure TestMergingServiceObjects(ServiceObject: Record "Subscription Header"; PrevServiceObject: Record "Subscription Header") begin ServiceObject.TestField(Type, PrevServiceObject.Type); ServiceObject.TestField("Source No.", PrevServiceObject."Source No."); ServiceObject.TestField("Unit of Measure", PrevServiceObject."Unit of Measure"); ServiceObject.TestField("End-User Contact No.", PrevServiceObject."End-User Contact No."); ServiceObject.TestField("End-User Customer No.", PrevServiceObject."End-User Customer No."); ServiceObject.TestField("Bill-to Customer No.", PrevServiceObject."Bill-to Customer No."); ServiceObject.TestField("Bill-to Contact No.", PrevServiceObject."Bill-to Contact No."); ServiceObject.TestField("Bill-to Contact", PrevServiceObject."Bill-to Contact"); ServiceObject.TestField("Bill-to Name", PrevServiceObject."Bill-to Name"); ServiceObject.TestField("Bill-to Name 2", PrevServiceObject."Bill-to Name 2"); ServiceObject.TestField("Bill-to Address", PrevServiceObject."Bill-to Address"); ServiceObject.TestField("Bill-to Address 2", PrevServiceObject."Bill-to Address 2"); ServiceObject.TestField("Bill-to City", PrevServiceObject."Bill-to City"); ServiceObject.TestField("Bill-to Post Code", PrevServiceObject."Bill-to Post Code"); ServiceObject.TestField("Bill-to Country/Region Code", PrevServiceObject."Bill-to Country/Region Code"); ServiceObject.TestField("Bill-to County", PrevServiceObject."Bill-to County"); ServiceObject.TestField("Ship-to Name", PrevServiceObject."Ship-to Name"); ServiceObject.TestField("Ship-to Name 2", PrevServiceObject."Ship-to Name 2"); ServiceObject.TestField("Ship-to Code", PrevServiceObject."Ship-to Code"); ServiceObject.TestField("Ship-to Address", PrevServiceObject."Ship-to Address"); ServiceObject.TestField("Ship-to Address 2", PrevServiceObject."Ship-to Address 2"); ServiceObject.TestField("Ship-to City", PrevServiceObject."Ship-to City"); ServiceObject.TestField("Ship-to Post Code", PrevServiceObject."Ship-to Post Code"); ServiceObject.TestField("Ship-to Country/Region Code", PrevServiceObject."Ship-to Country/Region Code"); ServiceObject.TestField("Ship-to County", PrevServiceObject."Ship-to County"); ServiceObject.TestField("Ship-to Contact", PrevServiceObject."Ship-to Contact"); ServiceObject.TestField("Customer Price Group", PrevServiceObject."Customer Price Group"); end; internal procedure TestMergingServiceCommitments(ServiceCommitment: Record "Subscription Line"; PrevServiceCommitment: Record "Subscription Line") begin ServiceCommitment.TestField("Subscription Line End Date", PrevServiceCommitment."Subscription Line End Date"); ServiceCommitment.TestField("Calculation Base Amount", PrevServiceCommitment."Calculation Base Amount"); ServiceCommitment.TestField("Calculation Base %", PrevServiceCommitment."Calculation Base %"); ServiceCommitment.TestField(Price, PrevServiceCommitment.Price); ServiceCommitment.TestField("Billing Base Period", PrevServiceCommitment."Billing Base Period"); ServiceCommitment.TestField("Invoicing via", PrevServiceCommitment."Invoicing via"); ServiceCommitment.TestField("Invoicing Item No.", PrevServiceCommitment."Invoicing Item No."); ServiceCommitment.TestField(Partner, PrevServiceCommitment.Partner); ServiceCommitment.TestField("Subscription Contract No.", PrevServiceCommitment."Subscription Contract No."); ServiceCommitment.TestField("Notice Period", PrevServiceCommitment."Notice Period"); ServiceCommitment.TestField("Initial Term", PrevServiceCommitment."Initial Term"); ServiceCommitment.TestField("Extension Term", PrevServiceCommitment."Extension Term"); ServiceCommitment.TestField("Billing Rhythm", PrevServiceCommitment."Billing Rhythm"); ServiceCommitment.TestField("Sub. Header Customer No.", PrevServiceCommitment."Sub. Header Customer No."); ServiceCommitment.TestField("Customer Price Group", PrevServiceCommitment."Customer Price Group"); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Document Attachment Mgmt", OnAfterGetRefTable, '', false, false)] local procedure SetServiceObjectAsRecRef(DocumentAttachment: Record "Document Attachment"; var RecRef: RecordRef) var ServiceObject: Record "Subscription Header"; CustomerContract: Record "Customer Subscription Contract"; begin case DocumentAttachment."Table ID" of Database::"Subscription Header": if ServiceObject.Get(DocumentAttachment."No.") then RecRef.GetTable(ServiceObject); Database::"Customer Subscription Contract": if CustomerContract.Get(DocumentAttachment."No.") then RecRef.GetTable(CustomerContract); end; end; [EventSubscriber(ObjectType::Page, Page::"Document Attachment Details", OnAfterOpenForRecRef, '', false, false)] local procedure FilterDocumentAttachmentOnRecRefPrimaryKey(var DocumentAttachment: Record "Document Attachment"; var RecRef: RecordRef) var FieldRef: FieldRef; RecNo: Code[20]; begin DocumentAttachment.SetRange("Table ID", RecRef.Number); case RecRef.Number of Database::"Subscription Header", Database::"Customer Subscription Contract": begin FieldRef := RecRef.Field(3); // "No." = 3 RecNo := FieldRef.Value(); DocumentAttachment.SetRange("No.", RecNo); end; end; end; [EventSubscriber(ObjectType::Table, Database::"Document Attachment", OnAfterInitFieldsFromRecRef, '', false, false)] local procedure InitDocumentAttachmentFields(var DocumentAttachment: Record "Document Attachment"; var RecRef: RecordRef) var FieldRef: FieldRef; RecNo: Code[20]; begin case RecRef.Number of Database::"Subscription Header", Database::"Customer Subscription Contract": begin FieldRef := RecRef.Field(3); // "No." = 3 RecNo := FieldRef.Value(); DocumentAttachment.Validate("No.", RecNo); end; end; end; internal procedure DeleteDocumentAttachmentForNo(TableId: Integer; RecNo: Code[20]) var DocumentAttachment: Record "Document Attachment"; begin DocumentAttachment.SetRange("Table ID", TableId); DocumentAttachment.SetRange("No.", RecNo); if not DocumentAttachment.IsEmpty() then DocumentAttachment.DeleteAll(false); end; [EventSubscriber(ObjectType::Table, Database::Customer, OnBeforeDeleteEvent, '', false, false)] local procedure CheckIfCustomerContractOrServiceObjectExistWhenDeleteCustomer(var Rec: Record Customer; RunTrigger: Boolean) var CustomerContract: Record "Customer Subscription Contract"; ServiceObject: Record "Subscription Header"; CustomerContractExistErr: Label 'You cannot delete %1 %2 because there is at least one outstanding Contract for this customer.', Comment = '%1 = Table Caption, %2 = Customer No.'; ServiceObjectExistErr: Label 'You cannot delete %1 %2 because there is at least one outstanding Subscription for this customer.', Comment = '%1 = Table Caption, %2 = Customer No.'; begin if Rec.IsTemporary() then exit; if not RunTrigger then exit; CustomerContract.SetRange("Sell-to Customer No.", Rec."No."); if not CustomerContract.IsEmpty() then Error(CustomerContractExistErr, Rec.TableCaption, Rec."No."); ServiceObject.SetRange("End-User Customer No.", Rec."No."); if not ServiceObject.IsEmpty() then Error(ServiceObjectExistErr, Rec.TableCaption, Rec."No."); end; [EventSubscriber(ObjectType::Table, Database::Vendor, OnBeforeDeleteEvent, '', false, false)] local procedure CheckIfVendorContractExistWhenDeleteVendor(var Rec: Record Vendor; RunTrigger: Boolean) var VendorContract: Record "Vendor Subscription Contract"; VendorContractExistErr: Label 'You cannot delete %1 %2 because there is at least one outstanding Contract for this vendor.', Comment = '%1 = Table Caption, %2 = Vendor No.'; begin if Rec.IsTemporary() then exit; if not RunTrigger then exit; VendorContract.SetRange("Buy-from Vendor No.", Rec."No."); if not VendorContract.IsEmpty() then Error(VendorContractExistErr, Rec.TableCaption, Rec."No."); end;}