Re: Vendor Numbers and Multiple Companies

Eric,

We have 4 automotive manufacturing companies and 4 management companies,
some US companies and some Canadian all of them operating under the same
database.  

We have been live for one month in the financials (AP, AR, and GL)  with
the management companies and will be live with the rest of them this
Monday, financials and all subsystems. What we have done is put the vendor
in for each company.  To help the AP department we have blocked off groups
of numbers for each company.  Although many do not like to block off
numbers it does have it's advantages in this case.  

One of the reasons we decided on this route is that we have security
requirements by company.  In addition our models uses the macro to vendor
company number to retrieve our first segment value, company.  We have also
built exception reports to validate some of our data, one of which to to
make sure vendor company number and vendor number fall into the assigned
blocks.

A lot of programs will require you to be company specific including the
customer master, bank code master, vendor types and customer types.  That's
just some from the financials. There are ones like warehouse master that
require it in the other subsystems as well.  

 I would be glad to discuss any of this with you if you have any questions.
 You can e-mail or call me at your convience if you like.


Melissa Urban
murban@schukra.com
Business Analyst
phone: (519) 254-4410 ext 230

----------
> From: estevens@adrus.com
> To: BPCS-L@midrange.com
> Subject: Vendor Numbers and Multiple Companies
> Date: Friday, March 27, 1998 1:11 PM
> 
> 
> 
> 
> 
> We have just discovered the requirement that vendor numbers be unique for
> each company within a database.  This is a big problem for us as we have
> multiple companies with many vendors in common (integrating with our
> financials should prove "interesting").
> 
> I'm sure we aren't alone in facing this issue.  We would be interested to
> know how have others dealt with this......particularly approaches that
> don't force us into using multiple databases.
> 
> 
> Thanks in advance,
> 
> 
>           .......Eric
> 
> 
> +---
> | This is the BPCS Users Mailing List!
> | To submit a new message, send your mail to BPCS-L@midrange.com.
> | To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: dasmussen@aol.com
> +---
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---