GP 2010 - Vendor Tax Id

Posted on 2014-01-03
Last Modified: 2014-01-04
On the Vendor Maintenance options screen is where our vendor tax id is.  What GP table is this located in?  Thanks
Question by:pstre
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
LVL 18

Expert Comment

by:Victoria Yudin
ID: 39755730
That's stored in the vendor master table - PM00200. The field is TXIDNMBR.

Author Comment

ID: 39755980
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..
LVL 18

Accepted Solution

Victoria Yudin earned 500 total points
ID: 39755990
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?
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.


Author Comment

ID: 39756392
Here is a screenshot of that window...

Author Comment

ID: 39756396
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!
LVL 18

Expert Comment

by:Victoria Yudin
ID: 39756487
Glad you found it. :-)

Author Closing Comment

ID: 39756807
I can always count on Victoria's quick response and acurate answers :)

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question