skip to Main Content
1-512-829-4000 sales@adv-usa.com

1099 processing, reporting, and correction in NAV

If you have 1099 vendors, here is how to setup, process, report and make corrections related to 1099 in NAV

SETUP THE VENDORS

Go to your vendor card(s) and fill in the IRS 1099 Code for the vendor on the Payments fast tab.

clip_image002

If you want to see what the Minimum reporting threshold for the code you are choosing, Select Advanced.

clip_image004

If you need to update a codes Minimum reporting amount, select Edit List from Home tab on the ribbon at the top and change the amount.

TRANSACTION ENTRY

When you enter transactions for the vendor, the IRS 1099 Code will fill in on the header on the Invoicing tab. You may override the IRS 1099 Code in the header if the invoice for the vendor does not relate to the 1099.

clip_image006

In the lines section, make sure you have the IRS 1099 Liable field displayed. If it is not displayed, right click on the label line showing the field names and Select Show Column. Click on the fields and click Add and then click OK. The screen will refresh.

clip_image008

The lines you enter will have this field flagged by default if there is an IRS 1099 code in the header.

If the line you are entering is not 1099 liable (reimbursed expenses), you should unflag the IRS 1099 liable field.

When you post the transaction, if you go to the Vendor list view and select a vendor, you can click on 1099 Statistics

clip_image010

This will display the 1099 summary for the vendor.

clip_image012

You can also go to the vendor card and click on 1099 Statistics from the Navigate ribbon.

To see the detail select Ledger Entries from the ribbon to see the specific Vendor Ledger Entries with their IRS 1099 Code and IRS 1099 Amount.

clip_image014

clip_image016

CORRECTING ENTRIES

If for instance for Invoice 108028, a transaction should have been a 1099 invoice, you may click in the IRS 1099 Code and IRS 1099 Amount fields and make corrections.

Here the first line which did not have 1099 information is updated.

clip_image018

REPORT VERIFICATION/PRINTING

There are a couple of ways you can verify your 1099 amounts.

1. Run the Vendor- Detail Trial Balance report

Here is an example of the parameters:

You will likely need to click on Add filter under the Vendor tab and add IRS 1099 Code and enter your filters.

clip_image020

clip_image022

2. Vendor Account Detail report

clip_image024

The output looks like this:

clip_image026

3. Run the 1099 reports found under Financial Management>Payables>Documents. (This is what you print on your pre-printed forms to send to your vendors. The documents will display ONLY if the 1099 related payments in the year are at or above the threshold for the 1099 code and the payments have been applied to the invoices

clip_image028

When entering payments, make sure you set the ‘Document Type’ to Payment or the 1099 report won’t pick it up.

Meghan Parisi

Consultant for Microsoft Dynamics NAV responsible for implementation, training, project management, support, testing, and documentation.

Back To Top
Search