I’m new to Dynamics and am developing SSRS reports against the data. I’m working on an AP report but have not been able to track down which table holds the 1099 box numbers and descriptions. Any help would be greatly appreciated!
Hi Diana,
Welcome to the Dynamics User Group!
Can you clarify what you mean by the “the 1099 box numbers and descriptions” ?
I have it as Table 10010 - Called IRS 1099 Form-Box
Thanks Harry - Must be a US localisation
I don’t see Table 10010 in my system. I wonder if this is customized by implementation… Our Solomon administrator is out for a while.
An AP invoice/vendor can be linked to a specific 1099 type. When you print the 1099s at year end, the amount paid goes in one or more “box numbers” on the form, each of which have their own description (like Rent, Royalties, etc.).
I’m looking for the table that has this info:
1 - Rent
2 - Royalties
3 - Other Income
4 - Federal Income Tax Withheld
5 - Fishing Boat Proceeds
6 - Medical and Health Care Payments
7 - Nonemployee Compensation
8 - Payments in Lieu of Dividends/Interest
10 – Crop Insurance Proceeds
13 – Excess Golden Parachute Payments
14 – Gross Proceeds Paid to an Attorney
15a – Section 409A Deferrals
15b – Section 409A Income
and it should be related to the vendor table and the invoices too, I believe.
Thanks for your help!
IN the table I mentioned I have
Code Description Minimum Reportable
MISC-01 Rents 600.00
MISC-02 Royalties 10.00
MISC-03 Other Income 600.00
MISC-04 Federal income tax withheld -1.00
MISC-05 Fishing boat proceeds 1.00
MISC-06 Medical+health care payments 600.00
MISC-07 Nonemployee compensation 600.00
MISC-08 Substitute payments in lieu of dividends/interest 10.00
MISC-09 Direct sales of consumer products for resale 5,000.00
MISC-10 Crop insurance proceeds 1.00
MISC-11 State income tax withheld -1.00
MISC-13-A Gross legal proceeds 0.00
MISC-13-E Golden Parachute payments 0.00
etc. etc.
But you mentioned Solomon - this is a Navision forum.
Tools->Object Designer->Click “ALL”->Filter on Name 1099
should bring you a list of all tables/forms&reports that contain 1099
Sorry. Internally its called Solomon but its MS Dynamics.
I’m trying to find an internal resource who can tell me where the table is. It must exist somewhere. Thanks for your time!
Internally its called Solomon but its MS Dynamics. - OK?[:^)]
I showed you where the Table was - but if you want to access the table thru a form to edit or just to browse - if you go to any vendor card - their should be a 1099 code field - that you can drill into to see the table.
I don’t see that table when I’m browsing the tables in SQL Server.
How do I drill into a field to see the table?
What I ment by drill is that many fields in Nav have an arrow at the end of them.
Some are lookups (arrow up) and some are drill downs (arrow down)
Lookups are like this…
By click on the actual field you can (for example)…(go to a vendor card)
By Clicking The Payment Terms Field - It brings you to the Form that shows all the payment terms in that table.
By Clicking the Vendor Posting Group Field it should bring you to the Vendor Posting Group form that shows you all the groups in the table.
By Clicking the 1099 Code field it should bring you to the form where it shows you all the possible 1099 codes.
a drill downs are l;ike this…
Click on the Balance($) field of a vendor it should then show you all the lines that make up that Balance.
etc etc. I don’t know how else to explain it.