Re: hierarchies -- SYSTEM21

I thought I'd throw in my two cents worth since you mentioned you considered
the delivery address approach but had a problem because of the number of
DSEQ's.

I have worked with a number of Style users who have over 3,000 delivery
addresses for an account and they are able to set them up as delivery
addresses with no real issues once they tried it.  The delivery address code
of course cannot be the actual store number but so what.  The store number
is incorporated into either the account name field or as part of address
line one.  You just make sure that address line one is one of the chosen
customer search attributes in the OE Company Profile.  When entering an
order or looking up something for the customer, you just depress F4 and
enter the store number in address line one lookup.  The worst scenario is
two or more companies might just have store number 1200, in which case you
then 'select' the one you want.  You really do not need to know the actual
delivery address code at all.

I've had some near rebellions in class when I've told students that the DSEQ
code was only three characters, but after challenging them to try it, they
have always ultimately found it to go away as an issue.  I'd suggest trying
it in a test environment and maybe you will like it after all.

Stan Rockey, Partner
BTC Group LLC
srockey@btcgrp.com



----- Original Message -----
From: Diana Larsson <dml@phoenixdsl.com>
To: <JBAUSERS-L@midrange.com>
Sent: Friday, December 08, 2000 11:19 AM
Subject: Re: hierarchies


> The OE delivery address limited us on the sequence # so we have 2000
stores and
> we wanted to use the store # as the delivery sequences so that is why we
went
> the hierarchy path.
>
> Michael Berman wrote:
>
> > Diana,
> > This is an extremely complex situation with performance impacts across
the
> > board.
> > It may be a situation where the children should be OE Delivery Addresses
> > rather than AR Customers.
> > I am intrigued as to how/why/what you are trying to achieve.  can you
> > describe the customer base?
> > (I will accept comment directly if necessary)
> >
> > Regards
> >
> > Michael Berman
> > Phone (03) 9860 1518
> > Mobile 0419 324 558
> > Email michael.berman@geac.com.au
> >
> > -----Original Message-----
> > From: Ed Lybrook [mailto:elybrook@btcgrp.com]
> > Sent: Friday, 8 December 2000 7:52
> > To: JBAUSERS-L@midrange.com
> > Subject: RE: hierachies
> >
> > No, @ctive Reporter will not work.  All you can do is build the
hierarchies.
> > Do you have 2000 children per check location, that is, do you receive
one
> > check that may contain uo to 2000 customers?  Are these 2000 customers
> > different ship-to's or truly unique customers?
> >
> > -----Original Message-----
> > From: owner-jbausers-l@midrange.com
> > [mailto:owner-jbausers-l@midrange.com]On Behalf Of Diana Larsson
> > Sent: Thursday, December 07, 2000 3:12 PM
> > To: JBAUSERS-L@midrange.com
> > Subject: Re: hierachies
> >
> > Our hierarchy issue is with accounts receivable; we have hierarchies
that
> > may consist of around 2000 accounts. Would this still work?
> >
> > Ed Lybrook wrote:
> >
> > > I worked with a customer who had the same situation.  When submitting
> > > budgets, it took three months to update all the hierarchies.
> > >
> > > We removed all the hierarchies by using @ctive Reporter.  @ctive
Reporter
> > > allows you to setup hierarchies as cube dimensions, which works for
> > reports,
> > > but not inquiries.
> > >
> > > Ed
> > >
> > > -----Original Message-----
> > > From: owner-jbausers-l@midrange.com
> > > [mailto:owner-jbausers-l@midrange.com]On Behalf Of Diana Larsson
> > > Sent: Wednesday, December 06, 2000 9:02 AM
> > > To: JBAUSERS-L@midrange.com
> > > Subject: Re: hierachies
> > >
> > > G general Ledger
> > >
> > > Ed Lybrook wrote:
> > >
> > > > What type of hierarchies (General Ledger accounts or Accounts
Receivable
> > > > accounts)?
> > > >
> > > > -----Original Message-----
> > > > From: owner-jbausers-l@midrange.com
> > > > [mailto:owner-jbausers-l@midrange.com]On Behalf Of Diana Larsson
> > > > Sent: Tuesday, December 05, 2000 5:06 PM
> > > > To: JBAUSERS-L@midrange.com
> > > > Subject: hierachies
> > > >
> > > > We using hierarchies that can go as deep as 22 accounts to one
parent.
> > > > The maintenance is really slow and tedious. Does anyone use as many?
Any
> > > > suggestions.
> > > >
> > > > +---
> > > > | This is the JBA Software Users Mailing List!
> > > > | To submit a new message send your mail to JBAUSERS-L@midrange.com.
> > > > | To subscribe to this list send email to
JBAUSERS-L-SUB@midrange.com.
> > > > | To unsubscribe from this list send email to
> > > JBAUSERS-L-UNSUB@midrange.com.
> > > > | Questions should be directed to the list owner: doug333@aol.com.
> > > > +---
> > > >
> > > > +---
> > > > | This is the JBA Software Users Mailing List!
> > > > | To submit a new message send your mail to JBAUSERS-L@midrange.com.
> > > > | To subscribe to this list send email to
JBAUSERS-L-SUB@midrange.com.
> > > > | To unsubscribe from this list send email to
> > > JBAUSERS-L-UNSUB@midrange.com.
> > > > | Questions should be directed to the list owner: doug333@aol.com.
> > > > +---
> > >
> > > +---
> > > | This is the JBA Software Users Mailing List!
> > > | To submit a new message send your mail to JBAUSERS-L@midrange.com.
> > > | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
> > > | To unsubscribe from this list send email to
> > JBAUSERS-L-UNSUB@midrange.com.
> > > | Questions should be directed to the list owner: doug333@aol.com.
> > > +---
> > >
> > > +---
> > > | This is the JBA Software Users Mailing List!
> > > | To submit a new message send your mail to JBAUSERS-L@midrange.com.
> > > | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
> > > | To unsubscribe from this list send email to
> > JBAUSERS-L-UNSUB@midrange.com.
> > > | Questions should be directed to the list owner: doug333@aol.com.
> > > +---
> >
> > +---
> > | This is the JBA Software Users Mailing List!
> > | To submit a new message send your mail to JBAUSERS-L@midrange.com.
> > | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
> > | To unsubscribe from this list send email to
JBAUSERS-L-UNSUB@midrange.com.
> > | Questions should be directed to the list owner: doug333@aol.com.
> > +---
> >
> > +---
> > | This is the JBA Software Users Mailing List!
> > | To submit a new message send your mail to JBAUSERS-L@midrange.com.
> > | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
> > | To unsubscribe from this list send email to
JBAUSERS-L-UNSUB@midrange.com.
> > | Questions should be directed to the list owner: doug333@aol.com.
> > +---
> > +---
> > | This is the JBA Software Users Mailing List!
> > | To submit a new message send your mail to JBAUSERS-L@midrange.com.
> > | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
> > | To unsubscribe from this list send email to
JBAUSERS-L-UNSUB@midrange.com.
> > | Questions should be directed to the list owner: doug333@aol.com.
> > +---
>
> +---
> | This is the JBA Software Users Mailing List!
> | To submit a new message send your mail to JBAUSERS-L@midrange.com.
> | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
JBAUSERS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: doug333@aol.com.
> +---
>

+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---