change field length

AndersW

Hi,

We are considering changing the field length of the customer name field in the customer table. As I understand it's limited to 40 chars, we would like it to be (at least) 60 chars.

I guess it wouldn't be enough just to change the field property?
How severe would the result be in forms, reports etc?
How much work can we exepect?

Thanks, Anders

Dave_Cox

I would not Advise this change but it is possible with some work!

You will need to also change the following.
Table: Ship to Address Field: Customer Name

Tables: Sales Shipment Header, Sales Invoice Header, Sales Credit Memo Header
Fields: Sell-to Customer, Bill-to Customer Ship-to Customer Names

Reports use Address Arrays of 80 chars so this will not be a problem

Most of the forms will also be OK apart from the journals which use a variable AccName which is set at 30 chars these will need changing.

Code unit GenJournalManagment function to get the Account Names is also set to pass size 30 this will have to be Changed.

If you Change to over 50 then you will need to change the Customer section on the FormatAddress CodeUnit (set at 50)

Any Code you have written that passes the Customer Name to a variable will have to be checked!

The only other issue! is it nessesary? most Companies change the data to suit Navision which makes upgrades easier, remember there is "Name 2" (Text 30 this will make your 60!) system wide you just need to drop it on the forms why not use this?.



[This message has been edited by Dave Cox (edited 16-02-2001).]