Sage 100

 View Only
  • 1.  Inventory Maintenance - 4 Categories - change to mixed case - how?

    Posted 11-24-2019 13:23
    I have a customer who wants the four Categories fields within Inventory Maintenance to accept and hold mixed-case data.

    They are on Sage 100 2017 Premium PU 1

    I can modify the panel and get to the four categories fields on the additional tab.
    I can change each field by removing the UPPER CASE
    I can save the panel

    When I go back into Item Maintenance to test I can enter in mixed case content but as soon as I move from the field it goes to upper case.

    Then, I go to UDF maintenance and Advanced Field Settings
    I can see that the Category fields have "UPPERCASE" as a value which cannot be changed

    a. Why does everything in this field have to be uppercase? 
    b. Is there any way to modify this so that the field accepts mixed case
    c. If I can make this change behind the scenes are there any potential downsides?

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------


  • 2.  RE: Inventory Maintenance - 4 Categories - change to mixed case - how?

    Posted 11-25-2019 09:57
    Use UDF's instead?

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Inventory Maintenance - 4 Categories - change to mixed case - how?

    Posted 11-25-2019 10:28
    That's probably what I'm going to do. I couldn't figure out why Sage would force upper case on that field unless there was some lower cased keyword that would cause havoc with their old code.

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------