Sage 100

Client copy and pastes item descriptions from vendor website which is mixed case.  Client wants to change all verbiage to upper case.  So for Item description in CI Item and for the extended description in CI Extended Description Master, I changed the setting under Advanced Field settings to upper.

This modification works for the ci item description but does not continue when I overflow into the extended description.  Is there another field that I overlooked of this a bug for all.  V2019 PU2 Advanced.

TIA



------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

If you want to see the characters converted to uppercase as they are typed, use Customizer to set the Item Code Description and Extended Description controls to uppercase with this option.


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

Thanks for the plan B option.  It appears that you are confirming that I had the correct fields and tables for the Advanced settings.  The item code field is working.  The extended description text field is not.  Replicated in both v2017 and V2017.

Does anyone submit bug fix requests anymore?  Does posting on Sage Community effective?  Would seem that this is a simple fix.  I hate having to wait until 2023 for it finally appear.

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 01-27-2020 02:08
From: David Speck II
Subject: Default UPPER case for Inventory Item description.

If you want to see the characters converted to uppercase as they are typed, use Customizer to set the Item Code Description and Extended Description controls to uppercase with this option.

Otherwise, use Advanced Field Settings on both CI_Item.ItemCodeDesc and CI_ExtendedDescription.ExtendedDescriptionText, the conversion to uppercase will take place when the record is saved. You should be able to test this yourself by make a change with lowercase letters then accept the changes, pull the item back up and you should see the lowercase letters were converted to uppercase.

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

Odd that neither version is working for you as I tested both methods on my local v2018 install.

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

Original Message:
Sent: 01-27-2020 08:47
From: Jeff Schwenk
Subject: Default UPPER case for Inventory Item description.

Thanks for the plan B option.  It appears that you are confirming that I had the correct fields and tables for the Advanced settings.  The item code field is working.  The extended description text field is not.  Replicated in both v2017 and V2017.

Does anyone submit bug fix requests anymore?  Does posting on Sage Community effective?  Would seem that this is a simple fix.  I hate having to wait until 2023 for it finally appear.

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 01-27-2020 02:08
From: David Speck II
Subject: Default UPPER case for Inventory Item description.

If you want to see the characters converted to uppercase as they are typed, use Customizer to set the Item Code Description and Extended Description controls to uppercase with this option.

Otherwise, use Advanced Field Settings on both CI_Item.ItemCodeDesc and CI_ExtendedDescription.ExtendedDescriptionText, the conversion to uppercase will take place when the record is saved. You should be able to test this yourself by make a change with lowercase letters then accept the changes, pull the item back up and you should see the lowercase letters were converted to uppercase.

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

A simple column pre-validate script (disable trigger, ucase(value) > SetValue, enable trigger) might work.

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

Original Message:
Sent: 01-27-2020 09:54
From: David Speck II
Subject: Default UPPER case for Inventory Item description.

Odd that neither version is working for you as I tested both methods on my local v2018 install.

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


Original Message:
Sent: 01-27-2020 08:47
From: Jeff Schwenk
Subject: Default UPPER case for Inventory Item description.

Thanks for the plan B option.  It appears that you are confirming that I had the correct fields and tables for the Advanced settings.  The item code field is working.  The extended description text field is not.  Replicated in both v2017 and V2017.

Does anyone submit bug fix requests anymore?  Does posting on Sage Community effective?  Would seem that this is a simple fix.  I hate having to wait until 2023 for it finally appear.

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 01-27-2020 02:08
From: David Speck II
Subject: Default UPPER case for Inventory Item description.

If you want to see the characters converted to uppercase as they are typed, use Customizer to set the Item Code Description and Extended Description controls to uppercase with this option.

Otherwise, use Advanced Field Settings on both CI_Item.ItemCodeDesc and CI_ExtendedDescription.ExtendedDescriptionText, the conversion to uppercase will take place when the record is saved. You should be able to test this yourself by make a change with lowercase letters then accept the changes, pull the item back up and you should see the lowercase letters were converted to uppercase.

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

@David, The advanced setting works for the item description but not the extended description.  To remedy the extended description field, I took your advice and modified the extended description panel ​in CO.  Workable but clumsy especially if it has been modified for specific user.  For extended descriptions, this is the first time I have ever modified that panel.  So minimal headache.

@Kevin Moyes, a great workaround as well IF you are a scriptwriter.  I am not!  My expectation that something this simple should work as DESIRED (the real meaning as WAD).

BTW, you are a Sage Community frequent flyer.  Would posting this there get anyone's attention at Sage?
​​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 01-27-2020 10:01
From: Kevin Moyes
Subject: Default UPPER case for Inventory Item description.

A simple column pre-validate script (disable trigger, ucase(value) > SetValue, enable trigger) might work.

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


Original Message:
Sent: 01-27-2020 09:54
From: David Speck II
Subject: Default UPPER case for Inventory Item description.

Odd that neither version is working for you as I tested both methods on my local v2018 install.

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


Original Message:
Sent: 01-27-2020 08:47
From: Jeff Schwenk
Subject: Default UPPER case for Inventory Item description.

Thanks for the plan B option.  It appears that you are confirming that I had the correct fields and tables for the Advanced settings.  The item code field is working.  The extended description text field is not.  Replicated in both v2017 and V2017.

Does anyone submit bug fix requests anymore?  Does posting on Sage Community effective?  Would seem that this is a simple fix.  I hate having to wait until 2023 for it finally appear.

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 01-27-2020 02:08
From: David Speck II
Subject: Default UPPER case for Inventory Item description.

If you want to see the characters converted to uppercase as they are typed, use Customizer to set the Item Code Description and Extended Description controls to uppercase with this option.

Otherwise, use Advanced Field Settings on both CI_Item.ItemCodeDesc and CI_ExtendedDescription.ExtendedDescriptionText, the conversion to uppercase will take place when the record is saved. You should be able to test this yourself by make a change with lowercase letters then accept the changes, pull the item back up and you should see the lowercase letters were converted to uppercase.

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

Sage does read everything in Sage City for sure.  Whether you catch the attention of one of the developers is... hit and miss.  Worth a try for sure, especially if you include what you have tried (to entice someone there to test on their own system).

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

Original Message:
Sent: 01-27-2020 10:39
From: Jeff Schwenk
Subject: Default UPPER case for Inventory Item description.

@David, The advanced setting works for the item description but not the extended description.  To remedy the extended description field, I took your advice and modified the extended description panel ​in CO.  Workable but clumsy especially if it has been modified for specific user.  For extended descriptions, this is the first time I have ever modified that panel.  So minimal headache.

@Kevin Moyes, a great workaround as well IF you are a scriptwriter.  I am not!  My expectation that something this simple should work as DESIRED (the real meaning as WAD).

BTW, you are a Sage Community frequent flyer.  Would posting this there get anyone's attention at Sage?
​​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 01-27-2020 10:01
From: Kevin Moyes
Subject: Default UPPER case for Inventory Item description.

A simple column pre-validate script (disable trigger, ucase(value) > SetValue, enable trigger) might work.

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


Original Message:
Sent: 01-27-2020 09:54
From: David Speck II
Subject: Default UPPER case for Inventory Item description.

Odd that neither version is working for you as I tested both methods on my local v2018 install.

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


Original Message:
Sent: 01-27-2020 08:47
From: Jeff Schwenk
Subject: Default UPPER case for Inventory Item description.

Thanks for the plan B option.  It appears that you are confirming that I had the correct fields and tables for the Advanced settings.  The item code field is working.  The extended description text field is not.  Replicated in both v2017 and V2017.

Does anyone submit bug fix requests anymore?  Does posting on Sage Community effective?  Would seem that this is a simple fix.  I hate having to wait until 2023 for it finally appear.

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 01-27-2020 02:08
From: David Speck II
Subject: Default UPPER case for Inventory Item description.

If you want to see the characters converted to uppercase as they are typed, use Customizer to set the Item Code Description and Extended Description controls to uppercase with this option.

Otherwise, use Advanced Field Settings on both CI_Item.ItemCodeDesc and CI_ExtendedDescription.ExtendedDescriptionText, the conversion to uppercase will take place when the record is saved. You should be able to test this yourself by make a change with lowercase letters then accept the changes, pull the item back up and you should see the lowercase letters were converted to uppercase.

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

Hmmmm.  Perhaps that someone will be named Kevin??

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 01-27-2020 10:47
From: Kevin Moyes
Subject: Default UPPER case for Inventory Item description.

Sage does read everything in Sage City for sure.  Whether you catch the attention of one of the developers is... hit and miss.  Worth a try for sure, especially if you include what you have tried (to entice someone there to test on their own system).

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


Original Message:
Sent: 01-27-2020 10:39
From: Jeff Schwenk
Subject: Default UPPER case for Inventory Item description.

@David, The advanced setting works for the item description but not the extended description.  To remedy the extended description field, I took your advice and modified the extended description panel ​in CO.  Workable but clumsy especially if it has been modified for specific user.  For extended descriptions, this is the first time I have ever modified that panel.  So minimal headache.

@Kevin Moyes, a great workaround as well IF you are a scriptwriter.  I am not!  My expectation that something this simple should work as DESIRED (the real meaning as WAD).

BTW, you are a Sage Community frequent flyer.  Would posting this there get anyone's attention at Sage?
​​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 01-27-2020 10:01
From: Kevin Moyes
Subject: Default UPPER case for Inventory Item description.

A simple column pre-validate script (disable trigger, ucase(value) > SetValue, enable trigger) might work.

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


Original Message:
Sent: 01-27-2020 09:54
From: David Speck II
Subject: Default UPPER case for Inventory Item description.

Odd that neither version is working for you as I tested both methods on my local v2018 install.

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


Original Message:
Sent: 01-27-2020 08:47
From: Jeff Schwenk
Subject: Default UPPER case for Inventory Item description.

Thanks for the plan B option.  It appears that you are confirming that I had the correct fields and tables for the Advanced settings.  The item code field is working.  The extended description text field is not.  Replicated in both v2017 and V2017.

Does anyone submit bug fix requests anymore?  Does posting on Sage Community effective?  Would seem that this is a simple fix.  I hate having to wait until 2023 for it finally appear.

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 01-27-2020 02:08
From: David Speck II
Subject: Default UPPER case for Inventory Item description.

If you want to see the characters converted to uppercase as they are typed, use Customizer to set the Item Code Description and Extended Description controls to uppercase with this option.

Otherwise, use Advanced Field Settings on both CI_Item.ItemCodeDesc and CI_ExtendedDescription.ExtendedDescriptionText, the conversion to uppercase will take place when the record is saved. You should be able to test this yourself by make a change with lowercase letters then accept the changes, pull the item back up and you should see the lowercase letters were converted to uppercase.

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

Or perhaps that someone will be name Jeff.  :-)

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

Original Message:
Sent: 01-27-2020 10:56
From: Jeff Schwenk
Subject: Default UPPER case for Inventory Item description.

Hmmmm.  Perhaps that someone will be named Kevin??

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 01-27-2020 10:47
From: Kevin Moyes
Subject: Default UPPER case for Inventory Item description.

Sage does read everything in Sage City for sure.  Whether you catch the attention of one of the developers is... hit and miss.  Worth a try for sure, especially if you include what you have tried (to entice someone there to test on their own system).

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


Original Message:
Sent: 01-27-2020 10:39
From: Jeff Schwenk
Subject: Default UPPER case for Inventory Item description.

@David, The advanced setting works for the item description but not the extended description.  To remedy the extended description field, I took your advice and modified the extended description panel ​in CO.  Workable but clumsy especially if it has been modified for specific user.  For extended descriptions, this is the first time I have ever modified that panel.  So minimal headache.

@Kevin Moyes, a great workaround as well IF you are a scriptwriter.  I am not!  My expectation that something this simple should work as DESIRED (the real meaning as WAD).

BTW, you are a Sage Community frequent flyer.  Would posting this there get anyone's attention at Sage?
​​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 01-27-2020 10:01
From: Kevin Moyes
Subject: Default UPPER case for Inventory Item description.

A simple column pre-validate script (disable trigger, ucase(value) > SetValue, enable trigger) might work.

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


Original Message:
Sent: 01-27-2020 09:54
From: David Speck II
Subject: Default UPPER case for Inventory Item description.

Odd that neither version is working for you as I tested both methods on my local v2018 install.

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


Original Message:
Sent: 01-27-2020 08:47
From: Jeff Schwenk
Subject: Default UPPER case for Inventory Item description.

Thanks for the plan B option.  It appears that you are confirming that I had the correct fields and tables for the Advanced settings.  The item code field is working.  The extended description text field is not.  Replicated in both v2017 and V2017.

Does anyone submit bug fix requests anymore?  Does posting on Sage Community effective?  Would seem that this is a simple fix.  I hate having to wait until 2023 for it finally appear.

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 01-27-2020 02:08
From: David Speck II
Subject: Default UPPER case for Inventory Item description.

If you want to see the characters converted to uppercase as they are typed, use Customizer to set the Item Code Description and Extended Description controls to uppercase with this option.

Otherwise, use Advanced Field Settings on both CI_Item.ItemCodeDesc and CI_ExtendedDescription.ExtendedDescriptionText, the conversion to uppercase will take place when the record is saved. You should be able to test this yourself by make a change with lowercase letters then accept the changes, pull the item back up and you should see the lowercase letters were converted to uppercase.

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

The advanced field settings are working on both fields for me on a v2018 install and a v2019.2 install. Are you sure you set it up for the right company and user combination, unless you did All - All?
Also, are you sure you are looking at the extended description AFTER you click Accept and revisit it?
My testing with the advanced field settings results in the following behavior on both v2018 and v2019.2.

1. Standard Item Code Description fields converts to uppercase as soon as you exit the field.
2. Extended Description field does not convert to uppercase when you exit the field or even after clicking OK, only after clicking OK, then Accept.

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

Original Message:
Sent: 01-27-2020 10:39
From: Jeff Schwenk
Subject: Default UPPER case for Inventory Item description.

@David, The advanced setting works for the item description but not the extended description.  To remedy the extended description field, I took your advice and modified the extended description panel ​in CO.  Workable but clumsy especially if it has been modified for specific user.  For extended descriptions, this is the first time I have ever modified that panel.  So minimal headache.

@Kevin Moyes, a great workaround as well IF you are a scriptwriter.  I am not!  My expectation that something this simple should work as DESIRED (the real meaning as WAD).

BTW, you are a Sage Community frequent flyer.  Would posting this there get anyone's attention at Sage?
​​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 01-27-2020 10:01
From: Kevin Moyes
Subject: Default UPPER case for Inventory Item description.

A simple column pre-validate script (disable trigger, ucase(value) > SetValue, enable trigger) might work.

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


Original Message:
Sent: 01-27-2020 09:54
From: David Speck II
Subject: Default UPPER case for Inventory Item description.

Odd that neither version is working for you as I tested both methods on my local v2018 install.

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


Original Message:
Sent: 01-27-2020 08:47
From: Jeff Schwenk
Subject: Default UPPER case for Inventory Item description.

Thanks for the plan B option.  It appears that you are confirming that I had the correct fields and tables for the Advanced settings.  The item code field is working.  The extended description text field is not.  Replicated in both v2017 and V2017.

Does anyone submit bug fix requests anymore?  Does posting on Sage Community effective?  Would seem that this is a simple fix.  I hate having to wait until 2023 for it finally appear.

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 01-27-2020 02:08
From: David Speck II
Subject: Default UPPER case for Inventory Item description.

If you want to see the characters converted to uppercase as they are typed, use Customizer to set the Item Code Description and Extended Description controls to uppercase with this option.

Otherwise, use Advanced Field Settings on both CI_Item.ItemCodeDesc and CI_ExtendedDescription.ExtendedDescriptionText, the conversion to uppercase will take place when the record is saved. You should be able to test this yourself by make a change with lowercase letters then accept the changes, pull the item back up and you should see the lowercase letters were converted to uppercase.

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

Well DON"T THAT beat all @David Speck II​​ !!!!  There is some inconsistency in the behavior of the two fields!

When creating a new record, if you hold a key down to repeat in lower case, the extended window will pop open displaying the first 30 characters in upper case and the lower case giving you a sense of a bug present.

Once ACCEPTED, you can then verify and the the extended field is now UPPER!

Thanks for staying with me on this one.

@Kevin Moyes Guess neither one of us has to post.......

Looks like a HSD coming on!
​​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 01-27-2020 11:06
From: David Speck II
Subject: Default UPPER case for Inventory Item description.

The advanced field settings are working on both fields for me on a v2018 install and a v2019.2 install. Are you sure you set it up for the right company and user combination, unless you did All - All?
Also, are you sure you are looking at the extended description AFTER you click Accept and revisit it?
My testing with the advanced field settings results in the following behavior on both v2018 and v2019.2.

1. Standard Item Code Description fields converts to uppercase as soon as you exit the field.
2. Extended Description field does not convert to uppercase when you exit the field or even after clicking OK, only after clicking OK, then Accept.

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


Original Message:
Sent: 01-27-2020 10:39
From: Jeff Schwenk
Subject: Default UPPER case for Inventory Item description.

@David, The advanced setting works for the item description but not the extended description.  To remedy the extended description field, I took your advice and modified the extended description panel ​in CO.  Workable but clumsy especially if it has been modified for specific user.  For extended descriptions, this is the first time I have ever modified that panel.  So minimal headache.

@Kevin Moyes, a great workaround as well IF you are a scriptwriter.  I am not!  My expectation that something this simple should work as DESIRED (the real meaning as WAD).

BTW, you are a Sage Community frequent flyer.  Would posting this there get anyone's attention at Sage?
​​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 01-27-2020 10:01
From: Kevin Moyes
Subject: Default UPPER case for Inventory Item description.

A simple column pre-validate script (disable trigger, ucase(value) > SetValue, enable trigger) might work.

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


Original Message:
Sent: 01-27-2020 09:54
From: David Speck II
Subject: Default UPPER case for Inventory Item description.

Odd that neither version is working for you as I tested both methods on my local v2018 install.

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


Original Message:
Sent: 01-27-2020 08:47
From: Jeff Schwenk
Subject: Default UPPER case for Inventory Item description.

Thanks for the plan B option.  It appears that you are confirming that I had the correct fields and tables for the Advanced settings.  The item code field is working.  The extended description text field is not.  Replicated in both v2017 and V2017.

Does anyone submit bug fix requests anymore?  Does posting on Sage Community effective?  Would seem that this is a simple fix.  I hate having to wait until 2023 for it finally appear.

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 01-27-2020 02:08
From: David Speck II
Subject: Default UPPER case for Inventory Item description.

If you want to see the characters converted to uppercase as they are typed, use Customizer to set the Item Code Description and Extended Description controls to uppercase with this option.

Otherwise, use Advanced Field Settings on both CI_Item.ItemCodeDesc and CI_ExtendedDescription.ExtendedDescriptionText, the conversion to uppercase will take place when the record is saved. You should be able to test this yourself by make a change with lowercase letters then accept the changes, pull the item back up and you should see the lowercase letters were converted to uppercase.

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