As a follow-up to some questions which arose at the EURODOLLAR meeting where we also reviewed the NEW
SERIAL report and CANCELLED serial reports... 

    
      RE: Discrepancies between cancelled value of serials from program vs manual 

  As suspected, the differences in value that Serial Acq is coming up with and my report is coming up with is due to
  currency table fluctuations.  Example: 

  This order is off of nut's database from March last year (was osiris's database from last year).  We see: 

  command:DISPLAY1 ORDER 

        order ID:982356               fiscal:2001                     line:1 
     requisition:AMS                 packing: 
  options--    amounts:Y      dates:N         numbers:Y    summary:Y 
   (single)   extended:Y   segments:Y   {load/deliver:Y        pay:Y    receive:Y} 
  -------------------------------------------------------------------------------- 
    requisition number:AMS 
            sub period:0           renew date:NEVER 

           call number:FOR INTERNET ACCESS SEE FULL DISPLAY 
                 Title:MathSciNet [computer file] / American Mathematical 
                       Society. 
     Current frequency:Daily 
                   key:lsn96034021 
     Local call number:INTERNET ACCESS - JSTOR 

           unit price:U5782.14         currency:USDOLLAR    exch:TABLE 
          # of copies:1                discount:TABLE 
             extended:U5782.14          native:$8815.58 
          multi parts:N                   parts: 

  Now as Barrie, said, that native amount was calculated on the day the order was keyed in the system. 

  Serial acq would copy that amount down in their manual cancel stats and know the title was cancelled and had
  been worth $8,815.58 CANDOLLAR. 

  But when my program runs (1st of each month right now), the order has been properly cancelled and now has a
  cancel segment in it and has zero copies on order and appears as follows in the workstation: 

  command:DISPLAY1 ORDER 
  WARNING: segments not correctly balanced 
        order ID:982356               fiscal:2001                     line:1 
     requisition:AMS                 packing: 
  options--    amounts:Y      dates:N         numbers:Y    summary:Y 
   (single)   extended:Y   segments:Y   {load/deliver:Y        pay:Y    receive:Y} 
  -------------------------------------------------------------------------------- 
    requisition number:AMS 
            sub period:0           renew date:NEVER 

           call number:QA76.9 .M35 INTERNET 
                 Title:MathSciNet [computer file] / American Mathematical 
                       Society. 
     Current frequency:Daily 
                   key:lsn96034021 
  Local LC call number:QA76.9 .M35 INTERNET 
     Local call number:INTERNET ACCESS - CNSLP 

           unit price:U5525.83         currency:USDOLLAR    exch:TABLE 
          # of copies:0                discount:TABLE 
             extended:U0.00             native:$0.00 
          multi parts:N                   parts: 

  The native has been cleared out because zero copies are now on order!! 

  So, the program (using seltools) recalculates the native price by taking the old unit price and pushing it through
  TODAY's currency table and voila, my value for this cancelled order is: 

  982356|1|$8552.59|USDOLLAR| 

  So we have a price difference of 262.99 on ONE title. 

  I think this should clarify and document this for all of us.