Report 1322 Standard Purchase - Order
src/Layers/W1/BaseApp/Purchases/Document/StandardPurchaseOrder.Report.al1,278 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.Purchases.Document;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.ReceivablesPayables;using Microsoft.Finance.VAT.Calculation;using Microsoft.Foundation.Address;using Microsoft.Foundation.Company;using Microsoft.Foundation.PaymentTerms;using Microsoft.Foundation.Shipping;using Microsoft.Inventory.Location;using Microsoft.Purchases.Posting;using Microsoft.Purchases.Setup;using Microsoft.Purchases.Vendor;using Microsoft.Utilities;using System.Email;using System.Globalization;using System.Utilities;report 1322 "Standard Purchase - Order"{ Caption = 'Purchase - Order'; DefaultRenderingLayout = "StandardPurchaseOrder.docx"; EnableHyperlinks = true; PreviewMode = PrintLayout; WordMergeDataItem = "Purchase Header"; dataset { dataitem("Purchase Header"; "Purchase Header") { DataItemTableView = sorting("Document Type", "No.") where("Document Type" = const(Order)); RequestFilterFields = "No.", "Buy-from Vendor No.", "No. Printed"; RequestFilterHeading = 'Standard Purchase - Order'; 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_Lbl; HomePageCaptionLbl) { } column(CompanyHomePage; CompanyInfo."Home Page") { } column(CompanyEmail_Lbl; EmailIDCaptionLbl) { } column(CompanyEMail; CompanyInfo."E-Mail") { } column(CompanyPicture; DummyCompanyInfo.Picture) { } column(CompanyPhoneNo; CompanyInfo."Phone No.") { } column(CompanyPhoneNo_Lbl; CompanyInfoPhoneNoCaptionLbl) { } column(CompanyGiroNo; CompanyInfo."Giro No.") { } column(CompanyGiroNo_Lbl; CompanyInfoGiroNoCaptionLbl) { } column(CompanyBankName; CompanyInfo."Bank Name") { } column(CompanyBankName_Lbl; CompanyInfoBankNameCaptionLbl) { } column(CompanyBankBranchNo; CompanyInfo."Bank Branch No.") { } column(CompanyBankBranchNo_Lbl; CompanyInfo.FieldCaption("Bank Branch No.")) { } column(CompanyBankAccountNo; CompanyInfo."Bank Account No.") { } column(CompanyBankAccountNo_Lbl; CompanyInfoBankAccNoCaptionLbl) { } column(CompanyIBAN; CompanyInfo.IBAN) { } column(CompanyIBAN_Lbl; CompanyInfo.FieldCaption(IBAN)) { } column(CompanySWIFT; CompanyInfo."SWIFT Code") { } column(CompanySWIFT_Lbl; CompanyInfo.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(DocType_PurchHeader; "Document Type") { } column(No_PurchHeader; "No.") { } column(DocumentTitle_Lbl; DocumentTitleLbl) { } column(Amount_Lbl; AmountCaptionLbl) { } column(PurchLineInvDiscAmt_Lbl; PurchLineInvDiscAmtCaptionLbl) { } column(Subtotal_Lbl; SubtotalCaptionLbl) { } column(VATAmtLineVAT_Lbl; VATAmtLineVATCaptionLbl) { } column(VATAmtLineVATAmt_Lbl; VATAmtLineVATAmtCaptionLbl) { } column(VATAmtSpec_Lbl; VATAmtSpecCaptionLbl) { } column(VATIdentifier_Lbl; VATIdentifierCaptionLbl) { } column(VATAmtLineInvDiscBaseAmt_Lbl; VATAmtLineInvDiscBaseAmtCaptionLbl) { } column(VATAmtLineLineAmt_Lbl; VATAmtLineLineAmtCaptionLbl) { } column(VALVATBaseLCY_Lbl; VALVATBaseLCYCaptionLbl) { } column(Total_Lbl; TotalCaptionLbl) { } column(PaymentTermsDesc_Lbl; PaymentTermsDescCaptionLbl) { } column(ShipmentMethodDesc_Lbl; ShipmentMethodDescCaptionLbl) { } column(PrepymtTermsDesc_Lbl; PrepymtTermsDescCaptionLbl) { } column(HomePage_Lbl; HomePageCaptionLbl) { } column(EmailID_Lbl; EmailIDCaptionLbl) { } column(AllowInvoiceDisc_Lbl; AllowInvoiceDiscCaptionLbl) { } column(DocumentDate; Format("Document Date", 0, 4)) { } column(DueDate; Format("Due Date", 0, 4)) { } column(ExptRecptDt_PurchaseHeader; Format("Expected Receipt Date", 0, 4)) { } column(OrderDate_PurchaseHeader; Format("Order Date", 0, 4)) { } column(VATNoText; VATNoText) { } column(VATRegNo_PurchHeader; "VAT Registration No.") { } column(PurchaserText; PurchaserText) { } column(SalesPurchPersonName; SalespersonPurchaser.Name) { } column(ReferenceText; ReferenceText) { } column(YourRef_PurchHeader; "Your Reference") { } column(BuyFrmVendNo_PurchHeader; "Buy-from Vendor No.") { } column(BuyFromAddr1; BuyFromAddr[1]) { } column(BuyFromAddr2; BuyFromAddr[2]) { } column(BuyFromAddr3; BuyFromAddr[3]) { } column(BuyFromAddr4; BuyFromAddr[4]) { } column(BuyFromAddr5; BuyFromAddr[5]) { } column(BuyFromAddr6; BuyFromAddr[6]) { } column(BuyFromAddr7; BuyFromAddr[7]) { } column(BuyFromAddr8; BuyFromAddr[8]) { } column(BuyFromContactPhoneNoLbl; BuyFromContactPhoneNoLbl) { } column(BuyFromContactMobilePhoneNoLbl; BuyFromContactMobilePhoneNoLbl) { } column(BuyFromContactEmailLbl; BuyFromContactEmailLbl) { } column(PayToContactPhoneNoLbl; PayToContactPhoneNoLbl) { } column(PayToContactMobilePhoneNoLbl; PayToContactMobilePhoneNoLbl) { } column(PayToContactEmailLbl; PayToContactEmailLbl) { } column(BuyFromContactPhoneNo; BuyFromContact."Phone No.") { } column(BuyFromContactMobilePhoneNo; BuyFromContact."Mobile Phone No.") { } column(BuyFromContactEmail; BuyFromContact."E-Mail") { } column(PayToContactPhoneNo; PayToContact."Phone No.") { } column(PayToContactMobilePhoneNo; PayToContact."Mobile Phone No.") { } column(PayToContactEmail; PayToContact."E-Mail") { } column(PricesIncludingVAT_Lbl; PricesIncludingVATCaptionLbl) { } column(PricesInclVAT_PurchHeader; "Prices Including VAT") { } column(OutputNo; OutputNo) { } column(VATBaseDisc_PurchHeader; "VAT Base Discount %") { } column(PricesInclVATtxt; PricesInclVATtxtLbl) { } column(PaymentTermsDesc; PaymentTerms.Description) { } column(ShipmentMethodDesc; ShipmentMethod.Description) { } column(PrepmtPaymentTermsDesc; PrepmtPaymentTerms.Description) { } column(DimText; DimText) { } column(OrderNo_Lbl; OrderNoCaptionLbl) { } column(Page_Lbl; PageCaptionLbl) { } column(DocumentDate_Lbl; DocumentDateCaptionLbl) { } column(BuyFrmVendNo_PurchHeader_Lbl; FieldCaption("Buy-from Vendor No.")) { } column(PricesInclVAT_PurchHeader_Lbl; FieldCaption("Prices Including VAT")) { } column(Receiveby_Lbl; ReceivebyCaptionLbl) { } column(Buyer_Lbl; BuyerCaptionLbl) { } column(PayToVendNo_PurchHeader; "Pay-to Vendor No.") { } column(VendAddr8; VendAddr[8]) { } column(VendAddr7; VendAddr[7]) { } column(VendAddr6; VendAddr[6]) { } column(VendAddr5; VendAddr[5]) { } column(VendAddr4; VendAddr[4]) { } column(VendAddr3; VendAddr[3]) { } column(VendAddr2; VendAddr[2]) { } column(VendAddr1; VendAddr[1]) { } column(PaymentDetails_Lbl; PaymentDetailsCaptionLbl) { } column(VendNo_Lbl; VendNoCaptionLbl) { } column(SellToCustNo_PurchHeader; "Sell-to Customer No.") { } column(ShipToAddr1; ShipToAddr[1]) { } column(ShipToAddr2; ShipToAddr[2]) { } column(ShipToAddr3; ShipToAddr[3]) { } column(ShipToAddr4; ShipToAddr[4]) { } column(ShipToAddr5; ShipToAddr[5]) { } column(ShipToAddr6; ShipToAddr[6]) { } column(ShipToAddr7; ShipToAddr[7]) { } column(ShipToAddr8; ShipToAddr[8]) { } column(ShiptoAddress_Lbl; ShiptoAddressCaptionLbl) { } column(ShipToPhoneNo; "Purchase Header"."Ship-to Phone No.") { } column(SellToCustNo_PurchHeader_Lbl; FieldCaption("Sell-to Customer No.")) { } column(ItemNumber_Lbl; ItemNumberCaptionLbl) { } column(ItemDescription_Lbl; ItemDescriptionCaptionLbl) { } column(ItemQuantity_Lbl; ItemQuantityCaptionLbl) { } column(ItemUnit_Lbl; ItemUnitCaptionLbl) { } column(ItemUnitPrice_Lbl; ItemUnitPriceCaptionLbl) { } column(ItemLineAmount_Lbl; ItemLineAmountCaptionLbl) { } column(ToCaption_Lbl; ToCaptionLbl) { } column(VendorIDCaption_Lbl; VendorIDCaptionLbl) { } column(ConfirmToCaption_Lbl; ConfirmToCaptionLbl) { } column(PurchOrderCaption_Lbl; PurchOrderCaptionLbl) { } column(PurchOrderNumCaption_Lbl; PurchOrderNumCaptionLbl) { } column(PurchOrderDateCaption_Lbl; PurchOrderDateCaptionLbl) { } column(TaxIdentTypeCaption_Lbl; TaxIdentTypeCaptionLbl) { } column(OrderDate_Lbl; OrderDateLbl) { } column(SpendRequestNo_Lbl; FieldCaption("Spend Request No.")) { } column(SpendRequestNo; "Spend Request No.") { } column(VendorInvoiceNo_Lbl; VendorInvoiceNoLbl) { } column(VendorInvoiceNo; "Vendor Invoice No.") { } column(VendorOrderNo_Lbl; VendorOrderNoLbl) { } column(VendorOrderNo; "Vendor Order No.") { } dataitem("Purchase Line"; "Purchase Line") { DataItemLink = "Document Type" = field("Document Type"), "Document No." = field("No."); DataItemTableView = sorting("Document Type", "Document No.", "Line No."); column(LineNo_PurchLine; "Line No.") { } column(AllowInvDisctxt; AllowInvDisctxt) { } column(Type_PurchLine; Format(Type, 0, 2)) { } column(No_PurchLine; ItemNo) { } column(ItemNo_PurchLine; "No.") { } column(VendorItemNo_PurchLine; "Vendor Item No.") { } column(ItemReferenceNo_PurchLine; "Item Reference No.") { } column(Desc_PurchLine; Description) { } column(Qty_PurchLine; FormattedQuanitity) { } column(UOM_PurchLine; "Unit of Measure") { } column(DirUnitCost_PurchLine; FormattedDirectUnitCost) { AutoFormatExpression = "Purchase Header"."Currency Code"; AutoFormatType = 2; } column(LineDisc_PurchLine; "Line Discount %") { } column(LineAmt_PurchLine; FormattedLineAmount) { } column(AllowInvDisc_PurchLine; "Allow Invoice Disc.") { } column(VATIdentifier_PurchLine; "VAT Identifier") { } column(InvDiscAmt_PurchLine; -"Inv. Discount Amount") { AutoFormatExpression = "Currency Code"; AutoFormatType = 1; } column(TotalInclVAT; "Line Amount" - "Inv. Discount Amount") { AutoFormatExpression = "Purchase Header"."Currency Code"; AutoFormatType = 1; } column(DirectUniCost_Lbl; DirectUniCostCaptionLbl) { } column(PurchLineLineDisc_Lbl; PurchLineLineDiscCaptionLbl) { } column(VATDiscountAmount_Lbl; VATDiscountAmountCaptionLbl) { } column(No_PurchLine_Lbl; FieldCaption("No.")) { } column(Desc_PurchLine_Lbl; FieldCaption(Description)) { } column(Qty_PurchLine_Lbl; FieldCaption(Quantity)) { } column(UOM_PurchLine_Lbl; ItemUnitOfMeasureCaptionLbl) { } column(VATIdentifier_PurchLine_Lbl; FieldCaption("VAT Identifier")) { } column(AmountIncludingVAT; "Amount Including VAT") { } column(TotalPriceCaption_Lbl; TotalPriceCaptionLbl) { } column(InvDiscCaption_Lbl; InvDiscCaptionLbl) { } column(UnitPrice_PurchLine; "Unit Price (LCY)") { } column(UnitPrice_PurchLine_Lbl; UnitPriceLbl) { } column(JobNo_PurchLine; "Job No.") { } column(JobNo_PurchLine_Lbl; JobNoLbl) { } column(JobTaskNo_PurchLine; "Job Task No.") { } column(JobTaskNo_PurchLine_Lbl; JobTaskNoLbl) { } column(PlannedReceiptDateLbl; PlannedReceiptDateLbl) { } column(PlannedReceiptDate; Format("Planned Receipt Date", 0, 4)) { } column(ExpectedReceiptDateLbl; ExpectedReceiptDateLbl) { } column(ExpectedReceiptDate; Format("Expected Receipt Date", 0, 4)) { } column(PromisedReceiptDateLbl; PromisedReceiptDateLbl) { } column(PromisedReceiptDate; Format("Promised Receipt Date", 0, 4)) { } column(RequestedReceiptDateLbl; RequestedReceiptDateLbl) { } column(RequestedReceiptDate; Format("Requested Receipt Date", 0, 4)) { } column(PurchLine_VATPct; "VAT %") { } column(SpendRequestNo_PurchLine2_Lbl; FieldCaption("Spend Request No.")) { } column(SpendRequestNo_PurchLine; "Spend Request No.") { } trigger OnAfterGetRecord() begin AllowInvDisctxt := Format("Allow Invoice Disc."); TotalSubTotal += "Line Amount"; TotalInvoiceDiscountAmount -= "Inv. Discount Amount"; TotalAmount += Amount; ItemNo := "No."; if "Vendor Item No." <> '' then ItemNo := "Vendor Item No."; if "Item Reference No." <> '' then ItemNo := "Item Reference No."; FormatDocument.SetPurchaseLine("Purchase Line", FormattedQuanitity, FormattedDirectUnitCost, FormattedVATPct, FormattedLineAmount); if FirstLineHasBeenOutput then Clear(DummyCompanyInfo.Picture); FirstLineHasBeenOutput := true; end; trigger OnPreDataItem() begin FirstLineHasBeenOutput := false; DummyCompanyInfo.Picture := CompanyInfo.Picture; end; } dataitem(Totals; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(VATAmountText; TempVATAmountLine.VATAmountText()) { } column(TotalVATAmount; VATAmount) { AutoFormatExpression = "Purchase Header"."Currency Code"; AutoFormatType = 1; } column(TotalVATDiscountAmount; -VATDiscountAmount) { AutoFormatExpression = "Purchase Header"."Currency Code"; AutoFormatType = 1; } column(TotalVATBaseAmount; VATBaseAmount) { AutoFormatExpression = "Purchase Header"."Currency Code"; AutoFormatType = 1; } column(TotalAmountInclVAT; TotalAmountInclVAT) { AutoFormatExpression = "Purchase Header"."Currency Code"; AutoFormatType = 1; } column(TotalInclVATText; TotalInclVATText) { } column(TotalExclVATText; TotalExclVATText) { } column(TotalSubTotal; TotalSubTotal) { AutoFormatExpression = "Purchase Header"."Currency Code"; AutoFormatType = 1; } column(TotalInvoiceDiscountAmount; TotalInvoiceDiscountAmount) { AutoFormatExpression = "Purchase Header"."Currency Code"; AutoFormatType = 1; } column(TotalAmount; TotalAmount) { AutoFormatExpression = "Purchase Header"."Currency Code"; AutoFormatType = 1; } column(TotalText; TotalText) { } trigger OnAfterGetRecord() var TempPrepmtPurchLine: Record "Purchase Line" temporary; begin FirstLineHasBeenOutput := false; Clear(TempPurchLine); Clear(PurchPost); TempPurchLine.DeleteAll(); TempVATAmountLine.DeleteAll(); PurchPost.GetPurchLines("Purchase Header", TempPurchLine, 0); TempPurchLine.CalcVATAmountLines(0, "Purchase Header", TempPurchLine, TempVATAmountLine); TempPurchLine.UpdateVATOnLines(0, "Purchase Header", TempPurchLine, TempVATAmountLine); VATAmount := TempVATAmountLine.GetTotalVATAmount(); VATBaseAmount := TempVATAmountLine.GetTotalVATBase(); VATDiscountAmount := TempVATAmountLine.GetTotalVATDiscount("Purchase Header"."Currency Code", "Purchase Header"."Prices Including VAT"); TotalAmountInclVAT := TempVATAmountLine.GetTotalAmountInclVAT(); TempPrepaymentInvLineBuffer.DeleteAll(); PurchasePostPrepayments.GetPurchLines("Purchase Header", 0, TempPrepmtPurchLine); if not TempPrepmtPurchLine.IsEmpty() then begin PurchasePostPrepayments.GetPurchLinesToDeduct("Purchase Header", TempPurchLine); if not TempPurchLine.IsEmpty() then PurchasePostPrepayments.CalcVATAmountLines("Purchase Header", TempPurchLine, TempPrePmtVATAmountLineDeduct, 1); end; PurchasePostPrepayments.CalcVATAmountLines("Purchase Header", TempPrepmtPurchLine, TempPrepmtVATAmountLine, 0); TempPrepmtVATAmountLine.DeductVATAmountLine(TempPrePmtVATAmountLineDeduct); PurchasePostPrepayments.UpdateVATOnLines("Purchase Header", TempPrepmtPurchLine, TempPrepmtVATAmountLine, 0); PurchasePostPrepayments.BuildInvLineBuffer("Purchase Header", TempPrepmtPurchLine, 0, TempPrepaymentInvLineBuffer); PrepmtVATAmount := TempPrepmtVATAmountLine.GetTotalVATAmount(); PrepmtVATBaseAmount := TempPrepmtVATAmountLine.GetTotalVATBase(); PrepmtTotalAmountInclVAT := TempPrepmtVATAmountLine.GetTotalAmountInclVAT(); end; } dataitem(VATCounter; "Integer") { DataItemTableView = sorting(Number); column(VATAmtLineVATBase; TempVATAmountLine."VAT Base") { AutoFormatExpression = "Purchase Header"."Currency Code"; AutoFormatType = 1; } column(VATAmtLineVATAmt; TempVATAmountLine."VAT Amount") { AutoFormatExpression = "Purchase Header"."Currency Code"; AutoFormatType = 1; } column(VATAmtLineLineAmt; TempVATAmountLine."Line Amount") { AutoFormatExpression = "Purchase Header"."Currency Code"; AutoFormatType = 1; } column(VATAmtLineInvDiscBaseAmt; TempVATAmountLine."Inv. Disc. Base Amount") { AutoFormatExpression = "Purchase Header"."Currency Code"; AutoFormatType = 1; } column(VATAmtLineInvDiscAmt; TempVATAmountLine."Invoice Discount Amount") { AutoFormatExpression = "Purchase Header"."Currency Code"; AutoFormatType = 1; } column(VATAmtLineVAT; TempVATAmountLine."VAT %") { DecimalPlaces = 0 : 5; } column(VATAmtLineVATIdentifier; TempVATAmountLine."VAT Identifier") { } trigger OnAfterGetRecord() begin TempVATAmountLine.GetLine(Number); end; trigger OnPreDataItem() begin if VATAmount = 0 then CurrReport.Break(); SetRange(Number, 1, TempVATAmountLine.Count); end; } dataitem(VATCounterLCY; "Integer") { DataItemTableView = sorting(Number); column(VALExchRate; VALExchRate) { } column(VALSpecLCYHeader; VALSpecLCYHeader) { } column(VALVATAmountLCY; VALVATAmountLCY) { AutoFormatType = 1; } column(VALVATBaseLCY; VALVATBaseLCY) { AutoFormatType = 1; } trigger OnAfterGetRecord() begin TempVATAmountLine.GetLine(Number); VALVATBaseLCY := TempVATAmountLine.GetBaseLCY( "Purchase Header"."Posting Date", "Purchase Header"."Currency Code", "Purchase Header"."Currency Factor"); VALVATAmountLCY := TempVATAmountLine.GetAmountLCY( "Purchase Header"."Posting Date", "Purchase Header"."Currency Code", "Purchase Header"."Currency Factor"); end; trigger OnPreDataItem() begin if (not GLSetup."Print VAT specification in LCY") or ("Purchase Header"."Currency Code" = '') or (TempVATAmountLine.GetTotalVATAmount() = 0) then CurrReport.Break(); SetRange(Number, 1, TempVATAmountLine.Count); if GLSetup."LCY Code" = '' then VALSpecLCYHeader := VATAmountSpecificationLbl + LocalCurrentyLbl else VALSpecLCYHeader := VATAmountSpecificationLbl + Format(GLSetup."LCY Code"); CurrExchRate.FindCurrency("Purchase Header"."Posting Date", "Purchase Header"."Currency Code", 1); VALExchRate := StrSubstNo(ExchangeRateLbl, CurrExchRate."Relational Exch. Rate Amount", CurrExchRate."Exchange Rate Amount"); end; } dataitem(PrepmtLoop; "Integer") { DataItemTableView = sorting(Number) where(Number = filter(1 ..)); column(PrepmtLineAmount; PrepmtLineAmount) { AutoFormatExpression = "Purchase Header"."Currency Code"; AutoFormatType = 1; } column(PrepmtInvBufGLAccNo; TempPrepaymentInvLineBuffer."G/L Account No.") { } column(PrepmtInvBufDesc; TempPrepaymentInvLineBuffer.Description) { } column(TotalInclVATText2; TotalInclVATText) { } column(TotalExclVATText2; TotalExclVATText) { } column(PrepmtInvBufAmt; TempPrepaymentInvLineBuffer.Amount) { AutoFormatExpression = "Purchase Header"."Currency Code"; AutoFormatType = 1; } column(PrepmtVATAmountText; TempPrepmtVATAmountLine.VATAmountText()) { } column(PrepmtVATAmount; PrepmtVATAmount) { AutoFormatExpression = "Purchase Header"."Currency Code"; AutoFormatType = 1; } column(PrepmtTotalAmountInclVAT; PrepmtTotalAmountInclVAT) { AutoFormatExpression = "Purchase Header"."Currency Code"; AutoFormatType = 1; } column(PrepmtVATBaseAmount; PrepmtVATBaseAmount) { AutoFormatExpression = "Purchase Header"."Currency Code"; AutoFormatType = 1; } column(PrepmtInvBuDescCaption; PrepmtInvBuDescCaptionLbl) { } column(PrepmtInvBufGLAccNoCaption; PrepmtInvBufGLAccNoCaptionLbl) { } column(PrepaymentSpecCaption; PrepaymentSpecCaptionLbl) { } trigger OnAfterGetRecord() begin if Number = 1 then begin if not TempPrepaymentInvLineBuffer.Find('-') then CurrReport.Break(); end else if TempPrepaymentInvLineBuffer.Next() = 0 then CurrReport.Break(); if "Purchase Header"."Prices Including VAT" then PrepmtLineAmount := TempPrepaymentInvLineBuffer."Amount Incl. VAT" else PrepmtLineAmount := TempPrepaymentInvLineBuffer.Amount; end; } dataitem(PrepmtVATCounter; "Integer") { DataItemTableView = sorting(Number); column(PrepmtVATAmtLineVATAmt; TempPrepmtVATAmountLine."VAT Amount") { AutoFormatExpression = "Purchase Header"."Currency Code"; AutoFormatType = 1; } column(PrepmtVATAmtLineVATBase; TempPrepmtVATAmountLine."VAT Base") { AutoFormatExpression = "Purchase Header"."Currency Code"; AutoFormatType = 1; } column(PrepmtVATAmtLineLineAmt; TempPrepmtVATAmountLine."Line Amount") { AutoFormatExpression = "Purchase Header"."Currency Code"; AutoFormatType = 1; } column(PrepmtVATAmtLineVAT; TempPrepmtVATAmountLine."VAT %") { DecimalPlaces = 0 : 5; } column(PrepmtVATAmtLineVATId; TempPrepmtVATAmountLine."VAT Identifier") { } column(PrepymtVATAmtSpecCaption; PrepymtVATAmtSpecCaptionLbl) { } trigger OnAfterGetRecord() begin TempPrepmtVATAmountLine.GetLine(Number); end; trigger OnPreDataItem() begin SetRange(Number, 1, TempPrepmtVATAmountLine.Count); end; } dataitem(LetterText; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(GreetingText; GreetingLbl) { } column(BodyText; BodyLbl) { } column(ClosingText; ClosingLbl) { } } trigger OnAfterGetRecord() begin FirstLineHasBeenOutput := false; TotalAmount := 0; TotalSubTotal := 0; TotalInvoiceDiscountAmount := 0; CurrReport.Language := LanguageMgt.GetLanguageIdOrDefault("Language Code"); CurrReport.FormatRegion := LanguageMgt.GetFormatRegionOrDefault("Format Region"); FormatAddr.SetLanguageCode("Language Code"); FormatAddressFields("Purchase Header"); FormatDocumentFields("Purchase Header"); if BuyFromContact.Get("Buy-from Contact No.") then; if PayToContact.Get("Pay-to Contact No.") then; if not IsReportInPreviewMode() then begin CODEUNIT.Run(CODEUNIT::"Purch.Header-Printed", "Purchase Header"); if ArchiveDocument then ArchiveManagement.StorePurchDocument("Purchase Header", LogInteraction); end; end; trigger OnPreDataItem() begin FirstLineHasBeenOutput := false; end; } } requestpage { SaveValues = true; layout { area(content) { group(Options) { Caption = 'Options'; field(ArchiveDocument; ArchiveDocument) { ApplicationArea = Suite; Caption = 'Archive Document'; ToolTip = 'Specifies whether to archive the order.'; } field(LogInteraction; LogInteraction) { ApplicationArea = Suite; Caption = 'Log Interaction'; Enabled = LogInteractionEnable; ToolTip = 'Specifies if you want to log this interaction.'; } } } } actions { } trigger OnInit() begin InitLogInteraction(); LogInteractionEnable := LogInteraction; ArchiveDocument := PurchSetup."Archive Orders"; end; } rendering { layout("StandardPurchaseOrder.docx") { Type = Word; LayoutFile = './Purchases/Document/StandardPurchaseOrder.docx'; Caption = 'Standard Purchase Order (Word)'; Summary = 'The Standard Purchase Order (Word) provides a basic layout.'; } layout("StandardPurchaseOrderThemable.docx") { Type = Word; LayoutFile = './Purchases/Document/StandardPurchaseOrderThemable.docx'; Caption = 'Standard Purchase Order - themable Word layout'; Summary = 'The Standard Purchase Order (Word) provides a Themable layout.'; } layout("StandardPurchaseOrderEmail.docx") { Type = Word; LayoutFile = './Purchases/Document/StandardPurchaseOrderEmail.docx'; Caption = 'Standard Purchase Order Email (Word)'; Summary = 'The Standard Purchase Order Email (Word) provides an email body layout.'; } } labels { } trigger OnInitReport() var IsHandled: Boolean; begin GLSetup.Get(); CompanyInfo.SetAutoCalcFields(Picture); CompanyInfo.Get(); PurchSetup.Get(); IsHandled := false; OnInitReportForGlobalVariable(IsHandled, LegalOfficeTxt, LegalOfficeLbl, CustomGiroTxt, CustomGiroLbl); end; trigger OnPostReport() begin if LogInteraction and not IsReportInPreviewMode() then if "Purchase Header".FindSet() then repeat SegManagement.LogDocument( 13, "Purchase Header"."No.", 0, 0, DATABASE::Vendor, "Purchase Header"."Buy-from Vendor No.", "Purchase Header"."Purchaser Code", '', "Purchase Header"."Posting Description", ''); until "Purchase Header".Next() = 0; end; var DummyCompanyInfo: Record "Company Information"; GLSetup: Record "General Ledger Setup"; TempPurchLine: Record "Purchase Line" temporary; CurrExchRate: Record "Currency Exchange Rate"; LanguageMgt: Codeunit Language; FormatAddr: Codeunit "Format Address"; FormatDocument: Codeunit "Format Document"; PurchPost: Codeunit "Purch.-Post"; SegManagement: Codeunit SegManagement; PurchasePostPrepayments: Codeunit "Purchase-Post Prepayments"; ArchiveManagement: Codeunit ArchiveManagement; VATNoText: Text[80]; ReferenceText: Text[80]; OutputNo: Integer; DimText: Text[120]; VATAmount: Decimal; VATBaseAmount: Decimal; VATDiscountAmount: Decimal; TotalAmountInclVAT: Decimal; VALVATBaseLCY: Decimal; VALVATAmountLCY: Decimal; VALSpecLCYHeader: Text[80]; VALExchRate: Text[50]; PrepmtVATAmount: Decimal; PrepmtVATBaseAmount: Decimal; PrepmtTotalAmountInclVAT: Decimal; PrepmtLineAmount: Decimal; AllowInvDisctxt: Text[30]; CompanyLogoPosition: Integer; ItemNo: Text; VATAmountSpecificationLbl: Label 'VAT Amount Specification in '; LocalCurrentyLbl: Label 'Local Currency'; ExchangeRateLbl: Label 'Exchange rate: %1/%2', Comment = '%1 = CurrExchRate."Relational Exch. Rate Amount", %2 = CurrExchRate."Exchange Rate Amount"'; CompanyInfoPhoneNoCaptionLbl: Label 'Phone No.'; CompanyInfoGiroNoCaptionLbl: Label 'Giro No.'; CompanyInfoBankNameCaptionLbl: Label 'Bank'; CompanyInfoBankAccNoCaptionLbl: Label 'Account No.'; OrderNoCaptionLbl: Label 'Order No.'; PageCaptionLbl: Label 'Page'; DocumentDateCaptionLbl: Label 'Document Date'; DirectUniCostCaptionLbl: Label 'Direct Unit Cost'; PurchLineLineDiscCaptionLbl: Label 'Discount %'; VATDiscountAmountCaptionLbl: Label 'Payment Discount on VAT'; PaymentDetailsCaptionLbl: Label 'Payment Details'; VendNoCaptionLbl: Label 'Vendor No.'; ShiptoAddressCaptionLbl: Label 'Ship-to Address'; PrepmtInvBuDescCaptionLbl: Label 'Description'; PrepmtInvBufGLAccNoCaptionLbl: Label 'G/L Account No.'; PrepaymentSpecCaptionLbl: Label 'Prepayment Specification'; PrepymtVATAmtSpecCaptionLbl: Label 'Prepayment VAT Amount Specification'; AmountCaptionLbl: Label 'Amount'; PurchLineInvDiscAmtCaptionLbl: Label 'Invoice Discount Amount'; SubtotalCaptionLbl: Label 'Subtotal'; VATAmtLineVATCaptionLbl: Label 'VAT %'; VATAmtLineVATAmtCaptionLbl: Label 'VAT Amount'; VATAmtSpecCaptionLbl: Label 'VAT Amount Specification'; VATIdentifierCaptionLbl: Label 'VAT Identifier'; VATAmtLineInvDiscBaseAmtCaptionLbl: Label 'Invoice Discount Base Amount'; VATAmtLineLineAmtCaptionLbl: Label 'Line Amount'; VALVATBaseLCYCaptionLbl: Label 'VAT Base'; PricesInclVATtxtLbl: Label 'Prices Including VAT'; TotalCaptionLbl: Label 'Total'; PaymentTermsDescCaptionLbl: Label 'Payment Terms'; ShipmentMethodDescCaptionLbl: Label 'Shipment Method'; PrepymtTermsDescCaptionLbl: Label 'Prepmt. Payment Terms'; HomePageCaptionLbl: Label 'Home Page'; EmailIDCaptionLbl: Label 'Email'; AllowInvoiceDiscCaptionLbl: Label 'Allow Invoice Discount'; BuyFromContactPhoneNoLbl: Label 'Buy-from Contact Phone No.'; BuyFromContactMobilePhoneNoLbl: Label 'Buy-from Contact Mobile Phone No.'; BuyFromContactEmailLbl: Label 'Buy-from Contact E-Mail'; PayToContactPhoneNoLbl: Label 'Pay-to Contact Phone No.'; PayToContactMobilePhoneNoLbl: Label 'Pay-to Contact Mobile Phone No.'; PayToContactEmailLbl: Label 'Pay-to Contact E-Mail'; DocumentTitleLbl: Label 'Purchase Order'; ReceivebyCaptionLbl: Label 'Receive By'; BuyerCaptionLbl: Label 'Buyer'; ItemNumberCaptionLbl: Label 'Item No.'; ItemDescriptionCaptionLbl: Label 'Description'; ItemQuantityCaptionLbl: Label 'Quantity'; ItemUnitCaptionLbl: Label 'Unit'; ItemUnitPriceCaptionLbl: Label 'Unit Price'; ItemLineAmountCaptionLbl: Label 'Line Amount'; PricesIncludingVATCaptionLbl: Label 'Prices Including VAT'; ItemUnitOfMeasureCaptionLbl: Label 'Unit'; ToCaptionLbl: Label 'To:'; VendorIDCaptionLbl: Label 'Vendor ID'; ConfirmToCaptionLbl: Label 'Confirm To'; PurchOrderCaptionLbl: Label 'PURCHASE ORDER'; PurchOrderNumCaptionLbl: Label 'Purchase Order Number:'; PurchOrderDateCaptionLbl: Label 'Purchase Order Date:'; TaxIdentTypeCaptionLbl: Label 'Tax Ident. Type'; TotalPriceCaptionLbl: Label 'Total Price'; InvDiscCaptionLbl: Label 'Invoice Discount:'; GreetingLbl: Label 'Hello'; ClosingLbl: Label 'Sincerely'; BodyLbl: Label 'The purchase order is attached to this message.'; OrderDateLbl: Label 'Order Date'; VendorOrderNoLbl: Label 'Vendor Order No.'; VendorInvoiceNoLbl: Label 'Vendor Invoice No.'; UnitPriceLbl: Label 'Unit Price (LCY)'; JobNoLbl: Label 'Project No.'; JobTaskNoLbl: Label 'Project Task No.'; PromisedReceiptDateLbl: Label 'Promised Receipt Date'; RequestedReceiptDateLbl: Label 'Requested Receipt Date'; ExpectedReceiptDateLbl: Label 'Expected Receipt Date'; PlannedReceiptDateLbl: Label 'Planned Receipt Date'; LegalOfficeTxt, LegalOfficeLbl, CustomGiroTxt, CustomGiroLbl : Text; protected var ResponsibilityCenter: Record "Responsibility Center"; BuyFromContact: Record Contact; PayToContact: Record Contact; CompanyInfo: Record "Company Information"; PurchSetup: Record "Purchases & Payables Setup"; ShipmentMethod: Record "Shipment Method"; PaymentTerms: Record "Payment Terms"; PrepmtPaymentTerms: Record "Payment Terms"; SalespersonPurchaser: Record "Salesperson/Purchaser"; TempVATAmountLine: Record "VAT Amount Line" temporary; TempPrepmtVATAmountLine: Record "VAT Amount Line" temporary; TempPrepaymentInvLineBuffer: Record "Prepayment Inv. Line Buffer" temporary; TempPrePmtVATAmountLineDeduct: Record "VAT Amount Line" temporary; BuyFromAddr: array[8] of Text[100]; CompanyAddr: array[8] of Text[100]; VendAddr: array[8] of Text[100]; ShipToAddr: array[8] of Text[100]; FormattedQuanitity: Text; FormattedDirectUnitCost: Text; FormattedVATPct: Text; FormattedLineAmount: Text; PurchaserText: Text[50]; TotalText: Text[50]; TotalInclVATText: Text[50]; TotalExclVATText: Text[50]; ArchiveDocument: Boolean; LogInteraction: Boolean; LogInteractionEnable: Boolean; FirstLineHasBeenOutput: Boolean; TotalSubTotal, TotalAmount, TotalInvoiceDiscountAmount : Decimal; procedure InitializeRequest(LogInteractionParam: Boolean) begin LogInteraction := LogInteractionParam; end; protected procedure IsReportInPreviewMode(): Boolean var MailManagement: Codeunit "Mail Management"; begin exit(CurrReport.Preview() or MailManagement.IsHandlingGetEmailBody()); end; local procedure FormatAddressFields(var PurchaseHeader: Record "Purchase Header") begin FormatAddr.GetCompanyAddr(PurchaseHeader."Responsibility Center", ResponsibilityCenter, CompanyInfo, CompanyAddr); FormatAddr.PurchHeaderBuyFrom(BuyFromAddr, PurchaseHeader); if PurchaseHeader."Buy-from Vendor No." <> PurchaseHeader."Pay-to Vendor No." then FormatAddr.PurchHeaderPayTo(VendAddr, PurchaseHeader); FormatAddr.PurchHeaderShipTo(ShipToAddr, PurchaseHeader); end; local procedure FormatDocumentFields(PurchaseHeader: Record "Purchase Header") begin FormatDocument.SetTotalLabels(PurchaseHeader."Currency Code", TotalText, TotalInclVATText, TotalExclVATText); FormatDocument.SetPurchaser(SalespersonPurchaser, PurchaseHeader."Purchaser Code", PurchaserText); FormatDocument.SetPaymentTerms(PaymentTerms, PurchaseHeader."Payment Terms Code", PurchaseHeader."Language Code"); FormatDocument.SetPaymentTerms(PrepmtPaymentTerms, PurchaseHeader."Prepmt. Payment Terms Code", PurchaseHeader."Language Code"); FormatDocument.SetShipmentMethod(ShipmentMethod, PurchaseHeader."Shipment Method Code", PurchaseHeader."Language Code"); ReferenceText := FormatDocument.SetText(PurchaseHeader."Your Reference" <> '', PurchaseHeader.FieldCaption("Your Reference")); VATNoText := FormatDocument.SetText(PurchaseHeader."VAT Registration No." <> '', PurchaseHeader.FieldCaption("VAT Registration No.")); OnAfterFormatDocumentFields(PurchaseHeader); end; local procedure InitLogInteraction() begin LogInteraction := SegManagement.FindInteractionTemplateCode(Enum::"Interaction Log Entry Document Type"::"Purch. Ord.") <> ''; end; [IntegrationEvent(true, false)] local procedure OnAfterFormatDocumentFields(var PurchaseHeader: Record "Purchase Header") begin end; [IntegrationEvent(false, false)] local procedure OnInitReportForGlobalVariable(var IsHandled: Boolean; var LegalOfficeTxt: Text; var LegalOfficeLbl: Text; var CustomGiroTxt: Text; var CustomGiroLbl: Text) begin end;}