Report 1307 Standard Sales - Credit Memo
src/Layers/W1/BaseApp/Sales/History/StandardSalesCreditMemo.Report.al1,391 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Sales.History;using Microsoft.Assembly.History;using Microsoft.Bank.BankAccount;using Microsoft.CRM.Contact;using Microsoft.CRM.Interaction;using Microsoft.CRM.Segment;using Microsoft.CRM.Team;using Microsoft.Finance.Currency;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Finance.VAT.Calculation;using Microsoft.Finance.VAT.Clause;using Microsoft.Foundation.Address;using Microsoft.Foundation.Company;using Microsoft.Foundation.PaymentTerms;using Microsoft.Foundation.Reporting;using Microsoft.Foundation.Shipping;using Microsoft.Foundation.UOM;using Microsoft.Inventory.Ledger;using Microsoft.Inventory.Location;using Microsoft.Sales.Customer;using Microsoft.Sales.Setup;using Microsoft.Utilities;using System.Email;using System.Globalization;using System.Reflection;using System.Text;using System.Utilities;/// <summary>/// Generates a standard format printable document for posted sales credit memos with amounts and VAT details./// </summary>report 1307 "Standard Sales - Credit Memo"{ Caption = 'Sales - Credit Memo'; DefaultRenderingLayout = "StandardSalesCreditMemo.docx"; Permissions = TableData "Sales Shipment Buffer" = rimd; PreviewMode = PrintLayout; WordMergeDataItem = Header; dataset { dataitem(Header; "Sales Cr.Memo Header") { DataItemTableView = sorting("No."); RequestFilterFields = "No.", "Sell-to Customer No.", "No. Printed"; RequestFilterHeading = 'Posted Sales Credit Memo'; column(CompanyAddress1; CompanyAddr[1]) { } column(CompanyAddress2; CompanyAddr[2]) { } column(CompanyAddress3; CompanyAddr[3]) { } column(CompanyAddress4; CompanyAddr[4]) { } column(CompanyAddress5; CompanyAddr[5]) { } column(CompanyAddress6; CompanyAddr[6]) { } column(CompanyAddress7; CompanyAddr[7]) { } column(CompanyAddress8; CompanyAddr[8]) { } column(CompanyHomePage; CompanyInfo."Home Page") { } column(CompanyEMail; CompanyInfo."E-Mail") { } column(CompanyPicture; DummyCompanyInfo.Picture) { } column(CompanyPhoneNo; CompanyInfo."Phone No.") { } column(CompanyPhoneNo_Lbl; CompanyInfoPhoneNoLbl) { } column(CompanyGiroNo; CompanyInfo."Giro No.") { } column(CompanyGiroNo_Lbl; CompanyInfoGiroNoLbl) { } column(CompanyBankName; CompanyBankAccount.Name) { } column(CompanyBankName_Lbl; CompanyInfoBankNameLbl) { } column(CompanyBankBranchNo; CompanyBankAccount."Bank Branch No.") { } column(CompanyBankBranchNo_Lbl; CompanyBankAccount.FieldCaption("Bank Branch No.")) { } column(CompanyBankAccountNo; CompanyBankAccount."Bank Account No.") { } column(CompanyBankAccountNo_Lbl; CompanyInfoBankAccNoLbl) { } column(CompanyIBAN; CompanyBankAccount.IBAN) { } column(CompanyIBAN_Lbl; CompanyBankAccount.FieldCaption(IBAN)) { } column(CompanySWIFT; CompanyBankAccount."SWIFT Code") { } column(CompanySWIFT_Lbl; CompanyBankAccount.FieldCaption("SWIFT Code")) { } column(CompanyLogoPosition; CompanyLogoPosition) { } column(CompanyRegistrationNumber; CompanyInfo.GetRegistrationNumber()) { } column(CompanyRegistrationNumber_Lbl; CompanyInfo.GetRegistrationNumberLbl()) { } column(CompanyVATRegNo; CompanyInfo.GetVATRegistrationNumber()) { } column(CompanyVATRegNo_Lbl; CompanyInfo.GetVATRegistrationNumberLbl()) { } column(CompanyVATRegistrationNo; CompanyInfo.GetVATRegistrationNumber()) { } column(CompanyVATRegistrationNo_Lbl; CompanyInfo.GetVATRegistrationNumberLbl()) { } column(CompanyLegalOffice; LegalOfficeTxt) { } column(CompanyLegalOffice_Lbl; LegalOfficeLbl) { } column(CompanyCustomGiro; CustomGiroTxt) { } column(CompanyCustomGiro_Lbl; CustomGiroLbl) { } column(CompanyLegalStatement; LegalStatementLbl) { } column(CustomerAddress1; CustAddr[1]) { } column(CustomerAddress2; CustAddr[2]) { } column(CustomerAddress3; CustAddr[3]) { } column(CustomerAddress4; CustAddr[4]) { } column(CustomerAddress5; CustAddr[5]) { } column(CustomerAddress6; CustAddr[6]) { } column(CustomerAddress7; CustAddr[7]) { } column(CustomerAddress8; CustAddr[8]) { } column(SellToContactPhoneNoLbl; SellToContactPhoneNoLbl) { } column(SellToContactMobilePhoneNoLbl; SellToContactMobilePhoneNoLbl) { } column(SellToContactEmailLbl; SellToContactEmailLbl) { } column(BillToContactPhoneNoLbl; BillToContactPhoneNoLbl) { } column(BillToContactMobilePhoneNoLbl; BillToContactMobilePhoneNoLbl) { } column(BillToContactEmailLbl; BillToContactEmailLbl) { } column(SellToContactPhoneNo; SellToContact."Phone No.") { } column(SellToContactMobilePhoneNo; SellToContact."Mobile Phone No.") { } column(SellToContactEmail; SellToContact."E-Mail") { } column(BillToContactPhoneNo; BillToContact."Phone No.") { } column(BillToContactMobilePhoneNo; BillToContact."Mobile Phone No.") { } column(BillToContactEmail; BillToContact."E-Mail") { } column(CustomerPostalBarCode; FormatAddr.PostalBarCode(1)) { } column(YourReference; "Your Reference") { } column(YourReference_Lbl; FieldCaption("Your Reference")) { } column(ExternalDocumentNo; "External Document No.") { } column(ExternalDocumentNoLbl; FieldCaption("External Document No.")) { } column(ShipmentMethodDescription; ShipmentMethod.Description) { } column(ShipmentMethodDescription_Lbl; ShptMethodDescLbl) { } column(ShipmentDate; Format("Shipment Date", 0, 4)) { } column(ShipmentDate_Lbl; FieldCaption("Shipment Date")) { } column(Shipment_Lbl; ShipmentLbl) { } column(ShowShippingAddress; ShowShippingAddr) { } column(ShipToAddress_Lbl; ShiptoAddrLbl) { } column(ShipToAddress1; ShipToAddr[1]) { } column(ShipToAddress2; ShipToAddr[2]) { } column(ShipToAddress3; ShipToAddr[3]) { } column(ShipToAddress4; ShipToAddr[4]) { } column(ShipToAddress5; ShipToAddr[5]) { } column(ShipToAddress6; ShipToAddr[6]) { } column(ShipToAddress7; ShipToAddr[7]) { } column(ShipToAddress8; ShipToAddr[8]) { } column(ShipToPhoneNo; Header."Ship-to Phone No.") { } column(PaymentTermsDescription; PaymentTerms.Description) { } column(PaymentTermsDescription_Lbl; PaymentTermsDescLbl) { } column(PaymentMethodDescription; PaymentMethod.Description) { } column(PaymentMethodDescription_Lbl; PaymentMethodDescLbl) { } column(DocumentCopyText; StrSubstNo(DocumentCaption(), CopyText)) { } column(BilltoCustumerNo; "Bill-to Customer No.") { } column(BilltoCustumerNo_Lbl; FieldCaption("Bill-to Customer No.")) { } column(DocumentDate; Format("Document Date", 0, 4)) { } column(DocumentDate_Lbl; FieldCaption("Document Date")) { } column(DueDate; Format("Due Date", 0, 4)) { } column(DueDate_Lbl; FieldCaption("Due Date")) { } column(DocumentNo; "No.") { } column(DocumentNo_Lbl; InvNoLbl) { } column(AppliesToDocument; AppliesToText) { } column(AppliesToDocument_Lbl; AppliesToTextLbl) { } column(PricesIncludingVAT; "Prices Including VAT") { } column(PricesIncludingVAT_Lbl; FieldCaption("Prices Including VAT")) { } column(PricesIncludingVATYesNo; Format("Prices Including VAT")) { } column(SalesPerson_Lbl; SalespersonLbl) { } column(SalesPersonBlank_Lbl; SalesPersonText) { } column(SalesPersonName; SalespersonPurchaser.Name) { } column(SelltoCustomerNo; "Sell-to Customer No.") { } column(SelltoCustomerNo_Lbl; FieldCaption("Sell-to Customer No.")) { } column(VATRegistrationNo; GetCustomerVATRegistrationNumber()) { } column(VATRegistrationNo_Lbl; GetCustomerVATRegistrationNumberLbl()) { } column(LegalEntityType; Cust.GetLegalEntityType()) { } column(LegalEntityType_Lbl; Cust.GetLegalEntityTypeLbl()) { } column(Copy_Lbl; CopyLbl) { } column(EMail_Header_Lbl; EMailLbl) { } column(HomePage_Header_Lbl; HomePageLbl) { } column(InvoiceDiscountBaseAmount_Lbl; InvDiscBaseAmtLbl) { } column(InvoiceDiscountAmount_Lbl; InvDiscountAmtLbl) { } column(LineAmountAfterInvoiceDiscount_Lbl; LineAmtAfterInvDiscLbl) { } column(LocalCurrency_Lbl; LocalCurrencyLbl) { } column(ExchangeRateASText; ExchangeRateText) { } column(Page_Lbl; PageLbl) { } column(SalesInvoiceLineDiscount_Lbl; SalesInvLineDiscLbl) { } column(DocumentTitle_Lbl; SalesCreditMemoLbl) { } column(ShowWorkDescription; ShowWorkDescription) { } column(Subtotal_Lbl; SubtotalLbl) { } column(Total_Lbl; TotalLbl) { } column(VATAmount_Lbl; VATAmtLbl) { } column(VATBase_Lbl; VATBaseLbl) { } column(VATAmountSpecification_Lbl; VATAmtSpecificationLbl) { } column(VATClauses_Lbl; VATClausesLbl) { } column(VATIdentifier_Lbl; VATIdentifierLbl) { } column(VATPercentage_Lbl; VATPercentageLbl) { } column(VATClause_Lbl; VATClause.TableCaption()) { } dataitem(Line; "Sales Cr.Memo Line") { DataItemLink = "Document No." = field("No."); DataItemLinkReference = Header; DataItemTableView = sorting("Document No.", "Line No."); column(LineNo_Line; "Line No.") { } column(AmountExcludingVAT_Line; Amount) { AutoFormatExpression = GetCurrencyCode(); AutoFormatType = 1; } column(AmountExcludingVAT_Line_Lbl; FieldCaption(Amount)) { } column(AmountIncludingVAT_Line; "Amount Including VAT") { AutoFormatExpression = GetCurrencyCode(); AutoFormatType = 1; } column(AmountIncludingVAT_Line_Lbl; FieldCaption("Amount Including VAT")) { AutoFormatExpression = GetCurrencyCode(); AutoFormatType = 1; } column(Description_Line; Description) { } column(Description_Line_Lbl; FieldCaption(Description)) { } column(LineDiscountPercent_Line; "Line Discount %") { } column(LineDiscountPercentText_Line; LineDiscountPctText) { } column(LineAmount_Line; FormattedLineAmount) { AutoFormatExpression = GetCurrencyCode(); AutoFormatType = 1; } column(LineAmount_Line_Lbl; FieldCaption("Line Amount")) { } column(ItemNo_Line; "No.") { } column(ItemNo_Line_Lbl; FieldCaption("No.")) { } column(ItemReferenceNo_Line; "Item Reference No.") { } column(ItemReferenceNo_Line_Lbl; FieldCaption("Item Reference No.")) { } column(ShipmentDate_Line; Format("Shipment Date")) { } column(ShipmentDate_Line_Lbl; PostedShipmentDateLbl) { } column(Quantity_Line; FormattedQuantity) { } column(Quantity_Line_Lbl; FieldCaption(Quantity)) { } column(Type_Line; Format(Type)) { } column(UnitPrice; FormattedUnitPrice) { AutoFormatExpression = GetCurrencyCode(); AutoFormatType = 2; } column(UnitPrice_Lbl; FieldCaption("Unit Price")) { } column(UnitOfMeasure; "Unit of Measure") { } column(UnitOfMeasure_Lbl; FieldCaption("Unit of Measure")) { } column(VATIdentifier_Line; "VAT Identifier") { } column(VATIdentifier_Line_Lbl; FieldCaption("VAT Identifier")) { } column(VATPct_Line; FormattedVATPct) { } column(VATPct_Line_Lbl; FieldCaption("VAT %")) { } column(TransHeaderAmount; TransHeaderAmount) { AutoFormatExpression = Header."Currency Code"; AutoFormatType = 1; } dataitem(ShipmentLine; "Sales Shipment Buffer") { DataItemTableView = sorting("Document No.", "Line No.", "Entry No."); UseTemporary = true; column(DocumentNo_ShipmentLine; "Document No.") { } column(PostingDate_ShipmentLine; Format("Posting Date")) { } column(PostingDate_ShipmentLine_Lbl; FieldCaption("Posting Date")) { } column(Quantity_ShipmentLine; Quantity) { DecimalPlaces = 0 : 5; } column(Quantity_ShipmentLine_Lbl; FieldCaption(Quantity)) { } trigger OnPreDataItem() begin if not DisplayShipmentInformation then CurrReport.Break(); SetRange("Line No.", Line."Line No."); end; } dataitem(AssemblyLine; "Posted Assembly Line") { DataItemTableView = sorting("Document No.", "Line No."); UseTemporary = true; column(LineNo_AssemblyLine; "No.") { } column(Description_AssemblyLine; Description) { } column(Quantity_AssemblyLine; Quantity) { DecimalPlaces = 0 : 5; } column(UnitOfMeasure_AssemblyLine; GetUOMText("Unit of Measure Code")) { } column(VariantCode_AssemblyLine; "Variant Code") { } trigger OnPreDataItem() var ValueEntry: Record "Value Entry"; begin Clear(AssemblyLine); if not DisplayAssemblyInformation then CurrReport.Break(); GetAssemblyLinesForDocument( AssemblyLine, ValueEntry."Document Type"::"Sales Credit Memo", Line."Document No.", Line."Line No."); end; } trigger OnAfterGetRecord() begin InitializeSalesShipmentLine(); if Type = Type::"G/L Account" then "No." := ''; OnLineOnAfterGetRecordOnBeforeCheckLineDiscount(Line, Header); if "Line Discount %" = 0 then LineDiscountPctText := '' else LineDiscountPctText := StrSubstNo('%1%', -Round("Line Discount %", 0.1)); InsertVATAmountLine(VATAmountLine, Line); TransHeaderAmount += PrevLineAmount; PrevLineAmount := "Line Amount"; TotalSubTotal += "Line Amount"; TotalInvDiscAmount -= "Inv. Discount Amount"; TotalAmount += Amount; TotalAmountVAT += "Amount Including VAT" - Amount; TotalAmountInclVAT += "Amount Including VAT"; TotalPaymentDiscOnVAT += -("Line Amount" - "Inv. Discount Amount" - "Amount Including VAT"); FormatLineValues(Line); if FormatDocument.HideDocumentLine(HideLinesWithZeroQuantity, Line, FieldNo(Quantity)) then CurrReport.Skip(); if FirstLineHasBeenOutput then Clear(DummyCompanyInfo.Picture); FirstLineHasBeenOutput := true; end; trigger OnPreDataItem() begin VATAmountLine.DeleteAll(); VATClauseLine.DeleteAll(); ShipmentLine.Reset(); ShipmentLine.DeleteAll(); MoreLines := Find('+'); while MoreLines and (Description = '') and ("No." = '') and (Quantity = 0) and (Amount = 0) do MoreLines := Next(-1) <> 0; if not MoreLines then CurrReport.Break(); SetFilter("Line No.", '<=%1', "Line No."); TransHeaderAmount := 0; PrevLineAmount := 0; FirstLineHasBeenOutput := false; DummyCompanyInfo.Picture := CompanyInfo.Picture; end; } dataitem(WorkDescriptionLines; "Integer") { DataItemTableView = sorting(Number) where(Number = filter(1 .. 99999)); column(WorkDescriptionLineNumber; Number) { } column(WorkDescriptionLine; WorkDescriptionLine) { } trigger OnAfterGetRecord() var TypeHelper: Codeunit "Type Helper"; begin if WorkDescriptionInstream.EOS then CurrReport.Break(); WorkDescriptionLine := TypeHelper.ReadAsTextWithSeparator(WorkDescriptionInstream, TypeHelper.LFSeparator()); if WorkDescriptionLine = '' then CurrReport.Break(); end; trigger OnPostDataItem() begin Clear(WorkDescriptionInstream) end; trigger OnPreDataItem() begin if not ShowWorkDescription then CurrReport.Break(); Header."Work Description".CreateInStream(WorkDescriptionInstream, TEXTENCODING::UTF8); end; } dataitem(VATAmountLine; "VAT Amount Line") { DataItemTableView = sorting("VAT Identifier", "VAT Calculation Type", "Tax Group Code", "Use Tax", Positive); UseTemporary = true; column(InvoiceDiscountAmount_VATAmountLine; "Invoice Discount Amount") { AutoFormatExpression = Header."Currency Code"; AutoFormatType = 1; } column(InvoiceDiscountAmount_VATAmountLine_Lbl; FieldCaption("Invoice Discount Amount")) { } column(InvoiceDiscountBaseAmount_VATAmountLine; "Inv. Disc. Base Amount") { AutoFormatExpression = Header."Currency Code"; AutoFormatType = 1; } column(InvoiceDiscountBaseAmount_VATAmountLine_Lbl; FieldCaption("Inv. Disc. Base Amount")) { } column(LineAmount_VatAmountLine; "Line Amount") { AutoFormatExpression = Header."Currency Code"; AutoFormatType = 1; } column(LineAmount_VatAmountLine_Lbl; FieldCaption("Line Amount")) { } column(VATAmount_VatAmountLine; "VAT Amount") { AutoFormatExpression = Header."Currency Code"; AutoFormatType = 1; } column(VATAmount_VatAmountLine_Lbl; FieldCaption("VAT Amount")) { } column(VATAmountLCY_VATAmountLine; VATAmountLCY) { } column(VATAmountLCY_VATAmountLine_Lbl; VATAmountLCYLbl) { } column(VATBase_VatAmountLine; "VAT Base") { AutoFormatExpression = Line.GetCurrencyCode(); AutoFormatType = 1; } column(VATBase_VatAmountLine_Lbl; FieldCaption("VAT Base")) { } column(VATBaseLCY_VATAmountLine; VATBaseLCY) { } column(VATBaseLCY_VATAmountLine_Lbl; VATBaseLCYLbl) { } column(VATIdentifier_VatAmountLine; "VAT Identifier") { } column(VATIdentifier_VatAmountLine_Lbl; FieldCaption("VAT Identifier")) { } column(VATPct_VatAmountLine; "VAT %") { DecimalPlaces = 0 : 5; } column(VATPct_VatAmountLine_Lbl; FieldCaption("VAT %")) { } column(NoOfVATIdentifiers; Count) { } trigger OnAfterGetRecord() begin VATBaseLCY := GetBaseLCY( Header."Posting Date", Header."Currency Code", Header."Currency Factor"); VATAmountLCY := GetAmountLCY( Header."Posting Date", Header."Currency Code", Header."Currency Factor"); TotalVATBaseLCY += VATBaseLCY; TotalVATAmountLCY += VATAmountLCY; if "VAT Clause Code" <> '' then begin VATClauseLine := VATAmountLine; if VATClauseLine.Insert() then; end; end; trigger OnPreDataItem() begin Clear(VATBaseLCY); Clear(VATAmountLCY); TotalVATBaseLCY := 0; TotalVATAmountLCY := 0; end; } dataitem(VATClauseLine; "VAT Amount Line") { DataItemTableView = sorting("VAT Identifier", "VAT Calculation Type", "Tax Group Code", "Use Tax", Positive); UseTemporary = true; column(VATIdentifier_VATClauseLine; "VAT Identifier") { } column(Code_VATClauseLine; VATClause.Code) { } column(Code_VATClauseLine_Lbl; VATClause.FieldCaption(Code)) { } column(Description_VATClauseLine; VATClauseText) { } column(Description2_VATClauseLine; VATClause."Description 2") { } column(VATAmount_VATClauseLine; "VAT Amount") { AutoFormatExpression = Header."Currency Code"; AutoFormatType = 1; } column(NoOfVATClauses; Count) { } trigger OnAfterGetRecord() begin if "VAT Clause Code" = '' then CurrReport.Skip(); if not VATClause.Get("VAT Clause Code") then CurrReport.Skip(); VATClauseText := VATClause.GetDescriptionText(Header); end; } dataitem(ReportTotalsLine; "Report Totals Buffer") { DataItemTableView = sorting("Line No."); UseTemporary = true; column(Description_ReportTotalsLine; Description) { } column(Amount_ReportTotalsLine; Amount) { AutoFormatExpression = Header."Currency Code"; AutoFormatType = 1; } column(AmountFormatted_ReportTotalsLine; "Amount Formatted") { } column(FontBold_ReportTotalsLine; "Font Bold") { } column(FontUnderline_ReportTotalsLine; "Font Underline") { } trigger OnPreDataItem() begin CreateReportTotalLines(); end; } dataitem(LetterText; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(GreetingText; GreetingLbl) { } column(BodyText; BodyLbl) { } column(ClosingText; ClosingLbl) { } } dataitem(Totals; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(TotalNetAmount; Format(TotalAmount, 0, AutoFormat.ResolveAutoFormat(Enum::"Auto Format"::AmountFormat, Header."Currency Code"))) { } column(TotalVATBaseLCY; TotalVATBaseLCY) { } column(TotalAmountIncludingVAT; Format(TotalAmountInclVAT, 0, AutoFormat.ResolveAutoFormat(Enum::"Auto Format"::AmountFormat, Header."Currency Code"))) { } column(TotalVATAmount; Format(TotalAmountVAT, 0, AutoFormat.ResolveAutoFormat(Enum::"Auto Format"::AmountFormat, Header."Currency Code"))) { } column(TotalVATAmountLCY; TotalVATAmountLCY) { } column(TotalInvoiceDiscountAmount; Format(TotalInvDiscAmount, 0, AutoFormat.ResolveAutoFormat(Enum::"Auto Format"::AmountFormat, Header."Currency Code"))) { } column(TotalPaymentDiscountOnVAT; TotalPaymentDiscOnVAT) { } column(TotalVATAmountText; VATAmountLine.VATAmountText()) { } column(TotalExcludingVATText; TotalExclVATText) { } column(TotalIncludingVATText; TotalInclVATText) { } column(TotalSubTotal; Format(TotalSubTotal, 0, AutoFormat.ResolveAutoFormat(Enum::"Auto Format"::AmountFormat, Header."Currency Code"))) { } column(TotalSubTotalMinusInvoiceDiscount; Format(TotalSubTotal + TotalInvDiscAmount, 0, AutoFormat.ResolveAutoFormat(Enum::"Auto Format"::AmountFormat, Header."Currency Code"))) { } column(TotalText; TotalText) { } column(CurrencyCode; CurrCode) { } column(CurrencySymbol; CurrSymbol) { } } trigger OnAfterGetRecord() var CurrencyExchangeRate: Record "Currency Exchange Rate"; Currency: Record Currency; GeneralLedgerSetup: Record "General Ledger Setup"; begin if not IsReportInPreviewMode() then CODEUNIT.Run(CODEUNIT::"Sales Cr. Memo-Printed", Header); OnHeaderOnAfterGetRecordOnAfterUpdateNoPrinted(IsReportInPreviewMode(), Header); CalcFields("Work Description"); ShowWorkDescription := "Work Description".HasValue; CurrReport.Language := LanguageMgt.GetLanguageIdOrDefault("Language Code"); CurrReport.FormatRegion := LanguageMgt.GetFormatRegionOrDefault("Format Region"); FormatAddr.SetLanguageCode("Language Code"); FormatAddressFields(Header); FormatDocumentFields(Header); if SellToContact.Get("Sell-to Contact No.") then; if BillToContact.Get("Bill-to Contact No.") then; if not Cust.Get("Bill-to Customer No.") then Clear(Cust); if not CompanyBankAccount.Get(Header."Company Bank Account Code") then CompanyBankAccount.CopyBankFieldsFromCompanyInfo(CompanyInfo); if "Currency Code" <> '' then begin CurrencyExchangeRate.FindCurrency("Posting Date", "Currency Code", 1); CalculatedExchRate := Round(1 / "Currency Factor" * CurrencyExchangeRate."Exchange Rate Amount", 0.000001); ExchangeRateText := StrSubstNo(ExchangeRateTxt, CalculatedExchRate, CurrencyExchangeRate."Exchange Rate Amount"); CurrCode := "Currency Code"; if Currency.Get("Currency Code") then CurrSymbol := Currency.GetCurrencySymbol(); end else if GeneralLedgerSetup.Get() then begin CurrCode := GeneralLedgerSetup."LCY Code"; CurrSymbol := GeneralLedgerSetup.GetCurrencySymbol(); end; TotalSubTotal := 0; TotalInvDiscAmount := 0; TotalAmount := 0; TotalAmountVAT := 0; TotalAmountInclVAT := 0; TotalPaymentDiscOnVAT := 0; end; trigger OnPreDataItem() begin FirstLineHasBeenOutput := false; end; } } requestpage { SaveValues = true; layout { area(content) { group(Options) { Caption = 'Options'; field(LogInteraction; LogInteraction) { ApplicationArea = Basic, Suite; Caption = 'Log Interaction'; Enabled = LogInteractionEnable; ToolTip = 'Specifies that interactions with the contact are logged.'; } field(DisplayAsmInformation; DisplayAssemblyInformation) { ApplicationArea = Assembly; Caption = 'Show Assembly Components'; ToolTip = 'Specifies if you want the report to include information about components that were used in linked assembly orders that supplied the item(s) being sold.'; } field(DisplayShipmentInformation; DisplayShipmentInformation) { ApplicationArea = Basic, Suite; Caption = 'Show Shipments'; ToolTip = 'Specifies that shipments are shown on the document.'; } field(HideLinesWithZeroQuantityControl; HideLinesWithZeroQuantity) { ApplicationArea = Basic, Suite; ToolTip = 'Specifies if the lines with zero quantity are printed.'; Caption = 'Hide lines with zero quantity'; } } } } actions { } trigger OnInit() begin InitLogInteraction(); LogInteractionEnable := LogInteraction; end; } rendering { layout("StandardSalesCreditMemo.rdlc") { Type = RDLC; LayoutFile = './Sales/History/StandardSalesCreditMemo.rdlc'; Caption = 'Standard Sales Credit Memo (RDLC)'; Summary = 'The Standard Sales Credit Memo (RDLC) provides a detailed layout.'; } layout("StandardSalesCreditMemo.docx") { Type = Word; LayoutFile = './Sales/History/StandardSalesCreditMemo.docx'; Caption = 'Standard Sales Credit Memo (Word)'; Summary = 'The Standard Sales Credit Memo (Word) provides a basic layout.'; } layout("StandardSalesCreditMemoThemable.docx") { Type = Word; LayoutFile = './Sales/History/StandardSalesCreditMemoThemable.docx'; Caption = 'Standard Sales Credit Memo - themable Word layout'; Summary = 'The Standard Sales Credit Memo (Word) provides a basic Themable layout.'; } layout("StandardSalesCreditMemoEmail.docx") { Type = Word; LayoutFile = './Sales/History/StandardSalesCreditMemoEmail.docx'; Caption = 'Standard Sales Credit Memo Email (Word)'; Summary = 'The Standard Sales Credit Memo Email (Word) provides an email body layout.'; } } labels { } trigger OnInitReport() var IsHandled: Boolean; begin GLSetup.Get(); CompanyInfo.SetAutoCalcFields(Picture); CompanyInfo.Get(); SalesSetup.Get(); CompanyInfo.VerifyAndSetPaymentInfo(); if SalesSetup.GetLegalStatement() <> '' then LegalStatementLbl := SalesSetup.GetLegalStatement(); IsHandled := false; OnInitReportForGlobalVariable(IsHandled, LegalOfficeTxt, LegalOfficeLbl, CustomGiroTxt, CustomGiroLbl, LegalStatementLbl); end; trigger OnPostReport() begin if LogInteraction and not IsReportInPreviewMode() then if Header.FindSet() then repeat if Header."Bill-to Contact No." <> '' then SegManagement.LogDocument( 6, Header."No.", 0, 0, DATABASE::Contact, Header."Bill-to Contact No.", Header."Salesperson Code", Header."Campaign No.", Header."Posting Description", '') else SegManagement.LogDocument( 6, Header."No.", 0, 0, DATABASE::Customer, Header."Bill-to Customer No.", Header."Salesperson Code", Header."Campaign No.", Header."Posting Description", ''); until Header.Next() = 0; end; trigger OnPreReport() begin if Header.GetFilters = '' then Error(NoFilterSetErr); CompanyLogoPosition := SalesSetup."Logo Position on Documents"; end; var GLSetup: Record "General Ledger Setup"; PaymentMethod: Record "Payment Method"; DummyCompanyInfo: Record "Company Information"; SalesSetup: Record "Sales & Receivables Setup"; Cust: Record Customer; RespCenter: Record "Responsibility Center"; LanguageMgt: Codeunit Language; FormatAddr: Codeunit "Format Address"; FormatDocument: Codeunit "Format Document"; SegManagement: Codeunit SegManagement; AutoFormat: Codeunit "Auto Format"; WorkDescriptionInstream: InStream; WorkDescriptionLine: Text; MoreLines: Boolean; CopyText: Text[30]; ShowWorkDescription: Boolean; LogInteraction: Boolean; TransHeaderAmount: Decimal; LogInteractionEnable: Boolean; CompanyLogoPosition: Integer; CalculatedExchRate: Decimal; ExchangeRateText: Text; PrevLineAmount: Decimal; AppliesToText: Text; CurrCode: Text[10]; CurrSymbol: Text[10];#pragma warning disable AA0470 SalesCreditMemoNoLbl: Label 'Sales - Credit Memo %1';#pragma warning restore AA0470 SalespersonLbl: Label 'Sales person'; CompanyInfoBankAccNoLbl: Label 'Account No.'; CompanyInfoBankNameLbl: Label 'Bank'; CompanyInfoGiroNoLbl: Label 'Giro No.'; CompanyInfoPhoneNoLbl: Label 'Phone No.'; CopyLbl: Label 'Copy'; EMailLbl: Label 'Email'; HomePageLbl: Label 'Home Page'; InvDiscBaseAmtLbl: Label 'Invoice Discount Base Amount'; InvDiscountAmtLbl: Label 'Invoice Discount'; InvNoLbl: Label 'Credit Memo No.'; LineAmtAfterInvDiscLbl: Label 'Payment Discount on VAT'; LocalCurrencyLbl: Label 'Local Currency'; PageLbl: Label 'Page'; PaymentTermsDescLbl: Label 'Payment Terms'; PaymentMethodDescLbl: Label 'Payment Method'; PostedShipmentDateLbl: Label 'Shipment Date'; SalesInvLineDiscLbl: Label 'Discount %'; SalesCreditMemoLbl: Label 'Credit Memo'; ShipmentLbl: Label 'Shipment'; ShiptoAddrLbl: Label 'Ship-to Address'; ShptMethodDescLbl: Label 'Shipment Method'; SubtotalLbl: Label 'Subtotal'; TotalLbl: Label 'Total'; VATAmtSpecificationLbl: Label 'VAT Amount Specification'; VATAmountLCYLbl: Label 'VAT Amount (LCY)'; VATBaseLbl: Label 'VAT Base'; VATBaseLCYLbl: Label 'VAT Base (LCY)'; VATClausesLbl: Label 'VAT Clause'; VATIdentifierLbl: Label 'VAT Identifier'; VATPercentageLbl: Label 'VAT %'; SellToContactPhoneNoLbl: Label 'Sell-to Contact Phone No.'; SellToContactMobilePhoneNoLbl: Label 'Sell-to Contact Mobile Phone No.'; SellToContactEmailLbl: Label 'Sell-to Contact E-Mail'; BillToContactPhoneNoLbl: Label 'Bill-to Contact Phone No.'; BillToContactMobilePhoneNoLbl: Label 'Bill-to Contact Mobile Phone No.'; BillToContactEmailLbl: Label 'Bill-to Contact E-Mail';#pragma warning disable AA0470 SalesPrepCreditMemoNoLbl: Label 'Sales - Prepmt. Credit Memo %1';#pragma warning restore AA0470 ExchangeRateTxt: Label 'Exchange rate: %1/%2', Comment = '%1 and %2 are both amounts.'; AppliesToTextLbl: Label 'Applies to Document'; NoFilterSetErr: Label 'You must specify one or more filters to avoid accidentally printing all documents.'; GreetingLbl: Label 'Hello'; ClosingLbl: Label 'Sincerely'; BodyLbl: Label 'Thank you for your business. Your credit memo is attached to this message.'; LCYTxt: label ' (LCY)'; VATClauseText: Text; LegalOfficeTxt, LegalOfficeLbl, CustomGiroTxt, CustomGiroLbl, LegalStatementLbl : Text; protected var CompanyInfo: Record "Company Information"; CompanyBankAccount: Record "Bank Account"; PaymentTerms: Record "Payment Terms"; SalespersonPurchaser: Record "Salesperson/Purchaser"; ShipmentMethod: Record "Shipment Method"; SellToContact: Record Contact; BillToContact: Record Contact; VATClause: Record "VAT Clause"; CustAddr: array[8] of Text[100]; ShipToAddr: array[8] of Text[100]; CompanyAddr: array[8] of Text[100]; FormattedLineAmount: Text; FormattedQuantity: Text; FormattedUnitPrice: Text; FormattedVATPct: Text; LineDiscountPctText: Text; SalesPersonText: Text[50]; TotalText: Text[50]; TotalExclVATText: Text[50]; TotalInclVATText: Text[50]; TotalAmount: Decimal; TotalAmountInclVAT: Decimal; TotalAmountVAT: Decimal; TotalSubTotal: Decimal; TotalInvDiscAmount: Decimal; TotalPaymentDiscOnVAT: Decimal; DisplayAssemblyInformation: Boolean; DisplayShipmentInformation: Boolean; FirstLineHasBeenOutput: Boolean; ShowShippingAddr: Boolean; VATBaseLCY: Decimal; VATAmountLCY: Decimal; TotalVATBaseLCY: Decimal; TotalVATAmountLCY: Decimal; VATAmtLbl: Label 'VAT Amount'; HideLinesWithZeroQuantity: Boolean; local procedure InitLogInteraction() begin LogInteraction := SegManagement.FindInteractionTemplateCode(Enum::"Interaction Log Entry Document Type"::"Sales Cr. Memo") <> ''; end; local procedure InitializeSalesShipmentLine() var ReturnReceiptHeader: Record "Return Receipt Header"; begin if not DisplayShipmentInformation then exit; if Line."Return Receipt No." <> '' then if ReturnReceiptHeader.Get(Line."Return Receipt No.") then exit; if Header."Return Order No." = '' then exit; if Line.Type = Line.Type::" " then exit; ShipmentLine.GetLinesForSalesCreditMemoLine(Line, Header); ShipmentLine.Reset(); ShipmentLine.SetRange("Line No.", Line."Line No."); if not ShipmentLine.IsEmpty() then begin ShipmentLine.CalcSums(Quantity); if ShipmentLine.Quantity <> Line.Quantity then begin ShipmentLine.DeleteAll(); exit; end; end; end; protected procedure IsReportInPreviewMode(): Boolean var MailManagement: Codeunit "Mail Management"; begin exit(CurrReport.Preview() or MailManagement.IsHandlingGetEmailBody()); end; local procedure DocumentCaption(): Text[250] var DocCaption: Text[250]; begin OnBeforeDocumentCaption(Header, DocCaption); if DocCaption <> '' then exit(DocCaption); if Header."Prepayment Credit Memo" then exit(SalesPrepCreditMemoNoLbl); exit(SalesCreditMemoNoLbl); end; /// <summary> /// Initializes the report request options for the sales credit memo report. /// </summary> /// <param name="NewLogInteraction">Specifies whether to log the interaction.</param> /// <param name="DisplayAsmInfo">Specifies whether to display assembly information.</param> procedure InitializeRequest(NewLogInteraction: Boolean; DisplayAsmInfo: Boolean) begin LogInteraction := NewLogInteraction; DisplayAssemblyInformation := DisplayAsmInfo; end; local procedure GetUOMText(UOMCode: Code[10]): Text[50] var UnitOfMeasure: Record "Unit of Measure"; begin if not UnitOfMeasure.Get(UOMCode) then exit(UOMCode); exit(UnitOfMeasure.Description); end; local procedure InsertVATAmountLine(var VATAmountLine2: Record "VAT Amount Line"; var SalesCrMemoLine: Record "Sales Cr.Memo Line") var IsHandled: Boolean; begin IsHandled := false; OnBeforeVATAmountLineInsertLine(VATAmountLine2, SalesCrMemoLine, IsHandled); if IsHandled then exit; VATAmountLine2.Init(); VATAmountLine2."VAT Identifier" := SalesCrMemoLine."VAT Identifier"; VATAmountLine2."VAT Calculation Type" := SalesCrMemoLine."VAT Calculation Type"; VATAmountLine2."Tax Group Code" := SalesCrMemoLine."Tax Group Code"; VATAmountLine2."VAT %" := SalesCrMemoLine."VAT %"; VATAmountLine2."VAT Base" := SalesCrMemoLine.Amount; VATAmountLine2."Amount Including VAT" := SalesCrMemoLine."Amount Including VAT"; VATAmountLine2."Line Amount" := SalesCrMemoLine."Line Amount"; if SalesCrMemoLine."Allow Invoice Disc." then VATAmountLine2."Inv. Disc. Base Amount" := SalesCrMemoLine."Line Amount"; VATAmountLine2."Invoice Discount Amount" := SalesCrMemoLine."Inv. Discount Amount"; VATAmountLine2."VAT Clause Code" := SalesCrMemoLine."VAT Clause Code"; VATAmountLine2.InsertLine(); end; local procedure CreateReportTotalLines() begin ReportTotalsLine.DeleteAll(); if (TotalInvDiscAmount <> 0) or (TotalAmountVAT <> 0) then ReportTotalsLine.Add(SubtotalLbl, TotalSubTotal, true, false, false, Header."Currency Code"); if TotalInvDiscAmount <> 0 then begin ReportTotalsLine.Add(InvDiscountAmtLbl, TotalInvDiscAmount, false, false, false, Header."Currency Code"); if TotalAmountVAT <> 0 then ReportTotalsLine.Add(TotalExclVATText, TotalAmount, true, false, false, Header."Currency Code"); end; if TotalAmountVAT <> 0 then begin ReportTotalsLine.Add(VATAmountLine.VATAmountText(), TotalAmountVAT, false, true, false, Header."Currency Code"); if TotalVATAmountLCY <> TotalAmountVAT then ReportTotalsLine.Add(VATAmountLine.VATAmountText() + LCYTxt, TotalVATAmountLCY, false, true, false); end; end; local procedure FormatAddressFields(var SalesCrMemoHeader: Record "Sales Cr.Memo Header") begin FormatAddr.GetCompanyAddr(SalesCrMemoHeader."Responsibility Center", RespCenter, CompanyInfo, CompanyAddr); FormatAddr.SalesCrMemoBillTo(CustAddr, SalesCrMemoHeader); ShowShippingAddr := FormatAddr.SalesCrMemoShipTo(ShipToAddr, CustAddr, SalesCrMemoHeader); end; local procedure FormatDocumentFields(SalesCrMemoHeader: Record "Sales Cr.Memo Header") begin FormatDocument.SetTotalLabels(SalesCrMemoHeader."Currency Code", TotalText, TotalInclVATText, TotalExclVATText); FormatDocument.SetSalesPerson(SalespersonPurchaser, SalesCrMemoHeader."Salesperson Code", SalesPersonText); FormatDocument.SetPaymentTerms(PaymentTerms, SalesCrMemoHeader."Payment Terms Code", SalesCrMemoHeader."Language Code"); FormatDocument.SetPaymentMethod(PaymentMethod, SalesCrMemoHeader."Payment Method Code", SalesCrMemoHeader."Language Code"); FormatDocument.SetShipmentMethod(ShipmentMethod, SalesCrMemoHeader."Shipment Method Code", SalesCrMemoHeader."Language Code"); AppliesToText := FormatDocument.SetText(SalesCrMemoHeader."Applies-to Doc. No." <> '', StrSubstNo('%1 %2', Format(SalesCrMemoHeader."Applies-to Doc. Type"), SalesCrMemoHeader."Applies-to Doc. No.")); OnAfterFormatDocumentFields(SalesCrMemoHeader); end; local procedure FormatLineValues(CurrLine: Record "Sales Cr.Memo Line") var IsHandled: Boolean; begin IsHandled := false; OnBeforeFormatLineValues(CurrLine, FormattedQuantity, FormattedUnitPrice, FormattedVATPct, FormattedLineAmount, IsHandled); if not IsHandled then FormatDocument.SetSalesCrMemoLine(CurrLine, FormattedQuantity, FormattedUnitPrice, FormattedVATPct, FormattedLineAmount); end; [IntegrationEvent(false, false)] local procedure OnBeforeDocumentCaption(SalesCrMemoHeader: Record "Sales Cr.Memo Header"; var DocCaption: Text[250]) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeFormatLineValues(SalesCrMemoLine: Record "Sales Cr.Memo Line"; var FormattedQuantity: Text; var FormattedUnitPrice: Text; var FormattedVATPercentage: Text; var FormattedLineAmount: Text; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnAfterFormatDocumentFields(SalesCrMemoHeader: Record "Sales Cr.Memo Header") begin end; [IntegrationEvent(false, false)] local procedure OnLineOnAfterGetRecordOnBeforeCheckLineDiscount(var SalesCrMemoLine: Record "Sales Cr.Memo Line"; var SalesCrMemoHeader: Record "Sales Cr.Memo Header") begin end; [IntegrationEvent(false, false)] local procedure OnInitReportForGlobalVariable(var IsHandled: Boolean; var LegalOfficeTxt: Text; var LegalOfficeLbl: Text; var CustomGiroTxt: Text; var CustomGiroLbl: Text; var LegalStatementLbl: Text) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeVATAmountLineInsertLine(var VATAmountLine: Record "VAT Amount Line"; var SalesCrMemoLine: Record "Sales Cr.Memo Line"; var IsHandled: Boolean) begin end; [IntegrationEvent(true, false)] local procedure OnHeaderOnAfterGetRecordOnAfterUpdateNoPrinted(ReportInPreviewMode: Boolean; var SalesCrMemoHeader: Record "Sales Cr.Memo Header") begin end;}