Codeunit 8064 Sub. Contract Billing Printout
src/Apps/W1/Subscription Billing/App/Billing/Codeunits/SubContractBillingPrintout.Codeunit.al136 lines, Copyright (c) Microsoft Corporation. MIT
namespace Microsoft.SubscriptionBilling;using Microsoft.Finance.Currency;using Microsoft.Projects.Project.Ledger;using Microsoft.Sales.History;codeunit 8064 "Sub. Contract Billing Printout"{ procedure FillContractBillingDetailsBufferFromSalesInvoice(SalesInvoiceHeader: Record "Sales Invoice Header"; var TempJobLedgerEntryBuffer: Record "Job Ledger Entry"; var ColumnHeaders: array[5] of Text) var BillingLineArchive: Record "Billing Line Archive"; SalesInvoiceLine: Record "Sales Invoice Line"; CustomerContract: Record "Customer Subscription Contract"; Currency: Record Currency; UsageDataBilling: Record "Usage Data Billing"; ServiceCommitment: Record "Subscription Line"; SalesDocuments: Codeunit "Sales Documents"; EntryNo: Integer; begin TempJobLedgerEntryBuffer.Reset(); TempJobLedgerEntryBuffer.DeleteAll(); Clear(ColumnHeaders); if not SalesInvoiceHeader."Recurring Billing" then exit; if SalesInvoiceHeader."Sub. Contract Detail Overview" = Enum::"Contract Detail Overview"::None then exit; SalesDocuments.MoveBillingLineToBillingLineArchiveForPostingPreview(SalesInvoiceHeader); SalesInvoiceLine.SetRange("Document No.", SalesInvoiceHeader."No."); SalesInvoiceLine.SetFilter("Subscription Contract No.", '<>%1', ''); SalesInvoiceLine.SetFilter("Subscription Contract Line No.", '<>%1', 0); if SalesInvoiceLine.FindSet() then repeat ServiceCommitment.SetRange("Subscription Contract No.", SalesInvoiceLine."Subscription Contract No."); ServiceCommitment.SetRange("Subscription Contract Line No.", SalesInvoiceLine."Subscription Contract Line No."); if ServiceCommitment.FindFirst() and ServiceCommitment."Usage Based Billing" then begin UsageDataBilling.SetRange("Document Type", UsageDataBilling."Document Type"::"Posted Invoice"); UsageDataBilling.SetRange("Document No.", SalesInvoiceHeader."No."); UsageDataBilling.SetRange("Subscription Contract No.", SalesInvoiceLine."Subscription Contract No."); UsageDataBilling.SetRange("Subscription Contract Line No.", SalesInvoiceLine."Subscription Contract Line No."); UsageDataBilling.SetAutoCalcFields("Subscription Description"); if UsageDataBilling.FindSet() then repeat EntryNo += 1; TempJobLedgerEntryBuffer.Init(); TempJobLedgerEntryBuffer."Entry No." := EntryNo; TempJobLedgerEntryBuffer."Document No." := SalesInvoiceLine."Document No."; TempJobLedgerEntryBuffer."Ledger Entry No." := SalesInvoiceLine."Line No."; TempJobLedgerEntryBuffer."Document Date" := UsageDataBilling."Charge Start Date"; TempJobLedgerEntryBuffer."Posting Date" := UsageDataBilling."Charge End Date"; TempJobLedgerEntryBuffer.Quantity := UsageDataBilling.Quantity; TempJobLedgerEntryBuffer.Description := UsageDataBilling.GetPrintoutDescription(); TempJobLedgerEntryBuffer."External Document No." := UsageDataBilling."Subscription Contract No."; TempJobLedgerEntryBuffer."Resource Group No." := SalesInvoiceHeader."Sell-to Customer No."; if SalesInvoiceHeader."Sub. Contract Detail Overview" = Enum::"Contract Detail Overview"::Complete then begin TempJobLedgerEntryBuffer."Unit Price" := UsageDataBilling."Unit Price"; TempJobLedgerEntryBuffer."Currency Code" := SalesInvoiceHeader."Currency Code"; TempJobLedgerEntryBuffer."Line Amount" := UsageDataBilling.Amount; end; OnBeforeInsertUsageDataBilling(TempJobLedgerEntryBuffer, UsageDataBilling, SalesInvoiceHeader, SalesInvoiceLine); TempJobLedgerEntryBuffer.Insert(false); until UsageDataBilling.Next() = 0; end else begin BillingLineArchive.SetRange("Document Type", BillingLineArchive."Document Type"::Invoice); BillingLineArchive.SetRange("Document No.", SalesInvoiceHeader."No."); BillingLineArchive.SetRange("Subscription Contract No.", SalesInvoiceLine."Subscription Contract No."); BillingLineArchive.SetRange("Subscription Contract Line No.", SalesInvoiceLine."Subscription Contract Line No."); BillingLineArchive.SetAutoCalcFields("Subscription Description"); if BillingLineArchive.FindSet() then repeat EntryNo += 1; TempJobLedgerEntryBuffer.Init(); TempJobLedgerEntryBuffer."Entry No." := EntryNo; TempJobLedgerEntryBuffer."Document No." := SalesInvoiceLine."Document No."; TempJobLedgerEntryBuffer."Ledger Entry No." := SalesInvoiceLine."Line No."; TempJobLedgerEntryBuffer."Document Date" := BillingLineArchive."Billing from"; TempJobLedgerEntryBuffer."Posting Date" := BillingLineArchive."Billing to"; TempJobLedgerEntryBuffer.Quantity := BillingLineArchive."Service Object Quantity"; TempJobLedgerEntryBuffer.Description := BillingLineArchive."Subscription Description"; TempJobLedgerEntryBuffer."External Document No." := BillingLineArchive."Subscription Contract No."; CustomerContract.Get(BillingLineArchive."Subscription Contract No."); TempJobLedgerEntryBuffer."Resource Group No." := CustomerContract."Sell-to Customer No."; if SalesInvoiceHeader."Sub. Contract Detail Overview" = Enum::"Contract Detail Overview"::Complete then begin TempJobLedgerEntryBuffer."Unit Price" := BillingLineArchive."Unit Price"; TempJobLedgerEntryBuffer."Line Discount %" := BillingLineArchive."Discount %"; TempJobLedgerEntryBuffer."Currency Code" := SalesInvoiceHeader."Currency Code"; if TempJobLedgerEntryBuffer."Currency Code" <> '' then Currency.Get(TempJobLedgerEntryBuffer."Currency Code"); Currency.InitRoundingPrecision(); TempJobLedgerEntryBuffer."Line Discount Amount" := Round(BillingLineArchive.Amount * BillingLineArchive."Discount %" / 100, Currency."Amount Rounding Precision"); TempJobLedgerEntryBuffer."Line Amount" := BillingLineArchive.Amount; end; OnBeforeInsertBillingLineArchive(TempJobLedgerEntryBuffer, CustomerContract, BillingLineArchive, SalesInvoiceHeader, SalesInvoiceLine); TempJobLedgerEntryBuffer.Insert(false); until BillingLineArchive.Next() = 0; end; until SalesInvoiceLine.Next() = 0; TempJobLedgerEntryBuffer.SetRange("Document No.", SalesInvoiceLine."Document No."); TempJobLedgerEntryBuffer.CalcSums("Unit Price", "Line Discount %", "Line Discount Amount", "Line Amount"); if TempJobLedgerEntryBuffer."Unit Price" <> 0 then ColumnHeaders[1] := TempJobLedgerEntryBuffer.FieldCaption("Unit Price"); if TempJobLedgerEntryBuffer."Line Discount %" <> 0 then ColumnHeaders[2] := DiscountPercentLbl; if TempJobLedgerEntryBuffer."Line Discount Amount" <> 0 then ColumnHeaders[3] := DiscountAmountLbl; if TempJobLedgerEntryBuffer."Line Amount" <> 0 then ColumnHeaders[4] := AmountLbl; TempJobLedgerEntryBuffer.Reset(); end; procedure FormatContractBillingDetails(var TempContractBillingDetailsBuffer: Record "Job Ledger Entry"; var SalesInvoiceLine: Record "Sales Invoice Line") begin if not SalesInvoiceLine.Get(TempContractBillingDetailsBuffer."Document No.", TempContractBillingDetailsBuffer."Ledger Entry No.") then SalesInvoiceLine.Init(); end; [IntegrationEvent(false, false)] procedure OnBeforeInsertUsageDataBilling(var TempJobLedgerEntryBuffer: Record "Job Ledger Entry"; UsageDataBilling: Record "Usage Data Billing"; SalesInvoiceHeader: Record "Sales Invoice Header"; SalesInvoiceLine: Record "Sales Invoice Line") begin end; [IntegrationEvent(false, false)] procedure onBeforeInsertBillingLineArchive(var TempJobLedgerEntryBuffer: Record "Job Ledger Entry"; CustomerContract: Record "Customer Subscription Contract"; BillingLineArchive: Record "Billing Line Archive"; SalesInvoiceHeader: Record "Sales Invoice Header"; SalesInvoiceLine: Record "Sales Invoice Line") begin end; var DiscountPercentLbl: Label 'Discount %'; DiscountAmountLbl: Label 'Discount'; AmountLbl: Label 'Amount';}