485
We need to populate the said fields with more than 30 characters. What's the safest way to do it? Would there be other tables that will be affected by the change?
Thank you.
*This post is locked for comments
As mentioned above the problem is that when you modify the description on the item card it affects many other tables, reports and variables in the system
If you miss updating any of them then when the system tries to fit the bigger text string into that smaller variable it will fail with an error
You have several possibilities,
Add a description 3 field, this will not be used anywhere so you can add it where needed with up to the maximum length, you could possibly hide description 2 and "replace" it with this one on the item card, that way they only see the main description and description 3
Rather use dimension to categorize the items, instead of a longer description, the positive spin off is that you can then report on those dimensions
Last option is to customize the description 2, but brace yourself for a huge amount of work and a pretty broken system until you find all the spots that it is used
Cheers
Nev
I agree that an extra field is probably the better option. EDI may also be a consideration; there's no point increasing field lengths if your EDI partners can only accept 30 characters.
In my case, our product range includes several finishes; chrome, antique gold, etc. So I've added an option group for that, which will be useful for filtering.
as well as reports & variables:
Why not add a description 3 if 1 & 2 are not enough.
You probably need it in just a few places so adding a new field is easier than changing the fields that are there everywhere in the system.
see discussion here:
www.mibuso.com/.../viewtopic.php
for us we combine them description+' '+"Description 2" to get 60 chars
I made that on my database. This is troublesome job. You hav many tables with item description:
Item
Item Translation
Item Ledger Entry
Sales Line
Purchase Line
Value Entry
Item Budget Entry
Sales Shipment Line
Sales Invoice Line
Sales Cr.Memo Line
Purch. Rcpt. Line
Purch. Inv. Line
Purch. Cr. Memo Line
Production Order
Production Order
...
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (