Table 27 Item

Base Application, Microsoft.Inventory.Item

src/Layers/W1/BaseApp/Inventory/Item/Item.Table.al107 procedures and triggers, in source order. Copyright (c) Microsoft Corporation. MIT

No..OnValidate line 79, trigger

  1. 84raisesOnBeforeValidateNoIsHandled
  2. 88callsGetInvtSetup
  3. 89callsCodeunit 310 No. Series TestManual

Description.OnValidate line 108, trigger

  1. 119writesTable 5718 Nonstock Item Modify
  2. 123callsUpdateMyItem

Base Unit of Measure.OnValidate line 153, trigger

  1. 161raisesOnBeforeValidateBaseUnitOfMeasureIsHandled
  2. 167writesTable 27 Item Insert(true)
  3. 169callsUpdateUnitOfMeasureId
  4. 171raisesOnValidateBaseUnitOfMeasure
  5. 177callsTestNoOpenEntriesExist
  6. 190callsCreateItemUnitOfMeasure
  7. 194callsUpdateQtyRoundingPrecisionForBaseUoM

Type.OnValidate line 210, trigger

  1. 215raisesOnValidateTypeOnBeforeCheckExistsItemLedgerEntryIsHandled
  2. 217callsExistsItemLedgerEntry
  3. 219callsTestNoWhseEntriesExist
  4. 220callsCheckJournalsAndWorksheets
  5. 221callsCheckDocuments
  6. 222callsIsNonInventoriableType
  7. 223callsCheckUpdateFieldsForNonInventoriableItem

Unit Price.OnValidate line 282, trigger

  1. 284validatesTable 27 Item Price/Profit Calculation
  2. 286callsUpdateMyItem

Price/Profit Calculation.OnValidate line 294, trigger

  1. 305callsCalcVAT
  2. 310callsGetGLSetup
  3. 314callsCalcVAT
  4. 316callsUpdateMyItem

Profit %.OnValidate line 328, trigger

  1. 330validatesTable 27 Item Price/Profit Calculation

Costing Method.OnValidate line 338, trigger

  1. 358callsTestNoEntriesExist
  2. 360callsCodeunit 5804 ItemCostManagement UpdateUnitCost

Unit Cost.OnValidate line 371, trigger

  1. 376raisesOnBeforeValidateUnitCostIsHandled
  2. 380callsIsNonInventoriableType
  3. 384validatesTable 27 Item Standard Cost
  4. 386callsTestNoEntriesExist
  5. 387validatesTable 27 Item Price/Profit Calculation

Standard Cost.OnValidate line 398, trigger

  1. 403raisesOnBeforeValidateStandardCostIsHandled
  2. 421callsCodeunit 5804 ItemCostManagement UpdateUnitCost

Indirect Cost %.OnValidate line 440, trigger

  1. 445callsAdjustCostIfRequired
  2. 447callsCodeunit 5804 ItemCostManagement UpdateUnitCost

Lead Time Calculation.OnValidate line 492, trigger

  1. 494callsCodeunit 5404 Lead-Time Management CheckLeadTimeIsNotNegative

Net Weight.OnValidate line 565, trigger

  1. 567callsUpdateItemUnitOfMeasureWeight

Tariff No..OnValidate line 601, trigger

  1. 618writesTable 260 Tariff Number Insert

Price Includes VAT.OnValidate line 983, trigger

  1. 994validatesTable 27 Item Price/Profit Calculation

VAT Bus. Posting Gr. (Price).OnValidate line 1008, trigger

  1. 1010validatesTable 27 Item Price/Profit Calculation

Gen. Prod. Posting Group.OnValidate line 1019, trigger

  1. 1027raisesOnValidateGenProdPostingGroupOnConfirmChange
  2. 1032callsTable 251 Gen. Product Posting Group ValidateVatProdPostingGroup
  3. 1033validatesTable 27 Item VAT Prod. Posting Group
  4. 1044validatesTable 27 Item Price/Profit Calculation

Tax Group Code.OnValidate line 1110, trigger

  1. 1112callsUpdateTaxGroupId

VAT Prod. Posting Group.OnValidate line 1121, trigger

  1. 1123validatesTable 27 Item Price/Profit Calculation

Global Dimension 1 Code.OnValidate line 1196, trigger

  1. 1198callsValidateShortcutDimCode

Global Dimension 2 Code.OnValidate line 1208, trigger

  1. 1210callsValidateShortcutDimCode

Assembly Policy.OnValidate line 1328, trigger

  1. 1332callsIsNonInventoriableType

Inventory Value Zero.OnValidate line 1450, trigger

  1. 1452callsCheckForProductionOutput

Replenishment System.OnValidate line 1513, trigger

  1. 1523raisesOnValidateReplenishmentSystemCaseTransferIsHandled
  2. 1530raisesOnValidateReplenishmentSystemCaseAssemblyrIsHandled
  3. 1535raisesOnValidateReplenishmentSystemCaseElse

Time Bucket.OnValidate line 1588, trigger

  1. 1590callsCodeunit 7600 Calendar Management CheckDateFormulaPositive

Rescheduling Period.OnValidate line 1644, trigger

  1. 1646callsCodeunit 7600 Calendar Management CheckDateFormulaPositive

Lot Accumulation Period.OnValidate line 1655, trigger

  1. 1657callsCodeunit 7600 Calendar Management CheckDateFormulaPositive

Dampener Period.OnValidate line 1666, trigger

  1. 1668callsCodeunit 7600 Calendar Management CheckDateFormulaPositive

Item Category Code.OnValidate line 1741, trigger

  1. 1746callsCodeunit 7500 Item Attribute Management InheritAttributesFromItemCategory
  2. 1747callsUpdateItemCategoryId
  3. 1749raisesOnAfterValidateItemCategoryCode

Item Tracking Code.OnValidate line 1861, trigger

  1. 1878raisesOnValidateItemTrackingCodeOnBeforeTestNoEntriesExistIsHandled
  2. 1879callsTable 6502 Item Tracking Code IsSpecificTrackingChanged
  3. 1881callsTestNoEntriesExist
  4. 1883callsTable 6502 Item Tracking Code IsWarehouseTrackingChanged
  5. 1884callsTestNoWhseEntriesExist
  6. 1887callsTestNoEntriesExist
  7. 1900callsTestNoOpenDocumentsWithTrackingExist
  8. 1903callsItemTrackingCodeUseExpirationDates

Expiration Calculation.OnValidate line 1924, trigger

  1. 1927callsItemTrackingCodeUseExpirationDates

Phys Invt Counting Period Code.OnValidate line 2027, trigger

  1. 2040raisesOnValidatePhysInvtCountingPeriodCodeOnBeforeConfirmUpdateIsHandled
  2. 2055callsCodeunit 7380 Phys. Invt. Count.-Management CalcPeriod

Unit of Measure Id.OnValidate line 2124, trigger

  1. 2126callsUpdateUnitOfMeasureCode

Tax Group Id.OnValidate line 2134, trigger

  1. 2136callsUpdateTaxGroupCode

Item Category Id.OnValidate line 2157, trigger

  1. 2159callsUpdateItemCategoryCode

Inventory Posting Group Id.OnValidate line 2167, trigger

  1. 2175validatesTable 27 Item Inventory Posting Group
  2. 2177validatesTable 27 Item Inventory Posting Group

Gen. Prod. Posting Group Id.OnValidate line 2184, trigger

  1. 2196validatesTable 27 Item Gen. Prod. Posting Group
  2. 2198validatesTable 27 Item Gen. Prod. Posting Group

Overhead Rate.OnValidate line 2293, trigger

  1. 2298callsAdjustCostIfRequired

Order Tracking Policy.OnValidate line 2410, trigger

  1. 2423raisesOnValidateOrderTrackingPolicyOnBeforeUpdateReservation
  2. 2434writesTable 99000849 Action Message Entry DeleteAll
  3. 2436callsTable 337 Reservation Entry TrackingExists
  4. 2439writesTable 337 Reservation Entry Insert
  5. 2441writesTable 337 Reservation Entry Delete
  6. 2447writesTable 337 Reservation Entry Modify

OnDelete line 2564, trigger

  1. 2569raisesOnBeforeOnDeleteIsHandled
  2. 2573callsCodeunit 1535 Approvals Mgmt. OnCancelItemApprovalRequest
  3. 2575callsCheckJournalsAndWorksheets
  4. 2576callsCheckDocuments
  5. 2578callsCodeunit 361 MoveEntries MoveItemEntries
  6. 2581callsRunCostAdjustment
  7. 2583callsDeleteRelatedData
  8. 2585callsDeleteItemUnitGroup

OnInsert line 2588, trigger

  1. 2594raisesOnBeforeOnInsertIsHandled
  2. 2597callsGetInvtSetup
  3. 2599callsCodeunit 310 No. Series AreRelated
  4. 2603callsCodeunit 310 No. Series GetNextNo
  5. 2607callsCodeunit 310 No. Series GetNextNo
  6. 2609raisesOnInsertOnAfterAssignNo
  7. 2612callsCodeunit 408 DimensionManagement UpdateDefaultDim
  8. 2616callsUpdateReferencedIds
  9. 2617callsSetLastDateTimeModified
  10. 2619callsUpdateItemUnitGroup
  11. 2622raisesOnAfterOnInsert

OnModify line 2625, trigger

  1. 2629callsUpdateReferencedIds
  2. 2630callsSetLastDateTimeModified
  3. 2633raisesOnModifyOnBeforePlanningAssignmentItemChangeIsHandled
  4. 2635callsTable 99000850 Planning Assignment ItemChange
  5. 2637callsUpdateItemUnitGroup

OnRename line 2640, trigger

  1. 2648callsTable 37 Sales Line RenameNo
  2. 2649callsTable 39 Purchase Line RenameNo
  3. 2650callsTable 5741 Transfer Line RenameNo
  4. 2651callsCodeunit 408 DimensionManagement RenameDefaultDim
  5. 2652callsTable 97 Comment Line RenameCommentLine
  6. 2653callsTable 1003 Job Planning Line RenameNo
  7. 2655callsCodeunit 1535 Approvals Mgmt. OnRenameRecordInApprovalRequest
  8. 2656callsTable 7505 Item Attribute Value Mapping RenameItemAttributeValueMapping
  9. 2657callsSetLastDateTimeModified
  10. 2659callsUpdateItemUnitGroup

DeleteRelatedData line 2758, local

  1. 2769writesTable 7134 Item Budget Entry DeleteAll(true)
  2. 2774writesTable 5715 Item Substitution DeleteAll
  3. 2779writesTable 5715 Item Substitution DeleteAll
  4. 2784writesTable 5700 Stockkeeping Unit DeleteAll
  5. 2786callsCodeunit 5703 Catalog Item Management NonstockItemDel
  6. 2789writesTable 97 Comment Line DeleteAll
  7. 2793writesTable 99 Item Vendor DeleteAll
  8. 2796writesTable 5777 Item Reference DeleteAll
  9. 2799writesTable 459 Sales Prepayment % DeleteAll
  10. 2802writesTable 460 Purchase Prepayment % DeleteAll
  11. 2805writesTable 30 Item Translation DeleteAll
  12. 2808writesTable 5404 Item Unit of Measure DeleteAll
  13. 2811writesTable 5401 Item Variant DeleteAll
  14. 2815writesTable 279 Extended Text Header DeleteAll(true)
  15. 2818writesTable 7154 Item Analysis View Entry DeleteAll
  16. 2821writesTable 7156 Item Analysis View Budg. Entry DeleteAll
  17. 2824writesTable 99000850 Planning Assignment DeleteAll
  18. 2828writesTable 90 BOM Component DeleteAll
  19. 2830callsCodeunit 408 DimensionManagement DeleteDefaultDim
  20. 2835writesTable 7704 Item Identifier DeleteAll
  21. 2839writesTable 7302 Bin Content DeleteAll
  22. 2842writesTable 9152 My Item DeleteAll
  23. 2847writesTable 7505 Item Attribute Value Mapping DeleteAll
  24. 2849callsDeleteItemVariantAttributes
  25. 2854writesTable 2000000132 Entity Text DeleteAll
  26. 2857writesTable 5310 Item Statistics Cache DeleteAll
  27. 2859raisesOnAfterDeleteRelatedData

AssistEdit line 2862

  1. 2867raisesOnBeforeAssistEditIsHandled
  2. 2871callsGetInvtSetup
  3. 2873callsCodeunit 310 No. Series LookupRelatedNoSeries
  4. 2874callsCodeunit 310 No. Series GetNextNo
  5. 2877raisesOnAssistEditOnAfterAssignNo

FindItemVend line 2882

  1. 2888raisesOnBeforeFindItemVendIsHandled
  2. 2897raisesOnFindItemVendOnAfterSetFilters
  3. 2902callsCodeunit 99000855 Planning-Get Parameters AtSKU
  4. 2909raisesOnFindItemVendOnAfterFindItemVend
  5. 2910callsTable 99 Item Vendor FindLeadTimeCalculation
  6. 2913raisesOnAfterFindItemVend

ValidateShortcutDimCode line 2916

  1. 2918raisesOnBeforeValidateShortcutDimCode
  2. 2920callsCodeunit 408 DimensionManagement ValidateDimValueCode
  3. 2922callsCodeunit 408 DimensionManagement SaveDefaultDim
  4. 2923writesTable 27 Item Modify
  5. 2926raisesOnAfterValidateShortcutDimCode

TestNoEntriesExist line 2929

  1. 2939raisesOnBeforeTestNoItemLedgEntiesExistIsHandled
  2. 2947raisesOnBeforeTestNoPurchLinesExistIsHandled

TestNoWhseEntriesExist line 2961

  1. 2967raisesOnBeforeTestNoWhseEntriesExistIsHandled

TestNoOpenEntriesExist line 2979

  1. 2985raisesOnBeforeTestNoOpenEntriesExistIsHandled

TestNoOpenDocumentsWithTrackingExist line 2998, local

  1. 3008raisesOnBeforeTestNoOpenDocumentsWithTrackingExistIsHandled

GetSKU line 3044

  1. 3048callsCodeunit 99000855 Planning-Get Parameters AtSKU

IsMfgItem line 3059

  1. 3061raisesOnIsMfgItem
  2. 3062raisesOnAfterIsMfgItem

IsProductionBOM line 3065

  1. 3067raisesOnIsProductionBOM

IsAssemblyItem line 3070

  1. 3072raisesOnIsAssemblyItem
  2. 3073raisesOnAfterIsAssemblyItem

HasBOM line 3076

  1. 3082raisesOnAfterHasBOM

HasRoutingNo line 3086

  1. 3088raisesOnAfterHasRoutingNo

CheckSerialNoQty line 3098

  1. 3113callsCheckSNSpecificTrackingInteger

CheckSNSpecificTrackingInteger line 3116, local

  1. 3121raisesOnBeforeCheckSNSpecificTrackingIntegerIsHandled

CheckJournalsAndWorksheets line 3151

  1. 3153callsCheckItemJnlLine
  2. 3154callsCheckStdCostWksh
  3. 3155callsCheckReqLine

CheckItemJnlLine line 3158, local

  1. 3166raisesOnBeforeCheckItemJnlLineIsHandled

CheckStdCostWksh line 3179, local

  1. 3188raisesOnBeforeCheckStdCostWkshIsHandled

CheckReqLine line 3200, local

  1. 3208raisesOnBeforeCheckReqLineIsHandled

CheckDocuments line 3228

  1. 3236raisesOnBeforeCheckDocumentsIsHandled
  2. 3240raisesOnAfterCheckDocuments

CheckTransLine line 3257

  1. 3261callsCodeunit 9134 Check Transfer Document CheckTransferLines

CheckUpdateFieldsForNonInventoriableItem line 3266

  1. 3271raisesOnBeforeCheckUpdateFieldsForNonInventoriableItemIsHandled
  2. 3281validatesTable 27 Item Assembly Policy
  3. 3282validatesTable 27 Item Replenishment System
  4. 3283validatesTable 27 Item Reserve
  5. 3284validatesTable 27 Item Inventory Posting Group
  6. 3285validatesTable 27 Item Item Tracking Code
  7. 3286validatesTable 27 Item Costing Method
  8. 3287validatesTable 27 Item Reordering Policy
  9. 3288validatesTable 27 Item Order Tracking Policy
  10. 3289validatesTable 27 Item Indirect Cost %
  11. 3291raisesOnAfterCheckUpdateFieldsForNonInventoriableItem

CalcVAT line 3312

  1. 3316raisesOnCalcVATOnAfterVATPostingSetupGet

CalcUnitPriceExclVAT line 3332

  1. 3334callsGetGLSetup
  2. 3335callsCalcVAT
  3. 3337callsCalcVAT

GetFirstItemNoFromLookup line 3340

  1. 3346raisesOnBeforeGetFirstItemNoFromLookupIsHandled

GetItemNo line 3384

  1. 3388callsTryGetItemNo

ShowPriceListLines line 3400

  1. 3405callsAsPriceAsset
  2. 3406callsCodeunit 7018 Price UX Management ShowPriceListLines

TryGetItemNo line 3409

  1. 3412callsTryGetItemNoOpenCard

TryGetItemNoOpenCard line 3415

  1. 3420callsTryGetItemNoOpenCardWithView

TryGetItemNoOpenCardWithView line 3423, internal

  1. 3436callsCodeunit 703 Find Record Management FindRecordByDescriptionAndView
  2. 3436callsTable 27 Item AsInteger
  3. 3449raisesOnTryGetItemNoOpenCardWithViewOnBeforeShowCreateItemOption
  4. 3459callsCreateNewItem
  5. 3473raisesOnTryGetItemNoOpenCardOnAfterSetItemFilters
  6. 3477callsPickItem

CreateNewItem line 3495, local

  1. 3501raisesOnBeforeCreateNewItem
  2. 3502callsCodeunit 1336 Item Templ. Mgt. InsertItemFromTemplate
  3. 3506writesTable 27 Item Modify(true)

CreateItemUnitOfMeasure line 3518, local

  1. 3523raisesOnBeforeCreateItemUnitOfMeasureIsHandled
  2. 3531validatesTable 5404 Item Unit of Measure Item No.
  3. 3532validatesTable 5404 Item Unit of Measure Code
  4. 3534writesTable 5404 Item Unit of Measure Insert

ShouldTryCostFromSKU line 3537

  1. 3544raisesOnShouldTryCostFromSKUOnCheckSKUCostOnMfg
  2. 3548callsTable 313 Inventory Setup GetRecordOnce

PickItem line 3552

  1. 3559callsPage 31 Item List SetTempFilteredItemRec
  2. 3561raisesOnPickItemOnBeforeFindFirstItem
  3. 3563callsCodeunit 703 Find Record Management GetMaxRecordCountToReturn
  4. 3570callsPage 31 Item List DoShowNotification

SetLastDateTimeModified line 3579

  1. 3584raisesOnAfterSetLastDateTimeModified

SetLastDateTimeFilter line 3587

  1. 3593callsCodeunit 3006 DotNet_DateTimeOffset ConvertToUtcDateTime

UpdateCostIsAdjusted line 3602

  1. 3632writesTable 27 Item Modify

UpdateReplenishmentSystem line 3636

  1. 3641raisesOnBeforeUpdateReplenishmentSystemIsHandled
  2. 3648callsIsMfgItem
  3. 3648callsIsAssemblyItem
  4. 3649validatesTable 27 Item Replenishment System
  5. 3653callsIsAssemblyItem
  6. 3655validatesTable 27 Item Replenishment System

UpdateQtyRoundingPrecisionForBaseUoM line 3676, local

  1. 3682raisesOnBeforeUpdateQtyRoundingPrecisionForBaseUoMIsHandled
  2. 3688validatesTable 5404 Item Unit of Measure Qty. Rounding Precision
  3. 3689writesTable 5404 Item Unit of Measure Modify(true)

UpdateItemCategoryId line 3693

  1. 3701callsCodeunit 5465 Graph Mgt - General Tools IsApiEnabled
  2. 3714raisesOnAfterUpdateItemCategoryId

UpdateTaxGroupCode line 3744, local

  1. 3752validatesTable 27 Item Tax Group Code

UpdateReferencedIds line 3766

  1. 3773callsCodeunit 5465 Graph Mgt - General Tools IsApiEnabled
  2. 3776callsUpdateUnitOfMeasureId
  3. 3777callsUpdateTaxGroupId
  4. 3778callsUpdateItemCategoryId

GetReferencedIds line 3781

  1. 3785callsCodeunit 701 Data Type Management InsertFieldToBuffer
  2. 3786callsCodeunit 701 Data Type Management InsertFieldToBuffer
  3. 3787callsCodeunit 701 Data Type Management InsertFieldToBuffer

IsInventoriableType line 3800

  1. 3802callsIsNonInventoriableType

IsVariantMandatory line 3817, local

  1. 3822raisesOnBeforeIsVariantMandatoryIsHandled
  2. 3833callsVariantMandatoryIfAvailable
  3. 3834callsVariantsAvailable

IsVariantMandatory line 3839, internal

  1. 3841callsVariantMandatoryIfAvailable
  2. 3842callsVariantsAvailable

VariantMandatoryIfAvailable line 3847, local

  1. 3854callsGetInvtSetup

UpdateItemUnitGroup line 3878, local

  1. 3883callsCodeunit 5330 CRM Integration Management IsIntegrationEnabled
  2. 3891writesTable 5400 Unit Group Insert

AdjustCostIfRequired line 3896, local

  1. 3904callsNonAdjustedProdOrAsmOrderExists
  2. 3907callsCodeunit 27 Confirm Management GetResponseOrDefault
  3. 3912callsRunCostAdjustment

RunCostAdjustment line 3937, local

  1. 3941callsGetInvtSetup
  2. 3943callsCodeunit 5823 Cost Adjustment Item Runner SetPostToGL
  3. 3944runsCodeunit 5823 Cost Adjustment Item Runner

DeleteItemUnitGroup line 3947, local

  1. 3952writesTable 5400 Unit Group Delete

DeleteItemVariantAttributes line 3955, local

  1. 3960writesTable 7507 Item Var. Attr. Value Mapping DeleteAll

CalcScheduledReceiptQty line 3963

  1. 3965raisesOnCalcScheduledReceiptQty

CalcQtyOnComponentLines line 3968

  1. 3970raisesOnCalcQtyOnComponentLines

CalcQtyOnProdOrder line 3973

  1. 3975raisesOnCalcQtyOnProdOrder

CalcResQtyonProdOrderComp line 3978

  1. 3980raisesOnCalcResQtyonProdOrderComp

CalcReservedQtyOnProdOrder line 3983

  1. 3985raisesOnCalcReservedQtyOnProdOrder

CalcPlannedOrderReceiptQty line 3988

  1. 3990raisesOnCalcPlannedOrderReceiptQty

CalcFPOrderReceiptQty line 3993

  1. 3995raisesOnCalcFPOrderReceiptQty

CalcRelOrderReceiptQty line 3998

  1. 4000raisesOnCalcRelOrderReceiptQty

CalcQtyOnServiceOrder line 4003

  1. 4005raisesOnCalcQtyOnServiceOrder

UpdateItemUnitOfMeasureWeight line 4008, local

  1. 4019raisesOnUpdateItemUnitOfMeasureWeightOnBeforeCalcWeight
  2. 4022callsTable 5404 Item Unit of Measure CalcWeight
  3. 4023writesTable 5404 Item Unit of Measure Modify

UpdateMyItem line 4214

  1. 4223writesTable 9152 My Item ModifyAll
  2. 4229writesTable 9152 My Item ModifyAll