Yesterday i was trying to create few suppliers in my test system. In supplier page, "Taxpayer ID" is a mandatory column. So i used a sequence of 9 digit number. That random number matched with some supplier that i must have created earlier. I tried few times and all the the time, "Taxpayer ID" was duplicate value. I thought to write a query that can give me a 9 digit number that is not used as "Taxpayer ID" of a supplier. But i did not know how to write that query.
Today i saw this post http://jonathanlewis.wordpress.com/2012/09/18/minimum-stats/. it has following query to generate list of sequence numbers.
This query gave me idea to generate unused taxpayer Id
Wednesday, September 19, 2012
Taxpayer ID of a Supplier
Labels:
Accounts Payable
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment