ERP Software Logo

Microsoft Dynamics vendors provide comparisons and opinions to professionals in the ERP/Accounting software selection process

 
 

Columbus Global

1099 Report Processing in Microsoft Dynamics AX 2012 R3


Email | Print

In this blog post, we will walk you through some of the important steps related to 1099 report processing.

1099 Reporting

  • Businesses required to file with IRS and provide individual reports to recipients annually
  • End-of-year process for Accounts Payable department
    • Ensure vendors marked as 1099 vendors
    • Verify receipt of W-9s from 1099 vendors
    • Review vendor invoices and make adjustments
      • Verify 1099 amounts captured are accurate
      • 1099 amounts for services

 

1099 Setup

  • Legal entity form
    • Navigation path: Organization administration>Setup>Organization> Legal entities
    • Enter Federal Tax ID
  • 1099 reportable amounts
    • Navigation path: Accounts payable>Setup>Tax 1099>1099 fields
    • Update Minimum amount reportable per 1099 box
  • Vendor setup

 

1099 Vendor Setup

  • Vendor record
    • Report 1099 checkbox
      • Record paid vendor invoice amounts as 1099 reportable
    • W-9 received
    • Check for W-9
    • Federal tax ID
    • Tax ID type
      • Employee Identification number, Individual Taxpayer Identification, etc.
    • 1099 box
    • Name to use on the 1099
    • DBA

 

1099 amount during invoicing

  • Modify 1099 amount on vendor invoice line during invoice processing
    • AP Vendor invoice journal lines (non-PO invoice)
      • 1099 tab or Invoice tab
      • Entered as a negative amount

Dynamics AX 1099 Vendor Invoice Amount

 

 

 

 

 

 

 

  • Modify 1099 amount on purchase order during invoice processing
    • Purchase order invoice line details
      • 1099 tab

Dynamics AX 1099 Purchase Order

 

 

 

 

 

 

 

 

 

 

Review 1099 amounts

  • Review vendor paid invoices
    • Review 1099 invoice amounts and make appropriate adjustments
    • Services not goods
    • Pass-through: Vendor previously reimbursed for expenses
  • Review and make adjustments by individual vendor
    • Vendor record>Vendor settlement for 1099s
    • Click Tax 1099 transactions to review individual paid invoice amounts and edit Settled 1099 amount or 1099 box
  • Review and make adjustments for all vendors
    • Navigation path: Accounts Payable>Periodic>Vendor settlement for 1099s
    • Enter date range in Criteria area
    • Enter vendor range in Criteria area
    • IRS reportable
    • Tax 1099 transactions for paid invoice detail
  • Verify Settled federal amount and 1099 box for each paid invoice

 

Update invoice transactions as 1099

  • Update paid invoices as 1099 reportable
    • Vendor record>Update 1099 on Vendor tab
    • Parameters:
      • From date / To date
      • Update all

 

Generate individual 1099 reports

  • Vendor settlements for 1099s
    • Navigation path: Accounts Payable>Periodic>Vendor settlements for 1099s
    • Enter date range in Criteria area
    • Enter vendor range in Criteria area
    • Click Print
  • Print parameters:
    • Type of Tax 1099 form
    • Reporting year
    • (Optional) State

 

1099 individual vendor report

Dynamics AX 1099 Individual Vendor Report

 

 

 

 

 

 

 

 

 

 

Create export file

  • Setup
    • 1099 transmitter form
      • Company contact info for filing electronically
    • 1099 software vendor form
      • Software vendor info and contact info for filing electronically
    • Generate file

 

1099 related reports

  • Tax 1099 summary report
    • 1099 reportable amounts and total grouped by vendor account
    • Navigation path: Accounts Payable>Reports>Tax 1099>Tax 1099 summary

 

 

 

 

 

 

 

  • Tax 1099 detail report
    • 1099 reportable amounts including date, voucher and invoice columns, total and grouped by vendor account
    • Navigation path: Accounts Payable>Reports>Tax 1099>Tax 1099 detail

Dynamics AX 1099 Detail Report

 

 

  • Duplicate taxpayer identification report
    • Verify no taxpayers have duplicate identification numbers
    • Navigation path: Accounts Payable>Reports>Tax 1099>Tax 1099 duplicate taxpayer identification

Dynamics AX 1099 Duplicate Taxpayer Identification Report

 

Should you have any questions, please feel free to reach out to us.

To learn more about how Tridea Partners can help you get the most out of your Microsoft solution, visit www.columbusglobal.com or contact us at [email protected]

Comments are closed.