How much to charge if an item has no listed price

If an item does not have a cost in the record, the correct amount to charge is the average cost of items that have the same collection code.  This amount is located in the Collection Code record and can be accessed through the Table Editor in Horizon.  If you do not have access to the Table Editor, please call the Jurisdiction System Administrator in eServices to get the price.

If you have access to the Table Editor follow these steps:

1. Double click on Table Editor to bring up the Code Lookup box.
2.  Scroll down to the 'collection' entry, highlight it, and press enter.  
3. The next box is called 'Indexes'. 'Collection' should be highlighted at the top of the box.  Type in the collection code for the item you are looking up (collection code can be found in the item detail status) in the 'Search for' box, press enter. 
4. Click and highlight the entry on the next screen then press the enter button.
5. You will see the 'Avg Replace Cost' about halfway down the screen. 
6. Click 'Close' when done, then x out of the Table Editor.

rev. 5/2018

Floating Collection Codes

The following collection codes are currently floating. Updated 12/14/12 - kks

fabefcx - Adult, Eng Fic
fabegrx - Adult, Eng Graphic Novel
fabesfx - Adult, Eng Sci-fi
fabewex - Adult, Eng Western
fabeyyx - Adult, Eng Mystery
fabjfcx - Adult, Japanese Fic
fabjnfx - Adult, Japanese Non-fic
fabknfx - Adult, Khmer Non-fic
fabmnfx - Adult, Hmong Non-fic
fabnfcx - Adult, Korean Fic
fabnnfx - Adult, Korean Non-fic
fabpbix - Adult, Panjabi Biography
fabpfcx - Adult, Panjabi Fic
fabpnfx - Adult, Panjabi Non-fic
fabrbix - Adult, Russian Biography
fabrfcx - Adult, Russian Fic
fabrnfx - Adult, Russian Non-fic
fabsbix - Adult, Spa Biography
fabsfcx - Adult, Spa Fic
fabsgrx - Adult, Spa Graphic Novel
fabsnfx - Adult, Spa Non-fic
fabvnfx - Adult, Vietnamese Non-fic
fabwfcx - Adult, Persian Fic
fabwnfx - Adult, Persian Non-Fic
fabzfcx - Adult World Lang Print Fic
fabznfx - Adult World Lang Print NF
facxmax - Adult CD Music-sacred
facxmbx - Adult CD Music-blues
facxmcx - Adult CD Music-classical
facxmex - Adult CD Music-easy Listen
facxmfx - Adult CD Music-folk
facxmhx - Adult CD Music-R&B
facxmjx - Adult CD Music-jazz
facxmkx - Adult CD - Spoken Word
facxmlx - Adult CD Music-latin
facxmmx - Adult CD Music-musicals
facxmnx - Adult CD Music-new age
facxmpx - Adult CD Music-rap
facxmrx - Adult CD Music-Rock & Pop
facxmsx - Adult CD Music-seasonal
facxmtx - Adult CD Music-soundtrack
facxmux - Adult CD Music-country
facxmwx - Adult CD Music-world
facxmxx - Adult CD Miscellaneous
faczfox - CD Music Folio / Oversized
fadcxxx - Adult Chinese DVD
fadebix - Adult Eng DVD Biography
fadenfx - Adult Eng DVD, Non-Fic
fadexxx - Adult Eng DVD Fic
fadhxxx - Adult Hindi DVD
fadpxxx - Adult Panjabi DVD
fadsnfx - Adult Spa DVD Non Fic
fadsxxx - Adult Spa DVD Fic
fadwxxx - Adult Persian DVD
fadznfx - Adult, World Lang DVD Non Fic
fadzxxx - Adult, World Language DVD
faoebix - Adult Eng Book On CD, Biography
faoefcx - Adult Eng Book On CD, Fic
faoenfx - Adult Eng Book On CD, Non-Fic
faosfcx - Adult Spa Book on CD, Fic
faosnfx - Adult Spa Book on CD, Non-Fic
faozxxx - Adult, World Lang Audio
faqefcx - Adult Book on Media Player
fawsxxx - Adult Spa Media Kit
fcbebbx - Child, Eng Boardbk
fcbegrx - Child, Eng Graphic Novel
fcbeibx - Child, Eng IBT
fcbeicx - Child, Eng I Can Read
fcbepbx - Child, Eng Picbk
fcbsbbx - Child Spa Boardbook
fcbsbix - Child Spa Biography
fcbsfcx - Child Spa Fiction
fcbsgrx - Child, Spa Graphic Novel
fcbsibx - Child Spa IBT
fcbsicx - Child Spa I Can Read
fcbsnfx - Child Spa Non-fic
fcbspbx - Child Spa Picbk
fcbzfcx - Child World Lang Print Fic
fcbznfx - Child World Lang Print NF
fccsmxx - Child Spa CD Music
fccxmxx - Child CD Music
fcdebix - Child, Eng DVD Biography
fcdenfx - Child, Eng DVD Non Fic
fcdexxx - Child, Eng DVD Fic
fcdsxxx - Child, Spa DVD
fcdzxxx - Child, World Language DVD
fcoexxx - Child Book on CD
fcosxxx - Child Spa Book on CD
fcpeibx - Child, Eng IBT Paperback
fcqefcx - Children's Book on Media Player
fcwsxxx - Child, Spa Media Kit
fcxerax - Child Eng Read-along
fcxsrax - Child Spa Read-along
fcxxprx - Child Parent's Shelf AV
fcxxvgx - Child Video Game
febefcx - Easy Eng, Fic
fybefcx - Teen, Eng Fiction
fybegrx - Teen, Eng Graphic Novel
fybsbix - Teen, Spa Biography
fybsfcx - Teen, Spa Fiction
fybsgrx - Teen, Spa Graphic Novel
fybsnfx - Teen, Spa Non-fic
fydxnfx - Teen DVD Non Fic
fydxxxx - Teen DVD Fic
fyoexxx - Teen Books on CD
fyqefcx - Teen Book on Media Player
fyxxvgx - Teen Video Game
fzbefcx - Large Print, Eng Fic
fzbsfcx - Large Print, Spanish Fic

"Attempted to Insert Duplicate Row" Error Message

You may receive the following error message when you are updating a collection code:

Attempted to insert a duplicate row. Attempt to insert duplicate key row in object 'dewey_call' with unique index 'dewey_call_item_index' Comand has been aborted.

If you receive this message, email the barcode of each item to Danielle Haas (Jurisdiction System Administrator) and mention the error message. She will run these items through a software routine to clear up the problem. You will be notified when that process has been completed and Horizon will then let you change the collection code. Unfortunately, we are not sure why this happens, only the workaround to fix it.

rev. 6/2017