Re: Large Lists - Please read and comment

From: Jeff Grippe (jgrippe_at_hilldun.com)
Date: 03/18/05 

Date: Fri, 18 Mar 2005 13:25:56 -0500

Jan,

I agree with what you said but there are some issues that I need to resolve
in my application which may or may not be resolvable with anything other
than a "large list" approach.

Although we do the AR for 200 companies, many of them sell to the same
customers. There are several issues that come up in which we need to look at
the data by customer for all of our clients.

The first and most important is trying to spot payment problem patterns
which will show up in more than one company. I guess it is worth mentioning
that we also do the collections and check processing for our clients.

Example 1:
We get checks that don't bother to identify which company they are paying or
which invoice they are paying. We need to search by customer accross all
companies.

Example 2:
We get checks that not only are like example 1 above but don't even come
from the same company that the invoice went to. Searching all companies by
amount comes in really useful here.

Example 3:
Our collections people want to call the companies with the highest total
open balance first. Having the transactions in a single file really makes it
easy to pull this data together.

I've got more reasons why moving away from the "large list" would make
things difficult here but I think you get the idea from these three
examples.

Thanks for the input.

Jeff

Relevant Pages

  • Re: Large Lists - Please read and comment
    ... "Here are all 10 transactions that are approximately $200. ... > look at the data by customer for all of our clients. ... > paying or which invoice they are paying. ... > come from the same company that the invoice went to. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Not in list event
    ... resolve it. ... I also have some generic code at my website: ... You will notice that the Response argument in the NotInList code uses: ... the new customer is there. ...
    (microsoft.public.access.forms)
  • Re: OT question about time tracking consultant software
    ... software that we can add many consultants and they can help to resolve ... customer IT issues and then we could know what the consult did and how ... long it took them to resolve the issue that might be in terms of hours, ... It is in the FC5 extras repository so ...
    (Fedora)
  • Re: Thank you to Jeff@ClassicArcades
    ... good replies. ... putting the customer first, otherwise you guys would be getting bashed ... problem to resolve for everyone involved - Jeff give a refund THEN John ...
    (rec.games.pinball)
  • Re: Another lousy Borland experience
    ... How do you "sack" a customer who has already bought your product? ... Offer them their money back since that is going to be cheaper than ... issues, resolve any possible personel conflicts, extensive free rework. ...
    (borland.public.delphi.non-technical)