Page 392 "Phys. Inventory Journal"
Base Application · Microsoft.Inventory.Counting.Journal
Across versions
- BC23-26present
- BC27declaration changed
- BC28declaration changed
- BC29-30unchanged
Neighbourhood 14 connected objects and pages
Base Application · Microsoft.Inventory.Counting.Journal · captioned “Physical Inventory Journals” · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Physical Inventory Journals |
| SourceTable | Item Journal Line |
| PageType | Worksheet |
| UsageCategory | Tasks |
| ApplicationArea | Basic, Suite |
Fields on this page
Layout controls in source order, grouped by the container they sit in. Shows: the table field a control is bound to (or its expression as written); ToolTip: the control’s own, else the bound field’s (marked).
| Group | Control | Shows | ToolTip |
|---|---|---|---|
| Control120 | Batch Name | CurrentJnlBatchName |
Specifies the name of the journal batch, a personalized journal layout, that the journal is based on. |
| Approval Status | ItemJnlBatchApprovalStatus |
Specifies the approval status for physical inventory journal. | |
| Control1 | Posting Date | Posting Date | Specifies the posting date for the entry. from the table field |
| Document Date | Document Date | Specifies the date when the related document was created. from the table field | |
| Entry Type | EntryType |
Specifies the type of transaction that will be posted from the item journal line. | |
| Document No. | Document No. | Specifies a document number for the journal line. from the table field | |
| Item No. | Item No. | Specifies the number of the item on the journal line. from the table field | |
| Item Reference No. | Item Reference No. | Specifies a reference to the item number as defined by the item’s barcode. from the table field | |
| Variant Code | Variant Code | Specifies the variant of the item on the line. from the table field | |
| Description | Description | Specifies a description of the item on the journal line. from the table field | |
| Location Code | Location Code | Specifies the code for the inventory location where the item on the journal line will be registered. from the table field | |
| Bin Code | Bin Code | Specifies the bin where the items are picked or put away. from the table field | |
| Salespers./Purch. Code | Salespers./Purch. Code | Specifies the code for the salesperson or purchaser who is linked to the sale or purchase on the journal line. from the table field | |
| Gen. Bus. Posting Group | Gen. Bus. Posting Group | 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. from the table field | |
| Gen. Prod. Posting Group | Gen. Prod. Posting Group | 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. from the table field | |
| Qty. (Calculated) | Qty. (Calculated) | Specifies the quantity on hand of the item. | |
| Qty. (Phys. Inventory) | Qty. (Phys. Inventory) | Specifies the quantity on hand of the item as determined from a physical count. | |
| Quantity | Quantity | Specifies the number of units of the item to be included on the journal line. from the table field | |
| Unit of Measure Code | Unit of Measure Code | 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. from the table field | |
| Unit Amount | Unit Amount | Specifies the price of one unit of the item on the journal line. from the table field | |
| Amount | Amount | Specifies the line’s net amount. from the table field | |
| Indirect Cost % | Indirect Cost % | Specifies the percentage of the item’s last purchase cost that includes indirect costs, such as freight that is associated with the purchase of the item. from the table field | |
| Unit Cost | Unit Cost | Specifies the cost of one unit of the item or resource on the line. from the table field | |
| Applies-to Entry | Applies-to Entry | 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. from the table field | |
| Reason Code | Reason Code | Specifies the reason code, a supplementary source code that enables you to trace the entry. from the table field | |
| Shortcut Dimension 1 Code | Shortcut Dimension 1 Code | 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. from the table field | |
| Shortcut Dimension 2 Code | Shortcut Dimension 2 Code | 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. from the table field | |
| ShortcutDimCode3 | ShortcutDimCode[3] |
— | |
| ShortcutDimCode4 | ShortcutDimCode[4] |
— | |
| ShortcutDimCode5 | ShortcutDimCode[5] |
— | |
| ShortcutDimCode6 | ShortcutDimCode[6] |
— | |
| ShortcutDimCode7 | ShortcutDimCode[7] |
— | |
| ShortcutDimCode8 | ShortcutDimCode[8] |
— | |
| Item Description | ItemDescription | ItemDescription |
Specifies a description of the item. |
| FactBoxes | JournalErrorsFactBox | part Page 9122 “Item Journal Errors Factbox” | — |
| Batch Workflows | part Page 1528 “Workflow Status FactBox” | — |
Actions
| Group | Action | ToolTip | Runs |
|---|---|---|---|
| Line | Dimensions | View or edit dimensions, such as area, project, or department, that you can assign to sales and purchase documents to distribute costs and analyze transaction history. | |
| Item Tracking Lines | View or edit serial, lot and package numbers that are assigned to the item on the document or journal line. | ||
| Bin Contents | View items in the bin if the selected line contains a bin code. | Page 7305 “Bin Contents List” | |
| Item | Card | View or change detailed information about the record on the document or journal line. | Page 30 “Item Card” |
| Ledger Entries | View the history of transactions that have been posted for the selected record. | Page 38 “Item Ledger Entries” | |
| Phys. Inventory Ledger Entries | Show the ledger entries for the current journal line. | Page 390 “Phys. Inventory Ledger Entries” | |
| Item Availability by | Event | View how the actual and the projected available balance of an item will develop over time according to supply and demand events. | |
| Period | Show the projected quantity of the item over time according to time periods, such as day, week, or month. | ||
| Variant | View or edit the item’s variants. Instead of setting up each color of an item as a separate item, you can set up the various colors as variants of the item. | ||
| Location | View the actual and projected quantity of the item per location. | ||
| Lot | View the current and projected quantity of the item in each lot. | Page 520 “Item Availability by Lot No.” | |
| BOM Level | View availability figures for items on bills of materials that show how many units of a parent item you can make based on the availability of child items. | ||
| Item | Approvals | View a list of the records that are waiting to be approved. For example, you can see who requested the record to be approved, when it was sent, and when it is due to be approved. | |
| Functions | Calculate Inventory | Start the process of counting inventory by filling the journal with known quantities. | |
| Calculate Counting Period | Show all items that a counting period has been assigned to, according to the counting period, the last counting period update, and the current work date. | ||
| Send Approval Request | Journal Batch | Send all journal lines for approval, also those that you may not see because of filters. | |
| Cancel Approval Request | Journal Batch | Cancel sending all journal lines for approval, also those that you may not see because of filters. | |
| Power Automate | Create approval flow | Create a new flow in Power Automate from a list of relevant flow templates. | |
| Approval | Approve | Approve the requested changes. | |
| Reject | Reject the approval request. | ||
| Delegate | Delegate the approval to a substitute approver. | ||
| Comments | View or add comments for the record. | ||
| Page | Edit in Excel | Send the data in the journal to an Excel file for analysis or editing. | |
| Processing | Prepare to print the document. A report request window for the document opens where you can specify what to include on the print-out. | ||
| Posting | Test Report | View a test report so that you can find and correct any errors before you perform the actual posting of the journal or document. | |
| Post | Finalize the document or journal by posting the amounts and quantities to the related accounts in your company books. | ||
| Preview Posting | Review the different types of entries that will be created when you post the document or journal. | ||
| Post and Print | Finalize and prepare to print the document or journal. The values and quantities are posted to the related accounts. A report request window where you can specify what to include on the print-out. | ||
| Issues | Show Lines with Issues | View a list of journal lines that have issues before you post the journal. | |
| Show All Lines | View all journal lines, including lines with and without issues. |
Events published
OnAfterValidateShortcutDimCode(var ItemJournalLine: Record "Item Journal Line"; var ShortcutDimCode: array[8] of Code[20]; DimIndex: Integer)(integration)OnReferenceNoOnAfterLookup(var ItemJournalLine: Record "Item Journal Line")(integration)OnAfterSetControlAppearanceFromBatch(ItemJournalBatch: Record "Item Journal Batch")(integration)OnBeforeDeleteRecord(var ItemJournalLine: Record "Item Journal Line"; var Result: Boolean; var IsHandled: Boolean)(integration)
Trigger event subscribers
- OnDeleteRecordEvent: Codeunit 9077 “Item Journal Errors Mgt.” OnDeleteRecordEventPhysInventoryJournal
- OnInsertRecordEvent: Codeunit 9077 “Item Journal Errors Mgt.” OnInsertRecordEventPhysInventoryJournal
- OnModifyRecordEvent: Codeunit 9077 “Item Journal Errors Mgt.” OnModifyRecordEventPhysInventoryJournal
Procedures
ItemNoOnAfterValidate()
Plus 5 local procedures.
Triggers
OnAfterGetCurrRecord, OnAfterGetRecord, OnInit, OnDeleteRecord, OnInsertRecord, OnModifyRecord, OnNewRecord, OnOpenPage
Relations
- source table Table 83 “Item Journal Line”
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 240 “ItemJnlManagement” (5 calls:
CurrentJnlBatchNameOnAfterValidate → SetName,ItemNoOnAfterValidate → GetItem,OnAfterGetCurrRecord → GetItem, …) - Codeunit 1535 “Approvals Mgmt.” (2 calls:
OnAfterGetCurrRecord → GetItemJnlBatchApprovalStatus,OnModifyRecord → CleanItemJournalApprovalStatus) - Codeunit 99000835 “Item Jnl. Line-Reserve” (2 calls:
OnDeleteRecord → DeleteLine,OnDeleteRecord → DeleteLineConfirm) - Codeunit 1563 “Privacy Notice” (1 call:
OnInit → GetPrivacyNoticeApprovalState) - Codeunit 241 “Item Jnl.-Post” (1 call:
ShowPreview → Preview) - Codeunit 4030 “Client Type Management” (1 call:
OnOpenPage → GetCurrentClientType) - Codeunit 408 “DimensionManagement” (1 call:
SetDimensionsVisibility → UseShortcutDims) - Codeunit 457 “Environment Information” (1 call:
OnOpenPage → IsSaaS) - Codeunit 6400 “Flow Service Management” (1 call:
OnInit → GetPowerAutomatePrivacyNoticeId) - Codeunit 6723 “Server Setting” (1 call:
OnOpenPage → GetIsSaasExcelAddinEnabled) - Codeunit 9077 “Item Journal Errors Mgt.” (1 call:
SetControlAppearanceFromBatch → SetFullBatchCheck) - Codeunit 9079 “Background Error Handling Mgt.” (1 call:
SetControlAppearanceFromBatch → BackgroundValidationFeatureEnabled)
Countries that replace it
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "page", object_name: "Phys. Inventory Journal"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.