more-arw search

Q&A Forum

Best Practice to manually assign vendor number

What's the best practice to manually assign a vendor number to a vendor if the management doesn't want to use the auto generated vendor numbers from the accounting system? I am looking at a growing business with US and international divisions. Any advice is greatly appreciated.

Answers

Anonymous
(CFO) |

000001, 000002, 000003..........

Len Green
Title: Performance Improvement Consultant and E..
Company: Haygarth Consulting LLC
LinkedIn Profile
(Performance Improvement Consultant and ERP Strategist, Haygarth Consulting LLC) |

Hi Anon

From my perspective of someone who helped design a global ERP system, who spent 17 years helping clients choose and use ERP systems, I have one simple phrase for your management colleagues:

" Smart numbering isn't, smart names are."

Vendor numbers are codes to uniquely identify the correct vendor record. That is all.

Data management 101.

PS - what ERP system are you using?

Topic Expert
Wayne Spivak
Title: President & CFO
Company: SBAConsulting.com
LinkedIn Profile
(President & CFO, SBAConsulting.com) |

Anonymous -

Why would management really care or be involved? With today's ERP systems, finding a vendor/customer can be as easy as starting to type in their name.

Thus if your system auto-numbers, that's great, eliminates possible duplicate numbers (not duplicated customers/vendors, the bane of all systems).

Not back in the old days.... I could see a point.... But we also used rotary phones...

John P. Hart
Title: Vice Pres - CFO
Company: Nova Pressroom Products, LLC
(Vice Pres - CFO, Nova Pressroom Products, LLC) |

Antiquated thinking.

Len Green
Title: Performance Improvement Consultant and E..
Company: Haygarth Consulting LLC
LinkedIn Profile
(Performance Improvement Consultant and ERP Strategist, Haygarth Consulting LLC) |

Anon-another thought

Sometimes there is another dimension to this thinking of user defined numbering when your company does business with many divisions/subsidiaries of a corporation. Often management want to know "how much business do we do with Acme Group?"

The better solution to this (especially when divisions/subsidiaries don't have the same name as Acme) is to be able to define vendor groups. First look to do this in your ERP vendor master record (even as a user defined field). If not then maybe it can become metadata in your data warehouse.

1185 views
Topics

Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email content@proformative.com to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.