Item Description Field

I noticed that this field is 30 chars long in the table.

Can we just change the field to 40 chars to give us more descriptive space?

Or will that screw up the whole program?

Reply to
Mickie
Loading thread data ...

Yes, that will screw up the program. Use the Extended Description field for long descriptions. There is an option in SO Manager/File/Configuration to show the extended description. This will make Ext. Description show on the POS, but not in the item list window... Using "Find" you can search by Ext. Description though...

Glenn Adams Tiber Creek C> I noticed that this field is 30 chars long in the table.

Reply to
Glenn Adams [MVP - Retail Mgmt]

Reply to
Jorge Jimenez

The reason it is the way it is is beacause of standards, if they do make the description longer then it would simply not fit onto the slip. And None of my customers need to change description filed to more than 30 chars as they all use extended description, also this can be added to lookup if you use standard find function but there are a few add-ons that allow you to search via any field, look on

formatting link
. So if it was a real issue MS would sort it out but thanks to standards throughout the industry this will never change.

Reply to
Stephen Zwarts

There is another way to solve the problem. Use the Extended Description field.

If you think the description field should be longer, enter it as a product suggestion - there's a link at

formatting link

Glenn Adams Tiber Creek C> We would like to know whether there is another way to solve this problem or

Reply to
Glenn Adams [MVP - Retail Mgmt]

"Columbia Ptarmigan X-Shell Jacket-3XL-Flax"

Would not fit...this is a simple description that will show up as an INTERNET and price-TAG description of the product.

Also gives the customer a clear description of what they bought on their receipt.

We have to use "Ptarmigan X Shell - 3XL Fl"

huh? what the heck is that?

Why not a to the next line on the 40-col receipt?????

"it won't fit" Bull. They don't want to MAKE IT WORK.

Glenn Adams [MVP - Retail Mgmt] wrote:

Reply to
Mickie

You asked if altering the field length in the database would screw up the program. Sorry you don't like the answer. You could always just go ahead and alter the db anyway; it probably won't be too inconvenient when POS crashes...

If you want to see a change, vote for the suggestion that Jorge entered.

Glenn Adams Tiber Creek C> "Columbia Ptarmigan X-Shell Jacket-3XL-Flax"

Reply to
Glenn Adams [MVP - Retail Mgmt]

Just curious if anyone has tested this and if you did what problems did you run into? I changed the item description in the db from 30 to 80 in a test enviroment and haven't seen any issues. The POS store ops manager displays and accepts the new length. NOT that i am suggesting anyone alter thier db but we were using the extended description already for the wordy description and really needed about 50 to 80 chars to properly identity the item name for web use. Would be nice if MS could take a look at that.

Only down side I found was that you still only get 30 chars on the xml receipt. Any suggestions on how to change/refresh that schema so the entry.description will use the new length?

"Glenn Adams [MVP - Retail Mgmt]" wrote:

Reply to
bjohn

Just curious if anyone has tested this and if you did what problems did you run into? I changed the item description in the db from 30 to 80 in a test enviroment and haven't seen any issues. The POS store ops manager displays and accepts the new length. NOT that i am suggesting anyone alter thier db but we were using the extended description already for the wordy description and really needed about 50 to 80 chars to properly identity the item name for web use. Would be nice if MS could take a look at that.

Only down side I found was that you still only get 30 chars on the xml receipt. Any suggestions on how to change/refresh that schema so the entry.description will use the new length?

"Glenn Adams [MVP - Retail Mgmt]" wrote:

Reply to
CptSoft

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.