GP 2010 - Vendor Tax Id

On the Vendor Maintenance options screen is where our vendor tax id is.  What GP table is this located in?  Thanks
pstreAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Victoria YudinOwner / Dynamics GP ConsultantCommented:
That's stored in the vendor master table - PM00200. The field is TXIDNMBR.
0
pstreAuthor Commented:
TXIDNMBR is blank in this table.  We put the Tax id # on the Vendor Maintenance Options screen in GP.  I have looked at around 30 tables and cannot find it..
0
Victoria YudinOwner / Dynamics GP ConsultantCommented:
Yes, the Tax ID on the Vendor Maintenance Options window is stored in the TXIDNMBR field in PM00200.

If that field is blank, then maybe you are putting the ID into a different field on the window? Can you confirm what field on the Vendor Maintenance Options window you are using?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

pstreAuthor Commented:
Here is a screenshot of that window...
Vendor-Maintenance.docx
0
pstreAuthor Commented:
You are so right... I saw a lot of blank fields and decided to query where txidnmbr <> ' ' and found the ids.  Sorry.  Thank so much!
0
Victoria YudinOwner / Dynamics GP ConsultantCommented:
Glad you found it. :-)
0
pstreAuthor Commented:
I can always count on Victoria's quick response and acurate answers :)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.