Sage 100

 View Only

  • 1.  What characters are NOT allowed in AP Vendor Number?

    Posted 04-26-2024 11:43

    Captain's Log, Stardate 20240426.0845.  We received a distress call from a user who apparently wiped out a vendor!
    According to their records, while performing routine maintenance on Accounts Payable, and using the proper change utility, the user changed the Vendor Number for "Guido Brothers Construction" (you can't make this sh!t up) from GUIBR to GUIBR*.  Yes, the user included an asterisk as part of the new number.  The system changed ALL of the files (history, open, etc.) with the "new" vendor number. The problem is, since the asterisk is NOT an acceptable character for this field, the system replaced the vendor number field in ALL of the files with a BLANK field. Thus, the data was there but couldn't be accessed!

    Panic ensued before a quick restore of the affected directory saved the day!

    Apparently, you should NEVER mess with the Guidos!

    Supplemental question from the user:  If the asterisk (*) is not allowed, what special characters, if any, ARE allowed in the Vendor Number field?



    ------------------------------
    Chuck Peddy
    Smartbridge Partners
    ------------------------------


  • 2.  RE: What characters are NOT allowed in AP Vendor Number?

    Posted 04-26-2024 11:59

    @Chuck Peddy, you're running in second behind Wayne for creative writing! I got nothing for you, but you amused me so thanks for that. 



    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    kolane@asifocus.com
    559-448-0900
    559-577-4142
    http://www.asifocus.com
    ------------------------------



  • 3.  RE: What characters are NOT allowed in AP Vendor Number?

    Posted 04-26-2024 13:48

    You can't use a dash (because of divisions, I assume) but other than that, I think anything is fair game.



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 4.  RE: What characters are NOT allowed in AP Vendor Number?

    Posted 04-26-2024 16:31

    I discourage the use of any special characters, save for perhaps the underscore (_).



    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    ------------------------------

    Original Message


  • 5.  RE: What characters are NOT allowed in AP Vendor Number?

    Posted 04-26-2024 21:40

    I thought the Guido Bros were in the debt collection service industry.  I have used them on occasion.



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------

    Original Message


  • 6.  RE: What characters are NOT allowed in AP Vendor Number?

    Posted 04-28-2024 22:09

    If * can cause this, I would suspect that ? and % would also be candidates for unexpected behavior.  In general, it is not a good idea to confuse your password requirements with your customer or vendor numbering...



    ------------------------------
    Phil McIntosh
    Friendly Systems, Inc.
    ------------------------------



Related Content