Order lines report (SalesLinesExtended) [AX 2012]

Updated: May 11, 2011

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

You can use the Order lines report to print sales order lines and basic information for each sales order line such as item number, sales price, and discount.

When you generate this report, the following default parameters are displayed. You can use these parameters to filter the data that will be displayed on the report. For more information, see Filter the data on a report.

Field

Description

Print

Use the check boxes in this field group to print information about the sales order lines per order status. The options are:

Quantity

Allocation

Weight

Volume

Gross amount

Discount

Net amount

Cost value

Margin

View

Use the check boxes in this field group to print available inventory dimensions for each sales order line. The options are:

Configuration

Size

Color

Site

Warehouse

Batch number

Serial number

Order lines

To create a query based on the following sales order criteria, click Select. You can indicate one or more of the following:

Item number

Sales order

Line status

Inventory dimensions

To create a query based on the following inventory dimensions, click Select. You can indicate one or more of the following:

Configuration

Size

Color

Site

Warehouse

The following topics explain how to print a report and how to filter and sort the data on a report.

The following table explains where to find the report in the Application Object Tree (AOT) and how to navigate to the report in the Microsoft Dynamics AX client.

Detail

Description

Name of report in the AOT

SalesLinesExtended

Location of report in the AOT

SSRS Reports\Reports\SalesLinesExtended

Menu item of the report

SalesLinesExtended

Navigation to the report

Click Sales and marketing > Reports > Transactions > Sales orders > Order lines.

The data on this report comes from the following sources:

  • SalesLinesExtendedTmp table

NoteNote

To learn where the data in the temp table comes from, view the cross-references for the SalesLinesExtendedDP.processReport class.

If you are a developer, you can learn more about where the data on a report comes from by using the following procedure.

  1. Open the AOT.

  2. Locate the report in the SSRS Reports\Reports node.

  3. Right-click the report and click Add-Ins > Cross-reference > Using (instant view).


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

ADD
Show: