Table 210 Job Journal Line, source in 29
Source29
src/Layers/W1/BaseApp/Projects/Project/Journal/JobJournalLine.Table.al2882 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.Projects.Project.Journal;
using Microsoft.Finance.Currency;
using Microsoft.Finance.Dimension;
using Microsoft.Finance.GeneralLedger.Account;
using Microsoft.Finance.GeneralLedger.Ledger;
using Microsoft.Finance.GeneralLedger.Setup;
using Microsoft.Foundation.Address;
using Microsoft.Foundation.AuditCodes;
using Microsoft.Foundation.NoSeries;
using Microsoft.Foundation.Shipping;
using Microsoft.Foundation.UOM;
using Microsoft.Inventory.Availability;
using Microsoft.Inventory.BOM;
using Microsoft.Inventory.Intrastat;
using Microsoft.Inventory.Item;
using Microsoft.Inventory.Journal;
using Microsoft.Inventory.Ledger;
using Microsoft.Inventory.Location;
using Microsoft.Inventory.Tracking;
using Microsoft.Pricing.Calculation;
using Microsoft.Pricing.PriceList;
using Microsoft.Projects.Project.Job;
using Microsoft.Projects.Project.Ledger;
using Microsoft.Projects.Project.Planning;
using Microsoft.Projects.Project.Setup;
using Microsoft.Projects.Resources.Ledger;
using Microsoft.Projects.Resources.Pricing;
using Microsoft.Projects.Resources.Resource;
using Microsoft.Projects.TimeSheet;
using Microsoft.Sales.Customer;
using Microsoft.Sales.Pricing;
using Microsoft.Utilities;
using Microsoft.Warehouse.Journal;
using Microsoft.Warehouse.Request;
using System.Utilities;
table 210 "Job Journal Line"
{
Caption = 'Project Journal Line';
DataClassification = CustomerContent;
fields
{
field(1; "Journal Template Name"; Code[10])
{
Caption = 'Journal Template Name';
TableRelation = "Job Journal Template";
}
field(2; "Line No."; Integer)
{
Caption = 'Line No.';
}
field(3; "Job No."; Code[20])
{
Caption = 'Project No.';
ToolTip = 'Specifies the number of the project.';
TableRelation = Job;
trigger OnValidate()
var
JobSetup: Record "Jobs Setup";
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeValidateJobNo(Rec, Cust, DimMgt, IsHandled);
if IsHandled then
exit;
if "Job No." = '' then begin
Validate("Currency Code", '');
Validate("Job Task No.", '');
CreateDimFromDefaultDim(Rec.FieldNo("Job No."));
exit;
end;
GetJob();
Job.TestBlocked();
IsHandled := false;
OnValidateJobNoOnBeforeCheckJob(Rec, xRec, Cust, IsHandled);
if not IsHandled then begin
Job.TestField("Bill-to Customer No.");
Cust.Get(Job."Bill-to Customer No.");
Validate("Job Task No.", '');
end;
"Customer Price Group" := Job."Customer Price Group";
Validate("Currency Code", Job."Currency Code");
CreateDimFromDefaultDim(Rec.FieldNo("Job No."));
SetCountryRegionCodeFromJob(Job);
"Price Calculation Method" := Job.GetPriceCalculationMethod();
"Cost Calculation Method" := Job.GetCostCalculationMethod();
JobSetup.Get();
if JobSetup."Document No. Is Job No." and ("Document No." = '') then
Validate("Document No.", Rec."Job No.");
end;
}
field(4; "Posting Date"; Date)
{
Caption = 'Posting Date';
ToolTip = 'Specifies the posting date you want to assign to each journal line. For more information, see Entering Dates and Times.';
trigger OnValidate()
var
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeValidatePostingDate(Rec, xRec, CurrFieldNo, IsHandled);
if IsHandled then
exit;
CheckPostingDateNotEmpty();
Validate("Document Date", "Posting Date");
if "Currency Code" <> '' then begin
UpdateCurrencyFactor();
UpdateAllAmounts();
end
end;
}
field(5; "Document No."; Code[20])
{
Caption = 'Document No.';
ToolTip = 'Specifies a document number for the journal line.';
}
field(6; Type; Enum "Job Journal Line Type")
{
Caption = 'Type';
ToolTip = 'Specifies an account type for project usage to be posted in the project journal. You can choose from the following options:';
trigger OnValidate()
begin
Validate("No.", '');
if Type = Type::Item then
CheckDirectedPutawayandPickIsFalse(Rec.FieldNo(Type));
end;
}
field(8; "No."; Code[20])
{
Caption = 'No.';
ToolTip = 'Specifies the number of the involved entry or record, according to the specified number series.';
TableRelation = if (Type = const(Resource)) Resource
else
if (Type = const(Item)) Item where(Blocked = const(false))
else
if (Type = const("G/L Account")) "G/L Account";
trigger OnValidate()
var
IsHandled: Boolean;
begin
if ("No." = '') or ("No." <> xRec."No.") then begin
Description := '';
"Unit of Measure Code" := '';
"Qty. per Unit of Measure" := 1;
"Variant Code" := '';
"Work Type Code" := '';
DeleteAmounts();
"Cost Factor" := 0;
"Applies-to Entry" := 0;
"Applies-from Entry" := 0;
CheckedAvailability := false;
"Job Planning Line No." := 0;
if Type = Type::Item then begin
"Bin Code" := '';
if ("No." <> '') and ("Location Code" <> '') then begin
InitLocation();
GetLocation("Location Code");
GetItem();
if IsDefaultBin() and Item.IsInventoriableType() and ("Bin Code" = '') then
WMSManagement.GetDefaultBin("No.", "Variant Code", "Location Code", "Bin Code");
end;
end;
if "No." = '' then begin
UpdateDimensions();
exit;
end;
end;
case Type of
Type::Resource:
CopyFromResource();
Type::Item:
CopyFromItem();
Type::"G/L Account":
CopyFromGLAccount();
end;
IsHandled := false;
OnValidateNoOnBeforeValidateQuantity(Rec, IsHandled);
if not IsHandled then
Validate(Quantity);
UpdateDimensions();
end;
}
field(9; Description; Text[100])
{
Caption = 'Description';
ToolTip = 'Specifies the name of the resource, item, or general ledger account to which this entry applies. You can change the description.';
}
field(10; Quantity; Decimal)
{
AutoFormatType = 0;
Caption = 'Quantity';
ToolTip = 'Specifies the number of units of the project journal''s No. field, that is, either the resource, item, or G/L account number, that applies. If you later change the value in the No. field, the quantity does not change on the journal line.';
DecimalPlaces = 0 : 5;
trigger OnValidate()
var
WhseValidateSourceLine: Codeunit "Whse. Validate Source Line";
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeValidateQuantity(Rec, xRec, CurrFieldNo, IsHandled);
if IsHandled then
exit;
Quantity := UOMMgt.RoundAndValidateQty(Quantity, "Qty. Rounding Precision", FieldCaption(Quantity));
"Quantity (Base)" := CalcBaseQty(Quantity, FieldCaption(Quantity), FieldCaption("Quantity (Base)"));
UpdateAllAmounts();
WhseValidateSourceLine.JobJnlLineVerifyChangeForWhsePick(Rec, xRec);
if "Job Planning Line No." <> 0 then
Validate("Job Planning Line No.");
CheckItemAvailable();
if Type = Type::Item then
if Item."Item Tracking Code" <> '' then
ReserveJobJnlLine.VerifyQuantity(Rec, xRec);
end;
}
field(12; "Direct Unit Cost (LCY)"; Decimal)
{
AutoFormatType = 2;
AutoFormatExpression = '';
Caption = 'Direct Unit Cost (LCY)';
MinValue = 0;
}
field(13; "Unit Cost (LCY)"; Decimal)
{
AutoFormatType = 2;
AutoFormatExpression = '';
Caption = 'Unit Cost (LCY)';
Editable = false;
MinValue = 0;
trigger OnValidate()
begin
if (Type = Type::Item) and
Item.Get("No.") and
(Item."Costing Method" = Item."Costing Method"::Standard)
then
UpdateAllAmounts()
else begin
InitRoundingPrecisions();
"Unit Cost" := ConvertAmountToFCY("Unit Cost (LCY)", UnitAmountRoundingPrecisionFCY);
OnValidateUnitCostLCYOnAfterConvertAmountToFCY(Rec);
UpdateAllAmounts();
end;
end;
}
field(14; "Total Cost (LCY)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Total Cost (LCY)';
Editable = false;
}
field(15; "Unit Price (LCY)"; Decimal)
{
AutoFormatType = 2;
AutoFormatExpression = '';
Caption = 'Unit Price (LCY)';
Editable = false;
trigger OnValidate()
begin
InitRoundingPrecisions();
"Unit Price" := ConvertAmountToFCY("Unit Price (LCY)", UnitAmountRoundingPrecisionFCY);
UpdateAllAmounts();
end;
}
field(16; "Total Price (LCY)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Total Price (LCY)';
Editable = false;
}
field(17; "Resource Group No."; Code[20])
{
Caption = 'Resource Group No.';
Editable = false;
TableRelation = "Resource Group";
trigger OnValidate()
begin
CreateDimFromDefaultDim(Rec.FieldNo("Resource Group No."));
end;
}
field(18; "Unit of Measure Code"; Code[10])
{
Caption = 'Unit of Measure Code';
ToolTip = 'Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted.';
TableRelation = if (Type = const(Item)) "Item Unit of Measure".Code where("Item No." = field("No."))
else
if (Type = const(Resource)) "Resource Unit of Measure".Code where("Resource No." = field("No."))
else
"Unit of Measure";
trigger OnValidate()
var
Resource: Record Resource;
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeValidateUnitofMeasureCode(Rec, IsHandled);
if IsHandled then
exit;
GetGLSetup();
case Type of
Type::Item:
begin
Item.Get("No.");
"Qty. per Unit of Measure" := UOMMgt.GetQtyPerUnitOfMeasure(Item, "Unit of Measure Code");
"Qty. Rounding Precision" := UOMMgt.GetQtyRoundingPrecision(Item, "Unit of Measure Code");
"Qty. Rounding Precision (Base)" := UOMMgt.GetQtyRoundingPrecision(Item, Item."Base Unit of Measure");
OnAfterAssignItemUoM(Rec, Item);
end;
Type::Resource:
begin
if CurrFieldNo <> FieldNo("Work Type Code") then
if "Work Type Code" <> '' then begin
WorkType.Get("Work Type Code");
if WorkType."Unit of Measure Code" <> '' then
TestUnitOfMeasureCode(WorkType);
end else
TestField("Work Type Code", '');
if "Unit of Measure Code" = '' then begin
Resource.Get("No.");
"Unit of Measure Code" := Resource."Base Unit of Measure";
end;
ResUnitofMeasure.Get("No.", "Unit of Measure Code");
"Qty. per Unit of Measure" := ResUnitofMeasure."Qty. per Unit of Measure";
"Quantity (Base)" := Quantity * "Qty. per Unit of Measure";
OnAfterAssignResourceUoM(Rec, Res);
end;
Type::"G/L Account":
begin
"Qty. per Unit of Measure" := 1;
OnAfterAssignGLAccountUoM(Rec);
end;
end;
IsHandled := false;
OnValidateUnitOfMeasureCodeOnBeforeOnBeforeValidateQuantity(Rec, IsHandled);
if not IsHandled then
Validate(Quantity);
end;
}
field(19; "Qty. Rounding Precision"; Decimal)
{
AutoFormatType = 0;
Caption = 'Qty. Rounding Precision';
InitValue = 0;
DecimalPlaces = 0 : 5;
MinValue = 0;
MaxValue = 1;
Editable = false;
}
field(20; "Qty. Rounding Precision (Base)"; Decimal)
{
AutoFormatType = 0;
Caption = 'Qty. Rounding Precision (Base)';
InitValue = 0;
DecimalPlaces = 0 : 5;
MinValue = 0;
MaxValue = 1;
Editable = false;
}
field(21; "Location Code"; Code[10])
{
Caption = 'Location Code';
ToolTip = 'Specifies a location code for an item.';
TableRelation = Location where("Use As In-Transit" = const(false));
trigger OnValidate()
begin
"Bin Code" := '';
OnValidateLocationCodeOnBeforeGetLocation(Rec);
CheckDirectedPutawayandPickIsFalse(Rec.FieldNo("Location Code"));
Validate(Quantity);
if (Type = Type::Item) and ("Location Code" <> xRec."Location Code") then
if ("Location Code" <> '') and ("No." <> '') then begin
GetItem();
if IsDefaultBin() and Item.IsInventoriableType() then
if not FindBin() then
WMSManagement.GetDefaultBin("No.", "Variant Code", "Location Code", "Bin Code");
end;
CreateDimFromDefaultDim(Rec.FieldNo("Location Code"));
UpdateDimensions();
end;
}
field(22; Chargeable; Boolean)
{
Caption = 'Chargeable';
InitValue = true;
trigger OnValidate()
begin
ValidateChargeable();
end;
}
field(30; "Posting Group"; Code[20])
{
Caption = 'Posting Group';
Editable = false;
TableRelation = if (Type = const(Item)) "Inventory Posting Group";
}
field(31; "Shortcut Dimension 1 Code"; Code[20])
{
CaptionClass = '1,2,1';
Caption = 'Shortcut Dimension 1 Code';
ToolTip = 'Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window.';
TableRelation = "Dimension Value".Code where("Global Dimension No." = const(1),
Blocked = const(false));
trigger OnValidate()
begin
Rec.ValidateShortcutDimCode(1, "Shortcut Dimension 1 Code");
end;
}
field(32; "Shortcut Dimension 2 Code"; Code[20])
{
CaptionClass = '1,2,2';
Caption = 'Shortcut Dimension 2 Code';
ToolTip = 'Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window.';
TableRelation = "Dimension Value".Code where("Global Dimension No." = const(2),
Blocked = const(false));
trigger OnValidate()
begin
Rec.ValidateShortcutDimCode(2, "Shortcut Dimension 2 Code");
end;
}
field(33; "Work Type Code"; Code[10])
{
Caption = 'Work Type Code';
ToolTip = 'Specifies which work type the resource applies to. Prices are updated based on this entry.';
TableRelation = "Work Type";
trigger OnValidate()
var
IsHandled: Boolean;
IsLineDiscountHandled: Boolean;
begin
IsHandled := false;
OnBeforeValidateWorkTypeCode(Rec, xRec, IsLineDiscountHandled, IsHandled);
if IsHandled then
exit;
TestField(Type, Type::Resource);
if ("Work Type Code" = '') and (xRec."Work Type Code" <> '') then begin
Res.Get("No.");
"Unit of Measure Code" := Res."Base Unit of Measure";
Validate("Unit of Measure Code");
end;
if WorkType.Get("Work Type Code") then
if WorkType."Unit of Measure Code" <> '' then begin
"Unit of Measure Code" := WorkType."Unit of Measure Code";
if ResUnitofMeasure.Get("No.", "Unit of Measure Code") then
"Qty. per Unit of Measure" := ResUnitofMeasure."Qty. per Unit of Measure";
end else begin
Res.Get("No.");
"Unit of Measure Code" := Res."Base Unit of Measure";
Validate("Unit of Measure Code");
end;
OnBeforeValidateWorkTypeCodeQty(Rec, xRec, Res, WorkType);
Validate(Quantity);
if not IsLineDiscountHandled then
Validate("Line Discount %", 0);
end;
}
field(34; "Customer Price Group"; Code[10])
{
Caption = 'Customer Price Group';
TableRelation = "Customer Price Group";
trigger OnValidate()
begin
if (Type = Type::Item) and ("No." <> '') then
UpdateAllAmounts();
end;
}
field(37; "Applies-to Entry"; Integer)
{
AccessByPermission = TableData Item = R;
Caption = 'Applies-to Entry';
ToolTip = 'Specifies if the quantity on the journal line must be applied to an already-posted entry. In that case, enter the entry number that the quantity will be applied to.';
trigger OnLookup()
begin
SelectItemEntry(FieldNo("Applies-to Entry"));
end;
trigger OnValidate()
var
ItemLedgEntry: Record "Item Ledger Entry";
begin
InitRoundingPrecisions();
TestField(Type, Type::Item);
if "Applies-to Entry" <> 0 then begin
ItemLedgEntry.Get("Applies-to Entry");
TestField(Quantity);
if Quantity < 0 then
FieldError(Quantity, Text002);
ItemLedgEntry.TestField(Open, true);
ItemLedgEntry.TestField(Positive, true);
"Location Code" := ItemLedgEntry."Location Code";
"Variant Code" := ItemLedgEntry."Variant Code";
GetItem();
if Item."Costing Method" <> Item."Costing Method"::Standard then begin
"Unit Cost" := ConvertAmountToFCY(CalcUnitCost(ItemLedgEntry), UnitAmountRoundingPrecisionFCY);
UpdateAllAmounts();
end;
end;
end;
}
field(40; "Shpt. Method Code"; Code[10])
{
Caption = 'Shpt. Method Code';
TableRelation = "Shipment Method";
}
field(61; "Entry Type"; Enum "Job Journal Line Entry Type")
{
Caption = 'Entry Type';
Editable = false;
}
field(62; "Source Code"; Code[10])
{
Caption = 'Source Code';
Editable = false;
TableRelation = "Source Code";
}
field(73; "Journal Batch Name"; Code[10])
{
Caption = 'Journal Batch Name';
TableRelation = "Job Journal Batch".Name where("Journal Template Name" = field("Journal Template Name"));
}
field(74; "Reason Code"; Code[10])
{
Caption = 'Reason Code';
TableRelation = "Reason Code";
}
field(75; "Recurring Method"; Option)
{
BlankZero = true;
Caption = 'Recurring Method';
ToolTip = 'Specifies the recurring method. The recurring method determines what happens to the quantity on the journal line after posting. For example, if you use the same quantity each time you post the line, you can reuse the same quantity after posting.';
OptionCaption = ',Fixed,Variable';
OptionMembers = ,"Fixed",Variable;
}
field(76; "Expiration Date"; Date)
{
Caption = 'Expiration Date';
ToolTip = 'Specifies the last date on which the recurring journal will be posted if you have indicated in the Recurring field of the project journal template that the journal should be a recurring journal.';
}
field(77; "Recurring Frequency"; DateFormula)
{
Caption = 'Recurring Frequency';
ToolTip = 'Specifies a recurring frequency if you have indicated in the Recurring field in the project journal template that the journal is a recurring journal.';
}
field(79; "Gen. Bus. Posting Group"; Code[20])
{
Caption = 'Gen. Bus. Posting Group';
ToolTip = 'Specifies the vendor''s or customer''s trade type to link transactions made for this business partner with the appropriate general ledger account according to the general posting setup.';
TableRelation = "Gen. Business Posting Group";
}
field(80; "Gen. Prod. Posting Group"; Code[20])
{
Caption = 'Gen. Prod. Posting Group';
ToolTip = 'Specifies the item''s product type to link transactions made for this item with the appropriate general ledger account according to the general posting setup.';
TableRelation = "Gen. Product Posting Group";
}
field(81; "Transaction Type"; Code[10])
{
Caption = 'Transaction Type';
ToolTip = 'Specifies the type of transaction that the document represents, for the purpose of reporting to INTRASTAT.';
TableRelation = "Transaction Type";
}
field(82; "Transport Method"; Code[10])
{
Caption = 'Transport Method';
ToolTip = 'Specifies the transport method, for the purpose of reporting to INTRASTAT.';
TableRelation = "Transport Method";
}
field(83; "Country/Region Code"; Code[10])
{
Caption = 'Country/Region Code';
ToolTip = 'Specifies the country/region of the address.';
TableRelation = "Country/Region";
}
field(86; "Entry/Exit Point"; Code[10])
{
Caption = 'Entry/Exit Point';
TableRelation = "Entry/Exit Point";
}
field(87; "Document Date"; Date)
{
Caption = 'Document Date';
ToolTip = 'Specifies the date when the related document was created.';
}
field(88; "External Document No."; Code[35])
{
Caption = 'External Document No.';
ToolTip = 'Specifies a document number that refers to the customer''s or vendor''s numbering system.';
}
field(89; "Area"; Code[10])
{
Caption = 'Area';
TableRelation = Area;
}
field(90; "Transaction Specification"; Code[10])
{
Caption = 'Transaction Specification';
TableRelation = "Transaction Specification";
}
field(91; "Serial No."; Code[50])
{
Caption = 'Serial No.';
trigger OnLookup()
begin
TestField(Type, Type::Item);
SelectItemEntry(FieldNo("Serial No."));
end;
}
field(92; "Posting No. Series"; Code[20])
{
Caption = 'Posting No. Series';
TableRelation = "No. Series";
}
field(93; "Source Currency Code"; Code[10])
{
Caption = 'Source Currency Code';
Editable = false;
TableRelation = Currency;
}
field(94; "Source Currency Total Cost"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = "Currency Code";
Caption = 'Source Currency Total Cost';
Editable = false;
}
field(95; "Source Currency Total Price"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = "Currency Code";
Caption = 'Source Currency Total Price';
Editable = false;
}
field(96; "Source Currency Line Amount"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = "Currency Code";
Caption = 'Source Currency Line Amount';
Editable = false;
}
field(480; "Dimension Set ID"; Integer)
{
Caption = 'Dimension Set ID';
Editable = false;
TableRelation = "Dimension Set Entry";
trigger OnLookup()
begin
Rec.ShowDimensions();
end;
trigger OnValidate()
begin
DimMgt.UpdateGlobalDimFromDimSetID("Dimension Set ID", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code");
end;
}
field(902; "Assemble to Order"; Boolean)
{
AccessByPermission = TableData "BOM Component" = R;
Caption = 'Assemble to Order';
Editable = false;
DataClassification = CustomerContent;
}
field(950; "Time Sheet No."; Code[20])
{
Caption = 'Time Sheet No.';
ToolTip = 'Specifies the number of a time sheet. A number is assigned to each time sheet when it is created. You cannot edit the number.';
TableRelation = "Time Sheet Header";
}
field(951; "Time Sheet Line No."; Integer)
{
Caption = 'Time Sheet Line No.';
ToolTip = 'Specifies the line number for a time sheet.';
TableRelation = "Time Sheet Line"."Line No." where("Time Sheet No." = field("Time Sheet No."));
}
field(952; "Time Sheet Date"; Date)
{
Caption = 'Time Sheet Date';
ToolTip = 'Specifies the date that a time sheet is created.';
TableRelation = "Time Sheet Detail".Date where("Time Sheet No." = field("Time Sheet No."),
"Time Sheet Line No." = field("Time Sheet Line No."));
}
field(1000; "Job Task No."; Code[20])
{
Caption = 'Project Task No.';
ToolTip = 'Specifies the number of the related project task.';
TableRelation = "Job Task"."Job Task No." where("Job No." = field("Job No."));
trigger OnValidate()
var
JobTask: Record "Job Task";
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeValidateJobTaskNo(Rec, xRec, IsHandled);
if IsHandled then
exit;
if ("Job Task No." = '') or (("Job Task No." <> xRec."Job Task No.") and (xRec."Job Task No." <> '')) then begin
Validate("No.", '');
exit;
end;
TestField("Job No.");
JobTask.Get("Job No.", "Job Task No.");
JobTask.TestField("Job Task Type", JobTask."Job Task Type"::Posting);
OnValidateJobTaskNoOnAfterTestJobTaskType(Rec, xRec, JobTask);
UpdateDimensions();
end;
}
field(1001; "Total Cost"; Decimal)
{
AutoFormatExpression = Rec."Currency Code";
AutoFormatType = 1;
Caption = 'Total Cost';
ToolTip = 'Specifies the total cost for the journal line. The total cost is calculated based on the project currency, which comes from the Currency Code field on the Project card.';
Editable = false;
}
field(1002; "Unit Price"; Decimal)
{
AutoFormatExpression = Rec."Currency Code";
AutoFormatType = 2;
Caption = 'Unit Price';
ToolTip = 'Specifies the price of one unit of the item or resource. You can enter a price manually or have it entered according to the Price/Profit Calculation field on the related card.';
MinValue = 0;
trigger OnValidate()
begin
UpdateAllAmounts();
end;
}
field(1003; "Line Type"; Enum "Job Line Type")
{
Caption = 'Line Type';
ToolTip = 'Specifies the type of planning line to create when a project ledger entry is posted. If the field is empty, no planning lines are created.';
trigger OnValidate()
begin
if "Job Planning Line No." <> 0 then
Error(Text006, FieldCaption("Line Type"), FieldCaption("Job Planning Line No."));
end;
}
field(1004; "Applies-from Entry"; Integer)
{
Caption = 'Applies-from Entry';
ToolTip = 'Specifies the number of the item ledger entry that the journal line costs have been applied from. This should be done when you reverse the usage of an item in a project and you want to return the item to inventory at the same cost as before it was used in the project.';
MinValue = 0;
trigger OnLookup()
begin
SelectItemEntry(FieldNo("Applies-from Entry"));
end;
trigger OnValidate()
var
ItemLedgEntry: Record "Item Ledger Entry";
begin
InitRoundingPrecisions();
TestField(Type, Type::Item);
if "Applies-from Entry" <> 0 then begin
TestField(Quantity);
if Quantity > 0 then
FieldError(Quantity, Text003);
ItemLedgEntry.Get("Applies-from Entry");
ItemLedgEntry.TestField(Positive, false);
if Item."Costing Method" <> Item."Costing Method"::Standard then begin
"Unit Cost" := ConvertAmountToFCY(CalcUnitCostFrom(ItemLedgEntry), UnitAmountRoundingPrecisionFCY);
UpdateAllAmounts();
end;
end;
end;
}
field(1005; "Job Posting Only"; Boolean)
{
Caption = 'Project Posting Only';
}
field(1006; "Line Discount %"; Decimal)
{
AutoFormatType = 0;
Caption = 'Line Discount %';
ToolTip = 'Specifies the discount percentage that is granted for the item on the line.';
DecimalPlaces = 0 : 5;
MaxValue = 100;
MinValue = 0;
trigger OnValidate()
begin
UpdateAllAmounts();
end;
}
field(1007; "Line Discount Amount"; Decimal)
{
AutoFormatExpression = Rec."Currency Code";
AutoFormatType = 1;
Caption = 'Line Discount Amount';
ToolTip = 'Specifies the discount amount that is granted for the item on the line.';
trigger OnValidate()
begin
UpdateAllAmounts();
end;
}
field(1008; "Currency Code"; Code[10])
{
Caption = 'Currency Code';
ToolTip = 'Specifies the project''s currency code that listed in the Currency Code field in the Project Card. You can only create a Project Journal using this currency code.';
Editable = false;
TableRelation = Currency;
trigger OnValidate()
begin
UpdateCurrencyFactor();
end;
}
field(1009; "Line Amount"; Decimal)
{
AutoFormatExpression = Rec."Currency Code";
AutoFormatType = 1;
Caption = 'Line Amount';
ToolTip = 'Specifies the amount that will be posted to the project ledger.';
trigger OnValidate()
begin
UpdateAllAmounts();
end;
}
field(1010; "Currency Factor"; Decimal)
{
AutoFormatType = 0;
Caption = 'Currency Factor';
DecimalPlaces = 0 : 15;
Editable = false;
MinValue = 0;
trigger OnValidate()
begin
if ("Currency Code" = '') and ("Currency Factor" <> 0) then
FieldError("Currency Factor", StrSubstNo(Text001, FieldCaption("Currency Code")));
UpdateAllAmounts();
end;
}
field(1011; "Unit Cost"; Decimal)
{
AutoFormatExpression = Rec."Currency Code";
AutoFormatType = 2;
Caption = 'Unit Cost';
ToolTip = 'Specifies the unit cost for the selected type and number on the journal line. The unit cost is in the project currency, derived from the Currency Code field on the project card.';
trigger OnValidate()
begin
UpdateAllAmounts();
end;
}
field(1012; "Line Amount (LCY)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Line Amount (LCY)';
Editable = false;
trigger OnValidate()
begin
InitRoundingPrecisions();
"Line Amount" := ConvertAmountToFCY("Line Amount (LCY)", AmountRoundingPrecisionFCY);
UpdateAllAmounts();
end;
}
field(1013; "Line Discount Amount (LCY)"; Decimal)
{
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Line Discount Amount (LCY)';
Editable = false;
trigger OnValidate()
begin
InitRoundingPrecisions();
"Line Discount Amount" := ConvertAmountToFCY("Line Discount Amount (LCY)", AmountRoundingPrecisionFCY);
UpdateAllAmounts();
end;
}
field(1014; "Total Price"; Decimal)
{
AutoFormatExpression = Rec."Currency Code";
AutoFormatType = 1;
Caption = 'Total Price';
ToolTip = 'Specifies the total price in the project currency on the journal line.';
Editable = false;
}
field(1015; "Cost Factor"; Decimal)
{
AutoFormatType = 0;
Caption = 'Cost Factor';
Editable = false;
}
field(1016; "Description 2"; Text[50])
{
Caption = 'Description 2';
ToolTip = 'Specifies information in addition to the description.';
}
field(1017; "Ledger Entry Type"; Enum "Job Ledger Entry Type")
{
Caption = 'Ledger Entry Type';
}
field(1018; "Ledger Entry No."; Integer)
{
BlankZero = true;
Caption = 'Ledger Entry No.';
TableRelation = if ("Ledger Entry Type" = const(Resource)) "Res. Ledger Entry"
else
if ("Ledger Entry Type" = const(Item)) "Item Ledger Entry"
else
if ("Ledger Entry Type" = const("G/L Account")) "G/L Entry";
}
field(1019; "Job Planning Line No."; Integer)
{
BlankZero = true;
Caption = 'Project Planning Line No.';
ToolTip = 'Specifies the project planning line number that the usage should be linked to when the project journal is posted. You can only link to project planning lines that have the Apply Usage Link option enabled.';
trigger OnLookup()
var
JobPlanningLine: Record "Job Planning Line";
Resource: Record Resource;
"Filter": Text;
begin
JobPlanningLine.SetRange("Job No.", "Job No.");
JobPlanningLine.SetRange("Job Task No.", "Job Task No.");
JobPlanningLine.SetRange(Type, Type);
JobPlanningLine.SetRange("No.", "No.");
JobPlanningLine.SetRange("Usage Link", true);
JobPlanningLine.SetRange("System-Created Entry", false);
if Type = Type::Resource then begin
Filter := Resource.GetUnitOfMeasureFilter("No.", "Unit of Measure Code");
JobPlanningLine.SetFilter("Unit of Measure Code", Filter);
end;
if Page.RunModal(0, JobPlanningLine) = Action::LookupOK then
Validate("Job Planning Line No.", JobPlanningLine."Line No.");
end;
trigger OnValidate()
var
JobPlanningLine: Record "Job Planning Line";
WhseValidateSourceLine: Codeunit "Whse. Validate Source Line";
begin
if "Job Planning Line No." <> 0 then begin
ValidateJobPlanningLineLink();
JobPlanningLine.Get("Job No.", "Job Task No.", "Job Planning Line No.");
JobPlanningLine.TestField("Job No.", "Job No.");
JobPlanningLine.TestField("Job Task No.", "Job Task No.");
JobPlanningLine.TestField(Type, Type);
JobPlanningLine.TestField("No.", "No.");
JobPlanningLine.TestField("Usage Link", true);
JobPlanningLine.TestField("System-Created Entry", false);
"Line Type" := JobPlanningLine.ConvertToJobLineType();
if (JobPlanningLine."Location Code" <> '') and (CurrFieldNo = FieldNo("Job Planning Line No.")) then
"Location Code" := JobPlanningLine."Location Code";
if (JobPlanningLine."Bin Code" <> '') and (CurrFieldNo = FieldNo("Job Planning Line No.")) then
"Bin Code" := JobPlanningLine."Bin Code";
Validate("Remaining Qty.", CalcQtyFromBaseQty(JobPlanningLine."Remaining Qty. (Base)" - "Quantity (Base)"));
"Assemble to Order" := JobPlanningLine."Assemble to Order";
if Quantity > 0 then
WhseValidateSourceLine.JobJnlLineVerifyChangeForWhsePick(Rec, xRec);
end else
Validate("Remaining Qty.", 0);
end;
}
field(1030; "Remaining Qty."; Decimal)
{
AutoFormatType = 0;
Caption = 'Remaining Qty.';
ToolTip = 'Specifies the quantity of the resource or item that remains to complete a project. The remaining quantity is calculated as the difference between Quantity and Qty. Posted. You can modify this field to indicate the quantity you want to remain on the project planning line after you post usage.';
DecimalPlaces = 0 : 5;
trigger OnValidate()
var
JobPlanningLine: Record "Job Planning Line";
begin
if ("Remaining Qty." <> 0) and ("Job Planning Line No." = 0) then
Error(Text004, FieldCaption("Remaining Qty."), FieldCaption("Job Planning Line No."));
if "Job Planning Line No." <> 0 then begin
JobPlanningLine.Get("Job No.", "Job Task No.", "Job Planning Line No.");
if JobPlanningLine.Quantity >= 0 then begin
if "Remaining Qty." < 0 then
"Remaining Qty." := 0;
end else
if "Remaining Qty." > 0 then
"Remaining Qty." := 0;
"Remaining Qty. (Base)" := CalcBaseQtyForJobPlanningLine("Remaining Qty.", FieldCaption("Remaining Qty."), FieldCaption("Remaining Qty. (Base)"), JobPlanningLine);
end else
"Remaining Qty. (Base)" := CalcBaseQty("Remaining Qty.", FieldCaption("Remaining Qty."), FieldCaption("Remaining Qty. (Base)"));
CheckItemAvailable();
end;
}
field(1031; "Remaining Qty. (Base)"; Decimal)
{
AutoFormatType = 0;
Caption = 'Remaining Qty. (Base)';
trigger OnValidate()
begin
Validate("Remaining Qty.", CalcQtyFromBaseQty("Remaining Qty. (Base)"));
end;
}
field(1081; "Qty. to Transfer to Invoice"; Decimal)
{
AutoFormatType = 0;
Caption = 'Qty. to Transfer to Invoice';
DecimalPlaces = 0 : 5;
}
field(5402; "Variant Code"; Code[10])
{
Caption = 'Variant Code';
ToolTip = 'Specifies the variant of the item on the line.';
TableRelation = if (Type = const(Item)) "Item Variant".Code where("Item No." = field("No."), Blocked = const(false));
trigger OnValidate()
var
ItemVariant: Record "Item Variant";
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeValidateVariantCode(Rec, IsHandled);
if IsHandled then
exit;
if Rec."Variant Code" = '' then begin
if Type = Type::Item then begin
Item.Get("No.");
Description := Item.Description;
"Description 2" := Item."Description 2";
GetItemTranslation();
end;
exit;
end;
TestField(Type, Type::Item);
ItemVariant.SetLoadFields(Description, "Description 2", Blocked);
ItemVariant.Get("No.", "Variant Code");
ItemVariant.TestField(Blocked, false);
Description := ItemVariant.Description;
"Description 2" := ItemVariant."Description 2";
IsHandled := false;
OnValidateVariantCodeOnBeforeValidateQuantity(Rec, xRec, IsHandled);
if not IsHandled then
Validate(Quantity);
end;
}
field(5403; "Bin Code"; Code[20])
{
AccessByPermission = TableData "Warehouse Source Filter" = R;
Caption = 'Bin Code';
ToolTip = 'Specifies the bin where the items are picked or put away.';
trigger OnLookup()
begin
TestField("Location Code");
TestField(Type, Type::Item);
BinContentLookUp();
end;
trigger OnValidate()
begin
TestField("Location Code");
if "Bin Code" <> '' then begin
GetLocation("Location Code");
Location.TestField("Bin Mandatory");
end;
TestField(Type, Type::Item);
GetItem();
Item.TestField(Type, Item.Type::Inventory);
CheckItemAvailable();
FindBinContent();
end;
}
field(5404; "Qty. per Unit of Measure"; Decimal)
{
AutoFormatType = 0;
Caption = 'Qty. per Unit of Measure';
DecimalPlaces = 0 : 5;
Editable = false;
InitValue = 1;
}
field(5410; "Quantity (Base)"; Decimal)
{
AutoFormatType = 0;
Caption = 'Quantity (Base)';
DecimalPlaces = 0 : 5;
trigger OnValidate()
begin
Validate(Quantity, CalcQtyFromBaseQty("Quantity (Base)"));
end;
}
field(5468; "Reserved Qty. (Base)"; Decimal)
{
AutoFormatType = 0;
AccessByPermission = TableData Item = R;
CalcFormula = sum("Reservation Entry"."Quantity (Base)" where("Source ID" = field("Journal Template Name"),
"Source Ref. No." = field("Line No."),
"Source Type" = const(210),
#pragma warning disable AL0603
"Source Subtype" = field("Entry Type"),
#pragma warning restore
"Source Batch Name" = field("Journal Batch Name"),
"Source Prod. Order Line" = const(0),
"Reservation Status" = const(Reservation)));
Caption = 'Reserved Qty. (Base)';
DecimalPlaces = 0 : 5;
Editable = false;
FieldClass = FlowField;
}
field(6501; "Lot No."; Code[50])
{
Caption = 'Lot No.';
Editable = false;
}
field(6515; "Package No."; Code[50])
{
Caption = 'Package No.';
CaptionClass = '6,1';
Editable = false;
}
field(7000; "Price Calculation Method"; Enum "Price Calculation Method")
{
Caption = 'Price Calculation Method';
ToolTip = 'Specifies the method that will be used for price calculation in the item journal line.';
}
field(7001; "Cost Calculation Method"; Enum "Price Calculation Method")
{
Caption = 'Cost Calculation Method';
ToolTip = 'Specifies the method that will be used for cost calculation in the item journal line.';
}
}
keys
{
key(Key1; "Journal Template Name", "Journal Batch Name", "Line No.")
{
Clustered = true;
}
key(Key2; "Journal Template Name", "Journal Batch Name", Type, "No.", "Unit of Measure Code", "Work Type Code")
{
MaintainSQLIndex = false;
}
key(Key3; Type, "No.", "Variant Code")
{
}
}
fieldgroups
{
fieldgroup(Brick; "No.", Description, Quantity, "Document No.", "Document Date")
{ }
}
trigger OnDelete()
begin
if Type = Type::Item then
ReserveJobJnlLine.DeleteLine(Rec);
end;
trigger OnInsert()
begin
LockTable();
if ("Journal Template Name" <> '') then begin
JobJnlTemplate.Get("Journal Template Name");
JobJnlBatch.Get("Journal Template Name", "Journal Batch Name");
end;
Rec.ValidateShortcutDimCode(1, "Shortcut Dimension 1 Code");
Rec.ValidateShortcutDimCode(2, "Shortcut Dimension 2 Code");
end;
trigger OnModify()
begin
if (Type = Type::Item) and (xRec.Type = Type::Item) then
ReserveJobJnlLine.VerifyChange(Rec, xRec)
else
if (Type <> Type::Item) and (xRec.Type = Type::Item) then
ReserveJobJnlLine.DeleteLine(xRec);
end;
trigger OnRename()
begin
ReserveJobJnlLine.RenameLine(Rec, xRec);
end;
var
Location: Record Location;
Item: Record Item;
Res: Record Resource;
Cust: Record Customer;
ItemJnlLine: Record "Item Journal Line";
GLAcc: Record "G/L Account";
Job: Record Job;
WorkType: Record "Work Type";
JobJnlBatch: Record "Job Journal Batch";
JobJnlLine: Record "Job Journal Line";
ResUnitofMeasure: Record "Resource Unit of Measure";
ItemTranslation: Record "Item Translation";
CurrExchRate: Record "Currency Exchange Rate";
SKU: Record "Stockkeeping Unit";
GLSetup: Record "General Ledger Setup";
ItemCheckAvail: Codeunit "Item-Check Avail.";
UOMMgt: Codeunit "Unit of Measure Management";
ReserveJobJnlLine: Codeunit "Job Jnl. Line-Reserve";
WMSManagement: Codeunit "WMS Management";
DontCheckStandardCost: Boolean;
HasGotGLSetup: Boolean;
CurrencyDate: Date;
CheckedAvailability: Boolean;
#pragma warning disable AA0074
#pragma warning disable AA0470
Text000: Label 'You cannot change %1 when %2 is %3.';
Text001: Label 'cannot be specified without %1';
#pragma warning restore AA0470
Text002: Label 'must be positive';
Text003: Label 'must be negative';
#pragma warning disable AA0470
Text004: Label '%1 is only editable when a %2 is defined.';
Text006: Label '%1 cannot be changed when %2 is set.';
Text007: Label '%1 %2 is already linked to %3 %4. Hence %5 cannot be calculated correctly. Posting the line may update the linked %3 unexpectedly. Do you want to continue?', Comment = 'Project Journal Line project DEFAULT 30000 is already linked to Project Planning Line DEERFIELD, 8 WP 1120 10000. Hence Remaining Qty. cannot be calculated correctly. Posting the line may update the linked %3 unexpectedly. Do you want to continue?';
#pragma warning restore AA0470
#pragma warning restore AA0074
DocNoFilterErr: Label 'The document numbers cannot be renumbered while there is an active filter on the Document No. field.';
RenumberDocNoQst: Label 'If you have many documents it can take time to sort them, and %1 might perform slowly during the process. In those cases we suggest that you sort them during non-working hours. Do you want to continue?', Comment = '%1= Business Central';
protected var
JobJnlTemplate: Record "Job Journal Template";
DimMgt: Codeunit DimensionManagement;
UnitAmountRoundingPrecision: Decimal;
AmountRoundingPrecision: Decimal;
UnitAmountRoundingPrecisionFCY: Decimal;
AmountRoundingPrecisionFCY: Decimal;
local procedure CalcQtyFromBaseQty(BaseQty: Decimal): Decimal
begin
TestField("Qty. per Unit of Measure");
exit(Round(BaseQty / "Qty. per Unit of Measure", UOMMgt.QtyRndPrecision()));
end;
local procedure CopyFromResource()
var
Resource: Record Resource;
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeCopyFromResource(Rec, Resource, CurrFieldNo, IsHandled);
if not IsHandled then begin
Resource.Get("No.");
CheckResource(Resource);
OnCopyFromResourceOnAfterCheckResource(Rec, Resource, CurrFieldNo);
Description := Resource.Name;
"Description 2" := Resource."Name 2";
"Resource Group No." := Resource."Resource Group No.";
"Gen. Prod. Posting Group" := Resource."Gen. Prod. Posting Group";
Validate("Unit of Measure Code", Resource."Base Unit of Measure");
end;
OnAfterAssignResourceValues(Rec, Resource, CurrFieldNo);
end;
local procedure CheckResource(Resource: Record Resource)
var
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeCheckResource(Rec, Resource, IsHandled);
if IsHandled then
exit;
Resource.CheckResourcePrivacyBlocked(false);
Resource.TestField(Blocked, false);
if "Time Sheet No." = '' then
Resource.TestField("Use Time Sheet", false);
end;
local procedure CheckPostingDateNotEmpty()
var
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeCheckPostingDateNotEmpty(Rec, IsHandled);
if IsHandled then
exit;
if not IsTemporary() then
TestField("Posting Date");
end;
local procedure CheckDirectedPutawayandPickIsFalse(CallingFieldNo: Integer)
var
IsHandled: Boolean;
begin
GetLocation(Rec."Location Code");
IsHandled := false;
OnCheckDirectedPutawayandPickIsFalseOnBeforeTestField(Location, CallingFieldNo, IsHandled);
if not IsHandled then
if CurrFieldNo <> 0 then
Location.TestField("Directed Put-away and Pick", false);
end;
local procedure CopyFromItem()
var
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeCopyFromItem(Rec, Item, IsHandled);
if not IsHandled then begin
GetItem();
Item.TestField(Blocked, false);
OnCopyFromItemOnAfterCheckItem(Rec, Item);
Description := Item.Description;
"Description 2" := Item."Description 2";
GetJob();
if Job."Language Code" <> '' then
GetItemTranslation();
"Posting Group" := Item."Inventory Posting Group";
"Gen. Prod. Posting Group" := Item."Gen. Prod. Posting Group";
OnCopyFromItemOnBeforeValidateUoMCode(Rec, Item, IsHandled);
if not IsHandled then
Validate("Unit of Measure Code", Item."Base Unit of Measure");
end;
OnAfterAssignItemValues(Rec, Item);
end;
local procedure CopyFromGLAccount()
var
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeCopyFromGLAccount(Rec, GLAcc, CurrFieldNo, IsHandled);
if not IsHandled then begin
GLAcc.Get("No.");
GLAcc.CheckGLAcc();
CheckDirectPosting(GLAcc);
Description := GLAcc.Name;
"Gen. Bus. Posting Group" := GLAcc."Gen. Bus. Posting Group";
"Gen. Prod. Posting Group" := GLAcc."Gen. Prod. Posting Group";
"Unit of Measure Code" := '';
"Direct Unit Cost (LCY)" := 0;
"Unit Cost (LCY)" := 0;
"Unit Price" := 0;
end;
OnAfterAssignGLAccountValues(Rec, GLAcc);
end;
local procedure CheckDirectPosting(var GLAccount: Record "G/L Account")
var
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeCheckDirectPosting(Rec, GLAccount, IsHandled);
if IsHandled then
exit;
GLAccount.TestField("Direct Posting", true);
end;
procedure CheckItemAvailable()
var
JobPlanningLine: Record "Job Planning Line";
IsHandled: Boolean;
begin
OnBeforeCheckItemAvailable(Rec, ItemJnlLine, CheckedAvailability);
if (CurrFieldNo <> 0) and (Type = Type::Item) and (Quantity > 0) and not CheckedAvailability then begin
ItemJnlLine."Item No." := "No.";
ItemJnlLine."Entry Type" := ItemJnlLine."Entry Type"::"Negative Adjmt.";
ItemJnlLine."Location Code" := "Location Code";
ItemJnlLine."Variant Code" := "Variant Code";
ItemJnlLine."Bin Code" := "Bin Code";
ItemJnlLine."Unit of Measure Code" := "Unit of Measure Code";
ItemJnlLine."Qty. per Unit of Measure" := "Qty. per Unit of Measure";
IsHandled := false;
OnCheckItemAvailableOnBeforeAssignQuantity(Rec, ItemJnlLine, IsHandled);
if not IsHandled then
if "Job Planning Line No." = 0 then
ItemJnlLine.Quantity := Quantity
else begin
JobPlanningLine.SetLoadFields("Remaining Qty.");
JobPlanningLine.Get("Job No.", "Job Task No.", "Job Planning Line No.");
if JobPlanningLine."Remaining Qty." < (Quantity + "Remaining Qty.") then
ItemJnlLine.Quantity := (Quantity + "Remaining Qty.") - JobPlanningLine."Remaining Qty."
else
exit;
end;
if ItemCheckAvail.ItemJnlCheckLine(ItemJnlLine) then
ItemCheckAvail.RaiseUpdateInterruptedError();
CheckedAvailability := true;
end;
end;
procedure EmptyLine(): Boolean
var
LineIsEmpty: Boolean;
begin
LineIsEmpty := ("Job No." = '') and ("No." = '') and (Quantity = 0);
OnBeforeEmptyLine(Rec, LineIsEmpty);
exit(LineIsEmpty);
end;
procedure SetUpNewLine(LastJobJnlLine: Record "Job Journal Line")
var
JobsSetup: Record "Jobs Setup";
NoSeries: Codeunit "No. Series";
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeSetUpNewLine(Rec, xRec, LastJobJnlLine, IsHandled);
if IsHandled then
exit;
JobsSetup.Get();
JobJnlTemplate.Get("Journal Template Name");
JobJnlBatch.Get("Journal Template Name", "Journal Batch Name");
JobJnlLine.SetRange("Journal Template Name", "Journal Template Name");
JobJnlLine.SetRange("Journal Batch Name", "Journal Batch Name");
if JobJnlLine.FindFirst() then begin
"Posting Date" := LastJobJnlLine."Posting Date";
"Document Date" := LastJobJnlLine."Posting Date";
if JobsSetup."Document No. Is Job No." and (LastJobJnlLine."Document No." = '') then
"Document No." := Rec."Job No."
else
"Document No." := LastJobJnlLine."Document No.";
Type := LastJobJnlLine.Type;
Validate("Line Type", LastJobJnlLine."Line Type");
end else begin
OnSetUpNewLineOnNewLine(JobJnlLine, JobJnlTemplate, JobJnlBatch);
"Posting Date" := WorkDate();
"Document Date" := WorkDate();
if JobsSetup."Document No. Is Job No." then begin
if "Document No." = '' then
"Document No." := Rec."Job No.";
end else
if JobJnlBatch."No. Series" <> '' then
"Document No." := NoSeries.PeekNextNo(JobJnlBatch."No. Series", "Posting Date");
end;
"Recurring Method" := LastJobJnlLine."Recurring Method";
"Entry Type" := "Entry Type"::Usage;
"Source Code" := JobJnlTemplate."Source Code";
"Reason Code" := JobJnlBatch."Reason Code";
"Posting No. Series" := JobJnlBatch."Posting No. Series";
"Price Calculation Method" := Job.GetPriceCalculationMethod();
"Cost Calculation Method" := Job.GetCostCalculationMethod();
OnAfterSetUpNewLine(Rec, LastJobJnlLine, JobJnlTemplate, JobJnlBatch);
end;
procedure CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])
var
IsHandled: Boolean;
OldDimSetID: Integer;
begin
IsHandled := false;
OnBeforeCreateDim(Rec, IsHandled, CurrFieldNo);
if IsHandled then
exit;
"Shortcut Dimension 1 Code" := '';
"Shortcut Dimension 2 Code" := '';
OldDimSetID := Rec."Dimension Set ID";
"Dimension Set ID" :=
DimMgt.GetRecDefaultDimID(
Rec, CurrFieldNo, DefaultDimSource, "Source Code", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code", 0, 0);
OnAfterCreateDim(Rec, CurrFieldNo, xRec, OldDimSetID, DefaultDimSource);
end;
procedure ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])
begin
OnBeforeValidateShortcutDimCode(Rec, xRec, FieldNumber, ShortcutDimCode);
DimMgt.ValidateShortcutDimValues(FieldNumber, ShortcutDimCode, "Dimension Set ID");
OnAfterValidateShortcutDimCode(Rec, xRec, FieldNumber, ShortcutDimCode);
end;
procedure LookupShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])
begin
DimMgt.LookupDimValueCode(FieldNumber, ShortcutDimCode);
DimMgt.ValidateShortcutDimValues(FieldNumber, ShortcutDimCode, "Dimension Set ID");
end;
procedure ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])
begin
DimMgt.GetShortcutDimensions(Rec."Dimension Set ID", ShortcutDimCode);
end;
local procedure GetLocation(LocationCode: Code[10])
var
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeGetLocation(Rec, Location, LocationCode, IsHandled);
if IsHandled then
exit;
if LocationCode = '' then
Clear(Location)
else
if Location.Code <> LocationCode then
Location.Get(LocationCode);
end;
local procedure GetJob()
var
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeGetJob(Rec, Job, IsHandled);
if IsHandled then
exit;
TestField("Job No.");
if "Job No." <> Job."No." then
Job.Get("Job No.");
end;
procedure UpdateCurrencyFactor()
begin
if "Currency Code" <> '' then begin
if "Posting Date" = 0D then
CurrencyDate := WorkDate()
else
CurrencyDate := "Posting Date";
OnUpdateCurrencyFactorOnBeforeGetExchangeRate(Rec, CurrExchRate);
"Currency Factor" := CurrExchRate.ExchangeRate(CurrencyDate, "Currency Code");
end else
"Currency Factor" := 0;
end;
local procedure GetItem()
begin
TestField("No.");
if "No." <> Item."No." then
Item.Get("No.");
end;
local procedure GetSKU() Result: Boolean
begin
if (SKU."Location Code" = "Location Code") and
(SKU."Item No." = "No.") and
(SKU."Variant Code" = "Variant Code")
then
exit(true);
if SKU.Get("Location Code", "No.", "Variant Code") then
exit(true);
Result := false;
OnAfterGetSKU(Rec, Result);
end;
procedure IsInbound(): Boolean
begin
if "Entry Type" in ["Entry Type"::Usage, "Entry Type"::Sale] then
exit("Quantity (Base)" < 0);
exit(false);
end;
procedure OpenItemTrackingLines(IsReclass: Boolean)
begin
TestField(Type, Type::Item);
TestField("No.");
ReserveJobJnlLine.CallItemTracking(Rec, IsReclass);
end;
procedure InitRoundingPrecisions()
var
Currency: Record Currency;
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeInitRoundingPrecisions(Rec, AmountRoundingPrecision, UnitAmountRoundingPrecision, AmountRoundingPrecisionFCY, UnitAmountRoundingPrecisionFCY, IsHandled);
if IsHandled then
exit;
if (AmountRoundingPrecision = 0) or
(UnitAmountRoundingPrecision = 0) or
(AmountRoundingPrecisionFCY = 0) or
(UnitAmountRoundingPrecisionFCY = 0)
then begin
Clear(Currency);
Currency.InitRoundingPrecision();
AmountRoundingPrecision := Currency."Amount Rounding Precision";
UnitAmountRoundingPrecision := Currency."Unit-Amount Rounding Precision";
if "Currency Code" <> '' then begin
Currency.Get("Currency Code");
Currency.TestField("Amount Rounding Precision");
Currency.TestField("Unit-Amount Rounding Precision");
end;
AmountRoundingPrecisionFCY := Currency."Amount Rounding Precision";
UnitAmountRoundingPrecisionFCY := Currency."Unit-Amount Rounding Precision";
end;
end;
procedure DontCheckStdCost()
begin
DontCheckStandardCost := true;
end;
local procedure CalcUnitCost(ItemLedgerEntry: Record "Item Ledger Entry"): Decimal
var
ValueEntry: Record "Value Entry";
UnitCost: Decimal;
begin
ValueEntry.SetCurrentKey("Item Ledger Entry No.");
ValueEntry.SetRange("Item Ledger Entry No.", ItemLedgerEntry."Entry No.");
ValueEntry.CalcSums("Cost Amount (Actual)", "Cost Amount (Expected)");
UnitCost :=
(ValueEntry."Cost Amount (Expected)" + ValueEntry."Cost Amount (Actual)") / ItemLedgerEntry.Quantity;
exit(Abs(UnitCost * "Qty. per Unit of Measure"));
end;
local procedure CalcUnitCostFrom(ItemLedgerEntry: Record "Item Ledger Entry"): Decimal
var
ValueEntry: Record "Value Entry";
begin
ValueEntry.Reset();
ValueEntry.SetCurrentKey("Item Ledger Entry No.");
ValueEntry.SetRange("Item Ledger Entry No.", ItemLedgerEntry."Entry No.");
ValueEntry.CalcSums("Cost Amount (Actual)", "Cost Amount (Expected)");
exit(
(ValueEntry."Cost Amount (Actual)" + ValueEntry."Cost Amount (Expected)") /
ItemLedgerEntry.Quantity * "Qty. per Unit of Measure");
end;
local procedure SetCountryRegionCodeFromJob(Job2: Record Job)
var
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeSetCountryRegionCodeFromJob(Rec, Job2, IsHandled);
if IsHandled then
exit;
Validate(Rec."Country/Region Code", Job."Bill-to Country/Region Code");
end;
local procedure SelectItemEntry(CurrentFieldNo: Integer)
var
ItemLedgerEntry: Record "Item Ledger Entry";
JobJournalLine2: Record "Job Journal Line";
begin
ItemLedgerEntry.SetCurrentKey("Item No.", Open, "Variant Code");
ItemLedgerEntry.SetRange("Item No.", "No.");
ItemLedgerEntry.SetRange(Correction, false);
if "Location Code" <> '' then
ItemLedgerEntry.SetRange("Location Code", "Location Code");
if CurrentFieldNo = FieldNo("Applies-to Entry") then begin
ItemLedgerEntry.SetRange(Positive, true);
ItemLedgerEntry.SetRange(Open, true);
end else
ItemLedgerEntry.SetRange(Positive, false);
OnSelectItemEntryOnAfterSetItemLedgerEntryFilters(ItemLedgerEntry, CurrentFieldNo, Rec);
if Page.RunModal(Page::"Item Ledger Entries", ItemLedgerEntry) = Action::LookupOK then begin
JobJournalLine2 := Rec;
if CurrentFieldNo = FieldNo("Applies-to Entry") then
JobJournalLine2.Validate("Applies-to Entry", ItemLedgerEntry."Entry No.")
else
JobJournalLine2.Validate("Applies-from Entry", ItemLedgerEntry."Entry No.");
Rec := JobJournalLine2;
end;
end;
procedure DeleteAmounts()
begin
Quantity := 0;
"Quantity (Base)" := 0;
"Direct Unit Cost (LCY)" := 0;
"Unit Cost (LCY)" := 0;
"Unit Cost" := 0;
"Total Cost (LCY)" := 0;
"Total Cost" := 0;
"Unit Price (LCY)" := 0;
"Unit Price" := 0;
"Total Price (LCY)" := 0;
"Total Price" := 0;
"Line Amount (LCY)" := 0;
"Line Amount" := 0;
"Line Discount %" := 0;
"Line Discount Amount (LCY)" := 0;
"Line Discount Amount" := 0;
"Remaining Qty." := 0;
"Remaining Qty. (Base)" := 0;
OnAfterDeleteAmounts(Rec);
end;
procedure SetCurrencyFactor(Factor: Decimal)
begin
"Currency Factor" := Factor;
end;
procedure GetItemTranslation()
begin
GetJob();
if ItemTranslation.Get("No.", "Variant Code", Job."Language Code") then begin
Description := ItemTranslation.Description;
"Description 2" := ItemTranslation."Description 2";
end;
end;
local procedure GetGLSetup()
begin
if HasGotGLSetup then
exit;
GLSetup.Get();
HasGotGLSetup := true;
end;
procedure SetReservationEntry(var ReservationEntry: Record "Reservation Entry")
begin
ReservationEntry.SetSource(Database::"Job Journal Line", "Entry Type".AsInteger(), "Journal Template Name", "Line No.", "Journal Batch Name", 0);
ReservationEntry.SetItemData("No.", Description, "Location Code", "Variant Code", "Qty. per Unit of Measure");
ReservationEntry."Expected Receipt Date" := "Posting Date";
ReservationEntry."Shipment Date" := "Posting Date";
end;
procedure SetReservationFilters(var ReservationEntry: Record "Reservation Entry")
begin
ReservationEntry.SetSourceFilter(Database::"Job Journal Line", "Entry Type".AsInteger(), "Journal Template Name", "Line No.", false);
ReservationEntry.SetSourceFilter("Journal Batch Name", 0);
OnAfterSetReservationFilters(ReservationEntry, Rec);
end;
procedure ReservEntryExist(): Boolean
var
ReservationEntry: Record "Reservation Entry";
begin
ReservationEntry.InitSortingAndFilters(false);
SetReservationFilters(ReservationEntry);
ReservationEntry.ClearTrackingFilter();
exit(not ReservationEntry.IsEmpty());
end;
procedure UpdateAllAmounts()
var
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeUpdateAllAmounts(Rec, xRec, CurrFieldNo, IsHandled);
if IsHandled then
exit;
InitRoundingPrecisions();
UpdateUnitCost();
FindPriceAndDiscount(CurrFieldNo);
UpdateTotalCost();
HandleCostFactor();
UpdateUnitPrice();
UpdateTotalPrice();
UpdateAmountsAndDiscounts();
OnAfterUpdateAllAmounts(Rec, xRec);
end;
procedure UpdateUnitCost()
var
RetrievedCost: Decimal;
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeUpdateUnitCost(Rec, IsHandled, xRec);
if IsHandled then
exit;
if (Type = Type::Item) and Item.Get("No.") then begin
if Item."Costing Method" = Item."Costing Method"::Standard then begin
if not DontCheckStandardCost then
// Prevent manual change of unit cost on items with standard cost
if (("Unit Cost" <> xRec."Unit Cost") or ("Unit Cost (LCY)" <> xRec."Unit Cost (LCY)")) and
(("No." = xRec."No.") and ("Location Code" = xRec."Location Code") and
("Variant Code" = xRec."Variant Code") and ("Unit of Measure Code" = xRec."Unit of Measure Code"))
then
Error(
Text000,
FieldCaption("Unit Cost"), Item.FieldCaption("Costing Method"), Item."Costing Method");
if RetrieveCostPrice(CurrFieldNo) then begin
if GetSKU() then
"Unit Cost (LCY)" := Round(SKU."Unit Cost" * "Qty. per Unit of Measure", UnitAmountRoundingPrecision)
else
"Unit Cost (LCY)" := Round(Item."Unit Cost" * "Qty. per Unit of Measure", UnitAmountRoundingPrecision);
"Unit Cost" := ConvertAmountToFCY("Unit Cost (LCY)", UnitAmountRoundingPrecisionFCY);
end else
if "Unit Cost" <> xRec."Unit Cost" then
"Unit Cost (LCY)" := ConvertAmountToLCY("Unit Cost", UnitAmountRoundingPrecision)
else
"Unit Cost" := ConvertAmountToFCY("Unit Cost (LCY)", UnitAmountRoundingPrecisionFCY);
end else
if RetrieveCostPrice(CurrFieldNo) then begin
if GetSKU() then
RetrievedCost := SKU."Unit Cost" * "Qty. per Unit of Measure"
else
RetrievedCost := Item."Unit Cost" * "Qty. per Unit of Measure";
"Unit Cost" := ConvertAmountToFCY(RetrievedCost, UnitAmountRoundingPrecisionFCY);
"Unit Cost (LCY)" := Round(RetrievedCost, UnitAmountRoundingPrecision);
end else
"Unit Cost (LCY)" := ConvertAmountToLCY("Unit Cost", UnitAmountRoundingPrecision);
end else
if (Type = Type::Resource) and ("Posting Date" <> xRec."Posting Date") and ("Currency Code" <> '') then
"Unit Cost (LCY)" := "Unit Cost (LCY)"
else
"Unit Cost (LCY)" := ConvertAmountToLCY("Unit Cost", UnitAmountRoundingPrecision);
OnAfterUpdateUnitCost(Rec, UnitAmountRoundingPrecision, CurrFieldNo);
end;
local procedure ValidateChargeable()
var
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeValidateChargeable(Rec, IsHandled, xRec);
if IsHandled then
exit;
if Chargeable <> xRec.Chargeable then
if not Chargeable then
Validate("Unit Price", 0)
else
Validate("No.");
end;
local procedure TestUnitOfMeasureCode(LocalWorkType: Record "Work Type")
var
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeTestUnitOfMeasureCode(Rec, LocalWorkType, IsHandled);
if IsHandled then
exit;
TestField("Unit of Measure Code", WorkType."Unit of Measure Code");
end;
local procedure RetrieveCostPrice(CalledByFieldNo: Integer) Result: Boolean
var
ShouldRetrieveCostPrice: Boolean;
begin
Result := true;
OnBeforeRetrieveCostPrice(Rec, xRec, ShouldRetrieveCostPrice, Result, CalledByFieldNo);
if ShouldRetrieveCostPrice then
exit(Result);
if CalledByFieldNo <> 0 then
case Type of
Type::Item:
if not (CalledByFieldNo in
[FieldNo("No."), FieldNo(Quantity), FieldNo("Location Code"),
FieldNo("Variant Code"), FieldNo("Unit of Measure Code")])
then
exit(false);
Type::Resource:
if not (CalledByFieldNo in
[FieldNo("No."), FieldNo(Quantity), FieldNo("Work Type Code"), FieldNo("Unit of Measure Code"), FieldNo("Posting Date")])
then
exit(false);
Type::"G/L Account":
if not (CalledByFieldNo in [FieldNo("No."), FieldNo(Quantity)]) then
exit(false);
end;
case Type of
Type::Item:
if ("No." <> xRec."No.") or
IsQuantityChangedForPrice() or
("Location Code" <> xRec."Location Code") or
("Variant Code" <> xRec."Variant Code") or
(Quantity <> xRec.Quantity) or
("Unit of Measure Code" <> xRec."Unit of Measure Code") and
(("Applies-to Entry" = 0) and ("Applies-from Entry" = 0))
then
exit(true);
Type::Resource:
if ("No." <> xRec."No.") or
IsQuantityChangedForPrice() or
("Work Type Code" <> xRec."Work Type Code") or
("Unit of Measure Code" <> xRec."Unit of Measure Code") or
(("Posting Date" <> xRec."Posting Date") and ("Currency Code" <> ''))
then
exit(true);
Type::"G/L Account":
if ("No." <> xRec."No.") or IsQuantityChangedForPrice() then
exit(true);
else
exit(false);
end;
exit(false);
end;
local procedure IsQuantityChangedForPrice(): Boolean;
var
PriceCalculationMgt: Codeunit "Price Calculation Mgt.";
begin
if Quantity = xRec.Quantity then
exit(false);
exit(PriceCalculationMgt.IsExtendedPriceCalculationEnabled());
end;
procedure UpdateTotalCost()
begin
"Total Cost" := Round("Unit Cost" * Quantity, AmountRoundingPrecisionFCY);
"Total Cost (LCY)" := ConvertAmountToLCY("Total Cost", AmountRoundingPrecision);
OnAfterUpdateTotalCost(Rec, AmountRoundingPrecision, AmountRoundingPrecisionFCY);
end;
local procedure ConvertAmountToFCY(AmountLCY: Decimal; Precision: Decimal) AmountFCY: Decimal;
begin
AmountFCY :=
Round(
CurrExchRate.ExchangeAmtLCYToFCY(
"Posting Date", "Currency Code", AmountLCY, "Currency Factor"),
Precision);
end;
local procedure ConvertAmountToLCY(AmountFCY: Decimal; Precision: Decimal) AmountLCY: Decimal;
begin
AmountLCY :=
Round(
CurrExchRate.ExchangeAmtFCYToLCY(
"Posting Date", "Currency Code", AmountFCY, "Currency Factor"),
Precision);
end;
procedure SwitchLinesWithErrorsFilter(var ShowAllLinesEnabled: Boolean)
var
TempErrorMessage: Record "Error Message" temporary;
JobJournalErrorsMgt: Codeunit "Job Journal Errors Mgt.";
begin
if ShowAllLinesEnabled then begin
MarkedOnly(false);
ShowAllLinesEnabled := false;
end else begin
JobJournalErrorsMgt.GetErrorMessages(TempErrorMessage);
if TempErrorMessage.FindSet() then
repeat
if Rec.Get(TempErrorMessage."Context Record ID") then
Rec.Mark(true)
until TempErrorMessage.Next() = 0;
MarkedOnly(true);
ShowAllLinesEnabled := true;
end;
end;
local procedure FindPriceAndDiscount(CalledByFieldNo: Integer)
var
PriceType: Enum "Price Type";
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeFindPriceAndDiscount(Rec, CalledByFieldNo, IsHandled);
if IsHandled then
exit;
if RetrieveCostPrice(CalledByFieldNo) and ("No." <> '') then begin
ApplyPrice(PriceType::Sale, CalledByFieldNo);
ApplyPrice(PriceType::Purchase, CalledByFieldNo);
if Type = Type::Resource then
"Unit Cost (LCY)" := ConvertAmountToLCY("Unit Cost", UnitAmountRoundingPrecision);
end;
end;
procedure AfterResourceFindCost(var ResourceCost: Record "Resource Cost")
begin
OnAfterResourceFindCost(Rec, ResourceCost);
end;
procedure ApplyPrice(PriceType: enum "Price Type"; CalledByFieldNo: Integer)
var
PriceCalculationMgt: Codeunit "Price Calculation Mgt.";
LineWithPrice: Interface "Line With Price";
PriceCalculation: Interface "Price Calculation";
Line: Variant;
begin
GetLineWithPrice(LineWithPrice);
LineWithPrice.SetLine(PriceType, Rec);
PriceCalculationMgt.GetHandler(LineWithPrice, PriceCalculation);
PriceCalculation.ApplyPrice(CalledByFieldNo);
if PriceType = PriceType::Sale then
PriceCalculation.ApplyDiscount();
PriceCalculation.GetLine(Line);
Rec := Line;
end;
procedure GetLineWithPrice(var LineWithPrice: Interface "Line With Price")
var
JobJournalLinePrice: Codeunit "Job Journal Line - Price";
begin
LineWithPrice := JobJournalLinePrice;
OnAfterGetLineWithPrice(LineWithPrice);
end;
local procedure FindBinContent()
var
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeFindBinContent(Rec, xRec, IsHandled);
if IsHandled then
exit;
WMSManagement.FindBinContent("Location Code", "Bin Code", "No.", "Variant Code", '')
end;
local procedure BinContentLookUp()
var
BinCode: Code[20];
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeBinContentLookUp(Rec, xRec, IsHandled);
if IsHandled then
exit;
BinCode := WMSManagement.BinContentLookUp("Location Code", "No.", "Variant Code", '', "Bin Code");
if BinCode <> '' then
Validate("Bin Code", BinCode);
end;
local procedure HandleCostFactor()
var
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeHandleCostFactor(Rec, Item, IsHandled);
if IsHandled then
exit;
if ("Cost Factor" <> 0) and
((("Unit Cost" <> xRec."Unit Cost") or ("Cost Factor" <> xRec."Cost Factor")) or
((Quantity <> xRec.Quantity) or ("Location Code" <> xRec."Location Code") or ("Variant Code" <> xRec."Variant Code")))
then
"Unit Price" := Round("Unit Cost" * "Cost Factor", UnitAmountRoundingPrecisionFCY)
else
if (Item."Price/Profit Calculation" = Item."Price/Profit Calculation"::"Price=Cost+Profit") and
(Item."Profit %" < 100) and
("Unit Cost" <> xRec."Unit Cost")
then
"Unit Price" := Round("Unit Cost" / (1 - Item."Profit %" / 100), UnitAmountRoundingPrecisionFCY);
end;
local procedure UpdateUnitPrice()
begin
"Unit Price (LCY)" := ConvertAmountToLCY("Unit Price", UnitAmountRoundingPrecision);
OnAfterUpdateUnitPrice(Rec, xRec, AmountRoundingPrecision, AmountRoundingPrecisionFCY);
end;
local procedure UpdateTotalPrice()
begin
"Total Price" := Round(Quantity * "Unit Price", AmountRoundingPrecisionFCY);
"Total Price (LCY)" := ConvertAmountToLCY("Total Price", AmountRoundingPrecision);
OnAfterUpdateTotalPrice(Rec);
end;
local procedure UpdateAmountsAndDiscounts()
var
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeUpdateAmountsAndDiscounts(Rec, xRec, IsHandled);
if IsHandled then
exit;
// Patch for fixing Edit-in-Excel issues due to dependency on xRec.
if not GuiAllowed() then
if xRec.Get(xRec.RecordId()) then;
if "Total Price" <> 0 then begin
if ("Line Amount" <> xRec."Line Amount") and ("Line Discount Amount" = xRec."Line Discount Amount") then begin
"Line Amount" := Round("Line Amount", AmountRoundingPrecisionFCY);
"Line Discount Amount" := "Total Price" - "Line Amount";
"Line Amount (LCY)" := ConvertAmountToLCY("Line Amount", AmountRoundingPrecision);
"Line Discount Amount (LCY)" := "Total Price (LCY)" - "Line Amount (LCY)";
"Line Discount %" := Round("Line Discount Amount" / "Total Price" * 100, 0.00001);
end else
if ("Line Discount Amount" <> xRec."Line Discount Amount") and ("Line Amount" = xRec."Line Amount") then begin
"Line Discount Amount" := Round("Line Discount Amount", AmountRoundingPrecisionFCY);
"Line Amount" := "Total Price" - "Line Discount Amount";
"Line Discount Amount (LCY)" := Round("Line Discount Amount (LCY)", AmountRoundingPrecision);
"Line Amount (LCY)" := "Total Price (LCY)" - "Line Discount Amount (LCY)";
"Line Discount %" := Round("Line Discount Amount" / "Total Price" * 100, 0.00001);
end else
if ("Line Discount Amount" <> xRec."Line Discount Amount") or ("Line Amount" <> xRec."Line Amount") or
("Total Price" <> xRec."Total Price") or ("Line Discount %" <> xRec."Line Discount %")
then begin
"Line Discount Amount" := Round("Total Price" * "Line Discount %" / 100, AmountRoundingPrecisionFCY);
"Line Amount" := "Total Price" - "Line Discount Amount";
"Line Discount Amount (LCY)" := Round("Total Price (LCY)" * "Line Discount %" / 100, AmountRoundingPrecision);
"Line Amount (LCY)" := "Total Price (LCY)" - "Line Discount Amount (LCY)";
end;
end else begin
"Line Amount" := 0;
"Line Discount Amount" := 0;
"Line Amount (LCY)" := 0;
"Line Discount Amount (LCY)" := 0;
end;
OnAfterUpdateAmountsAndDiscounts(Rec);
end;
local procedure ValidateJobPlanningLineLink()
var
JobPlanningLine: Record "Job Planning Line";
JobJournalLine: Record "Job Journal Line";
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeValidateJobPlanningLineLink(Rec, xRec, IsHandled);
if IsHandled then
exit;
JobJournalLine.SetRange("Job No.", "Job No.");
JobJournalLine.SetRange("Job Task No.", "Job Task No.");
JobJournalLine.SetRange("Job Planning Line No.", "Job Planning Line No.");
if JobJournalLine.FindFirst() then
if ("Journal Template Name" <> JobJournalLine."Journal Template Name") or
("Journal Batch Name" <> JobJournalLine."Journal Batch Name") or
("Line No." <> JobJournalLine."Line No.")
then begin
JobPlanningLine.SetLoadFields("Job No.", "Job Task No.", "Line No.");
JobPlanningLine.Get("Job No.", "Job Task No.", "Job Planning Line No.");
if not Confirm(Text007, false,
TableCaption,
StrSubstNo('%1, %2, %3', "Journal Template Name", "Journal Batch Name", "Line No."),
JobPlanningLine.TableCaption(),
StrSubstNo('%1, %2, %3', JobPlanningLine."Job No.", JobPlanningLine."Job Task No.", JobPlanningLine."Line No."),
FieldCaption("Remaining Qty."))
then
Error('');
end;
end;
procedure ShowDimensions()
begin
"Dimension Set ID" :=
DimMgt.EditDimensionSet("Dimension Set ID", StrSubstNo('%1 %2 %3', "Journal Template Name", "Journal Batch Name", "Line No."));
DimMgt.UpdateGlobalDimFromDimSetID("Dimension Set ID", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code");
OnAfterShowDimensions(Rec, xRec);
end;
procedure UpdateDimensions()
var
DimensionSetIDArr: array[10] of Integer;
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeUpdateDimensions(Rec, CurrFieldNo, IsHandled);
if not IsHandled then begin
CreateDimFromDefaultDim(0);
if "Job Task No." <> '' then begin
DimensionSetIDArr[1] := "Dimension Set ID";
DimensionSetIDArr[2] :=
DimMgt.CreateDimSetFromJobTaskDim("Job No.",
"Job Task No.", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code");
DimMgt.CreateDimForJobJournalLineWithHigherPriorities(
Rec, CurrFieldNo, DimensionSetIDArr[3], "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code", "Source Code", Database::Job);
"Dimension Set ID" :=
DimMgt.GetCombinedDimensionSetID(
DimensionSetIDArr, "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code");
end;
end;
OnAfterUpdateDimensions(Rec, DimensionSetIDArr);
end;
procedure IsOpenedFromBatch(): Boolean
var
JobJournalBatch: Record "Job Journal Batch";
TemplateFilter: Text;
BatchFilter: Text;
begin
BatchFilter := GetFilter("Journal Batch Name");
if BatchFilter <> '' then begin
TemplateFilter := GetFilter("Journal Template Name");
if TemplateFilter <> '' then
JobJournalBatch.SetFilter("Journal Template Name", TemplateFilter);
JobJournalBatch.SetFilter(Name, BatchFilter);
JobJournalBatch.FindFirst();
end;
exit((("Journal Batch Name" <> '') and ("Journal Template Name" = '')) or (BatchFilter <> ''));
end;
procedure IsNonInventoriableItem(): Boolean
begin
if Type <> Type::Item then
exit(false);
if "No." = '' then
exit(false);
GetItem();
exit(Item.IsNonInventoriableType());
end;
procedure IsInventoriableItem(): Boolean
begin
if Type <> Type::Item then
exit(false);
if "No." = '' then
exit(false);
GetItem();
exit(Item.IsInventoriableType());
end;
procedure RowID1(): Text[250]
var
ItemTrackingMgt: Codeunit "Item Tracking Management";
begin
exit(
ItemTrackingMgt.ComposeRowID(Database::"Job Journal Line", "Entry Type".AsInteger(),
"Journal Template Name", "Journal Batch Name", 0, "Line No."));
end;
procedure CopyTrackingFromItemLedgEntry(ItemLedgEntry: Record "Item Ledger Entry")
begin
"Serial No." := ItemLedgEntry."Serial No.";
"Lot No." := ItemLedgEntry."Lot No.";
OnAfterCopyTrackingFromItemLedgEntry(rec, ItemLedgEntry);
end;
procedure CopyTrackingFromJobPlanningLine(JobPlanningLine: Record "Job Planning Line")
begin
"Serial No." := JobPlanningLine."Serial No.";
"Lot No." := JobPlanningLine."Lot No.";
OnAfterCopyTrackingFromJobPlanningLine(rec, JobPlanningLine);
end;
local procedure IsDefaultBin() Result: Boolean
begin
Result := Location."Bin Mandatory" and not Location."Directed Put-away and Pick";
end;
local procedure CalcBaseQty(Qty: Decimal; FromFieldName: Text; ToFieldName: Text): Decimal
begin
exit(UOMMgt.CalcBaseQty(
"No.", "Variant Code", "Unit of Measure Code", Qty, "Qty. per Unit of Measure", "Qty. Rounding Precision (Base)", FieldCaption("Qty. Rounding Precision"), FromFieldName, ToFieldName));
end;
procedure CreateDimFromDefaultDim(FieldNo: Integer)
var
DefaultDimSource: List of [Dictionary of [Integer, Code[20]]];
begin
if not DimMgt.IsDefaultDimDefinedForTable(GetTableValuePair(FieldNo)) then
exit;
InitDefaultDimensionSources(DefaultDimSource, FieldNo);
CreateDim(DefaultDimSource);
end;
local procedure GetTableValuePair(FieldNo: Integer) TableValuePair: Dictionary of [Integer, Code[20]]
begin
case true of
FieldNo = Rec.FieldNo("No."):
TableValuePair.Add(DimMgt.TypeToTableID2(Rec.Type.AsInteger()), Rec."No.");
FieldNo = Rec.FieldNo("Job No."):
TableValuePair.Add(Database::Job, Rec."Job No.");
FieldNo = Rec.FieldNo("Resource Group No."):
TableValuePair.Add(Database::"Resource Group", Rec."Resource Group No.");
FieldNo = Rec.FieldNo("Location Code"):
TableValuePair.Add(Database::Location, Rec."Location Code");
end;
OnAfterInitTableValuePair(Rec, TableValuePair, FieldNo);
end;
local procedure InitDefaultDimensionSources(var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]; FieldNo: Integer)
begin
DimMgt.AddDimSource(DefaultDimSource, DimMgt.TypeToTableID2(Rec.Type.AsInteger()), Rec."No.", FieldNo = Rec.FieldNo("No."));
DimMgt.AddDimSource(DefaultDimSource, Database::Job, Rec."Job No.", FieldNo = Rec.FieldNo("Job No."));
DimMgt.AddDimSource(DefaultDimSource, Database::"Resource Group", Rec."Resource Group No.", FieldNo = Rec.FieldNo("Resource Group No."));
DimMgt.AddDimSource(DefaultDimSource, Database::Location, Rec."Location Code", FieldNo = Rec.FieldNo("Location Code"));
OnAfterInitDefaultDimensionSources(Rec, DefaultDimSource, FieldNo);
end;
local procedure InitLocation()
var
JobTask: Record "Job Task";
begin
if JobTask.Get(Rec."Job No.", Rec."Job Task No.") and (JobTask."Location Code" <> '') then
Validate("Location Code", JobTask."Location Code");
end;
local procedure FindBin(): Boolean
var
JobTask: Record "Job Task";
begin
if JobTask.Get(Rec."Job No.", Rec."Job Task No.") and (JobTask."Bin Code" <> '') then begin
if ("Location Code" <> '') and (JobTask."Location Code" <> "Location Code") then
exit(false);
if WMSManagement.GetDefaultBin("No.", "Variant Code", "Location Code", JobTask."Bin Code") then begin
"Bin Code" := JobTask."Bin Code";
exit(true);
end;
end;
end;
/// <summary>
/// Renumbers the document number of the current job journal line based on the number series specified in the
/// associated job journal batch.
/// </summary>
/// <remarks>
/// An error will be raised if there is an active filter on the document number field.
/// A commit is used during renumbering.
/// </remarks>
procedure RenumberDocumentNo()
var
JobJnlLine2: Record "Job Journal Line";
NoSeries: Codeunit "No. Series";
DocNo: Code[20];
FirstDocNo: Code[20];
FirstTempDocNo: Code[20];
LastTempDocNo: Code[20];
begin
if SkipRenumberDocumentNo() then
exit;
JobJnlBatch.Get("Journal Template Name", "Journal Batch Name");
JobJnlBatch.TestField("No. Series");
if GetFilter("Document No.") <> '' then
Error(DocNoFilterErr);
FirstDocNo := NoSeries.PeekNextNo(JobJnlBatch."No. Series", "Posting Date");
FirstTempDocNo := GetTempRenumberDocumentNo();
// step1 - renumber to non-existing document number
DocNo := FirstTempDocNo;
JobJnlLine2 := Rec;
JobJnlLine2.Reset();
RenumberDocNoOnLines(DocNo, JobJnlLine2);
LastTempDocNo := DocNo;
// step2 - renumber to real document number (within Filter)
DocNo := FirstDocNo;
JobJnlLine2.CopyFilters(Rec);
JobJnlLine2 := Rec;
RenumberDocNoOnLines(DocNo, JobJnlLine2);
// step3 - renumber to real document number (outside filter)
DocNo := IncStr(DocNo);
JobJnlLine2.Reset();
JobJnlLine2.SetRange("Document No.", FirstTempDocNo, LastTempDocNo);
RenumberDocNoOnLines(DocNo, JobJnlLine2);
if Get("Journal Template Name", "Journal Batch Name", "Line No.") then;
end;
local procedure RenumberDocNoOnLines(var DocNo: Code[20]; var JobJnlLine2: Record "Job Journal Line")
var
LastJobJnlLine: Record "Job Journal Line";
JobJnlLine3: Record "Job Journal Line";
NoSeries: Codeunit "No. Series";
PrevDocNo: Code[20];
FirstDocNo: Code[20];
TempFirstDocNo: Code[20];
First: Boolean;
IsHandled: Boolean;
PrevPostingDate: Date;
begin
IsHandled := false;
OnBeforeRenumberDocNoOnLines(DocNo, JobJnlLine2, IsHandled);
if IsHandled then
exit;
FirstDocNo := DocNo;
JobJnlLine2.SetCurrentKey("Journal Template Name", "Journal Batch Name", "Document No.");
JobJnlLine2.SetRange("Journal Template Name", JobJnlLine2."Journal Template Name");
JobJnlLine2.SetRange("Journal Batch Name", JobJnlLine2."Journal Batch Name");
LastJobJnlLine.Init();
First := true;
if JobJnlLine2.FindSet() then
repeat
if ((FirstDocNo <> GetTempRenumberDocumentNo()) and (JobJnlLine2.GetFilter("Document No.") = '')) then begin
Commit();
JobJnlBatch.Get(JobJnlLine2."Journal Template Name", JobJnlLine2."Journal Batch Name");
TempFirstDocNo := NoSeries.PeekNextNo(JobJnlBatch."No. Series", JobJnlLine2."Posting Date");
if (FirstDocNo <> TempFirstDocNo) and (FirstDocNo <> IncStr(TempFirstDocNo)) then begin
DocNo := TempFirstDocNo;
FirstDocNo := DocNo;
First := true;
end;
end;
if JobJnlLine2."Document No." = FirstDocNo then
exit;
if not First and
((JobJnlLine2."Posting Date" <> PrevPostingDate) or
(JobJnlLine2."Document No." = '')) and
not LastJobJnlLine.EmptyLine()
then
DocNo := IncStr(DocNo);
PrevDocNo := JobJnlLine2."Document No.";
PrevPostingDate := JobJnlLine2."Posting Date";
JobJnlLine3.Get(JobJnlLine2."Journal Template Name", JobJnlLine2."Journal Batch Name", JobJnlLine2."Line No.");
JobJnlLine3."Document No." := DocNo;
JobJnlLine3.Modify();
First := false;
LastJobJnlLine := JobJnlLine2;
until JobJnlLine2.Next() = 0;
OnAfterRenumberDocNoOnLines(DocNo, JobJnlLine2);
end;
local procedure SkipRenumberDocumentNo() Result: Boolean
var
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeSkipRenumberDocumentNo(Rec, Result, IsHandled);
if IsHandled then
exit(Result);
exit(GuiAllowed() and not Dialog.Confirm(StrSubstNo(RenumberDocNoQst, ProductName.Short()), true));
end;
local procedure GetTempRenumberDocumentNo(): Code[20]
begin
exit('RENUMBERED-000000001');
end;
local procedure CalcBaseQtyForJobPlanningLine(Qty: Decimal; FromFieldName: Text; ToFieldName: Text; JobPlanningLine: Record "Job Planning Line"): Decimal
begin
exit(UOMMgt.CalcBaseQty(
JobPlanningLine."No.", JobPlanningLine."Variant Code", JobPlanningLine."Unit of Measure Code", Qty, JobPlanningLine."Qty. per Unit of Measure", JobPlanningLine."Qty. Rounding Precision (Base)", FieldCaption("Qty. Rounding Precision"), FromFieldName, ToFieldName));
end;
[IntegrationEvent(false, false)]
local procedure OnAfterInitDefaultDimensionSources(var JobJournalLine: Record "Job Journal Line"; var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]; FieldNo: Integer)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnAfterAssignGLAccountValues(var JobJournalLine: Record "Job Journal Line"; GLAccount: Record "G/L Account")
begin
end;
[IntegrationEvent(false, false)]
local procedure OnAfterAssignItemValues(var JobJournalLine: Record "Job Journal Line"; Item: Record Item)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnAfterAssignResourceValues(var JobJournalLine: Record "Job Journal Line"; Resource: Record Resource; CurrFieldNo: Integer)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnAfterAssignItemUoM(var JobJournalLine: Record "Job Journal Line"; Item: Record Item)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnAfterAssignResourceUoM(var JobJournalLine: Record "Job Journal Line"; Resource: Record Resource)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnAfterAssignGLAccountUoM(var JobJournalLine: Record "Job Journal Line")
begin
end;
[IntegrationEvent(false, false)]
local procedure OnAfterCopyTrackingFromItemLedgEntry(var JobJournalLine: Record "Job Journal Line"; ItemLedgEntry: Record "Item Ledger Entry")
begin
end;
[IntegrationEvent(false, false)]
local procedure OnAfterCopyTrackingFromJobPlanningLine(var JobJournalLine: Record "Job Journal Line"; JobPlanningLine: Record "Job Planning Line")
begin
end;
[IntegrationEvent(false, false)]
local procedure OnAfterDeleteAmounts(var JobJournalLine: Record "Job Journal Line")
begin
end;
[IntegrationEvent(true, false)]
local procedure OnAfterGetLineWithPrice(var LineWithPrice: Interface "Line With Price")
begin
end;
[IntegrationEvent(false, false)]
local procedure OnAfterGetSKU(JobJournalLine: Record "Job Journal Line"; var Result: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnAfterResourceFindCost(var JobJournalLine: Record "Job Journal Line"; var ResourceCost: Record "Resource Cost")
begin
end;
[IntegrationEvent(false, false)]
local procedure OnAfterSetUpNewLine(var JobJournalLine: Record "Job Journal Line"; LastJobJournalLine: Record "Job Journal Line"; JobJournalTemplate: Record "Job Journal Template"; JobJournalBatch: Record "Job Journal Batch")
begin
end;
[IntegrationEvent(false, false)]
local procedure OnAfterShowDimensions(var JobJournalLine: Record "Job Journal Line"; xJobJournalLine: Record "Job Journal Line")
begin
end;
[IntegrationEvent(false, false)]
local procedure OnAfterUpdateDimensions(var JobJournalLine: Record "Job Journal Line"; var DimensionSetIDArr: array[10] of Integer)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnAfterUpdateTotalCost(var JobJournalLine: Record "Job Journal Line"; AmountRoundingPrecision: Decimal; AmountRoundingPrecisionFCY: Decimal)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnAfterUpdateTotalPrice(var JobJournalLine: Record "Job Journal Line")
begin
end;
[IntegrationEvent(false, false)]
local procedure OnAfterUpdateAmountsAndDiscounts(var JobJournalLine: Record "Job Journal Line")
begin
end;
[IntegrationEvent(false, false)]
local procedure OnAfterUpdateUnitPrice(var JobJournalLine: Record "Job Journal Line"; xJobJournalLine: Record "Job Journal Line"; var AmountRoundingPrecision: Decimal; var AmountRoundingPrecisionFCY: Decimal)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnAfterUpdateUnitCost(var JobJournalLine: Record "Job Journal Line"; UnitAmountRoundingPrecision: Decimal; CallingFieldNo: Integer)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeCheckDirectPosting(JobJournalLine: Record "Job Journal Line"; var GLAccount: Record "G/L Account"; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeCheckItemAvailable(var JobJournalLine: Record "Job Journal Line"; var ItemJournalLine: Record "Item Journal Line"; var CheckedAvailability: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeCheckPostingDateNotEmpty(var JobJournalLine: Record "Job Journal Line"; var LineIsEmpty: Boolean)
begin
end;
[IntegrationEvent(true, false)]
local procedure OnBeforeFindPriceAndDiscount(var JobJournalLine: Record "Job Journal Line"; CalledByFieldNo: Integer; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeGetJob(var JobJournalLine: Record "Job Journal Line"; var Job: Record Job; var IsHandled: Boolean);
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeGetLocation(var JobJournalLine: Record "Job Journal Line"; var Location: Record Location; LocationCode: Code[10]; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeHandleCostFactor(var JobJournalLine: Record "Job Journal Line"; Item: Record Item; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeInitRoundingPrecisions(var JobJournalLine: Record "Job Journal Line"; var AmountRoundingPrecision: Decimal; var UnitAmountRoundingPrecision: Decimal; var AmountRoundingPrecisionFCY: Decimal; var UnitAmountRoundingPrecisionFCY: Decimal; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeEmptyLine(var JobJournalLine: Record "Job Journal Line"; var LineIsEmpty: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeRetrieveCostPrice(var JobJournalLine: Record "Job Journal Line"; var xJobJournalLine: Record "Job Journal Line"; var ShouldRetrieveCostPrice: Boolean; var Result: Boolean; CalledByFieldNo: Integer)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeSetUpNewLine(var JobJournalLine: Record "Job Journal Line"; var xJobJournalLine: Record "Job Journal Line"; LastJobJnlLine: Record "Job Journal Line"; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeSetCountryRegionCodeFromJob(var JobJournalLine: Record "Job Journal Line"; Job: Record Job; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeValidateWorkTypeCodeQty(var JobJournalLine: Record "Job Journal Line"; xJobJournalLine: Record "Job Journal Line"; Resource: Record Resource; WorkType: Record "Work Type")
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeValidatePostingDate(var JobJournalLine: Record "Job Journal Line"; xJobJournalLine: Record "Job Journal Line"; CurrentFieldNo: Integer; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeValidateQuantity(var JobJournalLine: Record "Job Journal Line"; xJobJournalLine: Record "Job Journal Line"; CurrentFieldNo: Integer; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeValidateVariantCode(var JobJournalLine: Record "Job Journal Line"; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeValidateUnitofMeasureCode(var JobJournalLine: Record "Job Journal Line"; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeValidateJobNo(var JobJournalLine: Record "Job Journal Line"; var Customer: Record Customer; var DimensionManagement: Codeunit DimensionManagement; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(true, false)]
local procedure OnBeforeUpdateAllAmounts(var JobJournalLine: Record "Job Journal Line"; xJobJournalLine: Record "Job Journal Line"; CallingFieldNo: Integer; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeUpdateUnitCost(var JobJounralLine: Record "Job Journal Line"; var IsHandled: Boolean; xJobJounralLine: Record "Job Journal Line")
begin
end;
[IntegrationEvent(false, false)]
local procedure OnAfterSetReservationFilters(var ReservEntry: Record "Reservation Entry"; JobJournalLine: Record "Job Journal Line");
begin
end;
[IntegrationEvent(true, false)]
local procedure OnAfterUpdateAllAmounts(var JobJournalLine: Record "Job Journal Line"; xJobJournalLine: Record "Job Journal Line")
begin
end;
[IntegrationEvent(false, false)]
local procedure OnAfterValidateShortcutDimCode(var JobJournalLine: Record "Job Journal Line"; var xJobJournalLine: Record "Job Journal Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20])
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeCheckResource(var JobJournalLine: Record "Job Journal Line"; Resource: Record Resource; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeCreateDim(var JobJournalLine: Record "Job Journal Line"; var IsHandled: Boolean; CurrentFieldNo: Integer)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeFindBinContent(var JobJournalLine: Record "Job Journal Line"; xJobJournalLine: Record "Job Journal Line"; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeBinContentLookUp(var JobJournalLine: Record "Job Journal Line"; xJobJournalLine: Record "Job Journal Line"; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeTestUnitOfMeasureCode(var JobJournalLine: Record "Job Journal Line"; WorkType: Record "Work Type"; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeUpdateAmountsAndDiscounts(var JobJournalLine: Record "Job Journal Line"; xJobJournalLine: Record "Job Journal Line"; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeValidateChargeable(var JobJournalLine: Record "Job Journal Line"; var IsHandled: Boolean; xJobJournalLine: Record "Job Journal Line")
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeValidateShortcutDimCode(var JobJournalLine: Record "Job Journal Line"; var xJobJournalLine: Record "Job Journal Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20])
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeValidateWorkTypeCode(var JobJournalLine: Record "Job Journal Line"; var xJobJournalLine: Record "Job Journal Line"; var IsLineDiscountHandled: Boolean; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnCheckItemAvailableOnBeforeAssignQuantity(var JobJournalLine: Record "Job Journal Line"; var ItemJournalLine: Record "Item Journal Line"; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnCheckDirectedPutawayandPickIsFalseOnBeforeTestField(var Location: Record Location; CallingFieldNo: Integer; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnCopyFromItemOnAfterCheckItem(var JobJournalLine: Record "Job Journal Line"; Item: Record Item)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnCopyFromResourceOnAfterCheckResource(var JobJournalLine: Record "Job Journal Line"; Resource: Record Resource; CurrentFieldNo: Integer)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnSelectItemEntryOnAfterSetItemLedgerEntryFilters(var ItemLedgEntry: Record "Item Ledger Entry"; CurrentFieldNo: Integer; var JobJournalLine: Record "Job Journal Line")
begin
end;
[IntegrationEvent(false, false)]
local procedure OnUpdateCurrencyFactorOnBeforeGetExchangeRate(JobJournalLine: Record "Job Journal Line"; var CurrencyExchangeRate: Record "Currency Exchange Rate")
begin
end;
[IntegrationEvent(false, false)]
local procedure OnValidateJobNoOnBeforeCheckJob(var JobJournalLine: Record "Job Journal Line"; xJobJournalLine: Record "Job Journal Line"; var Customer: Record Customer; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnValidateJobTaskNoOnAfterTestJobTaskType(var JobJournalLine: Record "Job Journal Line"; xJobJournalLine: Record "Job Journal Line"; JobTask: Record "Job Task")
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeValidateJobTaskNo(var JobJournalLine: Record "Job Journal Line"; var xJobJournalLine: Record "Job Journal Line"; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeCopyFromGLAccount(var JobJournalLine: Record "Job Journal Line"; GLAccount: Record "G/L Account"; CurrFieldNo: Integer; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeCopyFromItem(var JobJournalLine: Record "Job Journal Line"; Item: Record Item; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeCopyFromResource(var JobJournalLine: Record "Job Journal Line"; Resource: Record Resource; CurrentFieldNo: Integer; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnValidateLocationCodeOnBeforeGetLocation(var JobJournalLine: Record "Job Journal Line")
begin
end;
[IntegrationEvent(false, false)]
local procedure OnValidateVariantCodeOnBeforeValidateQuantity(var JobJournalLine: Record "Job Journal Line"; xJobJournalLine: Record "Job Journal Line"; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnAfterCreateDim(var JobJournalLine: Record "Job Journal Line"; CurrFieldNo: Integer; xJobJournalLine: Record "Job Journal Line"; OldDimSetID: Integer; DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])
begin
end;
[IntegrationEvent(false, false)]
local procedure OnValidateUnitOfMeasureCodeOnBeforeOnBeforeValidateQuantity(var JobJournalLine: Record "Job Journal Line"; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnValidateNoOnBeforeValidateQuantity(var JobJournalLine: Record "Job Journal Line"; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnValidateUnitCostLCYOnAfterConvertAmountToFCY(var JobJournalLine: Record "Job Journal Line")
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeUpdateDimensions(var JobJournalLine: Record "Job Journal Line"; CurrentFieldNo: Integer; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnSetUpNewLineOnNewLine(var JobJournalLine: Record "Job Journal Line"; var JobJournalTemplate: Record "Job Journal Template"; var JobJournalBatch: Record "Job Journal Batch");
begin
end;
[IntegrationEvent(false, false)]
local procedure OnCopyFromItemOnBeforeValidateUoMCode(var JobJournalLine: Record "Job Journal Line"; Item: Record Item; var IsHandled: Boolean);
begin
end;
[IntegrationEvent(false, false)]
local procedure OnAfterInitTableValuePair(var JobJournalLine: Record "Job Journal Line"; var TableValuePair: Dictionary of [Integer, Code[20]]; FieldNo: Integer)
begin
end;
[IntegrationEvent(true, false)]
local procedure OnBeforeSkipRenumberDocumentNo(JobJournalLine: Record "Job Journal Line"; var Result: Boolean; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnBeforeRenumberDocNoOnLines(var DocNo: Code[20]; var JobJnlLine2: Record "Job Journal Line"; var IsHandled: Boolean)
begin
end;
[IntegrationEvent(false, false)]
local procedure OnAfterRenumberDocNoOnLines(var DocNo: Code[20]; var JobJnlLine2: Record "Job Journal Line")
begin
end;
[IntegrationEvent(false, false)]
internal procedure OnBeforeValidateJobPlanningLineLink(var JobJournalLine: Record "Job Journal Line"; xJobJournalLine: Record "Job Journal Line"; var IsHandled: Boolean);
begin
end;
}