GUI list of invoices incomplete for vendor with 10,041 invoices

Description

We have a vendor, Amazon Canada (AMZC), that presently has 10,041 invoices attached to it.

In the Acquisitions client, the "invoice bar" no longer displays all the invoice numbers for AMZC. When AMZC is selected in the Vendor List box, the drop down lists as far as the 9,988th invoice and no farther.

We don't have this problem with any other vendor; the next most popular has 8,256 invoices.

Will it be necessary to create another vendor for these invoices if we want them to list normally in the invoice bar?  Or is there some way to archive old invoices?

Resolution

The program which displays the invoice list for a vendor is pc_com_c0113.  It's not clear just where in this program the limit is, but, apparently, it's something less than 10,041.  At this stage of Aleph development, a change to allow more is unlikely....   

One could change the vendor code in the invoice and other records to a new vendor you create, such as, "AMZC-OLD" -- or, possibly, if the invoice is paid, delete it.  (There is no Aleph Service to "archive old invoices".)  The acq-26 Service ("Update Vendor Code in Order and Subscription Records") could be used to change those records.  Other records might need to be changed with SQL.  (Note:  acq-26 wants to update the vendor code in *all* of the order/subscription records for a particular sublibrary or sublibraries.)   It might be better to do this updating with SQL, where specific records could be targeted -- rather than all the records in the sublibrary(s). 

The following grep (in the ./alephm/source/copy directory) shows the records the vendor-code is found in:

...source/copy> grep VENDOR-CODE Z*
Z1007:            03 Z1007-VENDOR-CODE          PICTURE X(20).
Z1007:          02 Z1007-ABAC-VENDOR-CODE       PICTURE X(20).
Z16:            03 Z16-VENDOR-CODE          PICTURE X(20).                        S
Z30:        03 Z30-VENDOR-CODE             PICTURE X(20).
Z30H:            03 Z30H-VENDOR-CODE          PICTURE X(20).
Z313:     02 Z313-VENDOR-CODE              PICTURE X(20).
Z601:            03 Z601-VENDOR-CODE          PICTURE X(20).
Z68:            03 Z68-VENDOR-CODE          PICTURE X(20).
Z70:           03 Z70-VENDOR-CODE           PICTURE X(20).
Z70:           03 Z70-EDI-VENDOR-CODE       PICTURE X(35).
Z70:          02 Z70-EDI-VENDOR-CODE-TYPE       PICTURE X(3).
Z70:          02 Z70-ADDITIONAL-VENDOR-CODE PICTURE X(20).                         S
Z700:          02 Z700-ADDITIONAL-VENDOR-CODE                PICTURE X(30).
Z71:        03 Z71-VENDOR-CODE          PICTURE X(20).
Z72:           03 Z72-VENDOR-CODE               PICTURE X(20).
Z74:            03 Z74-VENDOR-CODE          PICTURE X(20).
Z75:            03 Z75-VENDOR-CODE          PICTURE X(20).
Z77:            03 Z77-VENDOR-CODE          PICTURE X(20).

And the following, the invoice-number:

...source/copy> grep INVOICE-NUMBER Z*
Z1007:            03 Z1007-INVOICE-NUMBER       PICTURE X(15).
Z1007:          02 Z1007-ABAC-INVOICE-NUMBER    PICTURE X(15).
Z30:            03 Z30-INVOICE-NUMBER          PICTURE X(15).
Z30H:            03 Z30H-INVOICE-NUMBER       PICTURE X(15).
Z313:          02 Z313-INVOICE-NUMBER           PICTURE X(15).
Z601:            03 Z601-INVOICE-NUMBER       PICTURE X(15).
Z71:        03 Z71-INVOICE-NUMBER       PICTURE X(15).
Z74:            03 Z74-INVOICE-NUMBER       PICTURE X(15).
Z75:            03 Z75-INVOICE-NUMBER       PICTURE X(15).
Z77:            03 Z77-INVOICE-NUMBER       PICTURE X(15).
Z77:      02 Z77-ORIG-INVOICE-NUMBER    PICTURE X(15).

The invoice-number's (which are unique for each vendor) can stay the same; it's just the vendor-code which would need to be changed -- not just in the records which also contain the invoice-number, but in all the records found by the above "grep VENDOR-CODE".