Table "Value Entry"

ID 5802

Namespace: Microsoft.Inventory.Ledger

Properties

Name	Value
Caption	Value Entry
DrillDownPageID	Page Microsoft.Inventory.Ledger."Value Entries"
LookupPageID	Page Microsoft.Inventory.Ledger."Value Entries"
Permissions	TableData "Value Entry" = ri
DataClassification	CustomerContent

Fields

Name	Type	Description
"Entry No."	Integer	Specifies the number of the entry, as assigned from the specified number series when the entry was created.
"Item No."	Code[20]	Specifies the number of the item that this value entry is linked to.
"Posting Date"	Date	Specifies the posting date of this entry.
"Item Ledger Entry Type"	Enum Microsoft.Inventory.Ledger."Item Ledger Entry Type"	Specifies the type of item ledger entry that caused this value entry.
"Source No."	Code[20]	Specifies the number of the source document that the entry originates from.
"Document No."	Code[20]	Specifies the document number of the entry.
Description	Text[100]	Specifies a description of the entry.
"Location Code"	Code[10]	Specifies the code for the location of the item that the entry is linked to.
"Inventory Posting Group"	Code[20]
"Source Posting Group"	Code[20]	Specifies the posting group for the item, customer, or vendor for the item entry that this value entry is linked to.
"Item Ledger Entry No."	Integer	Specifies the number of the item ledger entry that this value entry is linked to.
"Valued Quantity"	Decimal	Specifies the quantity that the adjusted cost and the amount of the entry belongs to.
"Item Ledger Entry Quantity"	Decimal	Specifies the average cost calculation.
"Invoiced Quantity"	Decimal	Specifies how many units of the item are invoiced by the posting that the value entry line represents.
"Cost per Unit"	Decimal	Specifies the cost for one base unit of the item in the entry.
"Sales Amount (Actual)"	Decimal
"Item Register No."	Integer
"SIFT Bucket No."	Integer	Specifies an automatically generated number that is used by the system to enable better concurrency.
"Salespers./Purch. Code"	Code[20]	Specifies which salesperson or purchaser is linked to the entry.
"Discount Amount"	Decimal	Specifies the total discount amount of this value entry.
"User ID"	Code[50]	Specifies the ID of the user who posted the entry, to be used, for example, in the change log.
"Source Code"	Code[10]	Specifies the source code that specifies where the entry was created.
"Applies-to Entry"	Integer
"Global Dimension 1 Code"	Code[20]	Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company's most important activities, are available on all cards, documents, reports, and lists.
"Global Dimension 2 Code"	Code[20]	Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company's most important activities, are available on all cards, documents, reports, and lists.
"Source Type"	Enum Microsoft.Foundation.Enums."Analysis Source Type"	Specifies the source type that applies to the source number that is shown in the Source No. field.
"Cost Amount (Actual)"	Decimal
"Cost Posted to G/L"	Decimal	Specifies the amount that has been posted to the general ledger.
"Reason Code"	Code[10]
"Drop Shipment"	Boolean
"Journal Batch Name"	Code[10]
"Gen. Bus. Posting Group"	Code[20]	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.
"Gen. Prod. Posting Group"	Code[20]	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.
"Document Date"	Date	Specifies the date when the related document was created.
"External Document No."	Code[35]	Specifies a document number that refers to the customer's or vendor's numbering system.
"Cost Amount (Actual) (ACY)"	Decimal
"Cost Posted to G/L (ACY)"	Decimal
"Cost per Unit (ACY)"	Decimal
"Document Type"	Enum Microsoft.Inventory.Ledger."Item Ledger Document Type"	Specifies what type of document was posted to create the value entry.
"Document Line No."	Integer	Specifies the line number of the line on the posted document that corresponds to the value entry.
"VAT Reporting Date"	Date
"Order Type"	Enum Microsoft.Foundation.Enums."Inventory Order Type"	Specifies which type of order that the entry was created in.
"Order No."	Code[20]	Specifies the number of the order that created the entry.
"Order Line No."	Integer
"Expected Cost"	Boolean
"Item Charge No."	Code[20]	Specifies the item charge number of the value entry.
"Valued By Average Cost"	Boolean	Specifies if the adjusted cost for the inventory decrease is calculated by the average cost of the item at the valuation date.
"Partial Revaluation"	Boolean
Inventoriable	Boolean
"Valuation Date"	Date	Specifies the valuation date from which the entry is included in the average cost calculation.
"Entry Type"	Enum Microsoft.Inventory.Costing."Cost Entry Type"	Specifies the type of value described in this entry.
"Variance Type"	Enum Microsoft.Inventory.Costing."Cost Variance Type"	Specifies the type of variance described in this entry.
"Purchase Amount (Actual)"	Decimal
"Purchase Amount (Expected)"	Decimal
"Sales Amount (Expected)"	Decimal
"Cost Amount (Expected)"	Decimal
"Cost Amount (Non-Invtbl.)"	Decimal
"Cost Amount (Expected) (ACY)"	Decimal
"Cost Amount (Non-Invtbl.)(ACY)"	Decimal
"Expected Cost Posted to G/L"	Decimal	Specifies the expected cost amount that has been posted to the interim account in the general ledger.
"Exp. Cost Posted to G/L (ACY)"	Decimal
"Dimension Set ID"	Integer	Specifies a reference to a combination of dimension values. The actual values are stored in the Dimension Set Entry table.
"Shortcut Dimension 3 Code"	Code[20]	Specifies the code for Shortcut Dimension 3, which is one of dimension codes that you set up in the General Ledger Setup window.
"Shortcut Dimension 4 Code"	Code[20]	Specifies the code for Shortcut Dimension 4, which is one of dimension codes that you set up in the General Ledger Setup window.
"Shortcut Dimension 5 Code"	Code[20]	Specifies the code for Shortcut Dimension 5, which is one of dimension codes that you set up in the General Ledger Setup window.
"Shortcut Dimension 6 Code"	Code[20]	Specifies the code for Shortcut Dimension 6, which is one of dimension codes that you set up in the General Ledger Setup window.
"Shortcut Dimension 7 Code"	Code[20]	Specifies the code for Shortcut Dimension 7, which is one of dimension codes that you set up in the General Ledger Setup window.
"Shortcut Dimension 8 Code"	Code[20]	Specifies the code for Shortcut Dimension 8, which is one of dimension codes that you set up in the General Ledger Setup window.
"Job No."	Code[20]	Specifies the number of the project that the value entry relates to.
"Job Task No."	Code[20]	Specifies the number of the related project task.
"Job Ledger Entry No."	Integer	Specifies the number of the project ledger entry that the value entry relates to.
"Variant Code"	Code[10]
Adjustment	Boolean	Specifies if this entry has been cost adjusted.
"Average Cost Exception"	Boolean
"Capacity Ledger Entry No."	Integer	Specifies the entry number of the item ledger entry that this value entry is linked to.
Type	Enum Microsoft.Manufacturing.Capacity."Capacity Type Journal"	Specifies the type of value entry when it relates to a capacity entry.
"No."	Code[20]	Specifies the number of the involved entry or record, according to the specified number series.
"Return Reason Code"	Code[10]	Specifies the code explaining why the item was returned.
"Item Description"	Text[100]	Specifies the description of the item that this value entry is linked to. Analysis mode must be used for sorting and filtering on this field.
SystemId	Guid
SystemCreatedAt	DateTime
SystemCreatedBy	Guid
SystemModifiedAt	DateTime
SystemModifiedBy	Guid
SystemCreatedByUserName	Text[50]
SystemCreatedByFullName	Text[80]
SystemModifiedByUserName	Text[50]
SystemModifiedByFullName	Text[80]
SystemRowVersion	BigInteger

Methods

GetNextEntryNo

[InherentPermissions(TableData,5802,r)]
procedure GetNextEntryNo(): Integer

Returns

Type	Description
Integer

GetLastEntryNo

[InherentPermissions(TableData,5802,r)]
procedure GetLastEntryNo(): Integer

Returns

Type	Description
Integer

GetValuationDate

procedure GetValuationDate(): Date

Returns

Type	Description
Date

AddCost

procedure AddCost(InvtAdjmtBuffer: Record "Inventory Adjustment Buffer")

Parameters

Name	Type	Description
InvtAdjmtBuffer	Table Microsoft.Inventory.Costing."Inventory Adjustment Buffer"

SumCostsTillValuationDate

procedure SumCostsTillValuationDate(var ValueEntry: Record "Value Entry")

Parameters

Name	Type	Description
ValueEntry	Table Microsoft.Inventory.Ledger."Value Entry"

CalcItemLedgEntryCost

procedure CalcItemLedgEntryCost(ItemLedgEntryNo: Integer; Expected: Boolean)

Parameters

Name	Type	Description
ItemLedgEntryNo	Integer
Expected	Boolean

NotInvdRevaluationExists

procedure NotInvdRevaluationExists(ItemLedgEntryNo: Integer): Boolean

Parameters

Name	Type	Description
ItemLedgEntryNo	Integer

Returns

Type	Description
Boolean

CalcQtyFactor

procedure CalcQtyFactor(FromDate: Date; ToDate: Date): Decimal

Parameters

Name	Type	Description
FromDate	Date
ToDate	Date

Returns

Type	Description
Decimal

ShowGL

procedure ShowGL()

IsAvgCostException

Obsolete

This element will become obsolete from version 27.0. Moved to the Inventory Adjustment codeunit

[Obsolete(Moved to the Inventory Adjustment codeunit,27.0)]
procedure IsAvgCostException(IsAvgCostCalcTypeItem: Boolean): Boolean

Parameters

Name	Type	Description
IsAvgCostCalcTypeItem	Boolean

Returns

Type	Description
Boolean

ShowDimensions

procedure ShowDimensions()

GetAvgToDate

procedure GetAvgToDate(ToDate: Date): Date

Parameters

Name	Type	Description
ToDate	Date

Returns

Type	Description
Date

GetAvgFromDate

procedure GetAvgFromDate(ToDate: Date; var AccountingPeriod: Record "Accounting Period"; var CostCalcIsChanged: Boolean): Date

Parameters

Name	Type	Description
ToDate	Date
AccountingPeriod	Table Microsoft.Foundation.Period."Accounting Period"
CostCalcIsChanged	Boolean

Returns

Type	Description
Date

FindFirstValueEntryByItemLedgerEntryNo

procedure FindFirstValueEntryByItemLedgerEntryNo(ItemLedgerEntryNo: Integer)

Parameters

Name	Type	Description
ItemLedgerEntryNo	Integer

IsInbound

procedure IsInbound(): Boolean

Returns

Type	Description
Boolean

Events

OnBeforeCheckApplyLocationVariantFilters

[IntegrationEvent(False,False)]
local procedure OnBeforeCheckApplyLocationVariantFilters(var RecValueEntry: Record "Value Entry"; AccountingPeriod: Record "Accounting Period"; ValueEntry: Record "Value Entry"; var IsHandled: Boolean; Item: Record Item; CostCalcIsChanged: Boolean; var QtyFactor: Decimal; FromDate: Date; ToDate: Date)

Parameters

Name	Type	Description
RecValueEntry	Table Microsoft.Inventory.Ledger."Value Entry"
AccountingPeriod	Table Microsoft.Foundation.Period."Accounting Period"
ValueEntry	Table Microsoft.Inventory.Ledger."Value Entry"
IsHandled	Boolean
Item	Table Microsoft.Inventory.Item.Item
CostCalcIsChanged	Boolean
QtyFactor	Decimal
FromDate	Date
ToDate	Date

OnSumCostsTillValuationDateOnAfterCalcSums

[IntegrationEvent(False,False)]
local procedure OnSumCostsTillValuationDateOnAfterCalcSums(var ValueEntry: Record "Value Entry")

Parameters

Name	Type	Description
ValueEntry	Table Microsoft.Inventory.Ledger."Value Entry"

OnSumCostsTillValuationDateOnAfterGetItem

[IntegrationEvent(False,False)]
local procedure OnSumCostsTillValuationDateOnAfterGetItem(var Item: Record Item; var ValueEntry: Record "Value Entry")

Parameters

Name	Type	Description
Item	Table Microsoft.Inventory.Item.Item
ValueEntry	Table Microsoft.Inventory.Ledger."Value Entry"

OnSumCostsTillValuationDateOnAfterSetFilters

[IntegrationEvent(False,False)]
local procedure OnSumCostsTillValuationDateOnAfterSetFilters(var ValueEntryRec: Record "Value Entry"; var ValueEntry: Record "Value Entry"; var Item: Record Item)

Parameters

Name	Type	Description
ValueEntryRec	Table Microsoft.Inventory.Ledger."Value Entry"
ValueEntry	Table Microsoft.Inventory.Ledger."Value Entry"
Item	Table Microsoft.Inventory.Item.Item

OnSumCostsTillValuationDateOnAfterSetCostAmounts

[IntegrationEvent(False,False)]
local procedure OnSumCostsTillValuationDateOnAfterSetCostAmounts(var ValueEntry: Record "Value Entry"; PrevValueEntrySum: Record "Value Entry"; QtyFactor: Decimal)

Parameters

Name	Type	Description
ValueEntry	Table Microsoft.Inventory.Ledger."Value Entry"
PrevValueEntrySum	Table Microsoft.Inventory.Ledger."Value Entry"
QtyFactor	Decimal

OnShowGLOnBeforeCopyToTempGLEntry

[IntegrationEvent(False,False)]
local procedure OnShowGLOnBeforeCopyToTempGLEntry(var GLEntry: Record "G/L Entry"; var GLItemLedgRelation: Record "G/L - Item Ledger Relation")

Parameters

Name	Type	Description
GLEntry	Table Microsoft.Finance.GeneralLedger.Ledger."G/L Entry"
GLItemLedgRelation	Table Microsoft.Inventory.Ledger."G/L - Item Ledger Relation"

OnBeforeCalcItemLedgEntryCost

[IntegrationEvent(False,False)]
local procedure OnBeforeCalcItemLedgEntryCost(var ValueEntry: Record "Value Entry"; ItemLedgEntryNo: Integer; Expected: Boolean; var IsHandled: Boolean)

Parameters

Name	Type	Description
ValueEntry	Table Microsoft.Inventory.Ledger."Value Entry"
ItemLedgEntryNo	Integer
Expected	Boolean
IsHandled	Boolean

OnBeforeAddCost

[IntegrationEvent(False,False)]
local procedure OnBeforeAddCost(var ValueEntry: Record "Value Entry"; InvtAdjmtBuffer: Record "Inventory Adjustment Buffer")

Parameters

Name	Type	Description
ValueEntry	Table Microsoft.Inventory.Ledger."Value Entry"
InvtAdjmtBuffer	Table Microsoft.Inventory.Costing."Inventory Adjustment Buffer"

See also

• Table