Sage 100

Customer just upgraded to 2021.2. They have bills with options and he states:

"On Sage 100 2019 the two character field used in the option codes would be displayed in capital letters regardless of whether they were entered in lower or upper case.  Sage would convert lower case letters to capital letters, which makes them clearer and easier to read.  On the new system, if you key the option codes in in lower case they stay lower case and are not converted to upper case.  The rub is that the option fields are not case sensitive, so "aa" "aA" "Aa" and AA are all the same."

Anyone else run into this? 

------------------------------
Therese Logeais, Technology Integrators
------------------------------

Have no experience with this specific issue, though can you mark the field to be Caps?

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772
------------------------------

I'm not seeing where that can be done. I can't find the field in any of the BM tables in CM.

------------------------------
Therese Logeais, Technology Integrators
------------------------------

Original Message:
Sent: 10-27-2021 15:14
From: Michelle Taylor
Subject: Bill of Materials Option Codes no longer in upper case?

Have no experience with this specific issue, though can you mark the field to be Caps?

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772
------------------------------

Oops!  Not an Option item, in Custom Office.  Select Uppercase for the field(s).

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772
------------------------------

Original Message:
Sent: 10-27-2021 15:33
From: Therese Logeais
Subject: Bill of Materials Option Codes no longer in upper case?

I'm not seeing where that can be done. I can't find the field in any of the BM tables in CM.

------------------------------
Therese Logeais, Technology Integrators
------------------------------


Original Message:
Sent: 10-27-2021 15:14
From: Michelle Taylor
Subject: Bill of Materials Option Codes no longer in upper case?

Have no experience with this specific issue, though can you mark the field to be Caps?

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772

Okay, not a problem in Bill Maintenance but it is a problem when entering option codes in SO Entry, BM Picking Sheet Printing and in BM Production Entry. It's fine if you use the lookup and select an option but not if you manually key it in (see attached). I cannot find a way to make it uppercase.

------------------------------
Therese Logeais, Technology Integrators
------------------------------

Original Message:
Sent: 10-27-2021 15:45
From: Michelle Taylor
Subject: Bill of Materials Option Codes no longer in upper case?

Oops!  Not an Option item, in Custom Office.  Select Uppercase for the field(s).

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772
------------------------------


Original Message:
Sent: 10-27-2021 15:33
From: Therese Logeais
Subject: Bill of Materials Option Codes no longer in upper case?

I'm not seeing where that can be done. I can't find the field in any of the BM tables in CM.

------------------------------
Therese Logeais, Technology Integrators


Original Message:
Sent: 10-27-2021 15:14
From: Michelle Taylor
Subject: Bill of Materials Option Codes no longer in upper case?

Have no experience with this specific issue, though can you mark the field to be Caps?

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772

Just spent a half hour on the phone with Sage. It took most of the time to walk her through recreating what I was talking about. She obviously wasn't well versed with Bill options. She said she could report it but the next update won't be until March when 2022 is released as December will be year-end fixes and nothing else - UNLESS they can create a hot fix but since the program is returning the correct data, it wouldn't be an urgent issue. "They will just have to do the lookups to enter the options." Great, that's what I'll tell my customer....

------------------------------
Therese Logeais, Technology Integrators
------------------------------

Original Message:
Sent: 10-27-2021 17:09
From: Therese Logeais
Subject: Bill of Materials Option Codes no longer in upper case?

Okay, not a problem in Bill Maintenance but it is a problem when entering option codes in SO Entry, BM Picking Sheet Printing and in BM Production Entry. It's fine if you use the lookup and select an option but not if you manually key it in (see attached). I cannot find a way to make it uppercase.

------------------------------
Therese Logeais, Technology Integrators
------------------------------


Original Message:
Sent: 10-27-2021 15:45
From: Michelle Taylor
Subject: Bill of Materials Option Codes no longer in upper case?

Oops!  Not an Option item, in Custom Office.  Select Uppercase for the field(s).

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772


Original Message:
Sent: 10-27-2021 15:33
From: Therese Logeais
Subject: Bill of Materials Option Codes no longer in upper case?

I'm not seeing where that can be done. I can't find the field in any of the BM tables in CM.

------------------------------
Therese Logeais, Technology Integrators


Original Message:
Sent: 10-27-2021 15:14
From: Michelle Taylor
Subject: Bill of Materials Option Codes no longer in upper case?

Have no experience with this specific issue, though can you mark the field to be Caps?

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772

Is the table available for a script?  Converting an entered value to upper case is a 2 line column pre-validate script (possibly adding commands to prevent recursive calls...).
retVal = 0 : sValue  = "" : sValue = UCase(value)
retVal = oBusObj.SetValue("TheFieldName$", sValue)

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

Original Message:
Sent: 10-27-2021 18:06
From: Therese Logeais
Subject: Bill of Materials Option Codes no longer in upper case?

Just spent a half hour on the phone with Sage. It took most of the time to walk her through recreating what I was talking about. She obviously wasn't well versed with Bill options. She said she could report it but the next update won't be until March when 2022 is released as December will be year-end fixes and nothing else - UNLESS they can create a hot fix but since the program is returning the correct data, it wouldn't be an urgent issue. "They will just have to do the lookups to enter the options." Great, that's what I'll tell my customer....

------------------------------
Therese Logeais, Technology Integrators
------------------------------


Original Message:
Sent: 10-27-2021 17:09
From: Therese Logeais
Subject: Bill of Materials Option Codes no longer in upper case?

Okay, not a problem in Bill Maintenance but it is a problem when entering option codes in SO Entry, BM Picking Sheet Printing and in BM Production Entry. It's fine if you use the lookup and select an option but not if you manually key it in (see attached). I cannot find a way to make it uppercase.

------------------------------
Therese Logeais, Technology Integrators


Original Message:
Sent: 10-27-2021 15:45
From: Michelle Taylor
Subject: Bill of Materials Option Codes no longer in upper case?

Oops!  Not an Option item, in Custom Office.  Select Uppercase for the field(s).

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772


Original Message:
Sent: 10-27-2021 15:33
From: Therese Logeais
Subject: Bill of Materials Option Codes no longer in upper case?

I'm not seeing where that can be done. I can't find the field in any of the BM tables in CM.

------------------------------
Therese Logeais, Technology Integrators


Original Message:
Sent: 10-27-2021 15:14
From: Michelle Taylor
Subject: Bill of Materials Option Codes no longer in upper case?

Have no experience with this specific issue, though can you mark the field to be Caps?

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772

I have no idea. It is in the Option Selection window.


------------------------------
Therese Logeais, Technology Integrators
------------------------------

Original Message:
Sent: 10-27-2021 18:13
From: Kevin Moyes
Subject: Bill of Materials Option Codes no longer in upper case?

Is the table available for a script?  Converting an entered value to upper case is a 2 line column pre-validate script (possibly adding commands to prevent recursive calls...).
retVal = 0 : sValue  = "" : sValue = UCase(value)
retVal = oBusObj.SetValue("TheFieldName$", sValue)

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


Original Message:
Sent: 10-27-2021 18:06
From: Therese Logeais
Subject: Bill of Materials Option Codes no longer in upper case?

Just spent a half hour on the phone with Sage. It took most of the time to walk her through recreating what I was talking about. She obviously wasn't well versed with Bill options. She said she could report it but the next update won't be until March when 2022 is released as December will be year-end fixes and nothing else - UNLESS they can create a hot fix but since the program is returning the correct data, it wouldn't be an urgent issue. "They will just have to do the lookups to enter the options." Great, that's what I'll tell my customer....

------------------------------
Therese Logeais, Technology Integrators


Original Message:
Sent: 10-27-2021 17:09
From: Therese Logeais
Subject: Bill of Materials Option Codes no longer in upper case?

Okay, not a problem in Bill Maintenance but it is a problem when entering option codes in SO Entry, BM Picking Sheet Printing and in BM Production Entry. It's fine if you use the lookup and select an option but not if you manually key it in (see attached). I cannot find a way to make it uppercase.

------------------------------
Therese Logeais, Technology Integrators


Original Message:
Sent: 10-27-2021 15:45
From: Michelle Taylor
Subject: Bill of Materials Option Codes no longer in upper case?

Oops!  Not an Option item, in Custom Office.  Select Uppercase for the field(s).

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772


Original Message:
Sent: 10-27-2021 15:33
From: Therese Logeais
Subject: Bill of Materials Option Codes no longer in upper case?

I'm not seeing where that can be done. I can't find the field in any of the BM tables in CM.

------------------------------
Therese Logeais, Technology Integrators


Original Message:
Sent: 10-27-2021 15:14
From: Michelle Taylor
Subject: Bill of Materials Option Codes no longer in upper case?

Have no experience with this specific issue, though can you mark the field to be Caps?

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772

On my 2021.0 system, Bill Options Maintenance does convert the option code entered to upper case BUT it does not when selecting options in Sales Order Entry.  However, after the options have been selected and OK is clicked, the values are converted to upper case in the table.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

Original Message:
Sent: 10-27-2021 18:18
From: Therese Logeais
Subject: Bill of Materials Option Codes no longer in upper case?

I have no idea. It is in the Option Selection window.


------------------------------
Therese Logeais, Technology Integrators
------------------------------


Original Message:
Sent: 10-27-2021 18:13
From: Kevin Moyes
Subject: Bill of Materials Option Codes no longer in upper case?

Is the table available for a script?  Converting an entered value to upper case is a 2 line column pre-validate script (possibly adding commands to prevent recursive calls...).
retVal = 0 : sValue  = "" : sValue = UCase(value)
retVal = oBusObj.SetValue("TheFieldName$", sValue)

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


Original Message:
Sent: 10-27-2021 18:06
From: Therese Logeais
Subject: Bill of Materials Option Codes no longer in upper case?

Just spent a half hour on the phone with Sage. It took most of the time to walk her through recreating what I was talking about. She obviously wasn't well versed with Bill options. She said she could report it but the next update won't be until March when 2022 is released as December will be year-end fixes and nothing else - UNLESS they can create a hot fix but since the program is returning the correct data, it wouldn't be an urgent issue. "They will just have to do the lookups to enter the options." Great, that's what I'll tell my customer....

------------------------------
Therese Logeais, Technology Integrators


Original Message:
Sent: 10-27-2021 17:09
From: Therese Logeais
Subject: Bill of Materials Option Codes no longer in upper case?

Okay, not a problem in Bill Maintenance but it is a problem when entering option codes in SO Entry, BM Picking Sheet Printing and in BM Production Entry. It's fine if you use the lookup and select an option but not if you manually key it in (see attached). I cannot find a way to make it uppercase.

------------------------------
Therese Logeais, Technology Integrators


Original Message:
Sent: 10-27-2021 15:45
From: Michelle Taylor
Subject: Bill of Materials Option Codes no longer in upper case?

Oops!  Not an Option item, in Custom Office.  Select Uppercase for the field(s).

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772


Original Message:
Sent: 10-27-2021 15:33
From: Therese Logeais
Subject: Bill of Materials Option Codes no longer in upper case?

I'm not seeing where that can be done. I can't find the field in any of the BM tables in CM.

------------------------------
Therese Logeais, Technology Integrators


Original Message:
Sent: 10-27-2021 15:14
From: Michelle Taylor
Subject: Bill of Materials Option Codes no longer in upper case?

Have no experience with this specific issue, though can you mark the field to be Caps?

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772

Correct @David Speck II but they want to visually see them as they are selecting them manually. ​

------------------------------
Therese Logeais, Technology Integrators
------------------------------

Original Message:
Sent: 10-27-2021 18:42
From: David Speck II
Subject: Bill of Materials Option Codes no longer in upper case?

On my 2021.0 system, Bill Options Maintenance does convert the option code entered to upper case BUT it does not when selecting options in Sales Order Entry.  However, after the options have been selected and OK is clicked, the values are converted to upper case in the table.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------


Original Message:
Sent: 10-27-2021 18:18
From: Therese Logeais
Subject: Bill of Materials Option Codes no longer in upper case?

I have no idea. It is in the Option Selection window.


------------------------------
Therese Logeais, Technology Integrators


Original Message:
Sent: 10-27-2021 18:13
From: Kevin Moyes
Subject: Bill of Materials Option Codes no longer in upper case?

Is the table available for a script?  Converting an entered value to upper case is a 2 line column pre-validate script (possibly adding commands to prevent recursive calls...).
retVal = 0 : sValue  = "" : sValue = UCase(value)
retVal = oBusObj.SetValue("TheFieldName$", sValue)

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


Original Message:
Sent: 10-27-2021 18:06
From: Therese Logeais
Subject: Bill of Materials Option Codes no longer in upper case?

Just spent a half hour on the phone with Sage. It took most of the time to walk her through recreating what I was talking about. She obviously wasn't well versed with Bill options. She said she could report it but the next update won't be until March when 2022 is released as December will be year-end fixes and nothing else - UNLESS they can create a hot fix but since the program is returning the correct data, it wouldn't be an urgent issue. "They will just have to do the lookups to enter the options." Great, that's what I'll tell my customer....

------------------------------
Therese Logeais, Technology Integrators


Original Message:
Sent: 10-27-2021 17:09
From: Therese Logeais
Subject: Bill of Materials Option Codes no longer in upper case?

Okay, not a problem in Bill Maintenance but it is a problem when entering option codes in SO Entry, BM Picking Sheet Printing and in BM Production Entry. It's fine if you use the lookup and select an option but not if you manually key it in (see attached). I cannot find a way to make it uppercase.

------------------------------
Therese Logeais, Technology Integrators


Original Message:
Sent: 10-27-2021 15:45
From: Michelle Taylor
Subject: Bill of Materials Option Codes no longer in upper case?

Oops!  Not an Option item, in Custom Office.  Select Uppercase for the field(s).

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772


Original Message:
Sent: 10-27-2021 15:33
From: Therese Logeais
Subject: Bill of Materials Option Codes no longer in upper case?

I'm not seeing where that can be done. I can't find the field in any of the BM tables in CM.

------------------------------
Therese Logeais, Technology Integrators


Original Message:
Sent: 10-27-2021 15:14
From: Michelle Taylor
Subject: Bill of Materials Option Codes no longer in upper case?

Have no experience with this specific issue, though can you mark the field to be Caps?

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772

I'm not saying that isn't something that Sage should fix, but looking at the big picture, they still get validated correctly and will be converted once accepted.  So I wouldn't invest a lot of effort into this.  Its kind of like a kid saying the food doesn't look good but it all gets mixed together in the stomach anyway.  For the record, I did briefly look in Customizer to see if it could be easily changed but that screen uses a grid which can't be customized with Customizer to force it to be uppercase.  Because this takes place within that panel, it doesn't quite behave the way a field added to a panel does which would allow you to toggle the uppercase option and because it isn't writing directly to a table at this point, you can't use Advanced Field Settings to force it to be uppercase.  It is probably possible to use a UI post load event script to redefine the cell format but I don't think it is worth the trouble.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

Original Message:
Sent: 10-27-2021 18:53
From: Therese Logeais
Subject: Bill of Materials Option Codes no longer in upper case?

Correct @David Speck II but they want to visually see them as they are selecting them manually. ​

------------------------------
Therese Logeais, Technology Integrators
------------------------------


Original Message:
Sent: 10-27-2021 18:42
From: David Speck II
Subject: Bill of Materials Option Codes no longer in upper case?

On my 2021.0 system, Bill Options Maintenance does convert the option code entered to upper case BUT it does not when selecting options in Sales Order Entry.  However, after the options have been selected and OK is clicked, the values are converted to upper case in the table.

------------------------------
David Speck II
Tennessee Software Solutions


Original Message:
Sent: 10-27-2021 18:18
From: Therese Logeais
Subject: Bill of Materials Option Codes no longer in upper case?

I have no idea. It is in the Option Selection window.


------------------------------
Therese Logeais, Technology Integrators


Original Message:
Sent: 10-27-2021 18:13
From: Kevin Moyes
Subject: Bill of Materials Option Codes no longer in upper case?

Is the table available for a script?  Converting an entered value to upper case is a 2 line column pre-validate script (possibly adding commands to prevent recursive calls...).
retVal = 0 : sValue  = "" : sValue = UCase(value)
retVal = oBusObj.SetValue("TheFieldName$", sValue)

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


Original Message:
Sent: 10-27-2021 18:06
From: Therese Logeais
Subject: Bill of Materials Option Codes no longer in upper case?

Just spent a half hour on the phone with Sage. It took most of the time to walk her through recreating what I was talking about. She obviously wasn't well versed with Bill options. She said she could report it but the next update won't be until March when 2022 is released as December will be year-end fixes and nothing else - UNLESS they can create a hot fix but since the program is returning the correct data, it wouldn't be an urgent issue. "They will just have to do the lookups to enter the options." Great, that's what I'll tell my customer....

------------------------------
Therese Logeais, Technology Integrators


Original Message:
Sent: 10-27-2021 17:09
From: Therese Logeais
Subject: Bill of Materials Option Codes no longer in upper case?

Okay, not a problem in Bill Maintenance but it is a problem when entering option codes in SO Entry, BM Picking Sheet Printing and in BM Production Entry. It's fine if you use the lookup and select an option but not if you manually key it in (see attached). I cannot find a way to make it uppercase.

------------------------------
Therese Logeais, Technology Integrators


Original Message:
Sent: 10-27-2021 15:45
From: Michelle Taylor
Subject: Bill of Materials Option Codes no longer in upper case?

Oops!  Not an Option item, in Custom Office.  Select Uppercase for the field(s).

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772


Original Message:
Sent: 10-27-2021 15:33
From: Therese Logeais
Subject: Bill of Materials Option Codes no longer in upper case?

I'm not seeing where that can be done. I can't find the field in any of the BM tables in CM.

------------------------------
Therese Logeais, Technology Integrators


Original Message:
Sent: 10-27-2021 15:14
From: Michelle Taylor
Subject: Bill of Materials Option Codes no longer in upper case?

Have no experience with this specific issue, though can you mark the field to be Caps?

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772