(USA) Tax 1099 detail report (Tax1099Detail) [AX 2012]

Updated: September 13, 2011

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

The Tax 1099 detail report is used to print a detailed list of 1099 statement transactions for each vendor and to verify the information before filing 1099 statements with the IRS. The report shows the 1099 amount for each voucher, the vendor's total amount by box, the vendor's total 1099 amount, and a total of the 1099 amounts for all vendors specified on the report. This report is typically used by collections managers, accountants, accounting managers, and accounting supervisors.


(USA) This report is only available to legal entities whose primary address is in the United States.

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 筛选报表上的数据.



Vendor account

The identification number of the vendor account for which the report is generated.


The state where the 1099 statements are filed.

1099 box

The box code on the 1099 form where the total amount is posted.

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.



Name of report in the AOT


Location of report in the AOT

SSRS Reports\Reports\Tax1099Detail

Menu item of the report


Navigation to the report

Click Accounts payable > Reports > Tax 1099 > Tax 1099 detail.

The data on this report comes from the following sources:

  • Tax1099Detail table

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).