Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    How to correct budget code in already-arrived order

     

    • 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