Table of Contents

Table "Purch. Rcpt. Line"

ID 121
Namespace: Microsoft.Purchases.History

Properties

Name Value
Caption Purch. Rcpt. Line
DrillDownPageID Page Microsoft.Purchases.History."Posted Purchase Receipt Lines"
LookupPageID Page Microsoft.Purchases.History."Posted Purchase Receipt Lines"
Permissions TableData "Item Ledger Entry" = r, TableData "Value Entry" = r
DataClassification CustomerContent

Fields

Name Type Description
"Buy-from Vendor No." Code[20]

Specifies the name of the vendor who delivered the items.

"Document No." Code[20]

Specifies the number of the related document.

"Line No." Integer
Type Enum Microsoft.Purchases.Document."Purchase Line Type"

Specifies the line type.

"No." Code[20]

Specifies the number of the involved entry or record, according to the specified number series.

"Location Code" Code[10]

Specifies a code for the location where you want the items to be placed when they are received.

"Posting Group" Code[20]
"Expected Receipt Date" Date

Specifies the date you expect the items to be available in your warehouse. If you leave the field blank, it will be calculated as follows: Planned Receipt Date + Safety Lead Time + Inbound Warehouse Handling Time = Expected Receipt Date.

Description Text[100]

Specifies either the name of or a description of the item or general ledger account.

"Description 2" Text[50]

Specifies information in addition to the description.

"Unit of Measure" Text[50]

Specifies the name of the item or resource's unit of measure, such as piece or hour.

Quantity Decimal

Specifies the number of units of the item specified on the line.

"Direct Unit Cost" Decimal

Specifies the cost of one unit of the selected item or resource.

"Unit Cost (LCY)" Decimal
"VAT %" Decimal
"Line Discount %" Decimal
"Unit Price (LCY)" Decimal
"Allow Invoice Disc." Boolean
"Gross Weight" Decimal

Specifies the gross weight of one unit of the item. In the purchase statistics window, the gross weight on the line is included in the total gross weight of all the lines for the particular purchase document.

"Net Weight" Decimal

Specifies the net weight of one unit of the item. In the purchase statistics window, the net weight on the line is included in the total net weight of all the lines for the particular purchase document.

"Units per Parcel" Decimal

Specifies the number of units per parcel of the item. In the purchase statistics window, the number of units per parcel on the line helps to determine the total number of units for all the lines for the particular purchase document.

"Unit Volume" Decimal

Specifies the volume of one unit of the item. In the purchase statistics window, the volume of one unit of the item on the line is included in the total volume of all the lines for the particular purchase document.

"Appl.-to Item Entry" Integer

Specifies the number of the item ledger entry that the document or journal line is applied to.

"Item Rcpt. Entry No." Integer
"Shortcut Dimension 1 Code" Code[20]

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.

"Shortcut Dimension 2 Code" Code[20]

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.

"Job No." Code[20]

Specifies the number of the related project.

"Indirect Cost %" Decimal

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.

"Qty. Rcd. Not Invoiced" Decimal

Specifies the quantity of the received item that has been posted as received but that has not yet been posted as invoiced.

"Quantity Invoiced" Decimal

Specifies how many units of the item on the line have been posted as invoiced.

"Order No." Code[20]

Specifies the line number of the order that created the entry.

"Order Line No." Integer

Specifies the line number of the order that created the entry.

"Pay-to Vendor No." Code[20]

Specifies the number of the vendor that you received the invoice from.

"Vendor Item No." Text[50]

Specifies the number that the vendor uses for this item.

"Sales Order No." Code[20]
"Sales Order Line No." Integer
"Gen. Bus. Posting Group" Code[20]
"Gen. Prod. Posting Group" Code[20]
"VAT Calculation Type" Enum Microsoft.Foundation.Enums."Tax Calculation Type"
"Transaction Type" Code[10]
"Transport Method" Code[10]
"Attached to Line No." Integer
"Entry Point" Code[10]
"Area" Code[10]
"Transaction Specification" Code[10]
"Tax Area Code" Code[20]
"Tax Liable" Boolean
"Tax Group Code" Code[20]
"Use Tax" Boolean
"VAT Bus. Posting Group" Code[20]
"VAT Prod. Posting Group" Code[20]
"Currency Code" Code[10]

Specifies the currency that is used on the entry.

"Blanket Order No." Code[20]

Specifies the number of the blanket order that the record originates from.

"Blanket Order Line No." Integer

Specifies the number of the blanket order line that the record originates from.

"VAT Base Amount" Decimal
"Unit Cost" Decimal

Specifies the cost of one unit of the item or resource on the line.

"IC Partner Ref. Type" Enum Microsoft.Intercompany.Partner."IC Partner Reference Type"
"IC Partner Reference" Code[20]
"Posting Date" Date
"IC Item Reference No." Code[50]
"Dimension Set ID" Integer
"Job Task No." Code[20]

Specifies the number of the related project task.

"Job Line Type" Enum Microsoft.Projects.Project.Job."Job Line Type"
"Job Unit Price" Decimal
"Job Total Price" Decimal
"Job Line Amount" Decimal
"Job Line Discount Amount" Decimal
"Job Line Discount %" Decimal
"Job Unit Price (LCY)" Decimal
"Job Total Price (LCY)" Decimal
"Job Line Amount (LCY)" Decimal
"Job Line Disc. Amount (LCY)" Decimal
"Job Currency Factor" Decimal
"Job Currency Code" Code[20]
"Job Planning Line No." Integer
"Variant Code" Code[10]

Specifies the variant of the item on the line.

"Bin Code" Code[20]

Specifies the bin where the items are picked or put away.

"Qty. per Unit of Measure" Decimal

Specifies the quantity per unit of measure of the item that was received.

"Unit of Measure Code" Code[10]

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.

"Quantity (Base)" Decimal
"Qty. Invoiced (Base)" Decimal
"FA Posting Date" Date
"FA Posting Type" Enum Microsoft.FixedAssets.Posting."Purchase FA Posting Type"
"Depreciation Book Code" Code[10]
"Salvage Value" Decimal
"Depr. until FA Posting Date" Boolean
"Depr. Acquisition Cost" Boolean
"Maintenance Code" Code[10]
"Insurance No." Code[20]
"Budgeted FA No." Code[20]
"Duplicate in Depreciation Book" Code[10]
"Use Duplication List" Boolean
"Responsibility Center" Code[10]
"Item Reference No." Code[50]

Specifies the referenced item number.

"Item Reference Unit of Measure" Code[10]
"Item Reference Type" Enum Microsoft.Inventory.Item.Catalog."Item Reference Type"
"Item Reference Type No." Code[30]
"Item Category Code" Code[20]
Nonstock Boolean

Specifies that this item is a catalog item.

"Purchasing Code" Code[10]

Specifies the purchasing code associated with the receipt line.

"Special Order Sales No." Code[20]
"Special Order Sales Line No." Integer
"Requested Receipt Date" Date

Specifies the date that you want the vendor to deliver to the ship-to address. The value in the field is used to calculate the latest date you can order the items to have them delivered on the requested receipt date. If you do not need delivery on a specific date, you can leave the field blank.

"Promised Receipt Date" Date

Specifies the date that the vendor has promised to deliver the order.

"Lead Time Calculation" DateFormula

Specifies a date formula for the amount of time it takes to replenish the item.

"Inbound Whse. Handling Time" DateFormula

Specifies the time it takes to make items part of available inventory, after the items have been posted as received.

"Planned Receipt Date" Date

Specifies the date when the item is planned to arrive in inventory. Forward calculation: planned receipt date = order date + vendor lead time (per the vendor calendar and rounded to the next working day in first the vendor calendar and then the location calendar). If no vendor calendar exists, then: planned receipt date = order date + vendor lead time (per the location calendar). Backward calculation: order date = planned receipt date - vendor lead time (per the vendor calendar and rounded to the previous working day in first the vendor calendar and then the location calendar). If no vendor calendar exists, then: order date = planned receipt date - vendor lead time (per the location calendar).

"Order Date" Date

Specifies the date when the related order was created.

"Vendor Order No." Code[35]
"Vendor Shipment No." Code[35]
"Your Reference" Text[35]
"Item Charge Base Amount" Decimal
Correction Boolean

Specifies the entry as a corrective entry. You can use the field if you need to post a corrective entry to an account.

"Return Reason Code" Code[10]

Specifies the code explaining why the item was returned.

"Price Calculation Method" Enum Microsoft.Pricing.Calculation."Price Calculation Method"
"Document Id" Guid
"Over-Receipt Quantity" Decimal
"Over-Receipt Code 2" Code[20]
"Overhead Rate" Decimal
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

GetCurrencyCodeFromHeader

procedure GetCurrencyCodeFromHeader(): Code[10]

Returns

Type Description
Code[10]

ShowDimensions

procedure ShowDimensions()

ShowItemTrackingLines

procedure ShowItemTrackingLines()

InsertInvLineFromRcptLine

procedure InsertInvLineFromRcptLine(var PurchLine: Record "Purchase Line")

Parameters

Name Type Description
PurchLine Table Microsoft.Purchases.Document."Purchase Line"

GetPurchInvLines

procedure GetPurchInvLines(var TempPurchInvLine: Record "Purch. Inv. Line" temporary)

Parameters

Name Type Description
TempPurchInvLine Table Microsoft.Purchases.History."Purch. Inv. Line"

CalcReceivedPurchNotReturned

procedure CalcReceivedPurchNotReturned(var RemainingQty: Decimal; var RevUnitCostLCY: Decimal; ExactCostReverse: Boolean)

Parameters

Name Type Description
RemainingQty Decimal
RevUnitCostLCY Decimal
ExactCostReverse Boolean

FilterPstdDocLnItemLedgEntries

procedure FilterPstdDocLnItemLedgEntries(var ItemLedgEntry: Record "Item Ledger Entry")

Parameters

Name Type Description
ItemLedgEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"

ShowItemPurchInvLines

procedure ShowItemPurchInvLines()

ShowLineComments

procedure ShowLineComments()

ShowShortcutDimCode

procedure ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])

Parameters

Name Type Description
ShortcutDimCode array[8] of Code[20]

InitFromPurchLine

procedure InitFromPurchLine(PurchRcptHeader: Record "Purch. Rcpt. Header"; PurchLine: Record "Purchase Line")

Parameters

Name Type Description
PurchRcptHeader Table Microsoft.Purchases.History."Purch. Rcpt. Header"
PurchLine Table Microsoft.Purchases.Document."Purchase Line"

FormatType

procedure FormatType(): Text

Returns

Type Description
Text

CalcBaseQuantities

procedure CalcBaseQuantities(var PurchaseLine: Record "Purchase Line"; QtyFactor: Decimal)

Parameters

Name Type Description
PurchaseLine Table Microsoft.Purchases.Document."Purchase Line"
QtyFactor Decimal

GetCaptionClass

procedure GetCaptionClass(FieldNumber: Integer): Text[80]

Parameters

Name Type Description
FieldNumber Integer

Returns

Type Description
Text[80]

HasTypeToFillMandatoryFields

procedure HasTypeToFillMandatoryFields(): Boolean

Returns

Type Description
Boolean

UpdateReferencedIds

procedure UpdateReferencedIds()

SetSecurityFilterOnRespCenter

procedure SetSecurityFilterOnRespCenter()

IsProdOrder

procedure IsProdOrder(): Boolean

Returns

Type Description
Boolean

TestWorkCenterNo

procedure TestWorkCenterNo(): Boolean

Returns

Type Description
Boolean

Events

OnAfterCopyFromPurchRcptLine

[IntegrationEvent(False,False)]
local procedure OnAfterCopyFromPurchRcptLine(var PurchaseLine: Record "Purchase Line"; PurchRcptLine: Record "Purch. Rcpt. Line"; var TempPurchLine: Record "Purchase Line")

Parameters

Name Type Description
PurchaseLine Table Microsoft.Purchases.Document."Purchase Line"
PurchRcptLine Table Microsoft.Purchases.History."Purch. Rcpt. Line"
TempPurchLine Table Microsoft.Purchases.Document."Purchase Line"

OnAfterInitFromPurchLine

[IntegrationEvent(False,False)]
local procedure OnAfterInitFromPurchLine(PurchRcptHeader: Record "Purch. Rcpt. Header"; PurchLine: Record "Purchase Line"; var PurchRcptLine: Record "Purch. Rcpt. Line")

Parameters

Name Type Description
PurchRcptHeader Table Microsoft.Purchases.History."Purch. Rcpt. Header"
PurchLine Table Microsoft.Purchases.Document."Purchase Line"
PurchRcptLine Table Microsoft.Purchases.History."Purch. Rcpt. Line"

OnAfterDescriptionPurchaseLineInsert

[IntegrationEvent(False,False)]
local procedure OnAfterDescriptionPurchaseLineInsert(var PurchLine: Record "Purchase Line"; PurchRcptLine: Record "Purch. Rcpt. Line"; var NextLineNo: Integer; var TempPurchaseLine: Record "Purchase Line" temporary)

Parameters

Name Type Description
PurchLine Table Microsoft.Purchases.Document."Purchase Line"
PurchRcptLine Table Microsoft.Purchases.History."Purch. Rcpt. Line"
NextLineNo Integer
TempPurchaseLine Table Microsoft.Purchases.Document."Purchase Line"

OnAfterInsertInvLineFromRcptLine

[IntegrationEvent(False,False)]
local procedure OnAfterInsertInvLineFromRcptLine(var PurchLine: Record "Purchase Line"; PurchOrderLine: Record "Purchase Line"; var NextLineNo: Integer; PurchRcptLine: Record "Purch. Rcpt. Line")

Parameters

Name Type Description
PurchLine Table Microsoft.Purchases.Document."Purchase Line"
PurchOrderLine Table Microsoft.Purchases.Document."Purchase Line"
NextLineNo Integer
PurchRcptLine Table Microsoft.Purchases.History."Purch. Rcpt. Line"

OnBeforeInsertInvLineFromRcptLine

[IntegrationEvent(False,False)]
local procedure OnBeforeInsertInvLineFromRcptLine(var PurchRcptLine: Record "Purch. Rcpt. Line"; var PurchLine: Record "Purchase Line"; PurchOrderLine: Record "Purchase Line"; var IsHandled: Boolean)

Parameters

Name Type Description
PurchRcptLine Table Microsoft.Purchases.History."Purch. Rcpt. Line"
PurchLine Table Microsoft.Purchases.Document."Purchase Line"
PurchOrderLine Table Microsoft.Purchases.Document."Purchase Line"
IsHandled Boolean

OnBeforeInsertInvLineFromRcptLineProcedure

[IntegrationEvent(False,False)]
local procedure OnBeforeInsertInvLineFromRcptLineProcedure(var PurchRcptLine: Record "Purch. Rcpt. Line"; var PurchaseLine: Record "Purchase Line"; var IsHandled: Boolean)

Parameters

Name Type Description
PurchRcptLine Table Microsoft.Purchases.History."Purch. Rcpt. Line"
PurchaseLine Table Microsoft.Purchases.Document."Purchase Line"
IsHandled Boolean

OnBeforeInsertInvLineFromRcptLineBeforeInsertTextLine

[IntegrationEvent(False,False)]
local procedure OnBeforeInsertInvLineFromRcptLineBeforeInsertTextLine(var PurchRcptLine: Record "Purch. Rcpt. Line"; var PurchLine: Record "Purchase Line"; var NextLineNo: Integer; var Handled: Boolean)

Parameters

Name Type Description
PurchRcptLine Table Microsoft.Purchases.History."Purch. Rcpt. Line"
PurchLine Table Microsoft.Purchases.Document."Purchase Line"
NextLineNo Integer
Handled Boolean

OnInsertInvLineFromRcptLineOnAfterAssignDescription

[IntegrationEvent(False,False)]
local procedure OnInsertInvLineFromRcptLineOnAfterAssignDescription(var PurchRcptLine: Record "Purch. Rcpt. Line"; var PurchaseLine: Record "Purchase Line")

Parameters

Name Type Description
PurchRcptLine Table Microsoft.Purchases.History."Purch. Rcpt. Line"
PurchaseLine Table Microsoft.Purchases.Document."Purchase Line"

OnInsertInvLineFromRcptLineOnAfterCalcShouldProcessAsRegularLine

[IntegrationEvent(False,False)]
local procedure OnInsertInvLineFromRcptLineOnAfterCalcShouldProcessAsRegularLine(var PurchRcptLine: Record "Purch. Rcpt. Line"; var PurchaseLine: Record "Purchase Line"; var PurchaseOrderLine: Record "Purchase Line"; var TempPurchLine: Record "Purchase Line"; var ShouldProcessAsRegularLine: Boolean)

Parameters

Name Type Description
PurchRcptLine Table Microsoft.Purchases.History."Purch. Rcpt. Line"
PurchaseLine Table Microsoft.Purchases.Document."Purchase Line"
PurchaseOrderLine Table Microsoft.Purchases.Document."Purchase Line"
TempPurchLine Table Microsoft.Purchases.Document."Purchase Line"
ShouldProcessAsRegularLine Boolean

OnInsertInvLineFromRcptLineOnAfterCalcQuantities

[IntegrationEvent(False,False)]
local procedure OnInsertInvLineFromRcptLineOnAfterCalcQuantities(var PurchaseLine: Record "Purchase Line"; PurchaseOrderLine: Record "Purchase Line")

Parameters

Name Type Description
PurchaseLine Table Microsoft.Purchases.Document."Purchase Line"
PurchaseOrderLine Table Microsoft.Purchases.Document."Purchase Line"

OnInsertInvLineFromRcptLineOnBeforeCheckPurchLineReceiptNo

[IntegrationEvent(False,False)]
local procedure OnInsertInvLineFromRcptLineOnBeforeCheckPurchLineReceiptNo(var PurchRcptLine: Record "Purch. Rcpt. Line"; var PurchLine: Record "Purchase Line"; var TempPurchLine: Record "Purchase Line"; var NextLineNo: Integer; var IsHandled: Boolean)

Parameters

Name Type Description
PurchRcptLine Table Microsoft.Purchases.History."Purch. Rcpt. Line"
PurchLine Table Microsoft.Purchases.Document."Purchase Line"
TempPurchLine Table Microsoft.Purchases.Document."Purchase Line"
NextLineNo Integer
IsHandled Boolean

OnInsertInvLineFromRcptLineOnBeforeCopyFromPurchRcptLine

[IntegrationEvent(False,False)]
local procedure OnInsertInvLineFromRcptLineOnBeforeCopyFromPurchRcptLine(var PurchRcptLine: Record "Purch. Rcpt. Line"; var PurchLine: Record "Purchase Line"; TempPurchLine: Record "Purchase Line"; var NextLineNo: Integer)

Parameters

Name Type Description
PurchRcptLine Table Microsoft.Purchases.History."Purch. Rcpt. Line"
PurchLine Table Microsoft.Purchases.Document."Purchase Line"
TempPurchLine Table Microsoft.Purchases.Document."Purchase Line"
NextLineNo Integer

OnInsertInvLineFromRcptLineOnBeforeSetDirectUnitCost

[IntegrationEvent(False,False)]
local procedure OnInsertInvLineFromRcptLineOnBeforeSetDirectUnitCost(var PurchaseLine: Record "Purchase Line"; PurchaseOrderLine: Record "Purchase Line"; var DirectUnitCost: Decimal)

Parameters

Name Type Description
PurchaseLine Table Microsoft.Purchases.Document."Purchase Line"
PurchaseOrderLine Table Microsoft.Purchases.Document."Purchase Line"
DirectUnitCost Decimal

OnInsertInvLineFromRcptLineOnBeforeValidateQuantity

[IntegrationEvent(False,False)]
local procedure OnInsertInvLineFromRcptLineOnBeforeValidateQuantity(PurchRcptLine: Record "Purch. Rcpt. Line"; var PurchaseLine: Record "Purchase Line"; var IsHandled: Boolean; var PurchInvHeader: Record "Purchase Header")

Parameters

Name Type Description
PurchRcptLine Table Microsoft.Purchases.History."Purch. Rcpt. Line"
PurchaseLine Table Microsoft.Purchases.Document."Purchase Line"
IsHandled Boolean
PurchInvHeader Table Microsoft.Purchases.Document."Purchase Header"

OnInsertInvLineFromRcptLineOnBeforePurchLineUpdatePrePaymentAmounts

[IntegrationEvent(False,False)]
local procedure OnInsertInvLineFromRcptLineOnBeforePurchLineUpdatePrePaymentAmounts(var PurchaseLine: Record "Purchase Line"; PurchOrderLine: Record "Purchase Line")

Parameters

Name Type Description
PurchaseLine Table Microsoft.Purchases.Document."Purchase Line"
PurchOrderLine Table Microsoft.Purchases.Document."Purchase Line"

OnInsertInvLineFromRcptLineOnAfterTransferOldExtLinesClearLineNumbers

[IntegrationEvent(False,False)]
local procedure OnInsertInvLineFromRcptLineOnAfterTransferOldExtLinesClearLineNumbers(var PurchRcptLine: Record "Purch. Rcpt. Line")

Parameters

Name Type Description
PurchRcptLine Table Microsoft.Purchases.History."Purch. Rcpt. Line"

OnInsertInvLineFromRcptLineOnAfterRoundLineDiscountAmount

[IntegrationEvent(False,False)]
local procedure OnInsertInvLineFromRcptLineOnAfterRoundLineDiscountAmount(var PurchRcptLine: Record "Purch. Rcpt. Line"; var PurchaseLine: Record "Purchase Line"; var PurchaseOrderLine: Record "Purchase Line"; Currency: Record Currency)

Parameters

Name Type Description
PurchRcptLine Table Microsoft.Purchases.History."Purch. Rcpt. Line"
PurchaseLine Table Microsoft.Purchases.Document."Purchase Line"
PurchaseOrderLine Table Microsoft.Purchases.Document."Purchase Line"
Currency Table Microsoft.Finance.Currency.Currency

OnBeforeSetSecurityFilterOnRespCenter

[IntegrationEvent(False,False)]
local procedure OnBeforeSetSecurityFilterOnRespCenter(var PurchRcptLine: Record "Purch. Rcpt. Line"; var IsHandled: Boolean)

Parameters

Name Type Description
PurchRcptLine Table Microsoft.Purchases.History."Purch. Rcpt. Line"
IsHandled Boolean

OnBeforeShowItemTrackingLines

[IntegrationEvent(False,False)]
local procedure OnBeforeShowItemTrackingLines(var PurchRcptLine: Record "Purch. Rcpt. Line"; var IsHandled: Boolean)

Parameters

Name Type Description
PurchRcptLine Table Microsoft.Purchases.History."Purch. Rcpt. Line"
IsHandled Boolean

OnAfterCalcReceivedPurchNotReturned

[IntegrationEvent(False,False)]
local procedure OnAfterCalcReceivedPurchNotReturned(var RemainingQty: Decimal; var RevUnitCostLCY: Decimal; ExactCostReverse: Boolean; var ItemLedgerEntry: Record "Item Ledger Entry")

Parameters

Name Type Description
RemainingQty Decimal
RevUnitCostLCY Decimal
ExactCostReverse Boolean
ItemLedgerEntry Table Microsoft.Inventory.Ledger."Item Ledger Entry"

OnIsProdOrder

[IntegrationEvent(False,False)]
local procedure OnIsProdOrder(var PurchRcptLine: Record "Purch. Rcpt. Line"; var Result: Boolean)

Parameters

Name Type Description
PurchRcptLine Table Microsoft.Purchases.History."Purch. Rcpt. Line"
Result Boolean

OnTestWorkCenterNo

[IntegrationEvent(False,False)]
local procedure OnTestWorkCenterNo(var PurchRcptLine: Record "Purch. Rcpt. Line"; var Result: Boolean)

Parameters

Name Type Description
PurchRcptLine Table Microsoft.Purchases.History."Purch. Rcpt. Line"
Result Boolean

See also