Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. "apachectl start" doesn't start apache; Red Hat test page appears; "httpd -k start" processes
    5. How to correct budget code in already-arrived order

    How to correct budget code in already-arrived order

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Description
    2. Resolution

     

    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

     

    Description

    We recently placed an order and received an EDI invoice. When we ordered them, we didn’t change the order group from its initial setting, so the budget code in ALEPH was set to MONPR-2018. We want to change it to MONEL-2018. 

    The items have already been invoiced and arrived.  The ADM doc numbers are 008189907 thru 008189914.  How can we correct this?

    Resolution

    The z601-BUDGET-NUMBER, the first 50 bytes in the z601_rec_key, is the only field which needs to be changed. The following SQL shows that there are 18 z601 records involved: 

    xxx50@ALEPH22> select z601_rec_key_3, substr (z601_rec_key,1,50) from z601 where z601_rec_key_3 > '008189906' and z601_rec_key_3 < '008189915'; 


    The following SQL was used to change it from MONPR-2018 to MONEL-2018: 

    xxx50@ALEPH22> update z601 set z601_rec_key = 'MONEL-2018' || substr (z601_rec_key,11,55) where z601_rec_key_3 > '008189906' and z601_rec_key_3 < '008189915'; 

    18 rows updated. 


     

     

     


    • Article last edited: 7-May-2018
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Can Aleph produce comma-delimited output for non-bib znn Oracles tables (z36, z37, etc.)?
      • "Can't create Shipping Cash transaction" error in Photocopy Requests in Circulation GUI
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. contype:kba
      2. Prod:Aleph
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved