Re: hierarchies

Thank You

STANLEY ROCKEY wrote:

> 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.
> +---

+---
| 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.
+---