Codeunit 5884 Phys. Invt. Order-Post
src/Layers/W1/BaseApp/Inventory/Counting/Document/PhysInvtOrderPost.Codeunit.al782 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.Counting.Document;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Preview;using Microsoft.Foundation.AuditCodes;using Microsoft.Foundation.NoSeries;using Microsoft.Inventory.Costing;using Microsoft.Inventory.Counting.Comment;using Microsoft.Inventory.Counting.History;using Microsoft.Inventory.Counting.Journal;using Microsoft.Inventory.Counting.Recording;using Microsoft.Inventory.Counting.Tracking;using Microsoft.Inventory.Item;using Microsoft.Inventory.Journal;using Microsoft.Inventory.Location;using Microsoft.Inventory.Posting;using Microsoft.Inventory.Setup;using Microsoft.Inventory.Tracking;using Microsoft.Utilities;using Microsoft.Warehouse.Journal;codeunit 5884 "Phys. Invt. Order-Post"{ Permissions = TableData "Item Entry Relation" = ri, TableData "Pstd. Phys. Invt. Order Hdr" = rimd, TableData "Pstd. Phys. Invt. Order Line" = rimd, TableData "Pstd. Phys. Invt. Record Hdr" = rimd, TableData "Pstd. Phys. Invt. Record Line" = rimd, TableData "Pstd. Phys. Invt. Tracking" = rimd, TableData "Pstd.Exp.Invt.Order.Tracking" = rimd; TableNo = "Phys. Invt. Order Header"; trigger OnRun() var SequenceNoMgt: Codeunit "Sequence No. Mgt."; begin SequenceNoMgt.SetPreviewMode(PreviewMode); PhysInvtOrderHeader.Copy(Rec); Code(); Rec := PhysInvtOrderHeader; OnAfterOnRun(Rec, PstdPhysInvtOrderHdr); end; var CheckingLinesMsg: Label 'Checking lines #2######\', Comment = '%2 = counter'; PostingLinesMsg: Label 'Posting lines #3######', Comment = '%3 = counter'; HeaderDimCombBlockedErr: Label 'The combination of dimensions used in phys. inventory order %1 is blocked. %2.', Comment = '%1 = Order No. %2 = error message'; LineDimCombBlockedErr: Label 'The combination of dimensions used in phys. inventory order %1, line no. %2 is blocked. %3.', Comment = '%1 = Order No. %2 = line no. %3 = error message'; InvalidDimErr: Label 'The dimensions used in phys. inventory order %1, line no. %2 are invalid. %3.', Comment = '%1 = Order No. %2 = line no. %3 = error message';#pragma warning disable AA0470 DifferenceErr: Label 'There is a difference between the values of the fields %1, %2 and %3. \Identified values in the line: %4 %5 %6 %7.', Comment = '%1,%2,%3 - quantities, %4 = text'; CopyFromToMsg: Label '%1 %2 -> %3 %4', Comment = '%1,%2 = table captions, %2,%4 = Order No.';#pragma warning restore AA0470 PhysInvtOrderHeader: Record "Phys. Invt. Order Header"; PhysInvtOrderLine: Record "Phys. Invt. Order Line"; PhysInvtOrderLine2: Record "Phys. Invt. Order Line"; PstdPhysInvtOrderHdr: Record "Pstd. Phys. Invt. Order Hdr"; PstdPhysInvtOrderLine: Record "Pstd. Phys. Invt. Order Line"; ExpInvtOrderTracking: Record "Exp. Invt. Order Tracking"; PstdExpInvtOrderTracking: Record "Pstd.Exp.Invt.Order.Tracking"; PhysInvtRecordHeader: Record "Phys. Invt. Record Header"; PhysInvtRecordLine: Record "Phys. Invt. Record Line"; PhysInvtCommentLine: Record "Phys. Invt. Comment Line"; PostedPhysInvtCommentLine: Record "Phys. Invt. Comment Line"; Item: Record Item; ItemJnlLine: Record "Item Journal Line"; Location: Record Location; TempWhseTrackingSpecification: Record "Tracking Specification" temporary; DimManagement: Codeunit DimensionManagement; PhysInvtTrackingMgt: Codeunit "Phys. Invt. Tracking Mgt."; DocumentErrorsMgt: Codeunit "Document Errors Mgt."; ItemJnlPostLine: Codeunit "Item Jnl.-Post Line"; Window: Dialog; ErrorText: Text[250]; SourceCode: Code[10]; LineCount: Integer; ModifyHeader: Boolean; LinesToPost: Boolean; WhsePosting: Boolean; OriginalQuantityBase: Decimal; SuppressCommit: Boolean; HideProgressWindow: Boolean; PreviewMode: Boolean; procedure "Code"() var SourceCodeSetup: Record "Source Code Setup"; InventorySetup: Record "Inventory Setup"; PhysInvtCountMgt: Codeunit "Phys. Invt. Count.-Management"; GenJnlPostPreview: Codeunit "Gen. Jnl.-Post Preview"; NoSeries: Codeunit "No. Series"; IsHandled: Boolean; begin OnBeforeCode(PhysInvtOrderHeader, HideProgressWindow, SuppressCommit); PhysInvtOrderHeader.TestField(Status, PhysInvtOrderHeader.Status::Finished); PhysInvtOrderHeader.TestField("Posting Date"); if not HideProgressWindow then begin Window.Open( '#1################################\\' + CheckingLinesMsg + PostingLinesMsg); Window.Update(1, StrSubstNo('%1 %2', PhysInvtOrderHeader.TableCaption(), PhysInvtOrderHeader."No.")); end; PhysInvtOrderHeader.LockTable(); PhysInvtOrderLine.LockTable(); ModifyHeader := false; if PhysInvtOrderHeader."Posting No." = '' then begin if PhysInvtOrderHeader."No. Series" <> '' then PhysInvtOrderHeader.TestField(PhysInvtOrderHeader."Posting No. Series"); if PhysInvtOrderHeader."No. Series" <> PhysInvtOrderHeader."Posting No. Series" then begin PhysInvtOrderHeader."Posting No." := NoSeries.GetNextNo(PhysInvtOrderHeader."Posting No. Series", PhysInvtOrderHeader."Posting Date"); ModifyHeader := true; end; end; if ModifyHeader then begin PhysInvtOrderHeader.Modify(); if not (SuppressCommit or PreviewMode) then Commit(); end; CheckDim(); // Check phys. inventory order lines LinesToPost := false; LineCount := 0; PhysInvtOrderLine.Reset(); PhysInvtOrderLine.SetRange("Document No.", PhysInvtOrderHeader."No."); OnCodeOnAfterSetFilters(PhysInvtOrderLine); if PhysInvtOrderLine.Find('-') then repeat LineCount := LineCount + 1; if not HideProgressWindow then Window.Update(2, LineCount); if not PhysInvtOrderLine.EmptyLine() then begin CheckOrderLine(PhysInvtOrderHeader, PhysInvtOrderLine, Item); PhysInvtOrderLine.TestField("Entry Type"); if IsDifference() then ThrowDifferenceError(); if not LinesToPost then LinesToPost := true; if (PhysInvtOrderLine."Phys Invt Counting Period Type" <> PhysInvtOrderLine."Phys Invt Counting Period Type"::" ") and (PhysInvtOrderLine."Phys Invt Counting Period Code" <> '') then begin PhysInvtCountMgt.InitTempItemSKUList(); PhysInvtCountMgt.AddToTempItemSKUList(PhysInvtOrderLine."Item No.", PhysInvtOrderLine."Location Code", PhysInvtOrderLine."Variant Code", PhysInvtOrderLine."Phys Invt Counting Period Type"); PhysInvtCountMgt.UpdateItemSKUListPhysInvtCount(); end; end; until PhysInvtOrderLine.Next() = 0; IsHandled := false; OnCodeOnBeforeCheckLinesToPost(PhysInvtOrderHeader, LinesToPost, IsHandled); if not IsHandled then if not LinesToPost then Error(DocumentErrorsMgt.GetNothingToPostErrorMsg()); SourceCodeSetup.Get(); SourceCode := SourceCodeSetup."Phys. Invt. Orders"; InventorySetup.Get(); // Insert posted order header InsertPostedHeader(PhysInvtOrderHeader); // Insert posted order lines LineCount := 0; PhysInvtOrderLine.Reset(); PhysInvtOrderLine.SetRange("Document No.", PhysInvtOrderHeader."No."); PhysInvtOrderLine.SetRange("Entry Type", PhysInvtOrderLine."Entry Type"::"Negative Adjmt."); if PhysInvtOrderLine.FindSet() then repeat PostPhysInventoryOrderLine(); until PhysInvtOrderLine.Next() = 0; PhysInvtOrderLine.SetFilter("Entry Type", '<>%1', PhysInvtOrderLine."Entry Type"::"Negative Adjmt."); if PhysInvtOrderLine.FindSet() then repeat PostPhysInventoryOrderLine(); OnCodeOnAferPostPhysInventoryOrderLineNonNegative(PhysInvtOrderHeader, PhysInvtOrderLine, ItemJnlPostLine); until PhysInvtOrderLine.Next() = 0; // Insert posted expected phys. invt. tracking Lines ExpInvtOrderTracking.Reset(); ExpInvtOrderTracking.SetRange("Order No", PhysInvtOrderHeader."No."); if ExpInvtOrderTracking.Find('-') then repeat PstdExpInvtOrderTracking.Init(); PstdExpInvtOrderTracking.TransferFields(ExpInvtOrderTracking); PstdExpInvtOrderTracking."Order No" := PstdPhysInvtOrderHdr."No."; PstdExpInvtOrderTracking.Insert(); until ExpInvtOrderTracking.Next() = 0; // Insert posted recording header and lines InsertPostedRecordings(PhysInvtOrderHeader."No.", PstdPhysInvtOrderHdr."No."); // Insert posted comment Lines PhysInvtCommentLine.Reset(); PhysInvtCommentLine.SetRange("Document Type", PhysInvtCommentLine."Document Type"::Order); PhysInvtCommentLine.SetRange("Order No.", PhysInvtOrderHeader."No."); PhysInvtCommentLine.SetRange("Recording No.", 0); if PhysInvtCommentLine.Find('-') then repeat InsertPostedCommentLine( PhysInvtCommentLine, PhysInvtCommentLine."Document Type"::"Posted Order", PstdPhysInvtOrderHdr."No."); until PhysInvtCommentLine.Next() = 0; PhysInvtCommentLine.DeleteAll(); PhysInvtCommentLine.Reset(); PhysInvtCommentLine.SetRange("Document Type", PhysInvtCommentLine."Document Type"::Recording); PhysInvtCommentLine.SetRange("Order No.", PhysInvtOrderHeader."No."); if PhysInvtCommentLine.Find('-') then repeat InsertPostedCommentLine( PhysInvtCommentLine, PhysInvtCommentLine."Document Type"::"Posted Recording", PstdPhysInvtOrderHdr."No."); until PhysInvtCommentLine.Next() = 0; PhysInvtCommentLine.DeleteAll(); PhysInvtOrderHeader."Last Posting No." := PhysInvtOrderHeader."Posting No."; MakeInventoryAdjustment(); OnCodeOnAfterMakeInventoryAdjustment(PhysInvtOrderHeader); if PreviewMode then GenJnlPostPreview.ThrowError(); FinalizePost(PhysInvtOrderHeader."No."); OnAfterCode(PhysInvtOrderHeader, PstdPhysInvtOrderHdr); end; local procedure CheckOrderLine(PhysInvtOrderHeader: Record "Phys. Invt. Order Header"; PhysInvtOrderLine: Record "Phys. Invt. Order Line"; var Item: Record Item) var ItemVariant: Record "Item Variant"; IsHandled: Boolean; begin PhysInvtOrderLine.CheckLine(); Item.Get(PhysInvtOrderLine."Item No."); IsHandled := false; OnCheckOrderLineOnBeforeTestFieldItemBlocked(Item, IsHandled); if not IsHandled then Item.TestField(Blocked, false); if PhysInvtOrderLine."Variant Code" <> '' then begin ItemVariant.Get(PhysInvtOrderLine."Item No.", PhysInvtOrderLine."Variant Code"); IsHandled := false; OnCheckOrderLineOnBeforeTestFieldItemVariantBlocked(ItemVariant, IsHandled); if not IsHandled then ItemVariant.TestField(Blocked, false); end; IsHandled := false; OnCheckOrderLineOnBeforeGetSamePhysInvtOrderLine(PhysInvtOrderHeader, PhysInvtOrderLine, PhysInvtOrderLine2, ErrorText, IsHandled); if not IsHandled then if PhysInvtOrderHeader.GetSamePhysInvtOrderLine(PhysInvtOrderLine, ErrorText, PhysInvtOrderLine2) > 1 then Error(ErrorText); end; local procedure CheckDim() begin PhysInvtOrderLine."Line No." := 0; CheckDimValuePosting(PhysInvtOrderLine); CheckDimComb(PhysInvtOrderLine); PhysInvtOrderLine.SetRange("Document No.", PhysInvtOrderHeader."No."); if PhysInvtOrderLine.FindSet() then repeat CheckDimComb(PhysInvtOrderLine); CheckDimValuePosting(PhysInvtOrderLine); until PhysInvtOrderLine.Next() = 0; end; local procedure CheckDimComb(PhysInvtOrderLine: Record "Phys. Invt. Order Line") begin if PhysInvtOrderLine."Line No." = 0 then if not DimManagement.CheckDimIDComb(PhysInvtOrderHeader."Dimension Set ID") then Error( HeaderDimCombBlockedErr, PhysInvtOrderHeader."No.", DimManagement.GetDimCombErr()); if PhysInvtOrderLine."Line No." <> 0 then if not DimManagement.CheckDimIDComb(PhysInvtOrderLine."Dimension Set ID") then Error( LineDimCombBlockedErr, PhysInvtOrderHeader."No.", PhysInvtOrderLine."Line No.", DimManagement.GetDimCombErr()); end; local procedure CheckDimValuePosting(PhysInvtOrderLine: Record "Phys. Invt. Order Line") var TableIDArr: array[10] of Integer; NumberArr: array[10] of Code[20]; begin TableIDArr[1] := DATABASE::Item; NumberArr[1] := PhysInvtOrderLine."Item No."; TableIDArr[2] := DATABASE::Location; NumberArr[2] := PhysInvtOrderLine."Location Code"; if not DimManagement.CheckDimValuePosting(TableIDArr, NumberArr, PhysInvtOrderLine."Dimension Set ID") then Error( InvalidDimErr, PhysInvtOrderHeader."No.", PhysInvtOrderLine."Line No.", DimManagement.GetDimValuePostingErr()); end; local procedure PostItemJnlLine(Positive: Boolean; Qty: Decimal) begin ItemJnlLine.Init(); ItemJnlLine."Posting Date" := PstdPhysInvtOrderHdr."Posting Date"; ItemJnlLine."Document Date" := PstdPhysInvtOrderHdr."Posting Date"; ItemJnlLine."Document No." := PstdPhysInvtOrderHdr."No."; if Positive then ItemJnlLine."Entry Type" := ItemJnlLine."Entry Type"::"Positive Adjmt." else ItemJnlLine."Entry Type" := ItemJnlLine."Entry Type"::"Negative Adjmt."; ItemJnlLine."Item No." := PhysInvtOrderLine."Item No."; ItemJnlLine."Variant Code" := PhysInvtOrderLine."Variant Code"; ItemJnlLine.Description := PhysInvtOrderLine.Description; ItemJnlLine."Item Category Code" := PhysInvtOrderLine."Item Category Code"; ItemJnlLine."Location Code" := PhysInvtOrderLine."Location Code"; ItemJnlLine."Bin Code" := PhysInvtOrderLine."Bin Code"; ItemJnlLine."Shortcut Dimension 1 Code" := PhysInvtOrderLine."Shortcut Dimension 1 Code"; ItemJnlLine."Shortcut Dimension 2 Code" := PhysInvtOrderLine."Shortcut Dimension 2 Code"; ItemJnlLine."Dimension Set ID" := PhysInvtOrderLine."Dimension Set ID"; ItemJnlLine.Quantity := Qty; ItemJnlLine."Invoiced Quantity" := ItemJnlLine.Quantity; ItemJnlLine."Quantity (Base)" := ItemJnlLine.Quantity; ItemJnlLine."Invoiced Qty. (Base)" := ItemJnlLine.Quantity; ItemJnlLine."Unit of Measure Code" := PhysInvtOrderLine."Base Unit of Measure Code"; ItemJnlLine."Qty. per Unit of Measure" := 1; ItemJnlLine."Source Code" := SourceCode; ItemJnlLine."Gen. Prod. Posting Group" := PhysInvtOrderLine."Gen. Prod. Posting Group"; ItemJnlLine."Gen. Bus. Posting Group" := PhysInvtOrderLine."Gen. Bus. Posting Group"; ItemJnlLine."Inventory Posting Group" := PhysInvtOrderLine."Inventory Posting Group"; ItemJnlLine."Qty. (Calculated)" := PhysInvtOrderLine."Qty. Expected (Base)"; if Positive then ItemJnlLine."Qty. (Phys. Inventory)" := PhysInvtOrderLine."Qty. Recorded (Base)" + PhysInvtOrderLine."Neg. Qty. (Base)" else ItemJnlLine."Qty. (Phys. Inventory)" := PhysInvtOrderLine."Qty. Recorded (Base)" - PhysInvtOrderLine."Pos. Qty. (Base)"; ItemJnlLine."Last Item Ledger Entry No." := PhysInvtOrderLine."Last Item Ledger Entry No."; ItemJnlLine."Phys. Inventory" := true; ItemJnlLine.Validate("Unit Amount", PhysInvtOrderLine."Unit Amount"); ItemJnlLine.Validate("Unit Cost", PhysInvtOrderLine."Unit Cost"); ItemJnlLine."Phys Invt Counting Period Code" := PhysInvtOrderLine."Phys Invt Counting Period Code"; ItemJnlLine."Phys Invt Counting Period Type" := PhysInvtOrderLine."Phys Invt Counting Period Type"; OnPostItemJnlLineOnBeforeTransferResEntry(ItemJnlLine, PhysInvtOrderLine, Qty, Positive); PhysInvtTrackingMgt.TransferResEntryToItemJnlLine(PhysInvtOrderLine, ItemJnlLine, Qty, Positive); OnBeforeItemJnlPostLine(ItemJnlLine, PhysInvtOrderLine, ItemJnlPostLine, Positive); ItemJnlPostLine.RunWithCheck(ItemJnlLine); end; local procedure InsertPostedHeader(PhysInvtOrderHeader: Record "Phys. Invt. Order Header") var IsHandled: Boolean; begin OnBeforeInsertPostedHeader(PhysInvtOrderHeader); PstdPhysInvtOrderHdr.LockTable(); PstdPhysInvtOrderHdr.Init(); PstdPhysInvtOrderHdr.TransferFields(PhysInvtOrderHeader); OnInsertPostedHeaderOnAfterTransferfields(PhysInvtOrderHeader, PstdPhysInvtOrderHdr); PstdPhysInvtOrderHdr."Pre-Assigned No." := PhysInvtOrderHeader."No."; if PhysInvtOrderHeader."Posting No." <> '' then begin PstdPhysInvtOrderHdr."No." := PhysInvtOrderHeader."Posting No."; if not HideProgressWindow then Window.Update( 1, StrSubstNo( CopyFromToMsg, PhysInvtOrderHeader.TableCaption(), PhysInvtOrderHeader."No.", PstdPhysInvtOrderHdr.TableCaption(), PstdPhysInvtOrderHdr."No.")); end; PstdPhysInvtOrderHdr."Source Code" := SourceCode; PstdPhysInvtOrderHdr."User ID" := CopyStr(UserId(), 1, MaxStrLen(PstdPhysInvtOrderHdr."User ID")); IsHandled := false; OnInsertPostedHeaderOnBeforeInsert(PhysInvtOrderHeader, PstdPhysInvtOrderHdr, IsHandled); if not IsHandled then PstdPhysInvtOrderHdr.Insert(); end; local procedure InsertPostedLine(PstdPhysInvtOrderHdr: Record "Pstd. Phys. Invt. Order Hdr"; PhysInvtOrderLine: Record "Phys. Invt. Order Line") var IsHandled: Boolean; begin IsHandled := false; OnBeforeInsertPostedLine(PstdPhysInvtOrderHdr, PhysInvtOrderLine, PstdPhysInvtOrderLine, IsHandled); if IsHandled then exit; PstdPhysInvtOrderLine.Init(); PstdPhysInvtOrderLine.TransferFields(PhysInvtOrderLine); PstdPhysInvtOrderLine."Document No." := PstdPhysInvtOrderHdr."No."; PstdPhysInvtOrderLine.Insert(); end; local procedure InsertPostedCommentLine(PhysInvtCommentLine: Record "Phys. Invt. Comment Line"; DocType: Option; DocNo: Code[20]) begin PostedPhysInvtCommentLine.Init(); PostedPhysInvtCommentLine.TransferFields(PhysInvtCommentLine); PostedPhysInvtCommentLine."Document Type" := DocType; PostedPhysInvtCommentLine."Order No." := DocNo; PostedPhysInvtCommentLine.Insert(); end; local procedure InsertPostedRecordings(DocNo: Code[20]; PostedDocNo: Code[20]) var PstdPhysInvtRecordHdr: Record "Pstd. Phys. Invt. Record Hdr"; PstdPhysInvtRecordLine: Record "Pstd. Phys. Invt. Record Line"; IsHandled: Boolean; begin PhysInvtRecordHeader.Reset(); PhysInvtRecordHeader.SetRange("Order No.", DocNo); if PhysInvtRecordHeader.Find('-') then repeat PstdPhysInvtRecordHdr.Init(); PstdPhysInvtRecordHdr.TransferFields(PhysInvtRecordHeader); PstdPhysInvtRecordHdr."Order No." := PostedDocNo; IsHandled := false; OnInsertPostedRecordingsOnBeforeInsertHdr(PhysInvtRecordHeader, PstdPhysInvtRecordHdr, IsHandled); if not IsHandled then PstdPhysInvtRecordHdr.Insert(); PhysInvtRecordLine.Reset(); PhysInvtRecordLine.SetRange("Order No.", PhysInvtRecordHeader."Order No."); PhysInvtRecordLine.SetRange("Recording No.", PhysInvtRecordHeader."Recording No."); if PhysInvtRecordLine.Find('-') then repeat PstdPhysInvtRecordLine.Init(); PstdPhysInvtRecordLine.TransferFields(PhysInvtRecordLine); PstdPhysInvtRecordLine."Order No." := PostedDocNo; IsHandled := false; OnInsertPostedRecordingsOnBeforeInsertLine(PstdPhysInvtRecordHdr, PhysInvtRecordLine, PstdPhysInvtRecordLine, IsHandled); if not IsHandled then PstdPhysInvtRecordLine.Insert(); until PhysInvtRecordLine.Next() = 0; PhysInvtRecordLine.DeleteAll(); until PhysInvtRecordHeader.Next() = 0; PhysInvtRecordHeader.DeleteAll(); end; local procedure InsertEntryRelation() var TempTrackingSpecification: Record "Tracking Specification" temporary; ItemEntryRelation: Record "Item Entry Relation"; begin if WhsePosting then begin TempWhseTrackingSpecification.Reset(); TempWhseTrackingSpecification.DeleteAll(); end; TempTrackingSpecification.Reset(); if ItemJnlPostLine.CollectTrackingSpecification(TempTrackingSpecification) then if TempTrackingSpecification.Find('-') then repeat if WhsePosting then begin TempWhseTrackingSpecification.Init(); TempWhseTrackingSpecification := TempTrackingSpecification; TempWhseTrackingSpecification."Source Type" := DATABASE::"Phys. Invt. Order Line"; TempWhseTrackingSpecification."Source Subtype" := 0; TempWhseTrackingSpecification."Source ID" := PhysInvtOrderLine."Document No."; TempWhseTrackingSpecification."Source Ref. No." := PhysInvtOrderLine."Line No."; TempWhseTrackingSpecification.Insert(); end; ItemEntryRelation.Init(); ItemEntryRelation."Item Entry No." := TempTrackingSpecification."Entry No."; ItemEntryRelation.CopyTrackingFromSpec(TempTrackingSpecification); ItemEntryRelation."Source Type" := DATABASE::"Pstd. Phys. Invt. Order Line"; ItemEntryRelation."Source Subtype" := 0; ItemEntryRelation."Source ID" := PstdPhysInvtOrderLine."Document No."; ItemEntryRelation."Source Batch Name" := ''; ItemEntryRelation."Source Prod. Order Line" := 0; ItemEntryRelation."Source Ref. No." := PstdPhysInvtOrderLine."Line No."; ItemEntryRelation."Order No." := PstdPhysInvtOrderLine."Document No."; ItemEntryRelation."Order Line No." := PstdPhysInvtOrderLine."Line No."; OnInsertEntryRelationOnBeforeInsert(ItemEntryRelation, TempTrackingSpecification, PstdPhysInvtOrderLine); ItemEntryRelation.Insert(); until TempTrackingSpecification.Next() = 0; TempTrackingSpecification.DeleteAll(); end; local procedure FinalizePost(DocNo: Code[20]) begin ExpInvtOrderTracking.Reset(); ExpInvtOrderTracking.SetRange("Order No", DocNo); ExpInvtOrderTracking.DeleteAll(); PhysInvtOrderLine.Reset(); PhysInvtOrderLine.SetRange("Document No.", DocNo); PhysInvtOrderLine.DeleteAll(); PhysInvtOrderHeader.Delete(); end; local procedure MakeInventoryAdjustment() var InvtSetup: Record "Inventory Setup"; InvtAdjmtHandler: Codeunit "Inventory Adjustment Handler"; begin InvtSetup.Get(); if InvtSetup.AutomaticCostAdjmtRequired() then InvtAdjmtHandler.MakeInventoryAdjustment(true, InvtSetup."Automatic Cost Posting"); end; local procedure PostWhseJnlLine(ItemJnlLine: Record "Item Journal Line"; OriginalQuantity: Decimal; OriginalQuantityBase: Decimal; Positive: Boolean) var WhseJnlLine: Record "Warehouse Journal Line"; TempWhseJnlLine2: Record "Warehouse Journal Line" temporary; ItemTrackingMgt: Codeunit "Item Tracking Management"; WMSMgt: Codeunit "WMS Management"; WhseJnlRegisterLine: Codeunit "Whse. Jnl.-Register Line"; IsHandled: Boolean; begin IsHandled := false; OnBeforePostWhseJnlLine(ItemJnlLine, PhysInvtOrderLine, PstdPhysInvtOrderHdr, OriginalQuantity, OriginalQuantityBase, Positive, IsHandled); if IsHandled then exit; ItemJnlLine.Quantity := OriginalQuantity; ItemJnlLine."Quantity (Base)" := OriginalQuantityBase; if WMSMgt.CreateWhseJnlLine(ItemJnlLine, 1, WhseJnlLine, false) then begin WhseJnlLine.SetSource( DATABASE::"Phys. Invt. Order Line", 0, PhysInvtOrderLine."Document No.", PhysInvtOrderLine."Line No.", 0); WhseJnlLine."Reference No." := PstdPhysInvtOrderHdr."No."; if Positive then WhseJnlLine."Entry Type" := WhseJnlLine."Entry Type"::"Positive Adjmt." else WhseJnlLine."Entry Type" := WhseJnlLine."Entry Type"::"Negative Adjmt."; ItemTrackingMgt.SplitWhseJnlLine(WhseJnlLine, TempWhseJnlLine2, TempWhseTrackingSpecification, false); if TempWhseJnlLine2.Find('-') then repeat OnPostWhseJnlLineOnBeforeCheckWhseJnlLine(TempWhseJnlLine2, Positive, Location, PhysInvtOrderLine); WMSMgt.CheckWhseJnlLine(TempWhseJnlLine2, 1, 0, false); WhseJnlRegisterLine.Run(TempWhseJnlLine2); Clear(WhseJnlRegisterLine); until TempWhseJnlLine2.Next() = 0; end; end; local procedure PostPhysInventoryOrderLine() var IsHandled: Boolean; begin LineCount := LineCount + 1; if not HideProgressWindow then Window.Update(3, LineCount); InsertPostedLine(PstdPhysInvtOrderHdr, PhysInvtOrderLine); IsHandled := false; OnPostPhysInventoryOrderLineOnAfterInsertPostedLine(PhysInvtOrderLine, IsHandled); if not IsHandled then if not PhysInvtOrderLine.EmptyLine() then begin if (PhysInvtOrderLine."Location Code" = '') or ((PhysInvtOrderLine."Pos. Qty. (Base)" = 0) and (PhysInvtOrderLine."Neg. Qty. (Base)" = 0)) then WhsePosting := false else begin Location.Get(PhysInvtOrderLine."Location Code"); ChecLocationDirectedPutAwayAndPick(); WhsePosting := Location."Bin Mandatory"; end; OnPostPhysInventoryOrderLineOnBeforePostPositiveItemJnlLine(PhysInvtOrderLine, WhsePosting, ItemJnlLine, PstdPhysInvtOrderHdr, PstdPhysInvtOrderLine); if (PhysInvtOrderLine."Pos. Qty. (Base)" <> 0) or (PhysInvtOrderLine."Neg. Qty. (Base)" = 0) then begin OriginalQuantityBase := PhysInvtOrderLine."Pos. Qty. (Base)"; PostItemJnlLine( true,// Positive PhysInvtOrderLine."Pos. Qty. (Base)"); InsertEntryRelation(); if WhsePosting then PostWhseJnlLine( ItemJnlLine, OriginalQuantityBase, OriginalQuantityBase, true); // Positive end; if PhysInvtOrderLine."Neg. Qty. (Base)" <> 0 then begin OriginalQuantityBase := PhysInvtOrderLine."Neg. Qty. (Base)"; PostItemJnlLine( false,// Negative PhysInvtOrderLine."Neg. Qty. (Base)"); InsertEntryRelation(); if WhsePosting then PostWhseJnlLine( ItemJnlLine, OriginalQuantityBase, OriginalQuantityBase, false); // Negative end; end; end; local procedure ChecLocationDirectedPutAwayAndPick() var IsHandled: Boolean; begin IsHandled := false; OnBeforeChecLocationDirectedPutAwayAndPick(PhysInvtOrderLine, IsHandled); if IsHandled then exit; Location.TestField("Directed Put-away and Pick", false); end; local procedure IsDifference() Result: Boolean begin Result := ((PhysInvtOrderLine."Entry Type" = PhysInvtOrderLine."Entry Type"::"Positive Adjmt.") and (PhysInvtOrderLine."Quantity (Base)" <> PhysInvtOrderLine."Pos. Qty. (Base)" - PhysInvtOrderLine."Neg. Qty. (Base)")) or ((PhysInvtOrderLine."Entry Type" = PhysInvtOrderLine."Entry Type"::"Negative Adjmt.") and (-PhysInvtOrderLine."Quantity (Base)" <> PhysInvtOrderLine."Pos. Qty. (Base)" - PhysInvtOrderLine."Neg. Qty. (Base)")); OnAfterIsDifference(PhysInvtOrderLine); end; local procedure ThrowDifferenceError() var ErrorMsg: Text; begin ErrorMsg := StrSubstNo( DifferenceErr, PhysInvtOrderLine.FieldCaption("Pos. Qty. (Base)"), PhysInvtOrderLine.FieldCaption("Neg. Qty. (Base)"), PhysInvtOrderLine.FieldCaption("Quantity (Base)"), PhysInvtOrderLine."Item No.", PhysInvtOrderLine."Variant Code", PhysInvtOrderLine."Location Code", PhysInvtOrderLine."Bin Code"); OnThrowDifferenceError(PhysInvtOrderLine, ErrorMsg); Error(ErrorMsg); end; procedure SetSuppressCommit(NewSuppressCommit: Boolean) begin SuppressCommit := NewSuppressCommit; end; procedure SetHideProgressWindow(NewHideProgressWindow: Boolean) begin HideProgressWindow := NewHideProgressWindow; end; internal procedure SetPreviewMode(NewPreviewMode: Boolean) begin PreviewMode := NewPreviewMode; end; [IntegrationEvent(false, false)] local procedure OnAfterOnRun(var PhysInvtOrderHeader: Record "Phys. Invt. Order Header"; var PstdPhysInvtOrderHdr: Record "Pstd. Phys. Invt. Order Hdr"); begin end; [IntegrationEvent(false, false)] local procedure OnBeforeCode(var PhysInvtOrderHeader: Record "Phys. Invt. Order Header"; var HideProgressWindow: Boolean; var SuppressCommit: Boolean); begin end; [IntegrationEvent(false, false)] local procedure OnBeforeItemJnlPostLine(var ItemJournalLine: Record "Item Journal Line"; PhysInvtOrderLine: Record "Phys. Invt. Order Line"; var ItemJnlPostLine: Codeunit "Item Jnl.-Post Line"; Positive: Boolean); begin end; [IntegrationEvent(false, false)] local procedure OnPostItemJnlLineOnBeforeTransferResEntry(var ItemJournalLine: Record "Item Journal Line"; PhysInvtOrderLine: Record "Phys. Invt. Order Line"; Qty: Decimal; Positive: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeChecLocationDirectedPutAwayAndPick(PhysInvtOrderLine: Record "Phys. Invt. Order Line"; var IsHandled: Boolean); begin end; [IntegrationEvent(false, false)] local procedure OnCheckOrderLineOnBeforeGetSamePhysInvtOrderLine(PhysInvtOrderHeader: Record "Phys. Invt. Order Header"; PhysInvtOrderLine: Record "Phys. Invt. Order Line"; var PhysInvtOrderLine2: Record "Phys. Invt. Order Line"; var ErrorText: Text[250]; var IsHandled: Boolean); begin end; [IntegrationEvent(false, false)] local procedure OnInsertEntryRelationOnBeforeInsert(var ItemEntryRelation: Record "Item Entry Relation"; TrackingSpecification: Record "Tracking Specification"; PstdPhysInvtOrderLine: Record "Pstd. Phys. Invt. Order Line") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeInsertPostedHeader(var PhysInvtOrderHeader: Record "Phys. Invt. Order Header"); begin end; [IntegrationEvent(false, false)] local procedure OnBeforeInsertPostedLine(PstdPhysInvtOrderHdr: Record "Pstd. Phys. Invt. Order Hdr"; PhysInvtOrderLine: Record "Phys. Invt. Order Line"; var PstdPhysInvtOrderLine: Record "Pstd. Phys. Invt. Order Line"; var IsHandled: Boolean); begin end; [IntegrationEvent(false, false)] local procedure OnCodeOnAfterSetFilters(var PhysInvtOrderLine: Record "Phys. Invt. Order Line") begin end; [IntegrationEvent(false, false)] local procedure OnInsertPostedHeaderOnAfterTransferfields(PhysInvtOrderHeader: Record "Phys. Invt. Order Header"; var PstdPhysInvtOrderHdr: Record "Pstd. Phys. Invt. Order Hdr"); begin end; [IntegrationEvent(false, false)] local procedure OnInsertPostedHeaderOnBeforeInsert(PhysInvtOrderHeader: Record "Phys. Invt. Order Header"; var PstdPhysInvtOrderHdr: Record "Pstd. Phys. Invt. Order Hdr"; var IsHandled: Boolean); begin end; [IntegrationEvent(false, false)] local procedure OnInsertPostedRecordingsOnBeforeInsertHdr(PhysInvtRecordHeader: Record "Phys. Invt. Record Header"; var PstdPhysInvtRecordHdr: Record "Pstd. Phys. Invt. Record Hdr"; var IsHandled: Boolean); begin end; [IntegrationEvent(false, false)] local procedure OnInsertPostedRecordingsOnBeforeInsertLine(PstdPhysInvtRecordHdr: Record "Pstd. Phys. Invt. Record Hdr"; PhysInvtRecordLine: Record "Phys. Invt. Record Line"; var PstdPhysInvtRecordLine: Record "Pstd. Phys. Invt. Record Line"; var IsHandled: Boolean); begin end; [IntegrationEvent(false, false)] local procedure OnPostWhseJnlLineOnBeforeCheckWhseJnlLine(var TempWhseJnlLine2: Record "Warehouse Journal Line" temporary; Positive: Boolean; Location: Record Location; PhysInvtOrderLine: Record "Phys. Invt. Order Line") begin end; [IntegrationEvent(false, false)] local procedure OnPostPhysInventoryOrderLineOnAfterInsertPostedLine(PhysInvtOrderLine: Record "Phys. Invt. Order Line"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnPostPhysInventoryOrderLineOnBeforePostPositiveItemJnlLine(var PhysInvtOrderLine: Record "Phys. Invt. Order Line"; WhsePosting: Boolean; var ItemJnlLine: Record "Item Journal Line"; var PstdPhysInvtOrderHdr: Record "Pstd. Phys. Invt. Order Hdr"; var PstdPhysInvtOrderLine: Record "Pstd. Phys. Invt. Order Line") begin end; [IntegrationEvent(false, false)] local procedure OnBeforePostWhseJnlLine(var ItemJnlLine: Record "Item Journal Line"; var PhysInvtOrderLine: Record "Phys. Invt. Order Line"; var PstdPhysInvtOrderHdr: Record "Pstd. Phys. Invt. Order Hdr"; var OriginalQuantity: Decimal; var OriginalQuantityBase: Decimal; var Positive: Boolean; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnAfterIsDifference(PhysInvtOrderLine: Record "Phys. Invt. Order Line") begin end; [IntegrationEvent(false, false)] local procedure OnThrowDifferenceError(PhysInvtOrderLine: Record "Phys. Invt. Order Line"; var ErrorMsg: Text) begin end; [IntegrationEvent(false, false)] local procedure OnCheckOrderLineOnBeforeTestFieldItemBlocked(Item: Record "Item"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnCheckOrderLineOnBeforeTestFieldItemVariantBlocked(ItemVariant: Record "Item Variant"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnCodeOnAferPostPhysInventoryOrderLineNonNegative(var PhysInvtOrderHeader: Record "Phys. Invt. Order Header"; var PhysInvtOrderLine: Record "Phys. Invt. Order Line"; var ItemJnlPostLine: Codeunit "Item Jnl.-Post Line"); begin end; [IntegrationEvent(false, false)] local procedure OnAfterCode(var PhysInvtOrderHeader: Record "Phys. Invt. Order Header"; var PstdPhysInvtOrderHdr: Record "Pstd. Phys. Invt. Order Hdr"); begin end; [IntegrationEvent(false, false)] local procedure OnCodeOnBeforeCheckLinesToPost(var PhysInvtOrderHeader: Record "Phys. Invt. Order Header"; var LinesToPost: Boolean; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnCodeOnAfterMakeInventoryAdjustment(var PhysInvtOrderHeader: Record "Phys. Invt. Order Header") begin end;}