Re: Aging report problem.

<sergia.dupoux@xxxxxxxxx> wrote in message
news:1194551533.345052.92390@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Oct 25, 7:21 pm, "Ron" <ronSPAMBLOCKINGwest...@xxxxxxxxxxx> wrote:
Hi All,

I've got a client/transaction type of database where tblClient is linked
to
tblTransactions via ClientID. The client table contains all clients from
day one. The transaction table contains all transactions from day one
(includes any purchases, labor charges, payments, adjustments) The aging
report I developed works fine, except...

For any client that owes money, it lists ALL the transactions for that
client. Or, it lists all the transactions for a client where the dates
of
entry are between 2 dates I have the operator input. But I really want
it
more open--I want it to list only transactions that haven't been
paid/adjusted yet regardless of some arbitrary date the operator can
input.
So, I want a report go through the transactions and find the first
transaction where the balance is not equal zero and start there on the
aging
detail.

Example would be where Jane Smith has had 22 transactions but the 1st 18
equal 0 and just happen to have happened prior to March 2007, so she's
got
just 4 that she still owes money on, and that's all I want to show on the
aging report--transactions since March 2007. Then John James has had 6
transactions and all are still owed and they date back to June of
2006--all
should appear on the aging. And Bill Adams has 11 transactions, the 1st
9
of which equals 0 and the last 2, from Sept 2007 are still owed and those
should appear, the first 9 shouldn't. Follow?

How can I pull out only the "unresolved" transactions?

TIA,
ron

did you ever get an answer to this? did it work? I have a similar
problem


I received one reply:

Ron,
Are you basing your report on a query?
Have you applied a criteria like "Balance <> 0" to that query?
Perhaps you could post the SQL.

--
Bob Darlington
Brisbane


But... haven't had a chance to even look at it really. I don't have a field
for "balance" as it's a running sum, and not saved anywhere. I still don't
know how I'd find the first unpaid charge and start the display from there.
I just went on to more pressing matters and figured I'd revisit when I have
time. Untill then, I'm mulling it over--that's sometimes when I do my best
work. ::grin::

Good luck to you in finding a solution though. I'll post mine, when/if I
come up with it...please do the same.

Thanks,
ron


.

Relevant Pages

  • Re: [2/3] POHMELFS: Documentation.
    ... userspace it works with any underlying filesystem and still is ... Courtesy to transactions, ... Resending transactions to different servers on timeout or error. ... request comes from different client, ...
    (Linux-Kernel)
  • Re: Aging report problem.
    ... The client table contains all clients ... The transaction table contains all transactions from day ... aging report I developed works fine, ...
    (comp.databases.ms-access)
  • Re: Is there an obvious way to do this in python?
    ... a sort of *pointer* to each of the kinds of transactions she can do, ... are shipped separately and *linked* at the client side... ... |upgrade to Python 3000 because it sounds cooler than plain old Python ... You can assume complete control of all the ...
    (comp.lang.python)
  • Re: Choosing the right embedded database.
    ... Do you have any information on learning web service development for noobs ... Second, if you use transactions, it is easier to manage transactions if you ... client, even something very simple like stored text files or XML files, ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Sql Server Locks
    ... Tran and Commit Tran are as close together as possible and the transactions ... > The problem is with SQL Server Database Locks. ... > client A and reinserts the same with some data changes ... > provide us any good links for this kind of scenarios. ...
    (microsoft.public.sqlserver.clients)
Loading