hai our navision user want to one of the field to be lengthen
External Document No. in Sales Header (Type : Code,Length 20)
I want to change data type External Document No. From Code 20 to be Code 30
So what other fields that should I change ?
I already change field External Document No. in table Sales header, Sales Shipment No., Sales Invoice No., Sales Credit Memo Header
do you think it’s a better idea if i change data type like this?
i mean lengthen data type
Hello Stan,
i don’t know in which fields / tables you have to lengthen the fields but you can determine with the Development Toolkit the detailed usage of each object, function and field of a table.
Hi Stan,
I think it is best to tell the Navision user that 20 characters is the limit, and that he has to live with that. [:)]
And remember to do a Microsoft-dialogue…
(“Are you sure?”, “Yes”, “Are You sure You’re sure?”)
If You have to do the modification, You must also remember to modify the entry-tables, as the “Ext. Doc. No.” are also copied to these tables.
Not just tables 36, 110, 112 and 114 are involved here.
Also remember to document it well, in relation to future updates.
You can also consider to create a new field in table 36, for the user to fll in, and then OnValidate-trigger of this new field, fill in the standard-field.
But this leads to some issues making sure that You always fill it with a unique value.
Development Tool Kit?
which one is it?
where can i Download it?
maybe I need something if i change in one table then it must be like a trigger for the other tables which are have relation
like if we change Customer No. in Customer Table , so that in other table will be changed
This is bad mistake. Don’t change the length of Navision fields.
External document it’s a widely used field in Navision don’t change length, add a field and copy that field to tables.
You can download developer toolkit from download section.
Ok, Thanx a lot all of you… I cancel to change length data type
Good to hear.
can you also mark the qustion as answered. Thanks.