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. Vendor record containing comma can't be deleted

    Vendor record containing comma can't be deleted

    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

    A z70 vendor record has been created both with a comma ("GROETECKE, JOHANNES") and without it ("GROETECKE JOHANNES").  When we try to delete the first one (with the comma) the GUI responds with "Vendor code has linked orders. Unable to delete vendor" -- even though the orders are linked to the vendor *without* the comma ("GROETECKE JOHANNES"); the vendor with the comma ("GROETECKE, JOHANNES") has no orders linked to it.   {Note:  It may be that the same applies to vendor codes with other punctuation (hyphen? quote-mark? parenthesis?)}
     

    Resolution

    We confirmed that, though "GROETECKE JOHANNES" has 12 linked orders (z68's), "GROETECKE, JOHANNES" had no linked orders. (It seems that the system has been removing the comma and checking "GROETECKE JOHANNES" when issuing this message?) And also that "GROETECKE, JOHANNES" has no linked z71, z74, z75, z77, z601, z16, z30, or z1007 records.   

    Using SQL, we deleted the z70 (vendor) record and z72 (vendor address) records for "GROETECKE, JOHANNES". 

     

     


    • Article last edited: 28-Mar-2018
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Vendor EDI Code definition requirements
      • Vendor Searching omits certain vendors
    • 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