Table of Contents

Table "Return Receipt Line"

ID 6661
Namespace: Microsoft.Sales.History

Stores line-level details for posted sales return receipts including returned items and quantities.

Properties

Name Value
Caption Return Receipt Line
LookupPageID Page Microsoft.Sales.History."Posted Return Receipt Lines"
Permissions TableData "Item Ledger Entry" = r, TableData "Value Entry" = r
DataClassification CustomerContent

Fields

Name Type Description
"Sell-to Customer No." Code[20]

Specifies the customer number who returned the items.

"Document No." Code[20]

Specifies the document number of the posted return receipt header.

"Line No." Integer

Specifies the sequential line number within the return receipt.

Type Enum Microsoft.Sales.Document."Sales Line Type"

Specifies the type of entity on the line such as Item, G/L Account, or Resource.

"No." Code[20]

Specifies the number of the item, G/L account, resource, or other entity on the line.

"Location Code" Code[10]

Specifies the location where returned items were received.

"Posting Group" Code[20]

Specifies the posting group used to post the line to the general ledger.

"Shipment Date" Date

Specifies the date when items were shipped or received.

Description Text[100]

Specifies the description of the item, account, or resource on the line.

"Description 2" Text[50]

Specifies additional description text for the line.

"Unit of Measure" Text[50]

Specifies the unit of measure description for the line item.

Quantity Decimal

Specifies the quantity received for the return.

"Unit Price" Decimal

Specifies the unit price of the item or resource on the line.

"Unit Cost (LCY)" Decimal

Specifies the unit cost in local currency for the line item.

"VAT %" Decimal

Specifies the VAT percentage applied to the line.

"Line Discount %" Decimal

Specifies the line discount percentage applied to the line.

"Allow Invoice Disc." Boolean

Indicates whether the line is included in invoice discount calculations.

"Gross Weight" Decimal

Specifies the gross weight of the items on the line.

"Net Weight" Decimal

Specifies the net weight of the items on the line.

"Units per Parcel" Decimal

Specifies the number of units per parcel for shipping.

"Unit Volume" Decimal

Specifies the volume of a single unit of the item.

"Appl.-to Item Entry" Integer

Specifies the item ledger entry to apply this return to.

"Item Rcpt. Entry No." Integer

Specifies the item receipt entry number created by posting.

"Shortcut Dimension 1 Code" Code[20]

Specifies the first global dimension code used for analysis.

"Shortcut Dimension 2 Code" Code[20]

Specifies the second global dimension code used for analysis.

"Customer Price Group" Code[10]

Specifies the customer price group used for pricing on this line.

"Job No." Code[20]

Specifies the project number associated with this line.

"Work Type Code" Code[10]

Specifies the work type code for resource billing.

"Quantity Invoiced" Decimal

Specifies the quantity that has been invoiced for this return.

"Bill-to Customer No." Code[20]

Specifies the customer number who receives the credit memo for billing.

"Gen. Bus. Posting Group" Code[20]

Specifies the general business posting group for the line.

"Gen. Prod. Posting Group" Code[20]

Specifies the general product posting group for the line.

"VAT Calculation Type" Enum Microsoft.Foundation.Enums."Tax Calculation Type"

Specifies the method used to calculate VAT on the line.

"Transaction Type" Code[10]

Specifies the transaction type code for Intrastat reporting.

"Transport Method" Code[10]

Specifies the transport method code for Intrastat reporting.

"Attached to Line No." Integer

Specifies the parent line number for attached lines such as extended text.

"Exit Point" Code[10]

Specifies the exit point for goods leaving the country for Intrastat.

"Area" Code[10]

Specifies the area code for Intrastat reporting.

"Transaction Specification" Code[10]

Specifies the transaction specification code for Intrastat reporting.

"Tax Area Code" Code[20]

Specifies the tax area code for sales tax calculations.

"Tax Liable" Boolean

Indicates whether the line is subject to sales tax.

"Tax Group Code" Code[20]

Specifies the tax group code for sales tax calculations.

"VAT Bus. Posting Group" Code[20]

Specifies the VAT business posting group for tax calculations.

"VAT Prod. Posting Group" Code[20]

Specifies the VAT product posting group for tax calculations.

"Currency Code" Code[10]

Specifies the currency code used for the return receipt line amounts.

"Blanket Order No." Code[20]

Specifies the blanket order number this line is linked to.

"Blanket Order Line No." Integer

Specifies the blanket order line number this line is linked to.

"VAT Base Amount" Decimal

Specifies the base amount used for VAT calculations.

"Unit Cost" Decimal

Specifies the unit cost in document currency.

"Posting Date" Date

Specifies the posting date of the return receipt line.

"IC Item Reference No." Code[50]

Specifies the intercompany item reference number for cross-company transactions.

"Dimension Set ID" Integer

Specifies the unique identifier for the dimension set applied to this line.

"Job Task No." Code[20]

Specifies the project task number associated with this line.

"Job Contract Entry No." Integer

Specifies the project contract entry number for project billing.

"Variant Code" Code[10]

Specifies the item variant code for the item on the line.

"Bin Code" Code[20]

Specifies the bin code where returned items were placed.

"Qty. per Unit of Measure" Decimal

Specifies the quantity per unit of measure for conversion.

"Unit of Measure Code" Code[10]

Specifies the unit of measure code for the line item.

"Quantity (Base)" Decimal

Specifies the quantity in the base unit of measure.

"Qty. Invoiced (Base)" Decimal

Specifies the invoiced quantity in the base unit of measure.

"FA Posting Date" Date

Specifies the fixed asset posting date for depreciation.

"Depreciation Book Code" Code[10]

Specifies the depreciation book code for fixed asset posting.

"Depr. until FA Posting Date" Boolean

Indicates whether depreciation is calculated until the FA posting date.

"Duplicate in Depreciation Book" Code[10]

Specifies another depreciation book to duplicate the posting to.

"Use Duplication List" Boolean

Indicates whether to use the duplication list for fixed asset posting.

"Responsibility Center" Code[10]

Specifies the responsibility center that processed this line.

"Item Category Code" Code[20]

Specifies the item category code for the item on the line.

Nonstock Boolean

Indicates whether the item is a catalog item not in regular inventory.

"Purchasing Code" Code[10]

Specifies the purchasing code for special order handling.

"Item Reference No." Code[50]

Specifies the item reference number for cross-reference lookup.

"Item Reference Unit of Measure" Code[10]

Specifies the unit of measure from the item reference.

"Item Reference Type" Enum Microsoft.Inventory.Item.Catalog."Item Reference Type"

Specifies the type of item reference used.

"Item Reference Type No." Code[30]

Specifies the number associated with the item reference type.

"Return Qty. Rcd. Not Invd." Decimal

Specifies the return quantity received but not yet invoiced.

"Appl.-from Item Entry" Integer

Specifies the item ledger entry this return was applied from.

"Item Charge Base Amount" Decimal

Specifies the base amount for item charge allocation.

Correction Boolean

Indicates whether this is a correcting entry that reverses a previous posting.

"Return Order No." Code[20]

Specifies the return order number that this line was created from.

"Return Order Line No." Integer

Specifies the return order line number that this line was created from.

"Return Reason Code" Code[10]

Specifies the reason code for the return.

"Price Calculation Method" Enum Microsoft.Pricing.Calculation."Price Calculation Method"

Specifies the method used to calculate prices on the line.

"Allow Line Disc." Boolean

Indicates whether line discounts are allowed on this line.

"Customer Disc. Group" Code[20]

Specifies the customer discount group for line discount calculations.

"Sell-to Customer Name" Text[100]

Specifies the name of the sell-to customer from the customer record.

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

GetCurrencyCode

Retrieves the currency code from the return receipt header.

procedure GetCurrencyCode(): Code[10]

Returns

Type Description
Code[10]

The currency code for this return receipt line.

ShowDimensions

Opens the dimension set entries page for this return receipt line.

procedure ShowDimensions()

ShowItemTrackingLines

Opens the Item Tracking Lines page showing the tracking for this return receipt line.

procedure ShowItemTrackingLines()

InsertInvLineFromRetRcptLine

Inserts a sales credit memo line from this return receipt line.

procedure InsertInvLineFromRetRcptLine(var SalesLine: Record "Sales Line")

Parameters

Name Type Description
SalesLine Table Microsoft.Sales.Document."Sales Line"

Returns the created sales line.

GetSalesCrMemoLines

Retrieves credit memo lines associated with this return receipt line.

procedure GetSalesCrMemoLines(var TempSalesCrMemoLine: Record "Sales Cr.Memo Line" temporary)

Parameters

Name Type Description
TempSalesCrMemoLine Table Microsoft.Sales.History."Sales Cr.Memo Line"

Returns the temporary sales credit memo lines.

FilterPstdDocLnItemLedgEntries

Applies filters to item ledger entries to retrieve entries for this posted document line.

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

Parameters

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

The item ledger entry record to apply filters to.

ShowItemSalesCrMemoLines

Opens a page displaying the credit memo lines for this return receipt line.

procedure ShowItemSalesCrMemoLines()

ShowLineComments

Opens a page displaying the comments for this return receipt line.

procedure ShowLineComments()

InitFromSalesLine

Initializes the return receipt line from a sales line when posting a sales return.

procedure InitFromSalesLine(ReturnRcptHeader: Record "Return Receipt Header"; SalesLine: Record "Sales Line")

Parameters

Name Type Description
ReturnRcptHeader Table Microsoft.Sales.History."Return Receipt Header"

The return receipt header to link to.

SalesLine Table Microsoft.Sales.Document."Sales Line"

The sales line to copy data from.

HasTypeToFillMandatoryFields

Determines whether the line has a type that requires mandatory fields to be filled.

procedure HasTypeToFillMandatoryFields(): Boolean

Returns

Type Description
Boolean

Returns true if the line type is not blank.

SetSecurityFilterOnRespCenter

Applies a security filter based on the user's responsibility center setup.

procedure SetSecurityFilterOnRespCenter()

Events

OnAfterCopyFieldsFromReturnReceiptLine

Raised after copying fields from the return receipt line to a sales line.

[IntegrationEvent(False,False)]
local procedure OnAfterCopyFieldsFromReturnReceiptLine(var ReturnReceiptLine: Record "Return Receipt Line"; var SalesLine: Record "Sales Line")

Parameters

Name Type Description
ReturnReceiptLine Table Microsoft.Sales.History."Return Receipt Line"

The source return receipt line record.

SalesLine Table Microsoft.Sales.Document."Sales Line"

The target sales line record.

OnAfterInitFromSalesLine

Raised after initializing the return receipt line from a sales line.

[IntegrationEvent(False,False)]
local procedure OnAfterInitFromSalesLine(ReturnRcptHeader: Record "Return Receipt Header"; SalesLine: Record "Sales Line"; var ReturnRcptLine: Record "Return Receipt Line")

Parameters

Name Type Description
ReturnRcptHeader Table Microsoft.Sales.History."Return Receipt Header"

The return receipt header record.

SalesLine Table Microsoft.Sales.Document."Sales Line"

The source sales line record.

ReturnRcptLine Table Microsoft.Sales.History."Return Receipt Line"

The return receipt line being initialized.

OnAftertInsertInvLineFromRetRcptLine

Raised after inserting an invoice line from a return receipt line.

[IntegrationEvent(False,False)]
local procedure OnAftertInsertInvLineFromRetRcptLine(var SalesLine: Record "Sales Line"; var SalesOrderLine: Record "Sales Line"; var ReturnReceiptLine: Record "Return Receipt Line"; var IsHandled: Boolean)

Parameters

Name Type Description
SalesLine Table Microsoft.Sales.Document."Sales Line"

The inserted sales line record.

SalesOrderLine Table Microsoft.Sales.Document."Sales Line"

The related sales order line record.

ReturnReceiptLine Table Microsoft.Sales.History."Return Receipt Line"

The source return receipt line record.

IsHandled Boolean

Set to true to skip additional processing.

OnBeforeCopySalesLinePriceAndDiscountFromSalesOrderLine

Raised before copying price and discount from a sales order line to a sales line.

[IntegrationEvent(False,False)]
local procedure OnBeforeCopySalesLinePriceAndDiscountFromSalesOrderLine(var SalesLine: Record "Sales Line"; SalesOrderLine: Record "Sales Line"; var IsHandled: Boolean)

Parameters

Name Type Description
SalesLine Table Microsoft.Sales.Document."Sales Line"

The target sales line record.

SalesOrderLine Table Microsoft.Sales.Document."Sales Line"

The source sales order line record.

IsHandled Boolean

Set to true to skip the default logic.

OnBeforeInsertInvLineFromRetRcptLine

Raised before inserting an invoice line from a return receipt line.

[IntegrationEvent(False,False)]
local procedure OnBeforeInsertInvLineFromRetRcptLine(var SalesLine: Record "Sales Line"; SalesOrderLine: Record "Sales Line"; var ReturnReceiptLine: Record "Return Receipt Line"; var IsHandled: Boolean; NextLineNo: Integer)

Parameters

Name Type Description
SalesLine Table Microsoft.Sales.Document."Sales Line"

The sales line to be inserted.

SalesOrderLine Table Microsoft.Sales.Document."Sales Line"

The related sales order line record.

ReturnReceiptLine Table Microsoft.Sales.History."Return Receipt Line"

The source return receipt line record.

IsHandled Boolean

Set to true to skip the default logic.

NextLineNo Integer

The next line number to be used.

OnBeforeInsertInvLineFromRetRcptLineBeforeInsertTextLine

Raised before inserting a text line when inserting an invoice line from a return receipt line.

[IntegrationEvent(False,False)]
local procedure OnBeforeInsertInvLineFromRetRcptLineBeforeInsertTextLine(var ReturnReceiptLine: Record "Return Receipt Line"; var SalesLine: Record "Sales Line"; var NextLineNo: Integer; var IsHandled: Boolean)

Parameters

Name Type Description
ReturnReceiptLine Table Microsoft.Sales.History."Return Receipt Line"

The source return receipt line record.

SalesLine Table Microsoft.Sales.Document."Sales Line"

The sales line record.

NextLineNo Integer

The next line number to be used.

IsHandled Boolean

Set to true to skip the default logic.

OnInsertInvLineFromRetRcptLineOnBeforeInitSalesLine

Raised before initializing the sales line during InsertInvLineFromRetRcptLine.

[IntegrationEvent(False,False)]
local procedure OnInsertInvLineFromRetRcptLineOnBeforeInitSalesLine(var ReturnReceiptLine: Record "Return Receipt Line"; SalesLine: Record "Sales Line")

Parameters

Name Type Description
ReturnReceiptLine Table Microsoft.Sales.History."Return Receipt Line"

The source return receipt line record.

SalesLine Table Microsoft.Sales.Document."Sales Line"

The sales line record being initialized.

OnInsertInvLineFromRetRcptLineOnAfterInsertAllLines

Raised after inserting all lines during InsertInvLineFromRetRcptLine.

[IntegrationEvent(False,False)]
local procedure OnInsertInvLineFromRetRcptLineOnAfterInsertAllLines(ReturnReceiptLine: Record "Return Receipt Line"; var SalesLine: Record "Sales Line"; var IsHandled: Boolean)

Parameters

Name Type Description
ReturnReceiptLine Table Microsoft.Sales.History."Return Receipt Line"

The source return receipt line record.

SalesLine Table Microsoft.Sales.Document."Sales Line"

The sales line record.

IsHandled Boolean

Set to true to skip additional processing.

OnInsertInvLineFromRetRcptLineOnBeforeValidateSalesLineQuantity

Raised before validating the sales line quantity during InsertInvLineFromRetRcptLine.

[IntegrationEvent(False,False)]
local procedure OnInsertInvLineFromRetRcptLineOnBeforeValidateSalesLineQuantity(var ReturnReceiptLine: Record "Return Receipt Line"; var SalesLine: Record "Sales Line"; var IsHandled: Boolean; var SalesHeader: Record "Sales Header")

Parameters

Name Type Description
ReturnReceiptLine Table Microsoft.Sales.History."Return Receipt Line"

The source return receipt line record.

SalesLine Table Microsoft.Sales.Document."Sales Line"

The sales line record.

IsHandled Boolean

Set to true to skip the default logic.

SalesHeader Table Microsoft.Sales.Document."Sales Header"

The sales header record.

OnAfterDescriptionSalesLineInsert

Raised after inserting the description sales line.

[IntegrationEvent(False,False)]
local procedure OnAfterDescriptionSalesLineInsert(var SalesLine: Record "Sales Line"; ReturnReceiptLine: Record "Return Receipt Line"; var NextLineNo: Integer)

Parameters

Name Type Description
SalesLine Table Microsoft.Sales.Document."Sales Line"

The inserted sales line record.

ReturnReceiptLine Table Microsoft.Sales.History."Return Receipt Line"

The source return receipt line record.

NextLineNo Integer

The next line number after insertion.

OnInsertInvLineFromRetRcptLine

Raised during the insertion of an invoice line from a return receipt line.

[IntegrationEvent(False,False)]
local procedure OnInsertInvLineFromRetRcptLine(var ReturnReceiptLine: Record "Return Receipt Line"; var SalesLine: Record "Sales Line"; var IsHandled: Boolean)

Parameters

Name Type Description
ReturnReceiptLine Table Microsoft.Sales.History."Return Receipt Line"

The source return receipt line record.

SalesLine Table Microsoft.Sales.Document."Sales Line"

The sales line being inserted.

IsHandled Boolean

Set to true to skip the default logic.

OnOnInsertInvLineFromRetRcptLineOnAfterCopySalesLinePriceAndDiscount

Raised after copying sales line price and discount during InsertInvLineFromRetRcptLine.

[IntegrationEvent(False,False)]
local procedure OnOnInsertInvLineFromRetRcptLineOnAfterCopySalesLinePriceAndDiscount(var SalesLine: Record "Sales Line"; SalesOrderLine: Record "Sales Line"; ReturnReceiptLine: Record "Return Receipt Line"; SalesHeader: Record "Sales Header")

Parameters

Name Type Description
SalesLine Table Microsoft.Sales.Document."Sales Line"

The target sales line record.

SalesOrderLine Table Microsoft.Sales.Document."Sales Line"

The source sales order line record.

ReturnReceiptLine Table Microsoft.Sales.History."Return Receipt Line"

The return receipt line record.

SalesHeader Table Microsoft.Sales.Document."Sales Header"

The sales header record.

OnInsertInvLineFromRetRcptLineOnAfterSalesHeaderGet

Raised after getting the sales header during InsertInvLineFromRetRcptLine.

[IntegrationEvent(False,False)]
local procedure OnInsertInvLineFromRetRcptLineOnAfterSalesHeaderGet(var ReturnReceiptLine: Record "Return Receipt Line"; var SalesHeader: Record "Sales Header"; var SalesLine: Record "Sales Line")

Parameters

Name Type Description
ReturnReceiptLine Table Microsoft.Sales.History."Return Receipt Line"

The source return receipt line record.

SalesHeader Table Microsoft.Sales.Document."Sales Header"

The sales header record.

SalesLine Table Microsoft.Sales.Document."Sales Line"

The sales line record.

OnInsertInvLineFromRetRcptLineOnBeforeNoExtTextLineError

Raised before raising the no extended text line error during InsertInvLineFromRetRcptLine.

[IntegrationEvent(False,False)]
local procedure OnInsertInvLineFromRetRcptLineOnBeforeNoExtTextLineError(var ReturnReceiptLine: Record "Return Receipt Line")

Parameters

Name Type Description
ReturnReceiptLine Table Microsoft.Sales.History."Return Receipt Line"

The return receipt line record.

OnInsertInvLineFromRetRcptLineOnAfterCalcUnitPrice

Raised after calculating the unit price during InsertInvLineFromRetRcptLine.

[IntegrationEvent(False,False)]
local procedure OnInsertInvLineFromRetRcptLineOnAfterCalcUnitPrice(var ReturnReceiptLine: Record "Return Receipt Line"; SalesHeader: Record "Sales Header"; SalesHeader2: Record "Sales Header"; var SalesLine: Record "Sales Line"; var SalesOrderLine: Record "Sales Line"; Currency: Record Currency)

Parameters

Name Type Description
ReturnReceiptLine Table Microsoft.Sales.History."Return Receipt Line"

The source return receipt line record.

SalesHeader Table Microsoft.Sales.Document."Sales Header"

The sales header record.

SalesHeader2 Table Microsoft.Sales.Document."Sales Header"

The secondary sales header record.

SalesLine Table Microsoft.Sales.Document."Sales Line"

The sales line record.

SalesOrderLine Table Microsoft.Sales.Document."Sales Line"

The sales order line record.

Currency Table Microsoft.Finance.Currency.Currency

The currency record.

OnBeforeSetSecurityFilterOnRespCenter

Raised before setting the security filter on responsibility center for the return receipt line.

[IntegrationEvent(False,False)]
local procedure OnBeforeSetSecurityFilterOnRespCenter(var ReturnReceiptLine: Record "Return Receipt Line"; var IsHandled: Boolean)

Parameters

Name Type Description
ReturnReceiptLine Table Microsoft.Sales.History."Return Receipt Line"

The return receipt line record.

IsHandled Boolean

Set to true to skip the default logic.

OnInsertInvLineFromRetRcptLineOnBeforeSalesHeaderGet

Raised before getting the sales header during InsertInvLineFromRetRcptLine.

[IntegrationEvent(False,False)]
local procedure OnInsertInvLineFromRetRcptLineOnBeforeSalesHeaderGet(var SalesHeader: Record "Sales Header"; ReturnReceiptLine: Record "Return Receipt Line"; var TempSalesLine: Record "Sales Line" temporary; var IsHandled: Boolean)

Parameters

Name Type Description
SalesHeader Table Microsoft.Sales.Document."Sales Header"

The sales header record.

ReturnReceiptLine Table Microsoft.Sales.History."Return Receipt Line"

The source return receipt line record.

TempSalesLine Table Microsoft.Sales.Document."Sales Line"

The temporary sales line buffer.

IsHandled Boolean

Set to true to skip the default logic.

OnBeforeShowItemTrackingLines

Raised before showing item tracking lines for the return receipt line.

[IntegrationEvent(False,False)]
local procedure OnBeforeShowItemTrackingLines(var ReturnReceiptLine: Record "Return Receipt Line"; var IsHandled: Boolean)

Parameters

Name Type Description
ReturnReceiptLine Table Microsoft.Sales.History."Return Receipt Line"

The return receipt line record.

IsHandled Boolean

Set to true to skip the default logic.

See also