Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / 1099's Printed for...
Finance | Project Operations, Human Resources, ...
Suggested answer

1099's Printed for Vendors that are not 1099 Vendors and also ignoring 1099 Dollar Limits

(0) ShareShare
ReportReport
Posted on by David Layten 1,817

I have a client that is having issues with One Companies 1099's. Vendors who are setup as "Not a 1099 Vendor" are printing $0.00 1099's. This customer has a GP installation with over 50 company databases. This 1099 issue is happening only in one company so I have to believe that the issue is database related and not GP Code related.

Here are the steps I have taken so far to try to resolve this issue:

1. Reviewed for select "Not a 1099 Vendor" Vendors the PM00200, PM00201, PM00202 and PM00204 tables. Have not found any issues with the data. Check Links has been run on all Purchasing Tables.

2. Used PSTL Tool Kit to recreate with data the PM40104 table. (PM 1099 Setup File).

3. Used Database Maintenance to re-install the Functions, Stored Procedures and Triggers for this database.

I have reviewed similar issues on this site (and others) for GP 2013 and GP 2016. I cannot find a resolution. Looking for any suggestions of other steps to try to fix this for my customer before they have to print 1099's for 2019 in 2020.

Thanks,

David

Categories:
Microsoft Dynamics GP
  • Suggested answer
    David Layten Profile Picture
    David Layten 1,817 on at
    RE: 1099's Printed for Vendors that are not 1099 Vendors and also ignoring 1099 Dollar Limits

    Making sure that the 1099's Minimum Setups are at least $.01 fixed this issue.

  • Suggested answer
    David Layten Profile Picture
    David Layten 1,817 on at
    RE: 1099's Printed for Vendors that are not 1099 Vendors and also ignoring 1099 Dollar Limits

    Brandon,

    Your suggestion did not work. I did start a support case with Microsoft and they were able to solve the issue. The problem was resolved by changing a setting in the 1099 Setup window for Miscellaneous 1099's.

    One of the setups for Rent had the minimum amount set to $0.00 dollars. Per Microsoft's support suggestion, I changed the setting to $0.01 and the 1099's now are printing correctly.

    FYI: All my client's 1099's were for 1099 Nonemployee Compenstation. (1099 Box 7)

    Thanks for your assistance in answering this request.

    David

  • Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: 1099's Printed for Vendors that are not 1099 Vendors and also ignoring 1099 Dollar Limits

    Hello David,

    My name is Brandon and I am an Engineers on the Dynamics GP Team at Microsoft.

    The very first thing I would do when you are seeing issues with a non 1099 Vendor that is reporting 1099's is use the Update 1099 process to change the Vendor and Transactions to a 1099 Vendor and then back to a not 1099 Vendor for the Vendor in questions.

    Please test the steps below:

    I recommend testing this in a test company with a copy of live data to ensure that you receive the results you are looking for:

    KB 871973 How to set up a test company that has a copy of live company data by using SQL Server 7.0, SQL Server 2000, or SQL Server 2005

    support.microsoft.com/.../set-up-a-test-company-that-has-a-copy-of-live-company-data-for-microsoft-dynamics-gp-by-using-microsoft-sql-server

    NOTE:  Please make sure that you have a restorable backup prior to performing any troubleshooting steps.

    1. Open the Update 1099 Information window.

    Purchasing >> Utilities >> Update 1099 Information

    2.Update = Vendor and 1099 Transaction.

    3. From = Not a 1099 Vendor.

    4. To = Miscellaneous

    5. Range = Vendor ID

    6. From / To = Vendor ID in question.

    7. Click INsert.

    8. Click Process.

    9. Print the report.

    10. Repeat the steps above but change back to a Not a 1099 Vendor.

    11. Test if the 1099's now print correctly.

    If this does not work, please open a support case so we can dig into this further together.

    Thank you!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans