View account sale details

Article • 10/30/2024 • 6 min read

You can view the following fields on the Account Sale Detail page.

Field	Description
Type	Specifies the type of the account sale detail line. The available options are Revenue: Indicates that it is linked to an account sale revenue line. Cost: Indicates that it is linked to an account sale cost line.
Subtype	Specifies the subtype of the revenue detail lines, indicating the current phase of the sales source. When the Type field is set to Revenue, the available options are: Expected: Indicates that the account sale detail line refers to a sales document that is not yet invoiced. Actual: Indicates that the account sale detail line refers to a value entry for revenue that resulted from a sales invoice. When the Type field is set to Cost, the available options are: Expected: Indicates that the account sale detail line refers to a value entry for a cost that needs to be invoiced. Actual: Indicates that the account sale detail line refers to a value entry for a cost that resulted from a purchase invoice.
Source Document Type	Specifies the type of document from which this account detail line was created. When the Type field is set to Revenue, the available options are: Sales Order Sales Shipment Sales Invoice When the Type field is set to Cost, the available options are: Purchase Receipt Purchase Invoice
Source Document No.	Specifies the document line number from which this account sale detail line was created. The document line number always corresponds to the document specified in the Source Document No. field.
Source Document Line No.	Specifies the document line number for which this account sale detail line was created. The document line number always corresponds to the document specified in the Source Document No. field.
Source Name	Specifies the name of the source. For account sale detail lines of type as a Revenue, the customer’s name is displayed in the Source Name field.
Source Document Category	Specifies the value of the source document category for the selected pooling detail line. The available options are: Return: Used for sales document lines of the item type. Credit: Used for sales document lines of the charge (item) type.
Posting Date	Specifies the posting date of the item ledger entry displayed on the account sale detail line. If the detail line does not refer to an item ledger entry, the posting date of the unposted document is displayed.
Item Ledger Entry No.	Specifies the item ledger entry number from which this account sale detail line is created.
Item Ledger Entry Type	Specifies the item ledger entry type from which this account sale detail line is created.
Gross Revenue (Direct)	Specifies the gross revenue from the specific source document. In all cases, this is calculated as the Unit Price field value in the sales document line multiplied by the Quantity field value in the sales document line.
Discount Value (Direct)	Specifies all types of possible discounts that are applicable to the specific sales document line. The following discount are: Sales Line Discount: This can be filled using the standard Business Central sales discount functionality or business logic from other Aptean extensions such as Advance Pricing or Trade Management. Invoice Discount: This discount is applied through the Business Central sales discount functionality. Item Charge Costs: This cost is posted to the sales document line with an Account Sale type of Accrual.
Net Revenue (Direct)	Specifies the Net revenue of the sales document line, calculated by Gross revenue (direct) - Discount Value (direct).
Factor	Specifies the output factor associated with the item ledger entry. This value is retrieved from the line trace functionality of the settlement.
Gross Revenue (Indirect)	Specifies the Gross Revenue field value of the sale document line multiplied by the Factor field value. In case the lot number sold/shipped/invoiced on the sales document line is a production lot number, the value represents the proportion of the gross revenue that is allocated to this purchase lot/line trace, as opposed to other lot numbers that may have contributed to the production lot in the form of supplying consumption for it.
Discount Value (Indirect)	Specifies the calculated discount value of the sale document line multiplied by the Factor field value.
Net Revenue (Indirect)	Specifies the direct net revenue of the sales document line, calculated as follows: Gross revenue (Direct) - Discount Value (Direct)
Trade Plan No.	Specifies the number of the trade plan under which the value entry was created that resulted in this account sale detail line.
Trade Cost Posting Type	Specifies the posting type of the trade cost. The available options are Empty, Standard, Expected, and Reversal.
Item Charge No.	Specifies the item charge number used in the value entry that resulted in this account sale detail line. Item charges can be used to post either costs or revenue which are picked up in the settlement calculation of purchase orders set to the account sale accounting method.
Item Charge Description	Specifies the description of the item charge number.
Source Quantity (Base)	Specifies the quantity of the item in the source document, expressed in the base unit of measure.
Source Base Unit of Measure Code	Specifies the base unit of measure of the item registered in the source document from which this account sale detail line was created.
Source Quantity (Direct)	Specifies the quantity registered in the source document from which this account sale detail line was created.
Source Unit of Measure Code	Specifies the unit of measure registered in the source document from which this account sale detail line was created.
Item No.	Specifies the number of the item associated with the account sale detail line.
Item Description	Specifies the description of the item associated with the account sale detail line.
Source Unit Price (Gross)	Specifies the direct unit price in the unit of measure of the sales document from which this account sale detail line was created. This value is visible only for account sale detail lines with the Type field set as Sales or Claim.
Source Unit Discount Value	Specifies the unit discount granted in the source document from which this account sale detail line was created.
Source Unit Price (Net)	Specifies the value of the direct unit price minus discounts in the unit of measure of the sales document from which this account sale detail line was created. This value is visible only for account sale detail lines with the Type field set as Sales or Claim.
Source Base Unit Price (Gross)	Specifies the direct unit price in the base unit of measure of the item. The value originates from the sales document from which this account sale detail line was created. This value is visible only for account sale detail lines with the Type field set as Sales or Claim.
Source Base Unit Price (Net)	Specifies the value of the direct unit price minus discounts in the base unit of measure of the item. This value originates from the sales document from which this pooling detail line was created. This value is visible only for account sale detail lines with the Type field set as Sales or Claim.