[363] in ad-lib
Forwarded message: ["David Alexander" :BUG LIST #00045, #00048]
daemon@ATHENA.MIT.EDU (Grant Young )
Wed Apr 19 12:41:33 1995
To: acq2@MIT.EDU
Date: Wed, 19 Apr 95 12:40:42
From: gyoung@MIT.EDU (Grant Young )
And the answer is...
-- Grant
------- Forwarded Message
To: gyoung@MIT.EDU
Cc: davea@quasi.ca.geac.com (David Alexander),
Subject: BUG LIST #00045, #00048
Date: Wed, 19 Apr 1995 10:50:39 -0400 (EDT)
From: "David Alexander" <davea@quasi.ca.geac.com>
Grant,
Regarding problem #'s 00045 and 00048:
After investigating the examples provided I found 2 issues.
1 - The spent amounts were incorrect for some funds. This was caused because
at least one order on the effected FUND had an ordering agency of HAYDEN
rather than MIT.
In Acq on ADVANCE in LIBCD we had only set up MIT as an ordering library.
I have added HAYDEN into LIBCD and rebalanced the funds.
All funds should now have the correct SPENT amounts.
2 - The commited amounts are not as straight forward:
In all the cases I have looked at where the comitted amounts differ fro
GLIS there appears to be a combination of transactions on GLIS which were
out of the ordinary but GLIS would allow you to do without any problems.
However it appears that GLIS had incorrectly handled the commitment and
outstanding order counts for these records.
For example, in FUND M-RTC-16069-539 the difference in the comitted amount
was order # 9300009885 which in ADVANCE was marked as completed but on
GLIS not and had a commited amount of $37.50.
As you can see from the audit trail for this order in GLIS it was
completed 93-12-22 and the committed and order count went to 0.
On 94-01-12 another copy was invoiced even though it was not ordered.
This is fine in the GLIS system. The spent amount is incremented but the
comitted and order count stay at 0.
On 94-06-16 one copy is credited. The amount is removed the spent but is
also added to the committed and the order count is set back to one.
This is incorrect. There was only 1 copy ordered and it was paid.
The order count and comitted amount should both be 0.
The display following the audit trail displays the ADVANCE screens
reflecting this.
Following these are GLIS audit trails for orders which have effected the
committed amounts on other funds.
In summary GLIS has been handling these cases incorrectly and they are
correct on ADVANCE.
Dave
------------------------------------------------------------------------------
AUDIT TRAIL : ORDER 9300009885
TRANSACTION DATE CPYS RESULTING RESULTING OUTSTANDING
COMMITTED SPENT CPYS ORDS
order with APPRAISA 93-10-05 1 37.50 0.00 1 1
{CMP} 329100471 1 93-12-22 1 0.00 37.50 0 0
{INV} 334900200 1 94-01-12 1 0.00 78.50 0 0
year end processing 94-05-31 0 0.00 0.00 0 0
[CRE] 4069002RT 1 94-06-16 1 37.50 37.50- 1 1
result...................... 95-04-18 1 37.50 37.50- 1 1
------------------------------------------------------------------------------
REC - STANDARD LOCATION DISPLAY MASTER
PO#/LINE#: 9300009885/0001 VENDOR : APPRAISA ORDER DATE: 10/05/93
REQUEST #: 930010139 ORDER TYPE: REGULA.MONOG REQST DATE: 10/05/93
LIBRARY : MIT CONDITION : COMPL EST DELVRY:
ISBN/ISSN: 0922154120 LC CARD # : 93025493 RECEIVED : 01/11/94
AUTHOR :
TITLE : The Dictionary of real estate appraisal
STATUS : Invoicing Completed,Rush Order,Rush Process,Received,Transferred,R+
LOCATION SHIPTO ORDER'D REC'D INVC'D PAID OUTSTANDING
CPY CPY CPY CPY CLAIMS
R-BKS 1 1 1 1
TOTAL 1 1 1 1 0
Options: Receiving transaction entry
Receive Return Claim Report Order update Transaction Invoice
Mono series add Title split/change add Title structure display
Main title display Forward Backward Prior screen ? help Exit
** Note that the ordered, rec'd, inv'd and paid copies are all 1
>==============================================================================<
ORD - ORDERING DATA MASTER
PO#/LINE#: 9300009885/0001 VENDOR : APPRAISA ORDER DATE: 10/05/93
REQUEST #: 930010139 ORDER TYPE: REGULA.MONOG REQST DATE: 10/05/93
LIBRARY : MIT CONDITION : COMPL EST DELVRY:
ISBN/ISSN: 0922154120 LC CARD # : 93025493 RECEIVED : 01/11/94
AUTHOR :
TITLE : The Dictionary of real estate appraisal
STATUS : Invoicing Completed,Rush Order,Rush Process,Received,Transferred,R+
1. VENDOR : APPRAISA 6. SELECTOR : 009 10. UNIT COST: 37.50
2. PAY TYPE : PAY 7. TOTAL CPY: 1 11. DISCOUNT%:
3. TRANSFER : Y 8. PRIORITY : RUSH 12. TAX % :
4. CLM CODE : DFLT 9. CURRENCY : USA 13. ADDED CHG:
5. REQUESTOR: KOLB, ROGER 14. CONDITION: COMPL
15. VENDOR : PLEASE WRITE 'RUSH' ON EITHER THE PACKAGE OR THE SHIPPING
NOTE : LABEL.THANK YOU.
ENCUMBERED: 0.00
Options: Enter specified line number
File # line Line by line Bibliographic Allocation Notes Status
Conditions Serial publication Vendor inquiry Prior screen ? help
Exit
** The encumbered amount remains at 0 as it should.
>==============================================================================<
REC - INVOICE SUMMARY DISPLAY MASTER
PO#/LINE#: 9300009885/0001 VENDOR : APPRAISA ORDER DATE: 10/05/93
REQUEST #: 930010139 ORDER TYPE: REGULA.MONOG REQST DATE: 10/05/93
LIBRARY : MIT CONDITION : COMPL EST DELVRY:
ISBN/ISSN: 0922154120 LC CARD # : 93025493 RECEIVED : 01/11/94
AUTHOR :
TITLE : The Dictionary of real estate appraisal
STATUS : Invoicing Completed,Rush Order,Rush Process,Received,Transferred,R+
DATE INVOICE NUMBER PAGE/LN TYPE STATUS AMOUNT VENDOR
1. 04/29/94 4069002RT 00/01 CRE Paid 37.50 APPRAISA
2. 01/11/94 334900200 00/01 INV Paid 41.00 APPRAISA
3. 12/15/93 329100471 00/01 INV Paid 37.50 APPRAISA
4.
Options: Enter specified line number
# line Forward Backward Parent's invoicing ? help Exit
** The Sequence of transactions shown on ADVANCE also shows that the
committed amount should be 0 as should the outstanding order count.
>==============================================================================<
REC - INVOICE DETAILED DISPLAY MASTER
PO#/LINE#: 9300009885/0001 VENDOR : APPRAISA ORDER DATE: 10/05/93
REQUEST #: 930010139 ORDER TYPE: REGULA.MONOG REQST DATE: 10/05/93
LIBRARY : MIT CONDITION : COMPL EST DELVRY:
ISBN/ISSN: 0922154120 LC CARD # : 93025493 RECEIVED : 01/11/94
AUTHOR :
TITLE : The Dictionary of real estate appraisal
STATUS : Invoicing Completed,Rush Order,Rush Process,Received,Transferred,R+
INVOICE # : 329100471 LIBRARY: MIT INVOICE CURR: USA
VENDOR : APPRAISA STATUS : Paid,Verified PAYMENT CURR: USA
PAGE/LINE : 00/01 FROM : TO:
LINE TYPE : INV QTY : 1 REPORT CD:
PRICE : 37.50 NOTE :
DISCOUNT : 0.00 N
REGULAR CHG: 0.00 N STATUS : Paid
SPECIAL CHG: 0.00 Paid : 12/22/93
TAX : 0.00 N TOTAL : 37.50
OTHER CHG : N
Options: Display note in window
Note display ? help Exit
>==============================================================================<
REC - INVOICE DETAILED DISPLAY MASTER
PO#/LINE#: 9300009885/0001 VENDOR : APPRAISA ORDER DATE: 10/05/93
REQUEST #: 930010139 ORDER TYPE: REGULA.MONOG REQST DATE: 10/05/93
LIBRARY : MIT CONDITION : COMPL EST DELVRY:
ISBN/ISSN: 0922154120 LC CARD # : 93025493 RECEIVED : 01/11/94
AUTHOR :
TITLE : The Dictionary of real estate appraisal
STATUS : Invoicing Completed,Rush Order,Rush Process,Received,Transferred,R+
INVOICE # : 334900200 LIBRARY: MIT INVOICE CURR: USA
VENDOR : APPRAISA STATUS : Paid,Verified PAYMENT CURR: USA
PAGE/LINE : 00/01 FROM : TO:
LINE TYPE : INV QTY : 1 REPORT CD:
PRICE : 37.50 NOTE :
DISCOUNT : 0.00 N
REGULAR CHG: 3.50 Y STATUS : Paid
SPECIAL CHG: 0.00 Paid : 01/12/94
TAX : 0.00 N TOTAL : 41.00
OTHER CHG : N
Options: Display note in window
Note display ? help Exit
>==============================================================================<
REC - INVOICE DETAILED DISPLAY MASTER
PO#/LINE#: 9300009885/0001 VENDOR : APPRAISA ORDER DATE: 10/05/93
REQUEST #: 930010139 ORDER TYPE: REGULA.MONOG REQST DATE: 10/05/93
LIBRARY : MIT CONDITION : COMPL EST DELVRY:
ISBN/ISSN: 0922154120 LC CARD # : 93025493 RECEIVED : 01/11/94
AUTHOR :
TITLE : The Dictionary of real estate appraisal
STATUS : Invoicing Completed,Rush Order,Rush Process,Received,Transferred,R+
INVOICE # : 4069002RT LIBRARY: MIT INVOICE CURR: USA
VENDOR : APPRAISA STATUS : Paid,Verified PAYMENT CURR: USA
PAGE/LINE : 00/01 FROM : TO:
LINE TYPE : CRE QTY : 1 REPORT CD:
PRICE : 37.50 NOTE :
DISCOUNT : 0.00 N
REGULAR CHG: 0.00 N STATUS : Paid
SPECIAL CHG: 0.00 Paid : 06/16/94
TAX : 0.00 N TOTAL : 37.50
OTHER CHG : 0.00 N
Options: Display note in window
Note display ? help Exit
For fund E-DEW-32040-535
------------------------------------------------------------------------------
AUDIT TRAIL : ORDER 9300015314
TRANSACTION DATE CPYS RESULTING RESULTING OUTSTANDING
COMMITTED SPENT CPYS ORDS
order with BRILL 94-02-07 1 151.50 0.00 1 1
{CMP} 175758 1 94-05-04 1 0.00 159.99 0 0
year end processing 94-05-31 0 0.00 0.00 0 0
[INV] 175758-326248 1 94-09-01 1 0.00 159.90 0 0
[CRE] KKVSO1 1 94-09-01 1 151.50 8.40 1 1
result...................... 95-04-18 1 151.50 8.40 1 1
For fund E-ENG-32195-537
------------------------------------------------------------------------------
AUDIT TRAIL : ORDER 9300016655
TRANSACTION DATE CPYS RESULTING RESULTING OUTSTANDING
COMMITTED SPENT CPYS ORDS
order with YBP 94-03-10 1 91.50 0.00 1 1
{CMP} 867097 35 94-05-02 1 0.00 79.61 0 0
{INV} 870153 24 94-05-10 1 0.00 99.19 0 0
{CRE} 207049 1 94-05-10 1 91.50 79.61 1 1
year end processing 94-05-31 1 91.50 0.00 1 1
result...................... 95-04-18 1 91.50 0.00 1 1
For fund E-MUS-32030-532
------------------------------------------------------------------------------
AUDIT TRAIL : ORDER 9400000839
TRANSACTION DATE CPYS RESULTING RESULTING OUTSTANDING
COMMITTED SPENT CPYS ORDS
order with SCHBO 94-07-15 1 155.00 0.00 1 1
[CMP] L888605 1 94-08-10 1 0.00 155.00 0 0
[INV] L897129 1 94-10-24 1 0.00 305.00 0 0
[CRE] LR93397 1 94-10-24 1 155.00 155.00 1 1
result...................... 95-04-18 1 155.00 155.00 1 1
For fund M-ENG-16130-532
------------------------------------------------------------------------------
AUDIT TRAIL : ORDER 9300018928
TRANSACTION DATE CPYS RESULTING RESULTING OUTSTANDING
COMMITTED SPENT CPYS ORDS
order with OH 94-06-14 1 68.67 0.00 1 1
[CMP] 109613 22 94-08-08 1 0.00 89.63 0 0
[CRE] 13685 1 94-12-20 1 68.67 3.18 1 1
result...................... 95-04-18 1 68.67 3.18 1 1
For fund M-TEC-16106-533
------------------------------------------------------------------------------
AUDIT TRAIL : ORDER 9300002775
TRANSACTION DATE CPYS RESULTING RESULTING OUTSTANDING
COMMITTED SPENT CPYS ORDS
order with YBP 93-05-03 1 1580.00 0.00 1 1
{PRO} 714002 1 93-05-20 1 0.00 1580.00 0 1
aut*cmp 93-12-08 0 0.00 1580.00 0 0
{INV} 758700 1 93-12-08 1 0.00 2954.60 0 0
{CRE} 207066 1 93-12-08 1 1580.00 1580.00 1 1
{CRE} 19150 1 94-02-23 0 1580.00 1374.60 1 1
year end processing 94-05-31 1 1580.00 0.00 1 1
result...................... 95-04-18 1 1580.00 0.00 1 1
