Share via

SalesLine

  • Article

Description

Defines the common properties for all sales document lines in the Sales Order Processing module of Microsoft Dynamics GP.

Properties

Property

Type

Length

Default

Description

Key

SalesLineKey

N/A

N/A

The sales line key object that uniquely identifies a sales line.

UnitPrice

MoneyAmount

N/A

0

The unit price of the item.

TotalAmount

MoneyAmount

N/A

If not provided, set to UnitPrice x Quantity.

The extended price for the sales line.

Quantity

Quantity

N/A

0

The quantity for the sales line.

Discount

MoneyPercentChoice

N/A

Default from sales document, otherwise 0.

The type and amount of the markdown for the sales line. The markdown amount can be a money amount or a percent.

UnitCost

MoneyAmount

N/A

Default from item if a return document line, otherwise 0.

The unit cost of a non-inventory item or an item on a return document line.

ItemDescription

string

100

Empty

The description of the item on the sales line.

IsNonInventory

boolean

N/A

False

Indicates whether the item on the sales line is not an inventory item.True indicates it is non-inventory item. False indicates it is an inventory item.

IsDropShip

boolean

N/A

False

Indicates whether the item is a drop ship item. True indicates it is a drop ship item. False indicates it is not. The drop ship status must be set to False for a negative quantity invoice item.

RequestedShipDate

dateTime

N/A

If not provided, defaults to the document date.

The date on which the item should be shipped.

Comment

string

N/A

Empty

A comment on the sales line.

UofM

string

8

Empty

The unit of measure for the sales line.

DeleteOnUpdate

boolean

N/A

False

Set to True when calling the Update operation to remove the sales line.

ExtendedCost

MoneyAmount

N/A

Set to Quantity x UnitCost

The extended cost of the sales line. This property is read-only.

ItemTaxScheduleKey

TaxScheduleKey

N/A

N/A

The tax schedule key object that uniquely identifies the item tax schedule for a sales line. This property is read-only.

TaxBasis

SalesTaxBasis

N/A

N/A

A tax option which will determine whether the item on the sales line is taxable. If it is taxable, it also specifies which tax schedule will be used. If the tax option for the item is Taxable, the tax schedule for the line item is compared to the item tax schedule. Taxes will be calculated for tax details found in both schedules. If the tax option for the item is Nontaxable, no tax is calculated for that item. If the tax option for the item is Based on Customer, the line item's tax schedule is used for calculating taxes for item. This property is read-only.

TaxAmount

MoneyAmount

N/A

Sum of the tax details for the line.

The tax amount for the sales line. This property is read-only.

TaxScheduleKey

TaxScheduleKey

N/A

N/A

The tax schedule key object that uniquely identifies the sales tax schedule for a sales line. This property is read-only.

CostOfSalesGLAccount
Key

GLAccountNumberKey

N/A

N/A

The GL account number key object that specifies the account to which cost of sales amounts for this sales line will be posted. This property is read-only.

DamagedGLAccountKey

GLAccountNumberKey

N/A

N/A

The GL account number key object that specifies the account to which damaged goods costs for this sales line will be posted. This property is read-only.

InServiceGLAccountKey

GLAccountNumberKey

N/A

N/A

The GL account number key object that specifies the account that will be updated when you enter a return document line and return some part of the total item quantity to the In Service quantity type. This property is read-only.

InUseGLAccountKey

GLAccountNumberKey

N/A

N/A

The GL account number key object that specifies the account that will be updated when you enter a return document line and return some part of the total item quantity to the In Use quantity type. This property is read-only.

InventoryGLAccountKey

GLAccountNumberKey

N/A

N/A

The GL account number key object that specifies the account to which inventory amounts for this sales line will be posted. This property is read-only.

DiscountGLAccountKey

GLAccountNumberKey

N/A

N/A

The GL account number key object that specifies the account to which discount (markdown) amounts for this sales line will be posted. This property is read-only.

ReturnsGLAccountKey

GLAccountNumberKey

N/A

N/A

The GL account number key object that specifies the account to which return amounts for this sales line will be posted. This property is read-only.

SalesGLAccountKey

GLAccountNumberKey

N/A

N/A

The GL account number key object that specifies the account to which sales amounts for this sales line will be posted. This property is read-only.

FrontOfficeIntegrationId

string

 

 

 

IntegrationSource

int

 

 

 

IntegrationId

string

 

 

 

WarehouseKey

WarehouseKey

N/A

If not provided, set based on the Default Warehouse Behavior option specified.

The warehouse key object that uniquely identifies the warehouse for a sales line.

ItemKey

ItemKey

N/A

N/A

The item key object that uniquely identifies the item for a sales line.

ShippingMethodKey

ShippingMethodKey

N/A

If not provided, defaults from Sales Document.

The shipping method key object that uniquely identifies the shipping method for a sales line.

SalesTerritoryKey

SalesTerritoryKey

N/A

N/A

The sales territory key object that uniquely identifies the sales territory for a sales line.

SalespersonKey

SalespersonKey

N/A

If not provided, defaults from ship to address on the sales line.

The salesperson key object that uniquely identifies the salesperson for a sales line.

CommentKey

CommentKey

N/A

N/A

The comment key object that uniquely identifies the comment for a sales line.

PriceLevelKey

PriceLevelKey

N/A

N/A

The price level key object that uniquely identifies the price level for a sales line.

ShipToAddressKey

CustomerAddressKey

N/A

N/A

The customer address key object that uniquely identifies the ship to address for a sales line.

ShipToAddress

BusinessAddress

N/A

If nothing is supplied, the default will be supplied from the "ship to" address on the SalesDocument. If any one of the following are supplied, the remaining that are not supplied will default to blank:

BusinessAddress.Name Address.Line1 Address.Line2 Address.Line3 Address.City Address.State Address.PostalCode Address.Country BusinessAddress.ContactPerson Address.Phone1 Address.Phone2 Address.Phone3 Address.Fax

 

The address details of the ship to address for the sales line.

Taxes

ArrayOfSalesLineTax

N/A

N/A

A collection a tax details for a sales line.

Inherits from

BusinessObject