Table 7190 Sales Shipment Buffer

Base Application, Microsoft.Sales.History

src/Layers/W1/BaseApp/Sales/History/SalesShipmentBuffer.Table.al383 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Sales.History;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.FixedAssets.FixedAsset;using Microsoft.Foundation.UOM;using Microsoft.Inventory.Item;using Microsoft.Inventory.Ledger;using Microsoft.Projects.Resources.Resource;using Microsoft.Sales.Document;/// <summary>/// Provides temporary storage for sales shipment data during invoice printing and document processing./// </summary>table 7190 "Sales Shipment Buffer"{    Caption = 'Sales Shipment Buffer';    ReplicateData = false;    DataClassification = CustomerContent;    fields    {        /// <summary>        /// Specifies the document number of the related shipment or receipt.        /// </summary>        field(1; "Document No."; Code[20])        {            Caption = 'Document No.';            DataClassification = SystemMetadata;            TableRelation = "Sales Invoice Header";        }        /// <summary>        /// Specifies the line number from the source document.        /// </summary>        field(2; "Line No."; Integer)        {            Caption = 'Line No.';            DataClassification = SystemMetadata;        }        /// <summary>        /// Specifies a unique sequential entry number for the buffer record.        /// </summary>        field(3; "Entry No."; Integer)        {            Caption = 'Entry No.';            DataClassification = SystemMetadata;        }        /// <summary>        /// Specifies the type of the line such as Item, G/L Account, or Resource.        /// </summary>        field(5; Type; Enum "Sales Line Type")        {            Caption = 'Type';            DataClassification = SystemMetadata;        }        /// <summary>        /// Specifies the number of the item, G/L account, or resource on the line.        /// </summary>        field(6; "No."; Code[20])        {            Caption = 'No.';            DataClassification = SystemMetadata;            TableRelation = if (Type = const("G/L Account")) "G/L Account"            else            if (Type = const(Item)) Item            else            if (Type = const(Resource)) Resource            else            if (Type = const("Fixed Asset")) "Fixed Asset"            else            if (Type = const("Charge (Item)")) "Item Charge";        }        /// <summary>        /// Specifies the quantity shipped or received for the line.        /// </summary>        field(7; Quantity; Decimal)        {            AutoFormatType = 0;            Caption = 'Quantity';            DataClassification = SystemMetadata;        }        /// <summary>        /// Specifies the posting date of the shipment or receipt.        /// </summary>        field(8; "Posting Date"; Date)        {            Caption = 'Posting Date';            DataClassification = SystemMetadata;        }    }    keys    {        key(Key1; "Document No.", "Line No.", "Entry No.")        {            Clustered = true;        }        key(Key2; "Document No.", "Line No.", "Posting Date")        {        }    }    fieldgroups    {    }    var        UOMMgt: Codeunit "Unit of Measure Management";        NextEntryNo: Integer;    /// <summary>    /// Populates the buffer with shipment information for a sales invoice line.    /// </summary>    /// <param name="SalesInvoiceLine">The sales invoice line to get shipment data for.</param>    /// <param name="SalesInvoiceHeader">The sales invoice header.</param>    procedure GetLinesForSalesInvoiceLine(var SalesInvoiceLine: Record "Sales Invoice Line"; var SalesInvoiceHeader: Record "Sales Invoice Header")    var        ValueEntry: Record "Value Entry";    begin        case SalesInvoiceLine.Type of            SalesInvoiceLine.Type::Item:                GenerateBufferFromValueEntry(                  ValueEntry."Document Type"::"Sales Invoice",                  SalesInvoiceLine."Document No.",                  SalesInvoiceLine."Line No.",                  SalesInvoiceLine.Type,                  SalesInvoiceLine."No.",                  SalesInvoiceHeader."Posting Date",                  SalesInvoiceLine."Quantity (Base)",                  SalesInvoiceLine."Qty. per Unit of Measure");            SalesInvoiceLine.Type::"G/L Account", SalesInvoiceLine.Type::Resource,          SalesInvoiceLine.Type::"Charge (Item)", SalesInvoiceLine.Type::"Fixed Asset":                GenerateBufferFromShipment(SalesInvoiceLine, SalesInvoiceHeader);        end;    end;    /// <summary>    /// Populates the buffer with shipment information for a sales credit memo line.    /// </summary>    /// <param name="SalesCrMemoLine">The sales credit memo line to get shipment data for.</param>    /// <param name="SalesCrMemoHeader">The sales credit memo header.</param>    procedure GetLinesForSalesCreditMemoLine(SalesCrMemoLine: Record "Sales Cr.Memo Line"; SalesCrMemoHeader: Record "Sales Cr.Memo Header")    var        ValueEntry: Record "Value Entry";    begin        case SalesCrMemoLine.Type of            SalesCrMemoLine.Type::Item:                GenerateBufferFromValueEntry(                  ValueEntry."Document Type"::"Sales Credit Memo",                  SalesCrMemoLine."Document No.",                  SalesCrMemoLine."Line No.",                  SalesCrMemoLine.Type,                  SalesCrMemoLine."No.",                  SalesCrMemoHeader."Posting Date",                  -SalesCrMemoLine."Quantity (Base)",                  SalesCrMemoLine."Qty. per Unit of Measure");            SalesCrMemoLine.Type::"G/L Account", SalesCrMemoLine.Type::Resource,            SalesCrMemoLine.Type::"Charge (Item)", SalesCrMemoLine.Type::"Fixed Asset":                GenerateBufferFromReceipt(SalesCrMemoLine, SalesCrMemoHeader);        end;    end;    local procedure GenerateBufferFromValueEntry(ValueEntryDocType: Enum "Item Ledger Document Type"; DocNo: Code[20]; DocLineNo: Integer; LineType: Enum "Sales Line Type"; ItemNo: Code[20]; PostingDate: Date; QtyBase: Decimal; QtyPerUOM: Decimal)    var        ValueEntry: Record "Value Entry";        ItemLedgerEntry: Record "Item Ledger Entry";        TotalQuantity: Decimal;        Quantity: Decimal;    begin        TotalQuantity := QtyBase;        ValueEntry.SetRange("Document Type", ValueEntryDocType);        ValueEntry.SetRange("Document No.", DocNo);        ValueEntry.SetRange("Document Line No.", DocLineNo);        ValueEntry.SetRange("Posting Date", PostingDate);        ValueEntry.SetRange("Item Charge No.", '');        ValueEntry.SetRange("Item No.", ItemNo);        if ValueEntry.Find('-') then            repeat                if ItemLedgerEntry.Get(ValueEntry."Item Ledger Entry No.") then begin                    if QtyPerUOM <> 0 then                        Quantity := Round(ValueEntry."Invoiced Quantity" / QtyPerUOM, UOMMgt.QtyRndPrecision())                    else                        Quantity := ValueEntry."Invoiced Quantity";                    AddBufferEntry(                      Abs(Quantity),                      ItemLedgerEntry."Posting Date",                      ItemLedgerEntry."Document No.",                      DocLineNo, LineType, ItemNo);                    TotalQuantity := TotalQuantity + ValueEntry."Invoiced Quantity";                end;            until (ValueEntry.Next() = 0) or (TotalQuantity = 0);    end;    local procedure GenerateBufferFromShipment(SalesInvoiceLine2: Record "Sales Invoice Line"; SalesInvoiceHeader2: Record "Sales Invoice Header")    var        SalesInvoiceHeader: Record "Sales Invoice Header";        SalesInvoiceLine: Record "Sales Invoice Line";        SalesShipmentHeader: Record "Sales Shipment Header";        SalesShipmentLine: Record "Sales Shipment Line";        TotalQuantity: Decimal;        Quantity: Decimal;    begin        if SalesInvoiceHeader2."Order No." = '' then            exit;        TotalQuantity := 0;        SalesInvoiceHeader.SetCurrentKey("Order No.");        SalesInvoiceHeader.SetFilter("No.", '..%1', SalesInvoiceHeader2."No.");        SalesInvoiceHeader.SetRange("Order No.", SalesInvoiceHeader2."Order No.");        if SalesInvoiceHeader.FindSet() then            repeat                SalesInvoiceLine.SetRange("Document No.", SalesInvoiceHeader."No.");                SalesInvoiceLine.SetRange("Line No.", SalesInvoiceLine2."Line No.");                SalesInvoiceLine.SetRange(Type, SalesInvoiceLine2.Type);                SalesInvoiceLine.SetRange("No.", SalesInvoiceLine2."No.");                SalesInvoiceLine.SetRange("Unit of Measure Code", SalesInvoiceLine2."Unit of Measure Code");                if not SalesInvoiceLine.IsEmpty() then begin                    SalesInvoiceLine.CalcSums(Quantity);                    TotalQuantity += SalesInvoiceLine.Quantity;                end;            until SalesInvoiceHeader.Next() = 0;        SalesShipmentLine.SetCurrentKey("Order No.", "Order Line No.", "Posting Date");        SalesShipmentLine.SetRange("Order No.", SalesInvoiceHeader2."Order No.");        SalesShipmentLine.SetRange("Order Line No.", SalesInvoiceLine2."Line No.");        SalesShipmentLine.SetRange("Line No.", SalesInvoiceLine2."Line No.");        SalesShipmentLine.SetRange(Type, SalesInvoiceLine2.Type);        SalesShipmentLine.SetRange("No.", SalesInvoiceLine2."No.");        SalesShipmentLine.SetRange("Unit of Measure Code", SalesInvoiceLine2."Unit of Measure Code");        SalesShipmentLine.SetFilter(Quantity, '<>%1', 0);        if SalesShipmentLine.FindSet() then            repeat                if SalesInvoiceHeader2."Get Shipment Used" then                    CorrectShipment(SalesShipmentLine);                if Abs(SalesShipmentLine.Quantity) <= Abs(TotalQuantity - SalesInvoiceLine2.Quantity) then                    TotalQuantity := TotalQuantity - SalesShipmentLine.Quantity                else begin                    if Abs(SalesShipmentLine.Quantity) > Abs(TotalQuantity) then                        SalesShipmentLine.Quantity := TotalQuantity;                    Quantity :=                      SalesShipmentLine.Quantity - (TotalQuantity - SalesInvoiceLine2.Quantity);                    TotalQuantity := TotalQuantity - SalesShipmentLine.Quantity;                    SalesInvoiceLine.Quantity := SalesInvoiceLine.Quantity - Quantity;                    if SalesShipmentHeader.Get(SalesShipmentLine."Document No.") then                        AddBufferEntry(                          Quantity,                          SalesShipmentHeader."Posting Date",                          SalesShipmentHeader."No.",                          SalesInvoiceLine2."Line No.",                          SalesInvoiceLine2.Type,                          SalesInvoiceLine2."No.");                end;            until (SalesShipmentLine.Next() = 0) or (TotalQuantity = 0);    end;    local procedure GenerateBufferFromReceipt(SalesCrMemoLine: Record "Sales Cr.Memo Line"; SalesCrMemoHeader: Record "Sales Cr.Memo Header")    var        SalesCrMemoHeader2: Record "Sales Cr.Memo Header";        SalesCrMemoLine2: Record "Sales Cr.Memo Line";        ReturnReceiptHeader: Record "Return Receipt Header";        ReturnReceiptLine: Record "Return Receipt Line";        TotalQuantity: Decimal;        Quantity: Decimal;    begin        if SalesCrMemoHeader."Return Order No." = '' then            exit;        TotalQuantity := 0;        SalesCrMemoHeader2.SetCurrentKey("Return Order No.");        SalesCrMemoHeader2.SetFilter("No.", '..%1', SalesCrMemoHeader."No.");        SalesCrMemoHeader2.SetRange("Return Order No.", SalesCrMemoHeader."Return Order No.");        if SalesCrMemoHeader2.Find('-') then            repeat                SalesCrMemoLine2.SetRange("Document No.", SalesCrMemoHeader2."No.");                SalesCrMemoLine2.SetRange("Line No.", SalesCrMemoLine."Line No.");                SalesCrMemoLine2.SetRange(Type, SalesCrMemoLine.Type);                SalesCrMemoLine2.SetRange("No.", SalesCrMemoLine."No.");                SalesCrMemoLine2.SetRange("Unit of Measure Code", SalesCrMemoLine."Unit of Measure Code");                SalesCrMemoLine2.CalcSums(Quantity);                TotalQuantity := TotalQuantity + SalesCrMemoLine2.Quantity;            until SalesCrMemoHeader2.Next() = 0;        ReturnReceiptLine.SetCurrentKey("Return Order No.", "Return Order Line No.");        ReturnReceiptLine.SetRange("Return Order No.", SalesCrMemoHeader."Return Order No.");        ReturnReceiptLine.SetRange("Return Order Line No.", SalesCrMemoLine."Line No.");        ReturnReceiptLine.SetRange("Line No.", SalesCrMemoLine."Line No.");        ReturnReceiptLine.SetRange(Type, SalesCrMemoLine.Type);        ReturnReceiptLine.SetRange("No.", SalesCrMemoLine."No.");        ReturnReceiptLine.SetRange("Unit of Measure Code", SalesCrMemoLine."Unit of Measure Code");        ReturnReceiptLine.SetFilter(Quantity, '<>%1', 0);        if ReturnReceiptLine.Find('-') then            repeat                if SalesCrMemoHeader."Get Return Receipt Used" then                    CorrectReceipt(ReturnReceiptLine);                if Abs(ReturnReceiptLine.Quantity) <= Abs(TotalQuantity - SalesCrMemoLine.Quantity) then                    TotalQuantity := TotalQuantity - ReturnReceiptLine.Quantity                else begin                    if Abs(ReturnReceiptLine.Quantity) > Abs(TotalQuantity) then                        ReturnReceiptLine.Quantity := TotalQuantity;                    Quantity :=                      ReturnReceiptLine.Quantity - (TotalQuantity - SalesCrMemoLine.Quantity);                    SalesCrMemoLine.Quantity := SalesCrMemoLine.Quantity - Quantity;                    TotalQuantity := TotalQuantity - ReturnReceiptLine.Quantity;                    if ReturnReceiptHeader.Get(ReturnReceiptLine."Document No.") then                        AddBufferEntry(                          Quantity,                          ReturnReceiptHeader."Posting Date",                          ReturnReceiptHeader."No.",                          SalesCrMemoLine."Line No.",                          SalesCrMemoLine.Type,                          SalesCrMemoLine."No.");                end;            until (ReturnReceiptLine.Next() = 0) or (TotalQuantity = 0);    end;    local procedure AddBufferEntry(QtyOnShipment: Decimal; PostingDate: Date; ShipmentNo: Code[20]; DocLineNo: Integer; LineType: Enum "Sales Line Type"; ItemNo: Code[20])    begin        SetRange("Document No.", ShipmentNo);        SetRange("Line No.", DocLineNo);        SetRange("Posting Date", PostingDate);        if FindFirst() then begin            Quantity += QtyOnShipment;            Modify();            exit;        end;        NextEntryNo := NextEntryNo + 1;        "Document No." := ShipmentNo;        "Line No." := DocLineNo;        "Entry No." := NextEntryNo;        Type := LineType;        "No." := ItemNo;        Quantity := QtyOnShipment;        "Posting Date" := PostingDate;        Insert();    end;    local procedure CorrectShipment(var SalesShipmentLine: Record "Sales Shipment Line")    var        SalesInvoiceLine: Record "Sales Invoice Line";    begin        SalesInvoiceLine.SetCurrentKey("Shipment No.", "Shipment Line No.");        SalesInvoiceLine.SetRange("Shipment No.", SalesShipmentLine."Document No.");        SalesInvoiceLine.SetRange("Shipment Line No.", SalesShipmentLine."Line No.");        SalesInvoiceLine.CalcSums(Quantity);        SalesShipmentLine.Quantity := SalesShipmentLine.Quantity - SalesInvoiceLine.Quantity;        OnAfterCorrectShipment(SalesInvoiceLine, SalesShipmentLine);    end;    local procedure CorrectReceipt(var ReturnReceiptLine: Record "Return Receipt Line")    var        SalesCrMemoLine: Record "Sales Cr.Memo Line";    begin        SalesCrMemoLine.SetCurrentKey("Return Receipt No.", "Return Receipt Line No.");        SalesCrMemoLine.SetRange("Return Receipt No.", ReturnReceiptLine."Document No.");        SalesCrMemoLine.SetRange("Return Receipt Line No.", ReturnReceiptLine."Line No.");        SalesCrMemoLine.CalcSums(Quantity);        ReturnReceiptLine.Quantity := ReturnReceiptLine.Quantity - SalesCrMemoLine.Quantity;        OnAfterCorrectReceipt(SalesCrMemoLine, ReturnReceiptLine);    end;    [IntegrationEvent(false, false)]    local procedure OnAfterCorrectShipment(var SalesInvoiceLine: Record "Sales Invoice Line"; var SalesShipmentLine: Record "Sales Shipment Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterCorrectReceipt(var SalesCrMemoLine: Record "Sales Cr.Memo Line"; var ReturnReceiptLine: Record "Return Receipt Line")    begin    end;}