Page 291 "Req. Worksheet"
Base Application · Microsoft.Inventory.Requisition
Across versions
- BC23-26present
- BC27declaration changed
- BC282 procedures added
- BC29-30unchanged
Neighbourhood 11 connected objects and pages
Base Application · Microsoft.Inventory.Requisition · captioned “Requisition Worksheets” · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Requisition Worksheets |
| SourceTable | Requisition Line |
| PageType | Worksheet |
| UsageCategory | Tasks |
| ApplicationArea | Basic, Suite, Planning |
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 | Name | CurrentJnlBatchName |
Specifies the name of the record. |
| Approval Status | RequisitionWkshBatchApprovalStatus |
Specifies the approval status for requisition worksheet batch. | |
| Control1 | Type | Type | Specifies the type of requisition worksheet line you are creating. from the table field |
| No. | No. | Specifies the number of the involved entry or record, according to the specified number series. from the table field | |
| Price Calculation Method | Price Calculation Method | Specifies the method that will be used for unit cost calculation in the line. from the table field | |
| Action Message | Action Message | Specifies an action to take to rebalance the demand-supply situation. from the table field | |
| Accept Action Message | Accept Action Message | Specifies whether to accept the action message proposed for the line. from the table field | |
| Variant Code | Variant Code | Specifies the variant of the item on the line. from the table field | |
| Bin Code | Bin Code | Specifies the bin of the item on the line. from the table field | |
| Description | Description | Specifies text that describes the entry. from the table field | |
| Description 2 | Description 2 | Specifies additional text describing the entry, or a remark about the requisition worksheet line. from the table field | |
| Transfer-from Code | Transfer-from Code | Specifies the code of the location that items are transferred from. from the table field | |
| Location Code | Location Code | Specifies a code for an inventory location where the items that are being ordered will be registered. from the table field | |
| Original Quantity | Original Quantity | Specifies the quantity stated on the production or purchase order, when an action message proposes to change the quantity on an order. from the table field | |
| Quantity | Quantity | Specifies the number of units of the item or resource specified on the line. | |
| 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 | |
| Direct Unit Cost | Direct Unit Cost | Specifies the cost of one unit of the selected item or resource. from the table field | |
| Currency Code | Currency Code | Specifies the currency code for the requisition lines. from the table field | |
| Line Discount % | Line Discount % | Specifies the discount percentage that is granted for the item on the line. from the table field | |
| Original Due Date | Original Due Date | Specifies the due date stated on the production or purchase order, when an action message proposes to reschedule an order. from the table field | |
| Due Date | Due Date | Specifies the date when you can expect to receive the items. from the table field | |
| Order Date | Order Date | Specifies the date when the related order was created. from the table field | |
| Vendor No. | Vendor No. | Specifies the number of the vendor who will ship the items in the purchase order. from the table field | |
| Vendor Item No. | Vendor Item No. | Specifies the number that the vendor uses for this item. from the table field | |
| Purchaser Code | Purchaser Code | Specifies which purchaser is assigned to the vendor. from the table field | |
| Order Address Code | Order Address Code | Specifies the order address of the related vendor. from the table field | |
| Sell-to Customer No. | Sell-to Customer No. | Specifies the number of the customer. from the table field | |
| Ship-to Code | Ship-to Code | Specifies a code for an alternate shipment address if you want to ship to another address than the one that has been entered automatically. This field is also used in case of drop shipment. from the table field | |
| Requester ID | Requester ID | Specifies the ID of the user who is ordering the items on the line. from the table field | |
| Confirmed | Confirmed | Specifies whether the items on the line have been approved for purchase. 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 | |
| ShortcutDimCode[3] | ShortcutDimCode[3] |
— | |
| ShortcutDimCode[4] | ShortcutDimCode[4] |
— | |
| ShortcutDimCode[5] | ShortcutDimCode[5] |
— | |
| ShortcutDimCode[6] | ShortcutDimCode[6] |
— | |
| ShortcutDimCode[7] | ShortcutDimCode[7] |
— | |
| ShortcutDimCode[8] | ShortcutDimCode[8] |
— | |
| Ref. Order No. | Ref. Order No. | Specifies the number of the relevant production or purchase order. from the table field | |
| Ref. Order Type | Ref. Order Type | Specifies whether the order is a purchase order, a production order, or a transfer order. from the table field | |
| Replenishment System | Replenishment System | Specifies which kind of order to use to create replenishment orders and order proposals. from the table field | |
| Supply From | Supply From | Specifies a value, according to the selected replenishment system, before a supply order can be created for the line. from the table field | |
| Ref. Line No. | Ref. Line No. | Specifies the number of the purchase or production order line. from the table field | |
| Planning Flexibility | Planning Flexibility | Specifies whether the supply represented by this line is considered by the planning system when calculating action messages. from the table field | |
| Blanket Purch. Order Exists | Blanket Purch. Order Exists | Specifies if a blanket purchase order exists for the item on the requisition line. from the table field | |
| Description | Description2 | Description2 |
Specifies an additional part of the worksheet description. |
| Buy-from Vendor Name | Buy-from Vendor Name | BuyFromVendorName |
Specifies the vendor according to the values in the Document No. and Document Type fields. |
| FactBoxes | Control1903326807 | part Page 9090 “Item Replenishment FactBox” | — |
| Batch Workflows | part Page 1528 “Workflow Status FactBox” | — |
Actions
| Group | Action | ToolTip | Runs |
|---|---|---|---|
| Line | Card | View or change detailed information about the item or resource. | Codeunit 335 “Req. Wksh.-Show Card” |
| 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. | ||
| 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. | ||
| 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. | ||
| Processing | Delete all lines in worksheet | Delete all lines in the current worksheet, disregarding any filters. | |
| Functions | Calculate Plan | Use a batch job to help you calculate a supply plan for items and stockkeeping units that have the Replenishment System field set to Purchase or Transfer. | |
| Drop Shipment | Get Sales Orders | Copy sales lines to the requisition worksheet. You can use the batch job to create requisition worksheet proposal lines from sales lines for drop shipments or special orders. | |
| Sales Order | View the sales order that is the source of the line. This applies only to drop shipments and special orders. | ||
| Special Order | Get Sales Orders | Copy sales lines to the requisition worksheet. You can use the batch job to create requisition worksheet proposal lines from sales lines for drop shipments or special orders. | |
| Sales Order | View the sales order that is the source of the line. This applies only to drop shipments and special orders. | ||
| Functions | Reserve | Reserve one or more units of the item on the project planning line, either from inventory or from incoming supply. | |
| Carry Out Action Message | Use a batch job to help you create actual supply orders from the order proposals. | ||
| Order Tracking | Order Tracking | Tracks the connection of a supply to its corresponding demand. This can help you find the original demand that created a specific production order or purchase order. | |
| Send Approval Request | Worksheet Batch | Send all worksheet lines for approval, also those that you may not see because of filters. | |
| Cancel Approval Request | Worksheet Batch | Cancel sending all worksheet 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 worksheet to an Excel file for analysis or editing. | |
| Reporting | Inventory Availability | — | Report 705 “Inventory Availability” |
| Status | View the status of the worksheet. | Report 706 “Status” | |
| Inventory - Availability Plan (Obsolete) obsolete Pending 28.0; #if not CLEAN28 | View a list of the quantity of each item in customer, purchase, and transfer orders and the quantity available in inventory. The list is divided into columns that cover six periods with starting and ending dates as well as the periods before and after those periods. The list is useful when you are p… | Report 707 “Inventory - Availability Plan” | |
| Inventory - Availability Plan (Excel) | — | Report 719 “Inv. Availability Plan” | |
| Inventory Order Details | — | Report 708 “Inventory Order Details” | |
| Inventory Purchase Orders | — | Report 709 “Inventory Purchase Orders” |
Events published
OnAfterLookupCurrentJnlBatchName(var RequisitionLine: Record "Requisition Line"; var CurrJnlBatchName: Code[10])(integration)OnBeforeOpenReqWorksheet(var CUrrentJnlBatchName: Code[10])(integration)OnBeforeTemplateSelection(var RequisitionLine: Record "Requisition Line"; CurrentJnlBatchName: Code[10])(integration)OnBeforeCarryOutActionMsg(var RequisitionLine: Record "Requisition Line"; var IsHandled: Boolean)(integration)OnCalculatePlanOnBeforeCalculatePlanRunModal(var CalculatePlan: Report "Calculate Plan - Req. Wksh."; var RequisitionLine: Record "Requisition Line")(integration)OnGetSalesOrderActionOnBeforeGetSalesOrderRunModal(var GetSalesOrder: Report "Get Sales Orders"; var RequisitionLine: Record "Requisition Line")(integration)OnActionGetSalesOrdersOnBeforeGetSalesOrderRunModal(var GetSalesOrder: Report "Get Sales Orders"; var RequisitionLine: Record "Requisition Line")(integration)OnBeforeCalculatePlan(var RequisitionLine: Record "Requisition Line"; var IsHandled: Boolean)(integration)
Procedures
4 local procedures, no public ones.
Triggers
OnAfterGetCurrRecord, OnAfterGetRecord, OnInit, OnDeleteRecord, OnModifyRecord, OnNewRecord, OnOpenPage
Relations
- source table Table 246 “Requisition Line”
Extended by
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 330 “ReqJnlManagement” (6 calls:
CurrentJnlBatchNameOnAfterVali → SetName,GetCurrentJnlBatchName → OpenJnl,OnAfterGetCurrRecord → GetDescriptionAndRcptName, …) - Codeunit 1535 “Approvals Mgmt.” (2 calls:
OnAfterGetCurrRecord → GetRequisitionWkshBatchApprovalStatus,OnModifyRecord → CleanRequisitionWkshApprovalStatus) - Codeunit 1563 “Privacy Notice” (1 call:
OnInit → GetPrivacyNoticeApprovalState) - Codeunit 4030 “Client Type Management” (1 call:
OnOpenPage → GetCurrentClientType) - 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 7001 “Price Calculation Mgt.” (1 call:
OnOpenPage → IsExtendedPriceCalculationEnabled)
Recent changes
- 2026-07-29 #9582 636017 Move Inventory report action tooltips to report objects (main, BC30, refactor)
- 2026-07-28 #9538 [main]- Requests to Approve: Open Record shows wrong Requisition Worksheet batch after viewing a different batch (main, BC30, fix)
Documented on Microsoft Learn
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: "Req. Worksheet"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.