× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: Re: hierarchies
  • From: Diana Larsson <dml@xxxxxxxxxxxxxx>
  • Date: Fri, 08 Dec 2000 11:19:05 -0500

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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.