Codeunit 6503 Item Tracking Doc. Management
src/Layers/W1/BaseApp/Inventory/Tracking/ItemTrackingDocManagement.Codeunit.al938 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.Inventory.Tracking;using Microsoft.Inventory.Document;using Microsoft.Inventory.History;using Microsoft.Inventory.Item;using Microsoft.Inventory.Ledger;using Microsoft.Inventory.Planning;using Microsoft.Inventory.Transfer;using Microsoft.Projects.Project.Planning;using Microsoft.Purchases.Document;using Microsoft.Purchases.History;using Microsoft.Sales.Document;using Microsoft.Sales.History;codeunit 6503 "Item Tracking Doc. Management"{ trigger OnRun() begin end; var ItemTrackingMgt: Codeunit "Item Tracking Management"; RetrieveAsmItemTracking: Boolean; CountingRecordsMsg: Label 'Counting records...'; TableNotSupportedErr: Label 'Table %1 is not supported.', Comment = '%1 - table number'; CreateTrackingSpecQst: Label 'This function create tracking specification from reservation entries. Continue?'; procedure AddTempRecordToSet(var TempItemLedgEntry: Record "Item Ledger Entry" temporary; SignFactor: Integer) var TempItemLedgEntry2: Record "Item Ledger Entry" temporary; begin if SignFactor <> 1 then begin TempItemLedgEntry.Quantity *= SignFactor; TempItemLedgEntry."Remaining Quantity" *= SignFactor; TempItemLedgEntry."Invoiced Quantity" *= SignFactor; OnAddTempRecordToSetOnAfterApplySignFactor(TempItemLedgEntry, SignFactor); end; ItemTrackingMgt.RetrieveAppliedExpirationDate(TempItemLedgEntry); OnAddTempRecordToSetOnAfterRetrieveAppliedExpirationDate(TempItemLedgEntry); TempItemLedgEntry2 := TempItemLedgEntry; TempItemLedgEntry.Reset(); TempItemLedgEntry.SetTrackingFilterFromItemLedgEntry(TempItemLedgEntry2); TempItemLedgEntry.SetRange("Warranty Date", TempItemLedgEntry2."Warranty Date"); TempItemLedgEntry.SetRange("Expiration Date", TempItemLedgEntry2."Expiration Date"); OnAddTempRecordToSetOnAfterTempItemLedgEntrySetFilters(TempItemLedgEntry, TempItemLedgEntry2); if TempItemLedgEntry.FindFirst() then begin TempItemLedgEntry.Quantity += TempItemLedgEntry2.Quantity; TempItemLedgEntry."Remaining Quantity" += TempItemLedgEntry2."Remaining Quantity"; TempItemLedgEntry."Invoiced Quantity" += TempItemLedgEntry2."Invoiced Quantity"; OnAddTempRecordToSetOnBeforeTempItemLedgEntryModify(TempItemLedgEntry, TempItemLedgEntry2); TempItemLedgEntry.Modify(); end else TempItemLedgEntry.Insert(); OnAfterAddTempRecordToSet(TempItemLedgEntry, TempItemLedgEntry2, SignFactor); TempItemLedgEntry.Reset(); end; procedure CollectItemTrkgPerPostedDocLine(var TempReservEntry: Record "Reservation Entry" temporary; var TempItemLedgEntry: Record "Item Ledger Entry" temporary; FromPurchase: Boolean; DocNo: Code[20]; LineNo: Integer) var ItemLedgEntry: Record "Item Ledger Entry"; begin TempItemLedgEntry.Reset(); TempItemLedgEntry.DeleteAll(); TempReservEntry.Reset(); TempReservEntry.SetCurrentKey("Source ID", "Source Ref. No."); TempReservEntry.SetRange("Source ID", DocNo); TempReservEntry.SetRange("Source Ref. No.", LineNo); if TempReservEntry.FindSet() then repeat ItemLedgEntry.Get(TempReservEntry."Item Ledger Entry No."); TempItemLedgEntry := ItemLedgEntry; if TempReservEntry."Reservation Status" = "Reservation Status"::Prospect then TempItemLedgEntry."Entry No." := -TempItemLedgEntry."Entry No."; if FromPurchase then TempItemLedgEntry."Remaining Quantity" := TempReservEntry."Quantity (Base)" else TempItemLedgEntry."Shipped Qty. Not Returned" := TempReservEntry."Quantity (Base)"; TempItemLedgEntry."Document No." := TempReservEntry."Source ID"; TempItemLedgEntry."Document Line No." := TempReservEntry."Source Ref. No."; OnCollectItemTrkgPerPostedDocLineOnBeforeTempItemLedgEntryInsert(TempItemLedgEntry, TempReservEntry, ItemLedgEntry, FromPurchase); TempItemLedgEntry.Insert(); until TempReservEntry.Next() = 0; end; procedure CopyItemLedgerEntriesToTemp(var TempItemLedgEntry: Record "Item Ledger Entry" temporary; var FromItemLedgEntry: Record "Item Ledger Entry") begin TempItemLedgEntry.Reset(); TempItemLedgEntry.DeleteAll(); if FromItemLedgEntry.FindSet() then repeat TempItemLedgEntry := FromItemLedgEntry; AddTempRecordToSet(TempItemLedgEntry, 1); until FromItemLedgEntry.Next() = 0; TempItemLedgEntry.Reset(); end; local procedure FillTrackingSpecBuffer(var TempTrackingSpecBuffer: Record "Tracking Specification" temporary; Type: Integer; Subtype: Integer; ID: Code[20]; BatchName: Code[10]; ProdOrderLine: Integer; RefNo: Integer; Description: Text[100]; ItemNo: Code[20]; VariantCode: Code[10]; ItemTrackingSetup: Record "Item Tracking Setup"; Qty: Decimal; Correction: Boolean) var LastEntryNo: Integer; begin TempTrackingSpecBuffer.Reset(); LastEntryNo := TempTrackingSpecBuffer.GetLastEntryNo(); if ItemTrackingExistsInBuffer(TempTrackingSpecBuffer, Type, Subtype, ID, BatchName, ProdOrderLine, RefNo, ItemTrackingSetup) then begin TempTrackingSpecBuffer."Quantity (Base)" += Abs(Qty); TempTrackingSpecBuffer.Modify(); end else begin LastEntryNo += 1; InitTrackingSpecBuffer( TempTrackingSpecBuffer, LastEntryNo, Type, Subtype, ID, BatchName, ProdOrderLine, RefNo, Description, ItemNo, VariantCode, ItemTrackingSetup, Correction); TempTrackingSpecBuffer."Quantity (Base)" := Abs(Qty); TempTrackingSpecBuffer.Insert(); end; end; procedure FillTrackingSpecBufferFromILE(var TempItemLedgEntry: Record "Item Ledger Entry" temporary; var TempTrackingSpecBuffer: Record "Tracking Specification" temporary; Type: Integer; Subtype: Integer; ID: Code[20]; BatchName: Code[10]; ProdOrderLine: Integer; RefNo: Integer; Description: Text[100]) var ItemTrackingSetup: Record "Item Tracking Setup"; begin // creates a new record in TempTrackingSpecBuffer (used for Posted Shipments/Receipts/Invoices) if TempItemLedgEntry.FindSet() then repeat if TempItemLedgEntry.TrackingExists() then begin ItemTrackingSetup.CopyTrackingFromItemLedgerEntry(TempItemLedgEntry); FillTrackingSpecBuffer( TempTrackingSpecBuffer, Type, Subtype, ID, BatchName, ProdOrderLine, RefNo, Description, TempItemLedgEntry."Item No.", TempItemLedgEntry."Variant Code", ItemTrackingSetup, TempItemLedgEntry.Quantity, TempItemLedgEntry.Correction); OnAfterFillTrackingSpecBufferFromItemLedgEntry(TempTrackingSpecBuffer, TempItemLedgEntry); end; until TempItemLedgEntry.Next() = 0; end; procedure FindReservEntries(var TempTrackingSpecBuffer: Record "Tracking Specification" temporary; Type: Integer; Subtype: Integer; ID: Code[20]; BatchName: Code[10]; ProdOrderLine: Integer; RefNo: Integer; Description: Text[100]) var ReservEntry: Record "Reservation Entry"; ItemTrackingSetup: Record "Item Tracking Setup"; begin // finds Item Tracking for Quote, Order, Invoice, Credit Memo, Return Order ReservEntry.SetSourceFilter(Type, Subtype, ID, RefNo, true); ReservEntry.SetSourceFilter(BatchName, ProdOrderLine); if ReservEntry.FindSet() then repeat if ReservEntry.TrackingExists() then begin ItemTrackingSetup.CopyTrackingFromReservEntry(ReservEntry); FillTrackingSpecBuffer( TempTrackingSpecBuffer, Type, Subtype, ID, BatchName, ProdOrderLine, RefNo, Description, ReservEntry."Item No.", ReservEntry."Variant Code", ItemTrackingSetup, ReservEntry."Quantity (Base)", ReservEntry.Correction); OnAfterFillTrackingSpecBufferFromReservEntry(TempTrackingSpecBuffer, ReservEntry); end; until ReservEntry.Next() = 0; end; procedure FindTrackingEntries(var TempTrackingSpecBuffer: Record "Tracking Specification" temporary; Type: Integer; Subtype: Integer; ID: Code[20]; BatchName: Code[10]; ProdOrderLine: Integer; RefNo: Integer; Description: Text[100]) var TrackingSpec: Record "Tracking Specification"; ItemTrackingSetup: Record "Item Tracking Setup"; begin // finds Item Tracking for Quote, Order, Invoice, Credit Memo, Return Order when shipped/received TrackingSpec.SetSourceFilter(Type, Subtype, ID, RefNo, true); TrackingSpec.SetSourceFilter(BatchName, ProdOrderLine); if TrackingSpec.FindSet() then repeat if TrackingSpec.TrackingExists() then begin ItemTrackingSetup.CopyTrackingFromTrackingSpec(TrackingSpec); FillTrackingSpecBuffer( TempTrackingSpecBuffer, Type, Subtype, ID, BatchName, ProdOrderLine, RefNo, Description, TrackingSpec."Item No.", TrackingSpec."Variant Code", ItemTrackingSetup, TrackingSpec."Quantity (Base)", TrackingSpec.Correction); OnAfterFillTrackingSpecBufferFromTrackingEntries(TempTrackingSpecBuffer, TrackingSpec); end; until TrackingSpec.Next() = 0; end; procedure FindShptRcptEntries(var TempTrackingSpecBuffer: Record "Tracking Specification" temporary; Type: Integer; Subtype: Integer; ID: Code[20]; BatchName: Code[10]; ProdOrderLine: Integer; RefNo: Integer; Description: Text[100]) var TempItemLedgEntry: Record "Item Ledger Entry" temporary; begin // finds Item Tracking for Posted Shipments/Receipts RetrieveEntriesFromShptRcpt(TempItemLedgEntry, Type, Subtype, ID, BatchName, ProdOrderLine, RefNo); FillTrackingSpecBufferFromILE( TempItemLedgEntry, TempTrackingSpecBuffer, Type, Subtype, ID, BatchName, ProdOrderLine, RefNo, Description); TempTrackingSpecBuffer.Reset(); end; procedure FindInvoiceEntries(var TempTrackingSpecBuffer: Record "Tracking Specification" temporary; Type: Integer; Subtype: Integer; ID: Code[20]; BatchName: Code[10]; ProdOrderLine: Integer; RefNo: Integer; Description: Text[100]) var TempItemLedgEntry: Record "Item Ledger Entry" temporary; InvoiceRowID: Text[250]; begin InvoiceRowID := ItemTrackingMgt.ComposeRowID(Type, Subtype, ID, BatchName, ProdOrderLine, RefNo); RetrieveEntriesFromPostedInvoice(TempItemLedgEntry, InvoiceRowID); FillTrackingSpecBufferFromILE( TempItemLedgEntry, TempTrackingSpecBuffer, Type, Subtype, ID, BatchName, ProdOrderLine, RefNo, Description); TempTrackingSpecBuffer.Reset(); end; local procedure InitTrackingSpecBuffer(var TempTrackingSpecBuffer: Record "Tracking Specification" temporary; EntryNo: Integer; Type: Integer; Subtype: Integer; ID: Code[20]; BatchName: Code[10]; ProdOrderLine: Integer; RefNo: Integer; Description: Text[100]; ItemNo: Code[20]; VariantCode: Code[10]; ItemTrackingSetup: Record "Item Tracking Setup"; Correction: Boolean) begin // initializes a new record for TempTrackingSpecBuffer TempTrackingSpecBuffer.Init(); TempTrackingSpecBuffer."Source Type" := Type; TempTrackingSpecBuffer."Entry No." := EntryNo; TempTrackingSpecBuffer."Item No." := ItemNo; TempTrackingSpecBuffer."Variant Code" := VariantCode; TempTrackingSpecBuffer.Description := Description; TempTrackingSpecBuffer."Source Subtype" := Subtype; TempTrackingSpecBuffer."Source ID" := ID; TempTrackingSpecBuffer."Source Batch Name" := BatchName; TempTrackingSpecBuffer."Source Prod. Order Line" := ProdOrderLine; TempTrackingSpecBuffer."Source Ref. No." := RefNo; TempTrackingSpecBuffer.CopyTrackingFromItemTrackingSetup(ItemTrackingSetup); TempTrackingSpecBuffer.Correction := Correction; end; local procedure ItemTrackingExistsInBuffer(var TempTrackingSpecBuffer: Record "Tracking Specification" temporary; Type: Integer; Subtype: Integer; ID: Code[20]; BatchName: Code[10]; ProdOrderLine: Integer; RefNo: Integer; ItemTrackingSetup: Record "Item Tracking Setup"): Boolean begin // searches after existing record in TempTrackingSpecBuffer TempTrackingSpecBuffer.SetSourceFilter(Type, Subtype, ID, RefNo, true); TempTrackingSpecBuffer.SetSourceFilter(BatchName, ProdOrderLine); TempTrackingSpecBuffer.SetTrackingFilterFromItemTrackingSetup(ItemTrackingSetup); OnItemTrackingExistsInBufferOnAfterTempTrackingSpecBufferSetFilters(TempTrackingSpecBuffer); if not TempTrackingSpecBuffer.IsEmpty() then begin TempTrackingSpecBuffer.FindFirst(); exit(true); end; exit(false); end; procedure RetrieveDocumentItemTracking(var TempTrackingSpecBuffer: Record "Tracking Specification" temporary; SourceID: Code[20]; SourceType: Integer; SourceSubType: Option): Integer var Found: Boolean; IsHandled: Boolean; begin // retrieves Item Tracking for Purchase Header, Sales Header, Sales Shipment Header, Sales Invoice Header TempTrackingSpecBuffer.DeleteAll(); IsHandled := false; OnBeforeRetrieveDocumentItemTracking(TempTrackingSpecBuffer, SourceID, SourceType, SourceSubType, IsHandled); if not IsHandled then case SourceType of Database::"Purchase Header": RetrieveTrackingPurchase(TempTrackingSpecBuffer, SourceID, SourceSubType); Database::"Sales Header": RetrieveTrackingSales(TempTrackingSpecBuffer, SourceID, SourceSubType); Database::"Purch. Rcpt. Header": RetrieveTrackingPurchaseReceipt(TempTrackingSpecBuffer, SourceID); Database::"Sales Shipment Header": RetrieveTrackingSalesShipment(TempTrackingSpecBuffer, SourceID); Database::"Sales Invoice Header": RetrieveTrackingSalesInvoice(TempTrackingSpecBuffer, SourceID); Database::"Sales Cr.Memo Header": RetrieveTrackingSalesCrMemoHeader(TempTrackingSpecBuffer, SourceID); Database::"Purch. Inv. Header": RetrieveTrackingPurhInvHeader(TempTrackingSpecBuffer, SourceID); Database::"Purch. Cr. Memo Hdr.": RetrieveTrackingPurchCrMemoHeader(TempTrackingSpecBuffer, SourceID); else begin OnRetrieveDocumentItemTracking(TempTrackingSpecBuffer, SourceID, Found, SourceType, SourceSubType, RetrieveAsmItemTracking); if not Found then Error(TableNotSupportedErr, SourceType); end; end; TempTrackingSpecBuffer.Reset(); exit(TempTrackingSpecBuffer.Count); end; procedure RetrieveEntriesFromShptRcpt(var TempItemLedgEntry: Record "Item Ledger Entry" temporary; Type: Integer; Subtype: Integer; ID: Code[20]; BatchName: Code[10]; ProdOrderLine: Integer; RefNo: Integer) var ItemEntryRelation: Record "Item Entry Relation"; ItemLedgEntry: Record "Item Ledger Entry"; SignFactor: Integer; begin // retrieves a data set of Item Ledger Entries (Posted Shipments/Receipts) ItemEntryRelation.SetCurrentKey("Source ID", "Source Type"); ItemEntryRelation.SetRange("Source Type", Type); ItemEntryRelation.SetRange("Source Subtype", Subtype); ItemEntryRelation.SetRange("Source ID", ID); ItemEntryRelation.SetRange("Source Batch Name", BatchName); ItemEntryRelation.SetRange("Source Prod. Order Line", ProdOrderLine); ItemEntryRelation.SetRange("Source Ref. No.", RefNo); if ItemEntryRelation.FindSet() then begin SignFactor := TableSignFactor(Type); repeat ItemLedgEntry.Get(ItemEntryRelation."Item Entry No."); TempItemLedgEntry := ItemLedgEntry; AddTempRecordToSet(TempItemLedgEntry, SignFactor); until ItemEntryRelation.Next() = 0; end; end; procedure RetrieveEntriesFromPostedInvoice(var TempItemLedgEntry: Record "Item Ledger Entry" temporary; InvoiceRowID: Text[250]) var ValueEntryRelation: Record "Value Entry Relation"; ValueEntry: Record "Value Entry"; ItemLedgEntry: Record "Item Ledger Entry"; SignFactor: Integer; begin // retrieves a data set of Item Ledger Entries (Posted Invoices) ValueEntryRelation.SetCurrentKey("Source RowId"); ValueEntryRelation.SetRange("Source RowId", InvoiceRowID); if ValueEntryRelation.Find('-') then begin SignFactor := TableSignFactor2(InvoiceRowID); repeat ValueEntry.Get(ValueEntryRelation."Value Entry No."); if ValueEntry."Item Ledger Entry Type" in [ValueEntry."Item Ledger Entry Type"::Purchase, ValueEntry."Item Ledger Entry Type"::Sale, ValueEntry."Item Ledger Entry Type"::"Positive Adjmt.", ValueEntry."Item Ledger Entry Type"::"Negative Adjmt."] then begin ItemLedgEntry.Get(ValueEntry."Item Ledger Entry No."); TempItemLedgEntry := ItemLedgEntry; TempItemLedgEntry.Quantity := ValueEntry."Invoiced Quantity"; OnRetrieveEntriesFromPostedInvOnBeforeAddTempRecordToSet(TempItemLedgEntry, ValueEntry); if TempItemLedgEntry.Quantity <> 0 then AddTempRecordToSet(TempItemLedgEntry, SignFactor); end; until ValueEntryRelation.Next() = 0; end; end; local procedure RetrieveTrackingPurchase(var TempTrackingSpecBuffer: Record "Tracking Specification" temporary; SourceID: Code[20]; SourceSubType: Option) var PurchaseLine: Record "Purchase Line"; Item: Record Item; Descr: Text[100]; begin PurchaseLine.SetRange("Document Type", SourceSubType); PurchaseLine.SetRange("Document No.", SourceID); OnRetrieveTrackingPurchaseOnAfterSetFilters(PurchaseLine, SourceID, SourceSubType); if not PurchaseLine.IsEmpty() then begin PurchaseLine.FindSet(); repeat if (PurchaseLine.Type = PurchaseLine.Type::Item) and (PurchaseLine."Quantity (Base)" <> 0) then begin if Item.Get(PurchaseLine."No.") then Descr := Item.Description; FindReservEntries( TempTrackingSpecBuffer, Database::"Purchase Line", PurchaseLine."Document Type".AsInteger(), PurchaseLine."Document No.", '', 0, PurchaseLine."Line No.", Descr); FindTrackingEntries( TempTrackingSpecBuffer, Database::"Purchase Line", PurchaseLine."Document Type".AsInteger(), PurchaseLine."Document No.", '', 0, PurchaseLine."Line No.", Descr); end; until PurchaseLine.Next() = 0; end; end; local procedure RetrieveTrackingPurchaseReceipt(var TempTrackingSpecBuffer: Record "Tracking Specification" temporary; SourceID: Code[20]) var PurchRcptLine: Record "Purch. Rcpt. Line"; Item: Record Item; Descr: Text[100]; begin PurchRcptLine.SetRange("Document No.", SourceID); OnRetrieveTrackingPurchaseReceiptOnAfterSetFilters(PurchRcptLine, SourceID); if PurchRcptLine.FindSet() then repeat if (PurchRcptLine.Type = PurchRcptLine.Type::Item) and (PurchRcptLine."No." <> '') and (PurchRcptLine."Quantity (Base)" <> 0) then begin if Item.Get(PurchRcptLine."No.") then Descr := Item.Description; FindShptRcptEntries( TempTrackingSpecBuffer, Database::"Purch. Rcpt. Line", 0, PurchRcptLine."Document No.", '', 0, PurchRcptLine."Line No.", Descr); end; until PurchRcptLine.Next() = 0; end; local procedure RetrieveTrackingSales(var TempTrackingSpecBuffer: Record "Tracking Specification" temporary; SourceID: Code[20]; SourceSubType: Option) var SalesLine: Record "Sales Line"; Item: Record Item; Descr: Text[100]; begin SalesLine.SetRange("Document Type", SourceSubType); SalesLine.SetRange("Document No.", SourceID); OnRetrieveTrackingSalesOnAfterSetFilters(SalesLine, SourceID, SourceSubType); if not SalesLine.IsEmpty() then begin SalesLine.FindSet(); repeat if (SalesLine.Type = SalesLine.Type::Item) and (SalesLine."No." <> '') and (SalesLine."Quantity (Base)" <> 0) then begin if Item.Get(SalesLine."No.") then Descr := Item.Description; FindReservEntries( TempTrackingSpecBuffer, Database::"Sales Line", SalesLine."Document Type".AsInteger(), SalesLine."Document No.", '', 0, SalesLine."Line No.", Descr); FindTrackingEntries( TempTrackingSpecBuffer, Database::"Sales Line", SalesLine."Document Type".AsInteger(), SalesLine."Document No.", '', 0, SalesLine."Line No.", Descr); end; until SalesLine.Next() = 0; end; end; local procedure RetrieveTrackingSalesShipment(var TempTrackingSpecBuffer: Record "Tracking Specification" temporary; SourceID: Code[20]) var SalesShipmentLine: Record "Sales Shipment Line"; Item: Record Item; Descr: Text[100]; begin SalesShipmentLine.SetRange("Document No.", SourceID); OnRetrieveTrackingSalesShipmentOnAfterSetFilters(SalesShipmentLine, SourceID); if not SalesShipmentLine.IsEmpty() then begin SalesShipmentLine.FindSet(); repeat if (SalesShipmentLine.Type = SalesShipmentLine.Type::Item) and (SalesShipmentLine."No." <> '') and (SalesShipmentLine."Quantity (Base)" <> 0) then begin if Item.Get(SalesShipmentLine."No.") then Descr := Item.Description; FindShptRcptEntries( TempTrackingSpecBuffer, Database::"Sales Shipment Line", 0, SalesShipmentLine."Document No.", '', 0, SalesShipmentLine."Line No.", Descr); if RetrieveAsmItemTracking then OnRetrieveTrackingSalesShipmentForAssembly(SalesShipmentLine, TempTrackingSpecBuffer); end; until SalesShipmentLine.Next() = 0; end; end; local procedure RetrieveTrackingSalesInvoice(var TempTrackingSpecBuffer: Record "Tracking Specification" temporary; SourceID: Code[20]) var SalesInvoiceLine: Record "Sales Invoice Line"; Item: Record Item; Descr: Text[100]; begin SalesInvoiceLine.SetRange("Document No.", SourceID); OnRetrieveTrackingSalesInvoiceOnAfterSetFilters(SalesInvoiceLine, SourceID); if not SalesInvoiceLine.IsEmpty() then begin SalesInvoiceLine.FindSet(); repeat if (SalesInvoiceLine.Type = SalesInvoiceLine.Type::Item) and (SalesInvoiceLine."No." <> '') and (SalesInvoiceLine."Quantity (Base)" <> 0) then begin if Item.Get(SalesInvoiceLine."No.") then Descr := Item.Description; FindInvoiceEntries(TempTrackingSpecBuffer, Database::"Sales Invoice Line", 0, SalesInvoiceLine."Document No.", '', 0, SalesInvoiceLine."Line No.", Descr); end; until SalesInvoiceLine.Next() = 0; end; end; local procedure RetrieveTrackingSalesCrMemoHeader(var TempTrackingSpecBuffer: Record "Tracking Specification" temporary; SourceID: Code[20]) var SalesCrMLine: Record "Sales Cr.Memo Line"; Item: Record Item; Descr: Text[100]; begin SalesCrMLine.SetRange("Document No.", SourceID); OnRetrieveTrackingSalesCrMemoHeaderOnAfterSetFilters(SalesCrMLine, SourceID); if not SalesCrMLine.IsEmpty() then begin SalesCrMLine.FindSet(); repeat if (SalesCrMLine.Type = SalesCrMLine.Type::Item) and (SalesCrMLine."No." <> '') and (SalesCrMLine."Quantity (Base)" <> 0) then begin if Item.Get(SalesCrMLine."No.") then Descr := Item.Description; FindInvoiceEntries(TempTrackingSpecBuffer, Database::"Sales Cr.Memo Line", 0, SalesCrMLine."Document No.", '', 0, SalesCrMLine."Line No.", Descr); end; until SalesCrMLine.Next() = 0; end; end; local procedure RetrieveTrackingPurhInvHeader(var TempTrackingSpecBuffer: Record "Tracking Specification" temporary; SourceID: Code[20]) var PurchInvLine: Record "Purch. Inv. Line"; Item: Record Item; Descr: Text[100]; begin PurchInvLine.SetRange("Document No.", SourceID); OnRetrieveTrackingPurhInvHeaderOnAfterSetFilters(PurchInvLine, SourceID); if not PurchInvLine.IsEmpty() then begin PurchInvLine.FindSet(); repeat if (PurchInvLine.Type = PurchInvLine.Type::Item) and (PurchInvLine."No." <> '') and (PurchInvLine."Quantity (Base)" <> 0) then begin if Item.Get(PurchInvLine."No.") then Descr := Item.Description; FindInvoiceEntries(TempTrackingSpecBuffer, Database::"Purch. Inv. Line", 0, PurchInvLine."Document No.", '', 0, PurchInvLine."Line No.", Descr); end; until PurchInvLine.Next() = 0; end; end; local procedure RetrieveTrackingPurchCrMemoHeader(var TempTrackingSpecBuffer: Record "Tracking Specification" temporary; SourceID: Code[20]) var PurchCrMLine: Record "Purch. Cr. Memo Line"; Item: Record Item; Descr: Text[100]; begin PurchCrMLine.SetRange("Document No.", SourceID); OnRetrieveTrackingPurchCrMemoHeaderOnAfterSetFilters(PurchCrMLine, SourceID); if not PurchCrMLine.IsEmpty() then begin PurchCrMLine.FindSet(); repeat if (PurchCrMLine.Type = PurchCrMLine.Type::Item) and (PurchCrMLine."No." <> '') and (PurchCrMLine."Quantity (Base)" <> 0) then begin if Item.Get(PurchCrMLine."No.") then Descr := Item.Description; FindInvoiceEntries(TempTrackingSpecBuffer, Database::"Purch. Cr. Memo Line", 0, PurchCrMLine."Document No.", '', 0, PurchCrMLine."Line No.", Descr); end; until PurchCrMLine.Next() = 0; end; end; procedure SetRetrieveAsmItemTracking(RetrieveAsmItemTracking2: Boolean) begin RetrieveAsmItemTracking := RetrieveAsmItemTracking2; end; procedure ShowItemTrackingForInvoiceLine(InvoiceRowID: Text[250]): Boolean var TempItemLedgEntry: Record "Item Ledger Entry" temporary; begin RetrieveEntriesFromPostedInvoice(TempItemLedgEntry, InvoiceRowID); if not TempItemLedgEntry.IsEmpty() then begin PAGE.RunModal(PAGE::"Posted Item Tracking Lines", TempItemLedgEntry); exit(true); end; exit(false); end; procedure ShowItemTrackingForEntity(SourceType: Integer; SourceNo: Code[20]; ItemNo: Code[20]; VariantCode: Code[20]; LocationCode: Code[10]; ItemTrackingSetup: Record "Item Tracking Setup") var ItemLedgEntry: Record "Item Ledger Entry"; TempItemLedgEntry: Record "Item Ledger Entry" temporary; Item: Record Item; Window: Dialog; begin // Used when calling Item Tracking from Item, Stockkeeping Unit, Customer, Vendor and information card: Window.Open(CountingRecordsMsg); if SourceNo <> '' then begin ItemLedgEntry.SetCurrentKey("Source Type", "Source No.", "Item No.", "Variant Code"); ItemLedgEntry.SetRange("Source No.", SourceNo); ItemLedgEntry.SetRange("Source Type", SourceType); end else ItemLedgEntry.SetCurrentKey("Item No.", Open, "Variant Code"); if LocationCode <> '' then ItemLedgEntry.SetRange("Location Code", LocationCode); if ItemNo <> '' then begin Item.Get(ItemNo); Item.TestField("Item Tracking Code"); ItemLedgEntry.SetRange("Item No.", ItemNo); end; if SourceType = 0 then ItemLedgEntry.SetRange("Variant Code", VariantCode); ItemLedgEntry.SetTrackingFilterFromItemTrackingSetupIfNotBlank(ItemTrackingSetup); if ItemLedgEntry.FindSet() then repeat if ItemLedgEntry.TrackingExists() then begin TempItemLedgEntry := ItemLedgEntry; OnShowItemTrackingForEntityOnBeforeTempItemLedgEntryInsert(TempItemLedgEntry, Item); TempItemLedgEntry.Insert(); end until ItemLedgEntry.Next() = 0; Window.Close(); PAGE.RunModal(PAGE::"Item Tracking Entries", TempItemLedgEntry); end; procedure ShowItemTrackingForEntity(SourceType: Integer; SourceNo: Code[20]; ItemNo: Code[20]; VariantCode: Code[20]; LocationCode: Code[10]) var DummyItemTrackingSetup: Record "Item Tracking Setup"; begin ShowItemTrackingForEntity(SourceType, SourceNo, ItemNo, VariantCode, LocationCode, DummyItemTrackingSetup); end;#if not CLEAN27 [Obsolete('Moved to codeunit Mfg. Item Tracking Mgt.', '27.0')] procedure ShowItemTrackingForProdOrderComp(Type: Integer; ID: Code[20]; ProdOrderLine: Integer; RefNo: Integer): Boolean var MfgItemTrackingMgt: Codeunit "Mfg. Item Tracking Mgt."; begin exit(MfgItemTrackingMgt.ShowItemTrackingForProdOrderComp(Type, ID, ProdOrderLine, RefNo)); end;#endif internal procedure ShowItemTrackingForJobPlanningLine(Type: Integer; ID: Code[20]; RefNo: Integer): Boolean var ItemLedgEntry: Record "Item Ledger Entry"; TempItemLedgEntry: Record "Item Ledger Entry" temporary; Window: Dialog; begin Window.Open(CountingRecordsMsg); ItemLedgEntry.SetLoadFields("Serial No.", "Lot No.", "Package No."); ItemLedgEntry.SetCurrentKey("Order Type", "Job No.", "Order Line No.", "Entry Type"); ItemLedgEntry.SetRange("Order Type", ItemLedgEntry."Order Type"::" "); ItemLedgEntry.SetRange("Job No.", ID); ItemLedgEntry.SetRange("Order Line No.", RefNo); if Type = Database::"Job Planning Line" then ItemLedgEntry.SetRange("Entry Type", ItemLedgEntry."Entry Type"::"Negative Adjmt.") else exit(false); if ItemLedgEntry.FindSet() then repeat if ItemLedgEntry.TrackingExists() then begin TempItemLedgEntry := ItemLedgEntry; TempItemLedgEntry.Insert(); end until ItemLedgEntry.Next() = 0; Window.Close(); if TempItemLedgEntry.IsEmpty() then exit(false); PAGE.RunModal(PAGE::"Posted Item Tracking Lines", TempItemLedgEntry); exit(true); end; procedure ShowItemTrackingForShptRcptLine(Type: Integer; Subtype: Integer; ID: Code[20]; BatchName: Code[10]; ProdOrderLine: Integer; RefNo: Integer): Boolean var TempItemLedgEntry: Record "Item Ledger Entry" temporary; begin RetrieveEntriesFromShptRcpt(TempItemLedgEntry, Type, Subtype, ID, BatchName, ProdOrderLine, RefNo); if not TempItemLedgEntry.IsEmpty() then begin PAGE.RunModal(PAGE::"Posted Item Tracking Lines", TempItemLedgEntry); exit(true); end; exit(false); end; procedure TableSignFactor(TableNo: Integer): Integer var Sign: Integer; begin if TableNo in [ Database::"Sales Line", Database::"Sales Shipment Line", Database::"Sales Invoice Line", Database::"Purch. Cr. Memo Line", Database::"Transfer Shipment Line", Database::"Return Shipment Line", Database::"Invt. Shipment Line", Database::"Planning Component"] then exit(-1); OnAfterTableSignFactor(TableNo, Sign); if Sign <> 0 then exit(Sign); exit(1); end; local procedure TableSignFactor2(RowID: Text[250]): Integer var TableNo: Integer; begin RowID := DelChr(RowID, '<', '"'); RowID := CopyStr(RowID, 1, StrPos(RowID, '"') - 1); if Evaluate(TableNo, RowID) then exit(TableSignFactor(TableNo)); exit(1); end; procedure CreateTrackingInfo(TableID: Integer; DocumentType: Integer; DocumentNo: Code[20]) var Item: Record Item; ItemTrackingCode: Record "Item Tracking Code"; SerialNoInfo: Record "Serial No. Information"; LotNoInfo: Record "Lot No. Information"; TempTrackingSpecification: Record "Tracking Specification" temporary; Inbound: Boolean; begin RetrieveDocumentItemTracking(TempTrackingSpecification, DocumentNo, TableID, DocumentType); Inbound := TableSignFactor(DocumentType) > 0; if TempTrackingSpecification.FindSet() then repeat Item.Get(TempTrackingSpecification."Item No."); ItemTrackingCode.Get(Item."Item Tracking Code"); if ((Inbound and ItemTrackingCode."SN Info. Inbound Must Exist") or (not Inbound and ItemTrackingCode."SN Info. Outbound Must Exist")) and (TempTrackingSpecification."Serial No." <> '') then if not SerialNoInfo.Get(TempTrackingSpecification."Item No.", TempTrackingSpecification."Variant Code", TempTrackingSpecification."Serial No.") then begin SerialNoInfo.Init(); SerialNoInfo."Item No." := TempTrackingSpecification."Item No."; SerialNoInfo."Variant Code" := TempTrackingSpecification."Variant Code"; SerialNoInfo."Serial No." := TempTrackingSpecification."Serial No."; SerialNoInfo.Insert(); end; if ((Inbound and ItemTrackingCode."Lot Info. Inbound Must Exist") or (not Inbound and ItemTrackingCode."Lot Info. Outbound Must Exist")) and (TempTrackingSpecification."Lot No." <> '') then if not LotNoInfo.Get(TempTrackingSpecification."Item No.", TempTrackingSpecification."Variant Code", TempTrackingSpecification."Lot No.") then begin LotNoInfo.Init(); LotNoInfo."Item No." := TempTrackingSpecification."Item No."; LotNoInfo."Variant Code" := TempTrackingSpecification."Variant Code"; LotNoInfo."Lot No." := TempTrackingSpecification."Lot No."; LotNoInfo.Insert(); end; OnCreateTrackingInformationOnAfterTrackingSpecLoop(TempTrackingSpecification, ItemTrackingCode, Inbound); until TempTrackingSpecification.Next() = 0; end; local procedure CreateLineTrkgFromReservation(ItemNo: Code[20]; Type: Integer; Subtype: Integer; DocNo: Code[20]; LineNo: Integer) var ReservEntryFor: Record "Reservation Entry"; ReservEntryFrom: Record "Reservation Entry"; Item: Record Item; ItemTrackingCode: Record "Item Tracking Code"; ItemTrackingSetup: Record "Item Tracking Setup"; begin Item.Get(ItemNo); if Item."Item Tracking Code" <> '' then begin ItemTrackingCode.Code := Item."Item Tracking Code"; ItemTrackingMgt.GetItemTrackingSetup( ItemTrackingCode, Enum::"Item Ledger Entry Type"::" ", false, ItemTrackingSetup); if ItemTrackingSetup.TrackingRequired() then begin ReservEntryFor.Reset(); ReservEntryFor.SetSourceFilter(Type, Subtype, DocNo, LineNo, true); if ReservEntryFor.FindSet() then repeat ReservEntryFrom.Get(ReservEntryFor."Entry No.", not ReservEntryFor.Positive); ReservEntryFor.CopyTrackingFromReservEntry(ReservEntryFrom); ReservEntryFor.UpdateItemTracking(); ReservEntryFor.Modify(); until ReservEntryFor.Next() = 0; end; end; end; procedure CopyDocTrkgFromReservation(SourceType: Integer; SourceSubtype: Integer; SourceID: Code[20]; HideDialog: Boolean) var SalesLine: Record "Sales Line"; TransLine: Record "Transfer Line"; InvtDocLine: Record "Invt. Document Line"; begin if not HideDialog then if not Confirm(CreateTrackingSpecQst, true) then exit; case SourceType of Database::"Sales Header": begin SalesLine.SetRange("Document Type", SourceSubtype); SalesLine.SetRange("Document No.", SourceID); SalesLine.SetRange(Type, SalesLine.Type::Item); if SalesLine.FindSet() then repeat CreateLineTrkgFromReservation( SalesLine."No.", Database::"Sales Line", SourceSubtype, SourceID, SalesLine."Line No."); until SalesLine.Next() = 0; end; Database::"Transfer Header": begin TransLine.SetRange("Document No.", SourceID); if TransLine.FindSet() then repeat CreateLineTrkgFromReservation( TransLine."Item No.", Database::"Transfer Line", SourceSubtype, SourceID, TransLine."Line No.") until TransLine.Next() = 0; end; Database::"Invt. Document Header": begin InvtDocLine.SetRange("Document No.", SourceID); if InvtDocLine.FindSet() then repeat CreateLineTrkgFromReservation( InvtDocLine."Item No.", Database::"Invt. Document Line", SourceSubtype, SourceID, InvtDocLine."Line No."); until InvtDocLine.Next() = 0; end; end; end; [IntegrationEvent(false, false)] local procedure OnAddTempRecordToSetOnAfterTempItemLedgEntrySetFilters(var TempItemLedgEntry: Record "Item Ledger Entry" temporary; TempItemLedgEntry2: Record "Item Ledger Entry" temporary) begin end; [IntegrationEvent(false, false)] local procedure OnAddTempRecordToSetOnAfterApplySignFactor(var TempItemLedgerEntry: Record "Item Ledger Entry" temporary; SignFactor: Integer) begin end; [IntegrationEvent(false, false)] local procedure OnAddTempRecordToSetOnBeforeTempItemLedgEntryModify(var TempItemLedgEntry: Record "Item Ledger Entry" temporary; TempItemLedgEntry2: Record "Item Ledger Entry" temporary) begin end; [IntegrationEvent(false, false)] local procedure OnAddTempRecordToSetOnAfterRetrieveAppliedExpirationDate(var TempItemLedgerEntry: Record "Item Ledger Entry" temporary) begin end; [IntegrationEvent(false, false)] local procedure OnAfterAddTempRecordToSet(var TempItemLedgerEntry: Record "Item Ledger Entry" temporary; var TempItemLedgerEntry2: Record "Item Ledger Entry" temporary; SignFactor: Integer) begin end; [IntegrationEvent(false, false)] local procedure OnAfterFillTrackingSpecBufferFromItemLedgEntry(var TempTrackingSpecification: Record "Tracking Specification" temporary; var TempItemLedgerEntry: Record "Item Ledger Entry" temporary) begin end; [IntegrationEvent(false, false)] local procedure OnAfterFillTrackingSpecBufferFromReservEntry(var TempTrackingSpecification: Record "Tracking Specification" temporary; var ReservationEntry: Record "Reservation Entry") begin end; [IntegrationEvent(false, false)] local procedure OnAfterFillTrackingSpecBufferFromTrackingEntries(var TempTrackingSpecification: Record "Tracking Specification" temporary; var TrackingSpecification: Record "Tracking Specification") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeRetrieveDocumentItemTracking(var TempTrackingSpecBuffer: Record "Tracking Specification" temporary; SourceID: Code[20]; SourceType: Integer; SourceSubType: Option; var IsHandled: Boolean) begin end; [IntegrationEvent(true, false)] local procedure OnRetrieveDocumentItemTracking(var TempTrackingSpecBuffer: Record "Tracking Specification" temporary; SourceID: Code[20]; var Found: Boolean; SourceType: Integer; SourceSubType: Option; RetrieveAsmItemTracking: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnRetrieveEntriesFromPostedInvOnBeforeAddTempRecordToSet(var TempItemLedgerEntry: Record "Item Ledger Entry" temporary; ValueEntry: Record "Value Entry") begin end; [IntegrationEvent(false, false)] local procedure OnRetrieveTrackingPurchaseOnAfterSetFilters(var PurchaseLine: Record "Purchase Line"; SourceID: Code[20]; SourceSubType: Option) begin end; [IntegrationEvent(false, false)] local procedure OnRetrieveTrackingPurchaseReceiptOnAfterSetFilters(var PurchRcptLine: Record "Purch. Rcpt. Line"; SourceID: Code[20]) begin end; [IntegrationEvent(false, false)] local procedure OnRetrieveTrackingPurchCrMemoHeaderOnAfterSetFilters(var PurchCrMemoLine: Record "Purch. Cr. Memo Line"; SourceID: Code[20]) begin end; [IntegrationEvent(false, false)] local procedure OnRetrieveTrackingPurhInvHeaderOnAfterSetFilters(var PurchInvLine: Record "Purch. Inv. Line"; SourceID: Code[20]) begin end; [IntegrationEvent(false, false)] local procedure OnRetrieveTrackingSalesOnAfterSetFilters(var SalesLine: Record "Sales Line"; SourceID: Code[20]; SourceSubType: Option) begin end; [IntegrationEvent(false, false)] local procedure OnRetrieveTrackingSalesCrMemoHeaderOnAfterSetFilters(var SalesCrMemoLine: Record "Sales Cr.Memo Line"; SourceID: Code[20]) begin end; [IntegrationEvent(false, false)] local procedure OnRetrieveTrackingSalesInvoiceOnAfterSetFilters(var SalesInvoiceLine: Record "Sales Invoice Line"; SourceID: Code[20]) begin end; [IntegrationEvent(false, false)] local procedure OnRetrieveTrackingSalesShipmentOnAfterSetFilters(var SalesShipmentLine: Record "Sales Shipment Line"; SourceID: Code[20]) begin end; [IntegrationEvent(false, false)] local procedure OnCollectItemTrkgPerPostedDocLineOnBeforeTempItemLedgEntryInsert(var TempItemLedgerEntry: Record "Item Ledger Entry" temporary; var TempReservationEntry: Record "Reservation Entry" temporary; ItemLedgerEntry: Record "Item Ledger Entry"; FromPurchase: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnCreateTrackingInformationOnAfterTrackingSpecLoop(TrackingSpecification: Record "Tracking Specification"; ItemTrackingCode: Record "Item Tracking Code"; Inbound: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnItemTrackingExistsInBufferOnAfterTempTrackingSpecBufferSetFilters(var TempTrackingSpecBuffer: Record "Tracking Specification" temporary) begin end; [IntegrationEvent(false, false)] local procedure OnShowItemTrackingForEntityOnBeforeTempItemLedgEntryInsert(var TempItemLedgerEntry: Record "Item Ledger Entry" temporary; Item: Record Item) begin end; [IntegrationEvent(false, false)] local procedure OnAfterTableSignFactor(TableNo: Integer; var Sign: Integer); begin end; [IntegrationEvent(true, false)] local procedure OnRetrieveTrackingSalesShipmentForAssembly(SalesShipmentLine: Record "Sales Shipment Line"; var TempTrackingSpecBuffer: Record "Tracking Specification" temporary) begin end;}