Page 46 Sales Order Subform
src/Layers/W1/BaseApp/Sales/Document/SalesOrderSubform.Page.al2,530 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.Document;using Microsoft.Assembly.Document;using Microsoft.Finance.AllocationAccount;using Microsoft.Finance.AllocationAccount.Sales;using Microsoft.Finance.Currency;using Microsoft.Finance.Deferral;using Microsoft.Finance.Dimension;using Microsoft.Foundation.Attachment;using Microsoft.Foundation.ExtendedText;using Microsoft.Foundation.Navigate;using Microsoft.Inventory.Availability;using Microsoft.Inventory.BOM;using Microsoft.Inventory.Item;using Microsoft.Inventory.Item.Catalog;using Microsoft.Inventory.Item.Substitution;using Microsoft.Inventory.Location;using Microsoft.Inventory.Setup;using Microsoft.Pricing.Calculation;using Microsoft.Purchases.Document;using Microsoft.Purchases.History;using Microsoft.Sales.History;using Microsoft.Sales.Pricing;using Microsoft.Sales.Setup;using Microsoft.Utilities;using System.Environment.Configuration;using System.Integration.Excel;using System.Utilities;/// <summary>/// Displays the line items subform for a sales order document./// </summary>page 46 "Sales Order Subform"{ AutoSplitKey = true; Caption = 'Lines'; DelayedInsert = true; LinksAllowed = false; MultipleNewLines = true; PageType = ListPart; SourceTable = "Sales Line"; SourceTableView = where("Document Type" = filter(Order)); layout { area(content) { repeater(Control1) { ShowCaption = false; field(Type; Rec.Type) { ApplicationArea = Advanced; ToolTip = 'Specifies the type of entity that will be posted for this sales line, such as Item, Resource, or G/L Account.'; Visible = not TypeAsTextFieldVisible; trigger OnValidate() begin NoOnAfterValidate(); SetLocationCodeMandatory(); UpdateEditableOnRow(); UpdateTypeText(); DeltaUpdateTotals(); end; } field(FilteredTypeField; TypeAsText) { ApplicationArea = Basic, Suite; Caption = 'Type'; Editable = CurrPageIsEditable; LookupPageID = "Option Lookup List"; TableRelation = "Option Lookup Buffer"."Option Caption" where("Lookup Type" = const(Sales)); ToolTip = 'Specifies the type of transaction that will be posted with the document line. If you select Comment, then you can enter any text in the Description field, such as a message to a customer. '; Visible = TypeAsTextFieldVisible; trigger OnValidate() begin TempOptionLookupBuffer.SetCurrentType(Rec.Type.AsInteger()); if TempOptionLookupBuffer.AutoCompleteLookup(TypeAsText, TempOptionLookupBuffer."Lookup Type"::Sales) then Rec.Validate(Type, TempOptionLookupBuffer.ID); TempOptionLookupBuffer.ValidateOption(TypeAsText); UpdateEditableOnRow(); UpdateTypeText(); DeltaUpdateTotals(); end; } field("No."; Rec."No.") { ApplicationArea = Basic, Suite; ShowMandatory = not IsCommentLine; ToolTip = 'Specifies what you are selling, such as a product or a fixed asset. You’ll see different lists of things to choose from depending on your choice in the Type field.'; trigger OnValidate() var IsHandled: Boolean; begin IsHandled := false; OnBeforeValidateNo(Rec, xRec, IsHandled); if IsHandled then exit; NoOnAfterValidate(); UpdateEditableOnRow(); Rec.ShowShortcutDimCode(ShortcutDimCode); UpdateTypeText(); DeltaUpdateTotals(); CurrPage.Update(); end; } field("Item Reference No."; Rec."Item Reference No.") { AccessByPermission = tabledata "Item Reference" = R; ApplicationArea = Suite, ItemReferences; QuickEntry = false; ToolTip = 'Specifies a reference to the item number as defined by the vendor or customer, or the item''s barcode.'; Visible = ItemReferenceVisible; trigger OnLookup(var Text: Text): Boolean var SalesHeader: Record "Sales Header"; ItemReferenceMgt: Codeunit "Item Reference Management"; begin SalesHeader.Get(Rec."Document Type", Rec."Document No."); ItemReferenceMgt.SalesReferenceNoLookup(Rec, SalesHeader); NoOnAfterValidate(); UpdateEditableOnRow(); DeltaUpdateTotals(); OnReferenceNoOnAfterLookup(Rec); CurrPage.Update(); end; trigger OnValidate() begin NoOnAfterValidate(); UpdateEditableOnRow(); DeltaUpdateTotals(); CurrPage.Update(); end; } field("IC Partner Code"; Rec."IC Partner Code") { ApplicationArea = Intercompany; Visible = false; } field("IC Partner Ref. Type"; Rec."IC Partner Ref. Type") { ApplicationArea = Intercompany; Visible = false; } field("IC Partner Reference"; Rec."IC Partner Reference") { ApplicationArea = Intercompany; Visible = false; } field("IC Item Reference"; Rec."IC Item Reference No.") { ApplicationArea = Intercompany; Visible = false; } field("Variant Code"; Rec."Variant Code") { ApplicationArea = Planning; ShowMandatory = VariantCodeMandatory; Visible = false; trigger OnValidate() var Item: Record Item; begin VariantCodeOnAfterValidate(); DeltaUpdateTotals(); if Rec."Variant Code" = '' then VariantCodeMandatory := Item.IsVariantMandatory(Rec.Type = Rec.Type::Item, Rec."No."); end; } field("Substitution Available"; Rec."Substitution Available") { ApplicationArea = Suite; Visible = false; } field("Purchasing Code"; Rec."Purchasing Code") { ApplicationArea = Basic, Suite; Visible = false; } field(Nonstock; Rec.Nonstock) { ApplicationArea = Basic, Suite; Visible = false; } field("Gen. Bus. Posting Group"; Rec."Gen. Bus. Posting Group") { ApplicationArea = Basic, Suite; Visible = false; trigger OnValidate() begin DeltaUpdateTotals(); end; } field("Gen. Prod. Posting Group"; Rec."Gen. Prod. Posting Group") { ApplicationArea = Basic, Suite; Visible = false; trigger OnValidate() begin DeltaUpdateTotals(); end; } field("VAT Bus. Posting Group"; Rec."VAT Bus. Posting Group") { ApplicationArea = Basic, Suite; Visible = false; trigger OnValidate() begin ForceTotalsCalculation(); DeltaUpdateTotals(); end; } field("VAT Prod. Posting Group"; Rec."VAT Prod. Posting Group") { ApplicationArea = Basic, Suite; Visible = false; trigger OnValidate() begin ForceTotalsCalculation(); DeltaUpdateTotals(); end; } field(Description; Rec.Description) { ApplicationArea = Basic, Suite; QuickEntry = false; ShowMandatory = not IsCommentLine; ToolTip = 'Specifies a description of what you’re selling. Based on your choices in the Type and No. fields, the field may show suggested text that you can change it for this document. To add a comment, set the Type field to Comment and write the comment itself here.'; trigger OnValidate() var LookupSelectionRestored: Boolean; begin UpdateEditableOnRow(); LookupSelectionRestored := Rec.RestoreLookupSelectionWithResult(); if (Rec."No." <> xRec."No.") or LookupSelectionRestored then NoOnAfterValidateInternal(LookupSelectionRestored); if Rec."No." <> xRec."No." then begin ResetxRecAmountValues(); CalculateTotals(); DeltaUpdateTotals(); end; if (Rec."No." = xRec."No.") and not LookupSelectionRestored then exit; Rec.ShowShortcutDimCode(ShortcutDimCode); UpdateTypeText(); OnAfterValidateDescription(Rec, xRec); end; trigger OnAfterLookup(Selected: RecordRef) begin Rec.SaveLookupSelection(Selected); end; } field("Description 2"; Rec."Description 2") { ApplicationArea = Basic, Suite; Importance = Additional; Visible = false; } field("Drop Shipment"; Rec."Drop Shipment") { ApplicationArea = Suite; Visible = false; } field("Special Order"; Rec."Special Order") { ApplicationArea = Basic, Suite; Visible = false; } field("Return Reason Code"; Rec."Return Reason Code") { ApplicationArea = Suite; Visible = false; } field("Location Code"; Rec."Location Code") { ApplicationArea = Location; Editable = not IsBlankNumber; Enabled = not IsBlankNumber; QuickEntry = false; ShowMandatory = LocationCodeMandatory; Visible = LocationCodeVisible; trigger OnValidate() begin LocationCodeOnAfterValidate(); DeltaUpdateTotals(); end; } field("Bin Code"; Rec."Bin Code") { ApplicationArea = Warehouse; Visible = false; } field(Control50; Rec.Reserve) { ApplicationArea = Reservation; Visible = false; trigger OnValidate() begin ReserveOnAfterValidate(); end; } field(Quantity; Rec.Quantity) { ApplicationArea = Basic, Suite; BlankZero = true; Editable = not IsCommentLine; Enabled = not IsCommentLine; ShowMandatory = (Rec.Type <> Rec.Type::" ") and (Rec."No." <> ''); AboutTitle = 'How much is being ordered'; AboutText = 'The quantity on a line specifies how much of an item a customer is ordering. This quantity determines whether the order qualifies for special prices or discounts.'; trigger OnValidate() begin QuantityOnAfterValidate(); DeltaUpdateTotals(); SetItemChargeFieldsStyle(); if SalesSetup."Calc. Inv. Discount" and (Rec.Quantity = 0) then CurrPage.Update(false); end; } field("Qty. to Assemble to Order"; Rec."Qty. to Assemble to Order") { ApplicationArea = Assembly; BlankZero = true; Visible = true; trigger OnDrillDown() begin Rec.ShowAsmToOrderLines(); end; trigger OnValidate() begin QtyToAsmToOrderOnAfterValidate(); end; } field("Reserved Quantity"; Rec."Reserved Quantity") { ApplicationArea = Reservation; BlankZero = true; QuickEntry = false; } field("Unit of Measure Code"; Rec."Unit of Measure Code") { ApplicationArea = Basic, Suite; Editable = UnitofMeasureCodeIsChangeable; Enabled = UnitofMeasureCodeIsChangeable; QuickEntry = false; trigger OnValidate() begin UnitofMeasureCodeOnAfterValidate(); end; } field("Unit of Measure"; Rec."Unit of Measure") { ApplicationArea = Suite; Visible = false; } field("Unit Cost (LCY)"; Rec."Unit Cost (LCY)") { ApplicationArea = Basic, Suite; ToolTip = 'Specifies the unit cost of the item on the line.'; Visible = false; } field(SalesPriceExist; Rec.PriceExists()) { ApplicationArea = Basic, Suite; Caption = 'Sales Price Exists'; Editable = false; ToolTip = 'Specifies that there is a specific price for this customer.'; Visible = false; } field("Unit Price"; Rec."Unit Price") { ApplicationArea = Basic, Suite; BlankZero = true; Editable = not IsBlankNumber; Enabled = not IsBlankNumber; ShowMandatory = (Rec.Type <> Rec.Type::" ") and (Rec."No." <> ''); trigger OnValidate() begin DeltaUpdateTotals(); end; } field("Tax Liable"; Rec."Tax Liable") { ApplicationArea = SalesTax; Editable = false; Visible = false; } field("Tax Area Code"; Rec."Tax Area Code") { ApplicationArea = SalesTax; trigger OnValidate() begin DeltaUpdateTotals(); end; } field("Tax Group Code"; Rec."Tax Group Code") { ApplicationArea = SalesTax; Editable = not IsCommentLine; Enabled = not IsCommentLine; ShowMandatory = Rec."Tax Area Code" <> ''; trigger OnValidate() begin DeltaUpdateTotals(); end; } field("Line Discount %"; Rec."Line Discount %") { ApplicationArea = Basic, Suite; BlankZero = true; Editable = not IsBlankNumber; Enabled = not IsBlankNumber; trigger OnValidate() begin DeltaUpdateTotals(); end; } field("Line Amount"; Rec."Line Amount") { ApplicationArea = Basic, Suite; BlankZero = true; Editable = not IsBlankNumber; Enabled = not IsBlankNumber; ShowMandatory = (Rec.Type <> Rec.Type::" ") and (Rec."No." <> ''); trigger OnValidate() begin DeltaUpdateTotals(); end; } field("Allocation Account No."; Rec."Selected Alloc. Account No.") { ApplicationArea = All; Caption = 'Allocation Account No.'; Visible = UseAllocationAccountNumber; trigger OnValidate() var SalesAllocAccMgt: Codeunit "Sales Alloc. Acc. Mgt."; begin SalesAllocAccMgt.VerifySelectedAllocationAccountNo(Rec); end; } field(SalesLineDiscExists; Rec.LineDiscExists()) { ApplicationArea = Basic, Suite; Caption = 'Sales Line Disc. Exists'; Editable = false; ToolTip = 'Specifies that there is a specific discount for this customer.'; Visible = false; } field("Line Discount Amount"; Rec."Line Discount Amount") { ApplicationArea = Basic, Suite; Visible = false; trigger OnValidate() begin DeltaUpdateTotals(); end; } field("Prepayment %"; Rec."Prepayment %") { ApplicationArea = Prepayments; Visible = false; } field("Prepmt. Line Amount"; Rec."Prepmt. Line Amount") { ApplicationArea = Prepayments; Visible = false; } field("Prepmt. Amt. Inv."; Rec."Prepmt. Amt. Inv.") { ApplicationArea = Prepayments; Visible = false; } field("Allow Invoice Disc."; Rec."Allow Invoice Disc.") { ApplicationArea = Basic, Suite; Visible = false; trigger OnValidate() begin CurrPage.SaveRecord(); AmountWithDiscountAllowed := DocumentTotals.CalcTotalSalesAmountOnlyDiscountAllowed(Rec); InvoiceDiscountAmount := Round(AmountWithDiscountAllowed * InvoiceDiscountPct / 100, Currency."Amount Rounding Precision"); ValidateInvoiceDiscountAmount(); end; } field("Inv. Discount Amount"; Rec."Inv. Discount Amount") { ApplicationArea = Basic, Suite; ToolTip = 'Specifies the total calculated invoice discount amount for the line.'; Visible = false; trigger OnValidate() begin DeltaUpdateTotals(); end; } field("Inv. Disc. Amount to Invoice"; Rec."Inv. Disc. Amount to Invoice") { ApplicationArea = Basic, Suite; Visible = false; } field("Qty. to Ship"; Rec."Qty. to Ship") { ApplicationArea = Basic, Suite; BlankZero = true; AboutTitle = 'Partially shipping the order?'; AboutText = 'If you want to ship only parts of the order, adjust the *Qty. to Ship* value to that quantity. By common default, the total quantity is shipped.'; trigger OnValidate() begin SetItemChargeFieldsStyle(); if Rec."Qty. to Asm. to Order (Base)" <> 0 then begin CurrPage.SaveRecord(); CurrPage.Update(false); end; end; } field("Quantity Shipped"; Rec."Quantity Shipped") { ApplicationArea = Basic, Suite; BlankZero = true; QuickEntry = false; trigger OnDrillDown() var SalesShipmentLine: Record "Sales Shipment Line"; begin SalesShipmentLine.SetCurrentKey("Document No.", "No.", "Shipment Date"); SalesShipmentLine.SetRange("Order No.", Rec."Document No."); SalesShipmentLine.SetRange("Order Line No.", Rec."Line No."); SalesShipmentLine.SetFilter(Quantity, '<>%1', 0); Page.RunModal(0, SalesShipmentLine); end; } field("Qty. to Invoice"; Rec."Qty. to Invoice") { ApplicationArea = Basic, Suite; BlankZero = true; AboutTitle = 'Invoicing more or less than you ship?'; AboutText = 'Adjust the *Qty. to Invoice* to specify the quantity you want to invoice now. If that is more than you ship, use the prepayment functionality.'; trigger OnValidate() begin SetItemChargeFieldsStyle(); CurrPage.Update(); end; } field("Quantity Invoiced"; Rec."Quantity Invoiced") { ApplicationArea = Basic, Suite; BlankZero = true; trigger OnDrillDown() var SalesInvoiceLine: Record "Sales Invoice Line"; begin SalesInvoiceLine.SetCurrentKey("Document No.", "No.", "Posting Date"); SalesInvoiceLine.SetRange("Order No.", Rec."Document No."); SalesInvoiceLine.SetRange("Order Line No.", Rec."Line No."); SalesInvoiceLine.SetFilter(Quantity, '<>%1', 0); Page.RunModal(0, SalesInvoiceLine); end; } field("Prepmt Amt to Deduct"; Rec."Prepmt Amt to Deduct") { ApplicationArea = Prepayments; Visible = false; } field("Prepmt Amt Deducted"; Rec."Prepmt Amt Deducted") { ApplicationArea = Prepayments; Visible = false; } field("Allow Item Charge Assignment"; Rec."Allow Item Charge Assignment") { ApplicationArea = ItemCharges; Visible = false; } field("Qty. to Assign"; Rec."Qty. to Assign") { ApplicationArea = ItemCharges; QuickEntry = false; StyleExpr = ItemChargeStyleExpression; ToolTip = 'Specifies how many units of the item charge are assigned to the line originally.'; trigger OnDrillDown() begin CurrPage.SaveRecord(); Rec.ShowItemChargeAssgnt(); UpdateForm(false); end; } field("Item Charge Qty. to Handle"; Rec."Item Charge Qty. to Handle") { ApplicationArea = ItemCharges; QuickEntry = false; StyleExpr = ItemChargeToHandleStyleExpression; trigger OnDrillDown() begin CurrPage.SaveRecord(); Rec.ShowItemChargeAssgnt(); UpdateForm(false); end; } field("Qty. Assigned"; Rec."Qty. Assigned") { ApplicationArea = ItemCharges; BlankZero = true; QuickEntry = false; trigger OnDrillDown() begin CurrPage.SaveRecord(); Rec.ShowItemChargeAssgnt(); CurrPage.Update(false); end; } field("Requested Delivery Date"; Rec."Requested Delivery Date") { ApplicationArea = Basic, Suite; Visible = false; trigger OnValidate() begin UpdateForm(true); end; } field("Promised Delivery Date"; Rec."Promised Delivery Date") { ApplicationArea = OrderPromising; Visible = false; trigger OnValidate() begin UpdateForm(true); end; } field("Planned Delivery Date"; Rec."Planned Delivery Date") { ApplicationArea = Planning; QuickEntry = false; trigger OnValidate() begin UpdateForm(true); end; } field("Planned Shipment Date"; Rec."Planned Shipment Date") { ApplicationArea = Planning; trigger OnValidate() begin UpdateForm(true); end; } field("Shipment Date"; Rec."Shipment Date") { ApplicationArea = Basic, Suite; QuickEntry = false; trigger OnValidate() begin ShipmentDateOnAfterValidate(); end; } field("Shipping Agent Code"; Rec."Shipping Agent Code") { ApplicationArea = Suite; Visible = false; } field("Shipping Agent Service Code"; Rec."Shipping Agent Service Code") { ApplicationArea = Suite; Visible = false; } field("Shipping Time"; Rec."Shipping Time") { ApplicationArea = Basic, Suite; Visible = false; } field("Work Type Code"; Rec."Work Type Code") { ApplicationArea = Jobs; Visible = false; } field("Whse. Outstanding Qty."; Rec."Whse. Outstanding Qty.") { ApplicationArea = Warehouse; Visible = false; } field("Whse. Outstanding Qty. (Base)"; Rec."Whse. Outstanding Qty. (Base)") { ApplicationArea = Warehouse; ToolTip = 'Specifies how many units on the sales order line remain to be handled in warehouse documents.'; Visible = false; } field("ATO Whse. Outstanding Qty."; Rec."ATO Whse. Outstanding Qty.") { ApplicationArea = Warehouse; Visible = false; } field("ATO Whse. Outstd. Qty. (Base)"; Rec."ATO Whse. Outstd. Qty. (Base)") { ApplicationArea = Warehouse; ToolTip = 'Specifies how many assemble-to-order units on the sales order line remain to be assembled and handled in warehouse documents.'; Visible = false; } field("Outbound Whse. Handling Time"; Rec."Outbound Whse. Handling Time") { ApplicationArea = Warehouse; Visible = false; } field("Blanket Order No."; Rec."Blanket Order No.") { ApplicationArea = Suite; Visible = false; } field("Blanket Order Line No."; Rec."Blanket Order Line No.") { ApplicationArea = Suite; Visible = false; } field("FA Posting Date"; Rec."FA Posting Date") { ApplicationArea = FixedAssets; Visible = false; } field("Depr. until FA Posting Date"; Rec."Depr. until FA Posting Date") { ApplicationArea = FixedAssets; Visible = false; } field("Depreciation Book Code"; Rec."Depreciation Book Code") { ApplicationArea = FixedAssets; Visible = false; } field("Use Duplication List"; Rec."Use Duplication List") { ApplicationArea = FixedAssets; ToolTip = 'Specifies, if the type is Fixed Asset, that information on the line is to be posted to all the assets defined depreciation books. '; Visible = false; } field("Duplicate in Depreciation Book"; Rec."Duplicate in Depreciation Book") { ApplicationArea = FixedAssets; Visible = false; } field("Appl.-from Item Entry"; Rec."Appl.-from Item Entry") { ApplicationArea = Basic, Suite; Visible = false; } field("Appl.-to Item Entry"; Rec."Appl.-to Item Entry") { ApplicationArea = Basic, Suite; Visible = false; } field("Deferral Code"; Rec."Deferral Code") { ApplicationArea = Suite; Enabled = (Rec.Type <> Rec.Type::"Fixed Asset") and (Rec.Type <> Rec.Type::" "); TableRelation = "Deferral Template"."Deferral Code"; Visible = false; trigger OnAssistEdit() begin CurrPage.SaveRecord(); Commit(); Rec.ShowDeferralSchedule(); end; } field("Shortcut Dimension 1 Code"; Rec."Shortcut Dimension 1 Code") { ApplicationArea = Dimensions; Visible = DimVisible1; } field("Shortcut Dimension 2 Code"; Rec."Shortcut Dimension 2 Code") { ApplicationArea = Dimensions; Visible = DimVisible2; } field(ShortcutDimCode3; ShortcutDimCode[3]) { ApplicationArea = Dimensions; CaptionClass = '1,2,3'; TableRelation = "Dimension Value".Code where("Global Dimension No." = const(3), "Dimension Value Type" = const(Standard), Blocked = const(false)); Visible = DimVisible3; trigger OnValidate() begin ValidateShortcutDimension(3); end; } field(ShortcutDimCode4; ShortcutDimCode[4]) { ApplicationArea = Dimensions; CaptionClass = '1,2,4'; TableRelation = "Dimension Value".Code where("Global Dimension No." = const(4), "Dimension Value Type" = const(Standard), Blocked = const(false)); Visible = DimVisible4; trigger OnValidate() begin ValidateShortcutDimension(4); end; } field(ShortcutDimCode5; ShortcutDimCode[5]) { ApplicationArea = Dimensions; CaptionClass = '1,2,5'; TableRelation = "Dimension Value".Code where("Global Dimension No." = const(5), "Dimension Value Type" = const(Standard), Blocked = const(false)); Visible = DimVisible5; trigger OnValidate() begin ValidateShortcutDimension(5); end; } field(ShortcutDimCode6; ShortcutDimCode[6]) { ApplicationArea = Dimensions; CaptionClass = '1,2,6'; TableRelation = "Dimension Value".Code where("Global Dimension No." = const(6), "Dimension Value Type" = const(Standard), Blocked = const(false)); Visible = DimVisible6; trigger OnValidate() begin ValidateShortcutDimension(6); end; } field(ShortcutDimCode7; ShortcutDimCode[7]) { ApplicationArea = Dimensions; CaptionClass = '1,2,7'; TableRelation = "Dimension Value".Code where("Global Dimension No." = const(7), "Dimension Value Type" = const(Standard), Blocked = const(false)); Visible = DimVisible7; trigger OnValidate() begin ValidateShortcutDimension(7); end; } field(ShortcutDimCode8; ShortcutDimCode[8]) { ApplicationArea = Dimensions; CaptionClass = '1,2,8'; TableRelation = "Dimension Value".Code where("Global Dimension No." = const(8), "Dimension Value Type" = const(Standard), Blocked = const(false)); Visible = DimVisible8; trigger OnValidate() begin ValidateShortcutDimension(8); end; } field("Document No."; Rec."Document No.") { ApplicationArea = Basic, Suite; Editable = false; Visible = false; } field("Line No."; Rec."Line No.") { ApplicationArea = Basic, Suite; Editable = false; Visible = false; } field("Gross Weight"; Rec."Gross Weight") { Caption = 'Unit Gross Weight'; ApplicationArea = Basic, Suite; Visible = false; } field("Net Weight"; Rec."Net Weight") { Caption = 'Unit Net Weight'; ApplicationArea = Basic, Suite; Visible = false; } field("Unit Volume"; Rec."Unit Volume") { ApplicationArea = Basic, Suite; Visible = false; } field("Units per Parcel"; Rec."Units per Parcel") { ApplicationArea = Basic, Suite; Visible = false; } field("Attached to Line No."; Rec."Attached to Line No.") { ApplicationArea = Basic, Suite; Visible = false; } field("Attached Lines Count"; Rec."Attached Lines Count") { ApplicationArea = Basic, Suite; Visible = AttachingLinesEnabled; } } group(Control51) { ShowCaption = false; group(Control45) { ShowCaption = false;#pragma warning disable AA0100 field("TotalSalesLine.""Line Amount"""; TotalSalesLine."Line Amount")#pragma warning restore AA0100 { ApplicationArea = Basic, Suite; AutoFormatExpression = Currency.Code; AutoFormatType = 1; CaptionClass = DocumentTotals.GetTotalLineAmountWithVATAndCurrencyCaption(Currency.Code, TotalSalesHeader."Prices Including VAT"); Caption = 'Subtotal Excl. VAT'; Editable = false; ToolTip = 'Specifies the sum of the value in the Line Amount Excl. VAT field on all lines in the document.'; } field("Invoice Discount Amount"; InvoiceDiscountAmount) { ApplicationArea = Basic, Suite; AutoFormatExpression = Currency.Code; AutoFormatType = 1; CaptionClass = DocumentTotals.GetInvoiceDiscAmountWithVATAndCurrencyCaption(Rec.FieldCaption("Inv. Discount Amount"), Currency.Code); Caption = 'Invoice Discount Amount'; Editable = InvDiscAmountEditable; ToolTip = 'Specifies a discount amount that is deducted from the value of the Total Incl. VAT field, based on sales lines where the Allow Invoice Disc. field is selected. You can enter or change the amount manually.'; trigger OnValidate() begin DocumentTotals.SalesDocTotalsNotUpToDate(); ValidateInvoiceDiscountAmount(); end; } field("Invoice Disc. Pct."; InvoiceDiscountPct) { AutoFormatType = 0; ApplicationArea = Basic, Suite; Caption = 'Invoice Discount %'; DecimalPlaces = 0 : 3; Editable = InvDiscAmountEditable; ToolTip = 'Specifies a discount percentage that is applied to the invoice, based on sales lines where the Allow Invoice Disc. field is selected. The percentage and criteria are defined in the Customer Invoice Discounts page, but you can enter or change the percentage manually.'; trigger OnValidate() begin DocumentTotals.SalesDocTotalsNotUpToDate(); AmountWithDiscountAllowed := DocumentTotals.CalcTotalSalesAmountOnlyDiscountAllowed(Rec); InvoiceDiscountAmount := Round(AmountWithDiscountAllowed * InvoiceDiscountPct / 100, Currency."Amount Rounding Precision"); ValidateInvoiceDiscountAmount(); end; } } group(Control28) { ShowCaption = false; field("Total Amount Excl. VAT"; TotalSalesLine.Amount) { ApplicationArea = Basic, Suite; AutoFormatExpression = Currency.Code; AutoFormatType = 1; CaptionClass = DocumentTotals.GetTotalExclVATCaption(Currency.Code); Caption = 'Total Amount Excl. VAT'; DrillDown = false; Editable = false; ToolTip = 'Specifies the sum of the value in the Line Amount Excl. VAT field on all lines in the document minus any discount amount in the Invoice Discount Amount field.'; } field("Total VAT Amount"; VATAmount) { ApplicationArea = Basic, Suite; AutoFormatExpression = Currency.Code; AutoFormatType = 1; CaptionClass = DocumentTotals.GetTotalVATCaption(Currency.Code); Caption = 'Total VAT'; Editable = false; ToolTip = 'Specifies the sum of VAT amounts on all lines in the document.'; } field("Total Amount Incl. VAT"; TotalSalesLine."Amount Including VAT") { ApplicationArea = Basic, Suite; AutoFormatExpression = Currency.Code; AutoFormatType = 1; CaptionClass = DocumentTotals.GetTotalInclVATCaption(Currency.Code); Caption = 'Total Amount Incl. VAT'; Editable = false; ToolTip = 'Specifies the sum of the value in the Line Amount Incl. VAT field on all lines in the document minus any discount amount in the Invoice Discount Amount field.'; } } } } } actions { area(processing) { action(SelectMultiItems) { AccessByPermission = TableData Item = R; ApplicationArea = Basic, Suite; Caption = 'Select items'; Ellipsis = true; Image = NewItem; ToolTip = 'Add two or more items from the full list of your inventory items.'; trigger OnAction() begin Rec.SelectMultipleItems(); end; } group("&Line") { Caption = '&Line'; Image = Line; group("F&unctions") { Caption = 'F&unctions'; Image = "Action"; action(GetPrice) { AccessByPermission = TableData "Sales Price" = R; ApplicationArea = Basic, Suite; Caption = 'Get Price'; Ellipsis = true; Image = Price; ToolTip = 'Insert the lowest possible price in the Unit Price field according to any special price that you have set up.'; Visible = not ExtendedPriceEnabled; trigger OnAction() begin ShowPrices(); end; } action("Get Li&ne Discount") { AccessByPermission = TableData "Sales Line Discount" = R; ApplicationArea = Basic, Suite; Caption = 'Get Li&ne Discount'; Ellipsis = true; Image = LineDiscount; ToolTip = 'Insert the best possible discount in the Line Discount field according to any special discounts that you have set up.'; Visible = not ExtendedPriceEnabled; trigger OnAction() begin ShowLineDisc(); end; } action(GetPrices) { AccessByPermission = TableData "Sales Price Access" = R; ApplicationArea = Basic, Suite; Caption = 'Get Price'; Ellipsis = true; Image = Price; Visible = ExtendedPriceEnabled; ToolTip = 'Insert the lowest possible price in the Unit Price field according to any special price that you have set up.'; trigger OnAction() begin ShowPrices(); end; } action(GetLineDiscount) { AccessByPermission = TableData "Sales Discount Access" = R; ApplicationArea = Basic, Suite; Caption = 'Get Li&ne Discount'; Ellipsis = true; Image = LineDiscount; Visible = ExtendedPriceEnabled; ToolTip = 'Insert the best possible discount in the Line Discount field according to any special discounts that you have set up.'; trigger OnAction() begin ShowLineDisc(); end; } action(ExplodeBOM_Functions) { AccessByPermission = TableData "BOM Component" = R; ApplicationArea = Suite; Caption = 'E&xplode BOM'; Image = ExplodeBOM; Enabled = Rec.Type = Rec.Type::Item; ToolTip = 'Add a line for each component on the bill of materials for the selected item. For example, this is useful for selling the parent item as a kit. CAUTION: The line for the parent item will be deleted and only its description will display. To undo this action, delete the component lines and add a line for the parent item again. This action is available only for lines that contain an item.'; trigger OnAction() begin ExplodeBOM(); end; } action("Insert Ext. Texts") { AccessByPermission = TableData "Extended Text Header" = R; ApplicationArea = Basic, Suite; Caption = 'Insert &Ext. Texts'; Image = Text; ToolTip = 'Insert the extended item description that is set up for the item that is being processed on the line.'; trigger OnAction() begin InsertExtendedText(true); end; } action("Attach to Inventory Item Line") { ApplicationArea = Basic, Suite; Caption = 'Attach to inventory item line'; Image = Allocations; Visible = AttachingLinesEnabled; Enabled = AttachToInvtItemEnabled; ToolTip = 'Attach the selected non-inventory product lines to a inventory item line in this sales order.'; trigger OnAction() var SelectedSalesLine: Record "Sales Line"; begin CurrPage.SetSelectionFilter(SelectedSalesLine); Rec.AttachToInventoryItemLine(SelectedSalesLine); end; } action(Reserve) { ApplicationArea = Reservation; Caption = '&Reserve'; Ellipsis = true; Image = Reserve; Enabled = Rec.Type = Rec.Type::Item; ToolTip = 'Reserve the quantity of the selected item that is required on the document line from which you opened this page. This action is available only for lines that contain an item.'; trigger OnAction() begin Rec.Find(); Rec.ShowReservation(); end; } action(OrderTracking) { ApplicationArea = Basic, Suite; Caption = 'Order &Tracking'; Image = OrderTracking; Enabled = Rec.Type = Rec.Type::Item; ToolTip = 'Track the connection of a supply to its corresponding demand for the selected item. This can help you find the original demand that created a specific production order or purchase order. This action is available only for lines that contain an item.'; trigger OnAction() begin Rec.ShowOrderTracking(); end; } action("Select Nonstoc&k Items") { AccessByPermission = TableData "Nonstock Item" = R; ApplicationArea = Basic, Suite; Caption = 'Select Ca&talog Items'; Image = NonStockItem; ToolTip = 'View the list of catalog items that exist in the system. '; trigger OnAction() begin ShowNonstockItems(); end; } action(ReserveFromInventory) { ApplicationArea = Reservation; Caption = 'Reserve from Inventory'; Image = LineReserve; ToolTip = 'Reserve items for the selected line from inventory.'; trigger OnAction() begin ReserveSelectedLines(); end; } } group("Item Availability by") { Enabled = Rec.Type = Rec.Type::Item; Caption = 'Item Availability by'; Image = ItemAvailability; action("<Action3>") { ApplicationArea = Basic, Suite; Caption = 'Event'; Image = "Event"; ToolTip = 'View how the actual and the projected available balance of an item will develop over time according to supply and demand events.'; trigger OnAction() begin SalesAvailabilityMgt.ShowItemAvailabilityFromSalesLine(Rec, "Item Availability Type"::"Event"); end; } action(ItemAvailabilityByPeriod) { ApplicationArea = Basic, Suite; Caption = 'Period'; Image = Period; ToolTip = 'Show the projected quantity of the item over time according to time periods, such as day, week, or month.'; trigger OnAction() begin SalesAvailabilityMgt.ShowItemAvailabilityFromSalesLine(Rec, "Item Availability Type"::Period); end; } action(ItemAvailabilityByVariant) { ApplicationArea = Planning; Caption = 'Variant'; Image = ItemVariant; ToolTip = 'View or edit the item''s variants. Instead of setting up each color of an item as a separate item, you can set up the various colors as variants of the item.'; trigger OnAction() begin SalesAvailabilityMgt.ShowItemAvailabilityFromSalesLine(Rec, "Item Availability Type"::Variant); end; } action(ItemAvailabilityByLocation) { AccessByPermission = TableData Location = R; ApplicationArea = Location; Caption = 'Location'; Image = Warehouse; ToolTip = 'View the actual and projected quantity of the item per location.'; trigger OnAction() begin SalesAvailabilityMgt.ShowItemAvailabilityFromSalesLine(Rec, "Item Availability Type"::Location); end; } action(Lot) { ApplicationArea = ItemTracking; Caption = 'Lot'; Image = LotInfo; RunObject = Page "Item Availability by Lot No."; RunPageLink = "No." = field("No."), "Location Filter" = field("Location Code"), "Variant Filter" = field("Variant Code"); ToolTip = 'View the current and projected quantity of the item for each lot.'; } action("BOM Level") { AccessByPermission = TableData "BOM Buffer" = R; ApplicationArea = Assembly; Caption = 'BOM Level'; Image = BOMLevel; ToolTip = 'View availability figures for items on bills of materials that show how many units of a parent item you can make based on the availability of child items.'; trigger OnAction() begin SalesAvailabilityMgt.ShowItemAvailabilityFromSalesLine(Rec, "Item Availability Type"::BOM); end; } action(ItemAvailabilityByUnitOfMeasure) { ApplicationArea = Basic, Suite; Caption = 'Unit of Measure'; Image = UnitOfMeasure; ToolTip = 'View the item''s availability by a unit of measure.'; trigger OnAction() begin SalesAvailabilityMgt.ShowItemAvailabilityFromSalesLine(Rec, "Item Availability Type"::UOM); end; } } group("Related Information") { Caption = 'Related Information'; action("Reservation Entries") { AccessByPermission = TableData Item = R; ApplicationArea = Reservation; Caption = 'Reservation Entries'; Image = ReservationLedger; Enabled = Rec.Type = Rec.Type::Item; ToolTip = 'View all reservation entries for the selected item. This action is available only for lines that contain an item.'; trigger OnAction() begin Rec.ShowReservationEntries(true); end; } action(ItemTrackingLines) { ApplicationArea = ItemTracking; Caption = 'Item &Tracking Lines'; Image = ItemTrackingLines; ShortCutKey = 'Ctrl+Alt+I'; Enabled = Rec.Type = Rec.Type::Item; ToolTip = 'View or edit serial, lot and package numbers for the selected item. This action is available only for lines that contain an item.'; trigger OnAction() begin Rec.OpenItemTrackingLines(); end; } action(SelectItemSubstitution) { AccessByPermission = TableData "Item Substitution" = R; ApplicationArea = Suite; Caption = 'Select Item Substitution'; Image = SelectItemSubstitution; ToolTip = 'Select another item that has been set up to be sold instead of the original item if it is unavailable.'; trigger OnAction() begin CurrPage.SaveRecord(); Rec.ShowItemSub(); CurrPage.Update(true); if (Rec.Reserve = Rec.Reserve::Always) and (Rec."No." <> xRec."No.") then begin Rec.AutoReserve(); CurrPage.Update(false); end; end; } action(Dimensions) { AccessByPermission = TableData Dimension = R; ApplicationArea = Dimensions; Caption = 'Dimensions'; Image = Dimensions; ShortCutKey = 'Alt+D'; ToolTip = 'View or edit dimensions, such as area, project, or department, that you can assign to sales and purchase documents to distribute costs and analyze transaction history.'; trigger OnAction() begin Rec.ShowDimensions(); end; } action("Co&mments") { ApplicationArea = Comments; Caption = 'Co&mments'; Image = ViewComments; ToolTip = 'View or add comments for the record.'; trigger OnAction() begin Rec.ShowLineComments(); end; } action("Item Charge &Assignment") { AccessByPermission = TableData "Item Charge" = R; ApplicationArea = ItemCharges; Caption = 'Item Charge &Assignment'; Image = ItemCosts; Enabled = Rec.Type = Rec.Type::"Charge (Item)"; ToolTip = 'Record additional direct costs, for example for freight. This action is available only for Charge (Item) line types.'; trigger OnAction() begin ItemChargeAssgnt(); SetItemChargeFieldsStyle(); end; } action(OrderPromising) { AccessByPermission = TableData "Order Promising Line" = R; ApplicationArea = OrderPromising; Caption = 'Order &Promising'; Image = OrderPromising; ToolTip = 'Calculate the shipment and delivery dates based on the item''s known and expected availability dates, and then promise the dates to the customer.'; trigger OnAction() begin OrderPromisingLine(); end; } action(DocAttach) { ApplicationArea = All; Caption = 'Attachments'; Image = Attach; ToolTip = 'Add a file as an attachment. You can attach images as well as documents.'; trigger OnAction() var DocumentAttachmentDetails: Page "Document Attachment Details"; RecRef: RecordRef; begin RecRef.GetTable(Rec); DocumentAttachmentDetails.OpenForRecRef(RecRef); DocumentAttachmentDetails.RunModal(); end; } group("Assemble to Order") { Caption = 'Assemble to Order'; Image = AssemblyBOM; action(AssembleToOrderLines) { AccessByPermission = TableData "BOM Component" = R; ApplicationArea = Assembly; Caption = 'Assemble-to-Order Lines'; ToolTip = 'View any linked assembly order lines if the documents represents an assemble-to-order sale.'; trigger OnAction() begin Rec.ShowAsmToOrderLines(); end; } action("Roll Up &Price") { AccessByPermission = TableData "BOM Component" = R; ApplicationArea = Assembly; Caption = 'Roll Up &Price'; Ellipsis = true; ToolTip = 'Update the unit price of the assembly item according to any changes that you have made to the assembly components.'; trigger OnAction() begin Rec.RollupAsmPrice(); CalculateTotals(); end; } action("Roll Up &Cost") { AccessByPermission = TableData "BOM Component" = R; ApplicationArea = Assembly; Caption = 'Roll Up &Cost'; Ellipsis = true; ToolTip = 'Update the unit cost of the assembly item according to any changes that you have made to the assembly components.'; trigger OnAction() begin Rec.RollUpAsmCost(); CalculateTotals(); end; } } action(DocumentLineTracking) { ApplicationArea = Basic, Suite; Caption = 'Document &Line Tracking'; Image = Navigate; ToolTip = 'View related open, posted, or archived documents or document lines. '; trigger OnAction() begin ShowDocumentLineTracking(); end; } action(DeferralSchedule) { ApplicationArea = Suite; Caption = 'Deferral Schedule'; Enabled = Rec."Deferral Code" <> ''; Image = PaymentPeriod; ToolTip = 'View or edit the deferral schedule that governs how revenue made with this sales document is deferred to different accounting periods when the document is posted.'; trigger OnAction() begin Rec.ShowDeferralSchedule(); end; } action(RedistributeAccAllocations) { ApplicationArea = All; Caption = 'Redistribute Account Allocations'; Image = EditList;#pragma warning disable AA0219 ToolTip = 'Use this action to redistribute the account allocations for this line.';#pragma warning restore AA0219 trigger OnAction() var AllocAccManualOverride: Page "Redistribute Acc. Allocations"; begin if ((Rec."Type" <> Rec."Type"::"Allocation Account") and (Rec."Selected Alloc. Account No." = '')) then Error(ActionOnlyAllowedForAllocationAccountsErr); AllocAccManualOverride.SetParentSystemId(Rec.SystemId); AllocAccManualOverride.SetParentTableId(Database::"Sales Line"); AllocAccManualOverride.RunModal(); end; } action(ReplaceAllocationAccountWithLines) { ApplicationArea = All; Caption = 'Generate lines from Allocation Account Line'; Image = CreateLinesFromJob;#pragma warning disable AA0219 ToolTip = 'Use this action to replace the Allocation Account line with the actual lines that would be generated from the line itself.';#pragma warning restore AA0219 trigger OnAction() var SalesAllocAccMgt: Codeunit "Sales Alloc. Acc. Mgt."; begin if ((Rec."Type" <> Rec."Type"::"Allocation Account") and (Rec."Selected Alloc. Account No." = '')) then Error(ActionOnlyAllowedForAllocationAccountsErr); SalesAllocAccMgt.CreateLinesFromAllocationAccountLine(Rec); Rec.Delete(); CurrPage.Update(false); end; } } } group("O&rder") { Caption = 'O&rder'; Image = "Order"; group("Dr&op Shipment") { Caption = 'Dr&op Shipment'; Image = Delivery; action("Purchase &Order") { AccessByPermission = TableData "Purch. Rcpt. Header" = R; ApplicationArea = Suite; Caption = 'Purchase &Order'; Image = Document; ToolTip = 'View the purchase order that is linked to the sales order, for drop shipment or special order.'; trigger OnAction() begin OpenPurchOrderForm(); end; } } group("Speci&al Order") { Caption = 'Speci&al Order'; Image = SpecialOrder; action(OpenSpecialPurchaseOrder) { AccessByPermission = TableData "Purch. Rcpt. Header" = R; ApplicationArea = Basic, Suite; Caption = 'Purchase &Order'; Image = Document; ToolTip = 'View the purchase order that is linked to the sales order, for drop shipment or special order.'; trigger OnAction() begin OpenSpecialPurchOrderForm(); end; } } action(BlanketOrder) { ApplicationArea = Suite; Caption = 'Blanket Order'; Image = BlanketOrder; ToolTip = 'View the blanket sales order.'; trigger OnAction() var SalesHeader: Record "Sales Header"; BlanketSalesOrder: Page "Blanket Sales Order"; begin Rec.TestField("Blanket Order No."); SalesHeader.SetRange("No.", Rec."Blanket Order No."); if not SalesHeader.IsEmpty() then begin BlanketSalesOrder.SetTableView(SalesHeader); BlanketSalesOrder.Editable := false; BlanketSalesOrder.Run(); end; end; } } group(Errors) { Caption = 'Issues'; Image = ErrorLog; Visible = BackgroundErrorCheck; ShowAs = SplitButton; action(ShowLinesWithErrors) { ApplicationArea = Basic, Suite; Caption = 'Show Lines with Issues'; Image = Error; Visible = BackgroundErrorCheck; Enabled = not ShowAllLinesEnabled; ToolTip = 'View a list of sales lines that have issues before you post the document.'; trigger OnAction() begin Rec.SwitchLinesWithErrorsFilter(ShowAllLinesEnabled); end; } action(ShowAllLines) { ApplicationArea = Basic, Suite; Caption = 'Show All Lines'; Image = ExpandAll; Visible = BackgroundErrorCheck; Enabled = ShowAllLinesEnabled; ToolTip = 'View all sales lines, including lines with and without issues.'; trigger OnAction() begin Rec.SwitchLinesWithErrorsFilter(ShowAllLinesEnabled); end; } } group("Page") { Caption = 'Page'; action(EditInExcel) { ApplicationArea = Basic, Suite; Caption = 'Edit in Excel'; Image = Excel; Visible = IsSaaSExcelAddinEnabled; ToolTip = 'Send the data in the sub page to an Excel file for analysis or editing'; AccessByPermission = System "Allow Action Export To Excel" = X; trigger OnAction() var EditinExcel: Codeunit "Edit in Excel"; EditinExcelFilters: Codeunit "Edit in Excel Filters"; begin EditinExcelFilters.AddFieldV2('Document_No', Enum::"Edit in Excel Filter Type"::Equal, Rec."Document No.", Enum::"Edit in Excel Edm Type"::"Edm.String"); EditinExcel.EditPageInExcel( 'Sales_Order_Line', page::"Sales Order Subform", EditinExcelFilters, StrSubstNo(ExcelFileNameTxt, Rec."Document No.")); end; } } } } trigger OnAfterGetCurrRecord() var IsHandled: Boolean; begin IsHandled := false; OnBeforeAfterGetCurrRecord(Rec, IsHandled, TotalSalesHeader, Currency); if IsHandled then exit; GetTotalSalesHeader(); CalculateTotals(); SetLocationCodeMandatory(); UpdateEditableOnRow(); UpdateTypeText(); SetItemChargeFieldsStyle(); end; trigger OnAfterGetRecord() var Item: Record "Item"; begin Rec.ShowShortcutDimCode(ShortcutDimCode); UpdateEditableOnRow(); UpdateTypeText(); SetItemChargeFieldsStyle(); if Rec."Variant Code" = '' then VariantCodeMandatory := Item.IsVariantMandatory(Rec.Type = Rec.Type::Item, Rec."No."); end; trigger OnDeleteRecord(): Boolean var SalesLineReserve: Codeunit "Sales Line-Reserve"; begin if Rec.Quantity <> 0 then if Rec.ItemExists(Rec."No.") then begin if not SalesLineReserve.DeleteLineConfirm(Rec) then exit(false); OnBeforeDeleteReservationEntries(Rec); SalesLineReserve.DeleteLine(Rec); end; DocumentTotals.SalesDocTotalsNotUpToDate(); end; trigger OnFindRecord(Which: Text): Boolean begin Rec.AddLoadFields( "Price Calculation Method", "Sell-to Customer No.", "Customer Disc. Group", "Customer Price Group", "VAT %", "VAT Calculation Type", "VAT Bus. Posting Group", "VAT Prod. Posting Group", "Dimension Set ID", "Currency Code", "Qty. per Unit of Measure", "Allow Line Disc."); DocumentTotals.SalesCheckAndClearTotals(Rec, xRec, TotalSalesLine, VATAmount, InvoiceDiscountAmount, InvoiceDiscountPct); exit(Rec.Find(Which)); end; trigger OnInit() var ApplicationAreaMgmtFacade: Codeunit "Application Area Mgmt. Facade"; begin SalesSetup.Get(); Currency.InitRoundingPrecision(); TempOptionLookupBuffer.FillLookupBuffer(Enum::"Option Lookup Type"::Sales); TypeAsTextFieldVisible := ApplicationAreaMgmtFacade.IsFoundationEnabled() and not ApplicationAreaMgmtFacade.IsAdvancedEnabled(); end; trigger OnModifyRecord(): Boolean begin DocumentTotals.SalesCheckIfDocumentChanged(Rec, xRec); end; trigger OnNewRecord(BelowxRec: Boolean) begin Rec.InitType(); SetDefaultType(); Clear(ShortcutDimCode); UpdateTypeText(); end; trigger OnOpenPage() var AllocationAccountMgt: Codeunit "Allocation Account Mgt."; begin UseAllocationAccountNumber := AllocationAccountMgt.UseAllocationAccountNoField(); SetOpenPage(); SetDimensionsVisibility(); SetItemReferenceVisibility(); end; var SalesSetup: Record "Sales & Receivables Setup"; TempOptionLookupBuffer: Record "Option Lookup Buffer" temporary; TransferExtendedText: Codeunit "Transfer Extended Text"; SalesAvailabilityMgt: Codeunit "Sales Availability Mgt."; SalesCalcDiscountByType: Codeunit "Sales - Calc Discount By Type"; AmountWithDiscountAllowed: Decimal;#pragma warning disable AA0074 Text001: Label 'You cannot use the Explode BOM function because a prepayment of the sales order has been invoiced.';#pragma warning restore AA0074 VariantCodeMandatory: Boolean; LocationCodeVisible: Boolean; CurrPageIsEditable: Boolean; BackgroundErrorCheck: Boolean; ShowAllLinesEnabled: Boolean; IsSaaSExcelAddinEnabled: Boolean; ExtendedPriceEnabled: Boolean; AttachingLinesEnabled: Boolean; UpdateInvDiscountQst: Label 'One or more lines have been invoiced. The discount distributed to invoiced lines will not be taken into account.\\Do you want to update the invoice discount?'; ItemChargeStyleExpression: Text; ItemChargeToHandleStyleExpression: Text; TypeAsText: Text[30]; TypeAsTextFieldVisible: Boolean; UseAllocationAccountNumber: Boolean; ActionOnlyAllowedForAllocationAccountsErr: Label 'This action is only available for lines that have Allocation Account set as Type.'; ExcelFileNameTxt: Label 'Sales Order %1 - Lines', Comment = '%1 = document number, ex. 10000'; protected var Currency: Record Currency; TotalSalesHeader: Record "Sales Header"; TotalSalesLine: Record "Sales Line"; DocumentTotals: Codeunit "Document Totals"; ShortcutDimCode: array[8] of Code[20]; DimVisible1: Boolean; DimVisible2: Boolean; DimVisible3: Boolean; DimVisible4: Boolean; DimVisible5: Boolean; DimVisible6: Boolean; DimVisible7: Boolean; DimVisible8: Boolean; InvDiscAmountEditable: Boolean; InvoiceDiscountAmount: Decimal; InvoiceDiscountPct: Decimal; IsCommentLine: Boolean; IsBlankNumber: Boolean; ItemReferenceVisible: Boolean; LocationCodeMandatory: Boolean; SuppressTotals: Boolean; UnitofMeasureCodeIsChangeable: Boolean; AttachToInvtItemEnabled: Boolean; VATAmount: Decimal; local procedure SetOpenPage() var [SecurityFiltering(SecurityFilter::Filtered)] Location: Record Location; ServerSetting: Codeunit "Server Setting"; PriceCalculationMgt: Codeunit "Price Calculation Mgt."; DocumentErrorsMgt: Codeunit "Document Errors Mgt."; begin OnBeforeSetOpenPage(); if Location.ReadPermission then LocationCodeVisible := not Location.IsEmpty(); IsSaaSExcelAddinEnabled := ServerSetting.GetIsSaasExcelAddinEnabled(); SuppressTotals := CurrentClientType() = ClientType::ODataV4; ExtendedPriceEnabled := PriceCalculationMgt.IsExtendedPriceCalculationEnabled(); BackgroundErrorCheck := DocumentErrorsMgt.BackgroundValidationEnabled(); AttachingLinesEnabled := SalesSetup."Auto Post Non-Invt. via Whse." = SalesSetup."Auto Post Non-Invt. via Whse."::"Attached/Assigned"; end; local procedure ReserveSelectedLines() var SalesLine: Record "Sales Line"; begin CurrPage.SetSelectionFilter(SalesLine); Rec.ReserveFromInventory(SalesLine); end; /// <summary> /// Approves and calculates the invoice discount for the current line. /// </summary> procedure ApproveCalcInvDisc() begin CODEUNIT.Run(CODEUNIT::"Sales-Disc. (Yes/No)", Rec); DocumentTotals.SalesDocTotalsNotUpToDate(); end; local procedure ValidateInvoiceDiscountAmount() var SalesHeader: Record "Sales Header"; ConfirmManagement: Codeunit "Confirm Management"; begin if SuppressTotals then exit; SalesHeader.Get(Rec."Document Type", Rec."Document No."); if SalesHeader.Status = SalesHeader.Status::"Pending Approval" then SalesHeader.FieldError(SalesHeader.Status); if SalesHeader.InvoicedLineExists() then if not ConfirmManagement.GetResponseOrDefault(UpdateInvDiscountQst, true) then exit; SalesCalcDiscountByType.ApplyInvDiscBasedOnAmt(InvoiceDiscountAmount, SalesHeader); DocumentTotals.SalesDocTotalsNotUpToDate(); CurrPage.Update(false); end; /// <summary> /// Calculates the invoice discount for the current line. /// </summary> procedure CalcInvDisc() var SalesCalcDiscount: Codeunit "Sales-Calc. Discount"; begin SalesCalcDiscount.CalculateInvoiceDiscountOnLine(Rec); DocumentTotals.SalesDocTotalsNotUpToDate(); end; /// <summary> /// Explodes the bill of materials for the current item line. /// </summary> procedure ExplodeBOM() begin if Rec."Prepmt. Amt. Inv." <> 0 then Error(Text001); CODEUNIT.Run(CODEUNIT::"Sales-Explode BOM", Rec); DocumentTotals.SalesDocTotalsNotUpToDate(); end; /// <summary> /// Opens the related purchase order form for drop shipment orders. /// </summary> procedure OpenPurchOrderForm() var PurchHeader: Record "Purchase Header"; PurchOrder: Page "Purchase Order"; IsHandled: Boolean; PageEditable: Boolean; begin IsHandled := false; OnBeforeOpenPurchOrderForm(Rec, PageEditable, IsHandled); if IsHandled then exit; Rec.TestField("Purchase Order No."); PurchHeader.SetRange("No.", Rec."Purchase Order No."); PurchOrder.SetTableView(PurchHeader); PurchOrder.Editable := PageEditable; PurchOrder.Run(); end; /// <summary> /// Opens the related special order purchase order or posted receipt. /// </summary> procedure OpenSpecialPurchOrderForm() var PurchHeader: Record "Purchase Header"; PurchRcptHeader: Record "Purch. Rcpt. Header"; PurchOrder: Page "Purchase Order"; IsHandled: Boolean; PageEditable: Boolean; begin IsHandled := false; OnBeforeOpenSpecialPurchOrderForm(Rec, PageEditable, IsHandled); if IsHandled then exit; Rec.TestField("Special Order Purchase No."); PurchHeader.SetRange("No.", Rec."Special Order Purchase No."); if not PurchHeader.IsEmpty() then begin PurchOrder.SetTableView(PurchHeader); PurchOrder.Editable := PageEditable; PurchOrder.Run(); end else begin PurchRcptHeader.SetRange("Order No.", Rec."Special Order Purchase No."); if PurchRcptHeader.Count = 1 then PAGE.Run(PAGE::"Posted Purchase Receipt", PurchRcptHeader) else PAGE.Run(PAGE::"Posted Purchase Receipts", PurchRcptHeader); end; end; /// <summary> /// Inserts extended text for the current line if available. /// </summary> /// <param name="Unconditionally">Whether to insert text without conditions.</param> procedure InsertExtendedText(Unconditionally: Boolean) begin if not Unconditionally and (Rec."No." = xRec."No.") then exit; OnBeforeInsertExtendedText(Rec); if TransferExtendedText.SalesCheckIfAnyExtText(Rec, Unconditionally) then begin CurrPage.SaveRecord(); Commit(); TransferExtendedText.InsertSalesExtText(Rec); end; OnInsertExtendedTextOnAfterInsertSalesExtText(Rec); if TransferExtendedText.MakeUpdate() then UpdateForm(true); end; /// <summary> /// Shows the nonstock items page for the current line. /// </summary> procedure ShowNonstockItems() begin Rec.ShowNonstock(); end; /// <summary> /// Shows the order tracking page for the current line. /// </summary> procedure ShowTracking() begin Rec.ShowOrderTracking(); end; /// <summary> /// Shows the item charge assignment page for the current line. /// </summary> procedure ItemChargeAssgnt() begin Rec.ShowItemChargeAssgnt(); end; /// <summary> /// Updates the current page with optional record save. /// </summary> /// <param name="SetSaveRecord">Whether to save the record before updating.</param> procedure UpdateForm(SetSaveRecord: Boolean) begin CurrPage.Update(SetSaveRecord); end; /// <summary> /// Shows available prices for the current line item. /// </summary> procedure ShowPrices() begin Rec.PickPrice(); UpdateForm(true); end; /// <summary> /// Shows available line discounts for the current line item. /// </summary> procedure ShowLineDisc() begin Rec.PickDiscount(); end; /// <summary> /// Opens the order promising lines page for the current line. /// </summary> procedure OrderPromisingLine() var OrderPromisingLine: Record "Order Promising Line" temporary; OrderPromisingLines: Page "Order Promising Lines"; begin OrderPromisingLine.SetRange("Source Type", Rec."Document Type"); OrderPromisingLine.SetRange("Source ID", Rec."Document No."); OrderPromisingLine.SetRange("Source Line No.", Rec."Line No."); OrderPromisingLines.SetSource(OrderPromisingLine."Source Type"::Sales); OrderPromisingLines.SetTableView(OrderPromisingLine); OrderPromisingLines.RunModal(); end; /// <summary> /// Handles post-validation logic after the No. field is validated. /// </summary> procedure NoOnAfterValidate() begin NoOnAfterValidateInternal(false); end; local procedure NoOnAfterValidateInternal(AutoReserveFromLookup: Boolean) var NoHasChanged: Boolean; begin OnBeforeNoOnAfterValidate(Rec, xRec); NoHasChanged := (Rec."No." <> xRec."No.") or AutoReserveFromLookup; InsertExtendedText(false); if (Rec.Type = Rec.Type::"Charge (Item)") and (Rec."No." <> xRec."No.") and (xRec."No." <> '') then CurrPage.SaveRecord(); OnNoOnAfterValidateOnBeforeSaveAndAutoAsmToOrder(); SaveAndAutoAsmToOrder(); OnNoOnAfterValidateOnAfterSaveAndAutoAsmToOrder(Rec); if Rec.Reserve = Rec.Reserve::Always then begin CurrPage.SaveRecord(); if (Rec."Outstanding Qty. (Base)" <> 0) and NoHasChanged then begin Rec.AutoReserve(); CurrPage.Update(false); end; end; OnAfterNoOnAfterValidate(Rec, xRec); end; protected procedure VariantCodeOnAfterValidate() begin OnBeforeVariantCodeOnAfterValidate(Rec, xRec); SaveAndAutoAsmToOrder(); end; /// <summary> /// Handles post-validation logic after the Location Code field is validated. /// </summary> procedure LocationCodeOnAfterValidate() begin SaveAndAutoAsmToOrder(); if (Rec.Reserve = Rec.Reserve::Always) and (Rec."Outstanding Qty. (Base)" <> 0) and (Rec."Location Code" <> xRec."Location Code") then begin CurrPage.SaveRecord(); Rec.AutoReserve(); CurrPage.Update(false); end; OnAfterLocationCodeOnAfterValidate(Rec, xRec); end; protected procedure ReserveOnAfterValidate() begin if (Rec.Reserve = Rec.Reserve::Always) and (Rec."Outstanding Qty. (Base)" <> 0) then begin CurrPage.SaveRecord(); Rec.AutoReserve(); end; end; protected procedure QuantityOnAfterValidate() begin OnBeforeQuantityOnAfterValidate(Rec, xRec); if Rec.Type = Rec.Type::Item then begin CurrPage.SaveRecord(); case Rec.Reserve of Rec.Reserve::Always: Rec.AutoReserve(); end; end; OnAfterQuantityOnAfterValidate(Rec, xRec); end; protected procedure QtyToAsmToOrderOnAfterValidate() var IsHandled: Boolean; begin IsHandled := false; OnBeforeQtyToAsmToOrderOnAfterValidate(Rec, IsHandled); if IsHandled then exit; CurrPage.SaveRecord(); if Rec.Reserve = Rec.Reserve::Always then Rec.AutoReserve(); CurrPage.Update(true); end; protected procedure UnitofMeasureCodeOnAfterValidate() begin OnBeforeUnitofMeasureCodeOnAfterValidate(Rec, xRec); DeltaUpdateTotals(); if Rec.Reserve = Rec.Reserve::Always then begin CurrPage.SaveRecord(); Rec.AutoReserve(); CurrPage.Update(false); end; OnAfterUnitofMeasureCodeOnAfterValidate(Rec, xRec); end; protected procedure ShipmentDateOnAfterValidate() begin if (Rec.Reserve = Rec.Reserve::Always) and (Rec."Outstanding Qty. (Base)" <> 0) and (Rec."Shipment Date" <> xRec."Shipment Date") then begin CurrPage.SaveRecord(); Rec.AutoReserve(); CurrPage.Update(false); end else CurrPage.Update(true); end; protected procedure SaveAndAutoAsmToOrder() begin if (Rec.Type = Rec.Type::Item) and Rec.IsAsmToOrderRequired() then begin CurrPage.SaveRecord(); Rec.AutoAsmToOrder(); CurrPage.Update(false); end; end; /// <summary> /// Shows the document line tracking page for the current line. /// </summary> procedure ShowDocumentLineTracking() var DocumentLineTrackingPage: Page "Document Line Tracking"; begin Clear(DocumentLineTrackingPage); DocumentLineTrackingPage.SetSourceDoc( "Document Line Source Type"::"Sales Order", Rec."Document No.", Rec."Line No.", Rec."Blanket Order No.", Rec."Blanket Order Line No.", '', 0); DocumentLineTrackingPage.RunModal(); end; local procedure SetLocationCodeMandatory() var InventorySetup: Record "Inventory Setup"; begin LocationCodeMandatory := InventorySetup."Location Mandatory" and (Rec.Type = Rec.Type::Item); end; local procedure GetTotalSalesHeader() begin DocumentTotals.GetTotalSalesHeaderAndCurrency(Rec, TotalSalesHeader, Currency); end; /// <summary> /// Clears the total sales header variable. /// </summary> procedure ClearTotalSalesHeader(); begin Clear(TotalSalesHeader); end; /// <summary> /// Calculates the document totals for all sales lines. /// </summary> procedure CalculateTotals() var IsHandled: Boolean; begin IsHandled := false; OnBeforeCalculateTotals(Rec, IsHandled, DocumentTotals, SuppressTotals); if IsHandled then exit; if SuppressTotals then exit; DocumentTotals.SalesCheckIfDocumentChanged(Rec, xRec); DocumentTotals.CalculateSalesSubPageTotals(TotalSalesHeader, TotalSalesLine, VATAmount, InvoiceDiscountAmount, InvoiceDiscountPct); DocumentTotals.RefreshSalesLine(Rec); end; /// <summary> /// Performs an incremental update of document totals based on line changes. /// </summary> procedure DeltaUpdateTotals() var IsHandled: Boolean; begin IsHandled := false; OnBeforeDeltaUpdateTotals(Rec, IsHandled, xRec, SuppressTotals); if IsHandled then exit; if SuppressTotals then exit; DocumentTotals.SalesDeltaUpdateTotals(Rec, xRec, TotalSalesLine, VATAmount, InvoiceDiscountAmount, InvoiceDiscountPct); if Rec."Line Amount" <> xRec."Line Amount" then Rec.SendLineInvoiceDiscountResetNotification(); end; /// <summary> /// Forces a recalculation of document totals on the next update. /// </summary> procedure ForceTotalsCalculation() begin DocumentTotals.SalesDocTotalsNotUpToDate(); end; /// <summary> /// Redistributes invoice discount amounts across lines after validation. /// </summary> procedure RedistributeTotalsOnAfterValidate() var SalesHeader: Record "Sales Header"; begin if SuppressTotals then exit; CurrPage.SaveRecord(); SalesHeader.Get(Rec."Document Type", Rec."Document No."); DocumentTotals.SalesRedistributeInvoiceDiscountAmounts(Rec, VATAmount, TotalSalesLine); CurrPage.Update(false); end; /// <summary> /// Updates the editable state of fields on the current row. /// </summary> procedure UpdateEditableOnRow() begin IsCommentLine := not Rec.HasTypeToFillMandatoryFields(); IsBlankNumber := IsCommentLine; UnitofMeasureCodeIsChangeable := not IsCommentLine; if AttachingLinesEnabled then AttachToInvtItemEnabled := not Rec.IsInventoriableItem(); CurrPageIsEditable := CurrPage.Editable; InvDiscAmountEditable := CurrPageIsEditable and not SalesSetup."Calc. Inv. Discount" and (TotalSalesHeader.Status = TotalSalesHeader.Status::Open); OnAfterUpdateEditableOnRow(Rec, IsCommentLine, IsBlankNumber); end; /// <summary> /// Updates the type text display based on the current line type. /// </summary> procedure UpdateTypeText() var RecRef: RecordRef; begin if not TypeAsTextFieldVisible then exit; OnBeforeUpdateTypeText(Rec); RecRef.GetTable(Rec); TypeAsText := TempOptionLookupBuffer.FormatOption(RecRef.Field(Rec.FieldNo(Type))); end; local procedure SetItemChargeFieldsStyle() begin ItemChargeStyleExpression := ''; ItemChargeToHandleStyleExpression := ''; if Rec.AssignedItemCharge() then begin if Rec."Qty. To Assign" <> (Rec.Quantity - Rec."Qty. Assigned") then ItemChargeStyleExpression := 'Unfavorable'; if Rec."Item Charge Qty. to Handle" <> Rec."Qty. to Invoice" then ItemChargeToHandleStyleExpression := 'Unfavorable'; end; end; local procedure SetDimensionsVisibility() var DimMgt: Codeunit DimensionManagement; begin DimVisible1 := false; DimVisible2 := false; DimVisible3 := false; DimVisible4 := false; DimVisible5 := false; DimVisible6 := false; DimVisible7 := false; DimVisible8 := false; DimMgt.UseShortcutDims( DimVisible1, DimVisible2, DimVisible3, DimVisible4, DimVisible5, DimVisible6, DimVisible7, DimVisible8); Clear(DimMgt); OnAfterSetDimensionsVisibility(); end; local procedure SetItemReferenceVisibility() var ItemReference: Record "Item Reference"; begin ItemReferenceVisible := not ItemReference.IsEmpty(); end; local procedure SetDefaultType() var IsHandled: Boolean; begin IsHandled := false; OnBeforeSetDefaultType(Rec, xRec, IsHandled); if IsHandled then exit; if xRec."Document No." = '' then Rec.Type := Rec.GetDefaultLineType(); end; local procedure ValidateShortcutDimension(DimIndex: Integer) var AssembleToOrderLink: Record "Assemble-to-Order Link"; begin Rec.ValidateShortcutDimCode(DimIndex, ShortcutDimCode[DimIndex]); AssembleToOrderLink.UpdateAsmDimFromSalesLine(Rec); OnAfterValidateShortcutDimCode(Rec, ShortcutDimCode, DimIndex); end; local procedure ResetxRecAmountValues() begin xRec."Line Amount" := 0; xRec."Amount Including VAT" := 0; xRec.Amount := 0; xRec."Inv. Discount Amount" := 0; xRec."VAT Base Amount" := 0; xRec."VAT Difference" := 0; end; [IntegrationEvent(true, false)] local procedure OnAfterNoOnAfterValidate(var SalesLine: Record "Sales Line"; xSalesLine: Record "Sales Line") begin end; [IntegrationEvent(true, false)] local procedure OnAfterQuantityOnAfterValidate(var SalesLine: Record "Sales Line"; xSalesLine: Record "Sales Line") begin end; [IntegrationEvent(true, false)] local procedure OnAfterLocationCodeOnAfterValidate(var SalesLine: Record "Sales Line"; xSalesLine: Record "Sales Line") begin end; [IntegrationEvent(false, false)] local procedure OnAfterUpdateEditableOnRow(SalesLine: Record "Sales Line"; var IsCommentLine: Boolean; var IsBlankNumber: Boolean); begin end; [IntegrationEvent(true, false)] local procedure OnAfterValidateDescription(var SalesLine: Record "Sales Line"; xSalesLine: Record "Sales Line") begin end; [IntegrationEvent(false, false)] local procedure OnAfterValidateShortcutDimCode(var SalesLine: Record "Sales Line"; var ShortcutDimCode: array[8] of Code[20]; DimIndex: Integer) begin end; [IntegrationEvent(true, false)] local procedure OnBeforeDeleteReservationEntries(var SalesLine: Record "Sales Line"); begin end; [IntegrationEvent(false, false)] local procedure OnBeforeInsertExtendedText(var SalesLine: Record "Sales Line") begin end; [IntegrationEvent(true, false)] local procedure OnBeforeNoOnAfterValidate(var SalesLine: Record "Sales Line"; xSalesLine: Record "Sales Line") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeSetDefaultType(var SalesLine: Record "Sales Line"; var xSalesLine: Record "Sales Line"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeUpdateTypeText(var SalesLine: Record "Sales Line") begin end; [IntegrationEvent(false, false)] local procedure OnReferenceNoOnAfterLookup(var SalesLine: Record "Sales Line") begin end; [IntegrationEvent(true, false)] local procedure OnNoOnAfterValidateOnAfterSaveAndAutoAsmToOrder(var SalesLine: Record "Sales Line") begin end; [IntegrationEvent(true, false)] local procedure OnNoOnAfterValidateOnBeforeSaveAndAutoAsmToOrder() begin end; [IntegrationEvent(false, false)] local procedure OnBeforeQtyToAsmToOrderOnAfterValidate(var SalesLine: Record "Sales Line"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeAfterGetCurrRecord(var SalesLine: Record "Sales Line"; var IsHandled: Boolean; var TotalSalesHeader: Record "Sales Header"; var Currency: Record Currency) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeCalculateTotals(var SalesLine: Record "Sales Line"; var IsHandled: Boolean; var DocumentTotals: Codeunit "Document Totals"; var SuppressTotals: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeOpenPurchOrderForm(SalesOrderLine: Record "Sales Line"; var PageEditable: Boolean; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeOpenSpecialPurchOrderForm(SalesOrderLine: Record "Sales Line"; var PageEditable: Boolean; var IsHandled: Boolean) begin end; [IntegrationEvent(true, false)] local procedure OnBeforeSetOpenPage() begin end; [IntegrationEvent(true, false)] local procedure OnAfterSetDimensionsVisibility(); begin end; [IntegrationEvent(true, false)] local procedure OnBeforeDeltaUpdateTotals(var SalesLine: Record "Sales Line"; var IsHandled: Boolean; xSalesLine: Record "Sales Line"; SuppressTotals: Boolean) begin end; [IntegrationEvent(true, false)] local procedure OnBeforeQuantityOnAfterValidate(var SalesLine: Record "Sales Line"; var xSalesLine: Record "Sales Line") begin end; [IntegrationEvent(true, false)] local procedure OnBeforeVariantCodeOnAfterValidate(var SalesLine: Record "Sales Line"; var xSalesLine: Record "Sales Line") begin end; [IntegrationEvent(true, false)] local procedure OnBeforeUnitofMeasureCodeOnAfterValidate(var SalesLine: Record "Sales Line"; var xSalesLine: Record "Sales Line") begin end; [IntegrationEvent(true, false)] local procedure OnAfterUnitofMeasureCodeOnAfterValidate(var SalesLine: Record "Sales Line"; xSalesLine: Record "Sales Line") begin end; [IntegrationEvent(false, false)] local procedure OnInsertExtendedTextOnAfterInsertSalesExtText(SalesLine: Record "Sales Line") begin end; [IntegrationEvent(true, false)] local procedure OnBeforeValidateNo(var SalesLine: Record "Sales Line"; var xSalesLine: Record "Sales Line"; var IsHandled: Boolean) begin end;}