Browse lookup

George flowersoft at compuserve.com
Wed Jul 22 20:32:28 PDT 2009


Let's assume you are doing the lookup using the account number and a date to
do the browse lookup, such as ky=acctno&first_date.  I imagine is a equal or
greater lookup.
When the user highlights and presses "P" to pay an invoice, if there is
going to be money left over, save the date of that invoice
(ky=accno&invoice_date) and re-execute the lookup.  It should take you to
the next invoice with an outstanding amount since the one selected should be
dropped.  The user can then press "P" to pay that invoice or you can do a
pushkey "P" for them if you want.  You can keep doing this until there is no
money left over.  One problem to consider is that you might have monies left
over and no open invoices to pay, in which case you would have to issue a
credit to the account for the amount of monies left over.  Another one is
that after you do this, there is no going back to an earlier invoice unless
you reset ky to acctno&first_date.

-----Original Message-----
From: filepro-list-bounces+flowersoft=compuserve.com at lists.celestial.com
[mailto:filepro-list-bounces+flowersoft=compuserve.com at lists.celestial.com]
On Behalf Of Richard Kreiss
Sent: Wednesday, July 22, 2009 1:09 PM
To: filepro-list at lists.celestial.com
Subject: Browse lookup

Writing an cash application routine which uses a browse lookup to list all
open transactions.  The use highlights the item to be paid, presses <P> to
apply the payment amount.

My problem is that some payments to be applied are larger than the current
amount due and I want to apply the balance to the next transaction.

Since I use a drop with the browse so paid items are not listed, I added
code which would read into an array the record #'s of the transactions
selected.  The maximum number of open items should be no more than 24.

The array was filled with the record #'s but they were not in the sequence
of the displayed transactions.  What should have been the number 4 item was
actually in the 11th element of the array.

Short of doing a lookup next using the browse index for sequencing, does
anyone have a better idea of how to approach this?

The may be a Ken question, is there a way to access the system array that
hold the record numbers of the records in the browse display window?


Richard Kreiss
GCC Consulting
rkreiss at gccconsulting.net
  




_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
http://mailman.celestial.com/mailman/listinfo/filepro-list



More information about the Filepro-list mailing list