Top 10 Most Asked Questions for 1099 Processing in NAV

by | Updated July 18, 2017 | Dynamics 365 Business Central, Dynamics NAV

*This post was written for Dynamics NAV but the content directly applies to Dynamics 365 for Financials, which is the cloud product based on Dynamics NAV. You may notice some slight differences in the screenshots, but the information and steps are directly applicable to Dynamics 365 for Financials.

Each year as the 1099 season approaches, I find myself fielding similar questions regarding 1099 processing in Dynamics NAV. Below is a summary of those questions and answers.

Q1: Why doesn’t changing the “1099 Code” field on the vendor card impact the output on my 1099 documents?

A: When reporting on 1099 information, NAV looks directly at the vendor ledger entry table (posted history). Changing the vendor card setup will only impact future postings against the vendor.

Q2: Can I change 1099 information on a transaction after it’s been posted?

A: Yes. If you find yourself in a position where certain vendor ledger entries are missing a 1099 code, have the wrong 1099 code, or have an incorrect 1099 amount; the “1099 Code” and “1099 Amount” fields on the vendor ledger entry page are editable and can be adjusted after the fact.

Q3: NAV includes summary 1099 codes like “MISC” and “INT” in its 1099 code listing. Should I use them?

A:   No. These codes are there as headings and should not be assigned to vendors or documents. For example, dollars reported against 1099 code “MISC” won’t show up within the printed 1099, while codes like “MISC-07” and “DIV-03” will.

Q4: The minimum reportable 1099 amount has changed, how do I adjust this setting within NAV?

A: There is a “Minimum Reportable” column within the “IRS From-Box” page. This value can be changed at any time. You can access this page by searching for “1099 Forms-Boxes” or by drilling into the “1099 Code” field on the vendor card. 

Q5: Can I create a magnetic media file out of NAV?

A: Yes. Search for “Vendor 1099 Magnetic Media” or navigate to “Financial Management” > “Payables” > “Reports”.

Q6: Why do some vendors appear on the “1099 Information” report, but don’t print as an actual 1099 document?

A: The 1099 documents respect the “Minimum Reportable” setting within the “IRS Forms-Box” setup, while the 1099 Information report does not. Thus, you may see some vendors listed on the 1099 Vendor Information report that have 1099able amounts below the “Minimum Reportable”.

Q7: Does the “1099 Code” and “1099 Amount” fields on a “payment” vendor ledger entry matter?

A: No. If end of the year adjustments need to be made to the vendor ledger entries, only the 1099able invoices and credit memos need to be considered. 

Q8: Why don’t all of my 1099able invoices/credits not pull into the 1099 document?

A: Only 1099able invoices/credits that have been applied against a payment within the calendar year will be included. Unpaid invoices will pull into next year’s 1099.

Q9: How do I post an invoice that’s only partially 1099able?

A: Mark the header with the appropriate 1099 code. Then, at the line level, make sure to check/un-check the “1099 Liable” column appropriately. For example, if only half of a $100 invoice is 1099able, you can key in a two line purchase invoice ($50 per line) and only mark one of the lines as “1099 Liable”. Posting this invoice will result in a vendor ledger entry where “Amount” = $100 and “1099 Amount” = $50.

Q10: Should I set the 1099 code on the vendor card or on the document’s header?

A: It depends. I usually suggest that for a vendor that is usually 1099able, the “1099 Code” field on the vendor card should be filled in. For a vendor that is only 1099able on occasion, leave the vendor card’s “1099 Code” field blank, then manually fill in the purchase invoice/order header’s “1099 Code” field manually as needed.

Related Posts

4 Comments

  1. Molly Moats

    Hi, I am trying to filter the 1099 vendor information report by Global Dimension 1. I want to filter the global dimension 1 specified on the payment entry. it seems like the filter option is not doing this, what is the purpose of this filter?

  2. Taylor Valnes

    Hello Molly,

    I spoke with Matt, the writer of the blog, and he replied with the following:

    If you are running the stock vendor 1099 information report, setting the “Global Dimension 1 Filter” on the “Vendor” tab of the report’s request page, will not impact the output of the report.

    The “Global Dimension 1 Filter” can be used in some pages/report to limit the transactions reported based on the filter, but the vendor 1099 information report is not one of them.

    However, I believe the report could be modified to get the results you are looking for. You could have your developer (or partner) limit the payments to only those that are included in your “Global Dimension 1 Filter”.

    Regards,
    Taylor

  3. John Clark

    We need to generate 1099’s based on total payments for the year, not total purchase invoices. I’ve tried setting the 1099 code and 1099 amount on ledger entry payments. It does not work. Any suggestions?

  4. Dalton Roll

    Hello John,

    I spoke with the author of the blog, and the following is his response:

    1. NAV works as you described in that it generates 1099s based on total payment for the year. It takes all payment within the year and checks to see the invoice(s) the payment applied to are 1099able.

    2. Setting the 1099 code and 1099 amount on the payment vendor ledger entries won’t work. You need to update the invoice (and credit memo if applicable) vendor ledger entries.

    3. If after adjusting the “invoice” type vendor ledger entries, you still get no 1099 to generate, check the following:
    a. Is the 1099able amount over the minimum reportable amount? (See Q4 from the blog)
    b. Are you using a proper 1099 code (See Q3 from the blog)
    c. Make sure that the 1099able invoices are actually applied to payments that occurred in 2018.
    d. Make sure that the sign of the value you entered in the “1099 Amount” field on the invoices matches the sign of the “Amount” on the vendor ledger entry.

    Regards,
    Dalton

Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events

august

05aug10:00 am10:30 amOn the Job with Dynamics 365 - Manufacturing Shipping / Receiving Department

05aug12:00 pm1:00 pmHow Ag Coops Can Simplify Processing Equity Payments using Levridge

12aug10:00 am10:30 amWhy Levridge Grain? How to Achieve Efficient and Accurate Scale Tickets

12aug12:00 pm1:00 pmThe Three Paths to Dynamics 365 Finance and Supply Chain from Dynamics AX

13aug11:00 am12:00 pmConfab with Stoneridge - Livestream - Inspire Keynote Breakdown

19aug10:00 am11:00 amWhat is Levridge? An Overview of the Ultimate Ag Solution

19aug12:00 pm12:30 pmThe Modern Manufacturer - Death by Safety Stock

27aug11:00 am12:00 pmConfab with Stoneridge - Livestream - Dynamics 365 2020 Wave 2 Preview

september

02sep10:00 am10:30 amThe Modern Manufacturer - Cycle Count Management

09sep11:00 am12:00 pmModernizing Batch Manufacturing - Ensuring Compliance and Quality Control

16sep10:00 am10:30 amThe Modern Manufacturer - Product Lifecycle Management

30sep10:00 am10:30 amThe Modern Manufacturer - Return Management

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X