I have used Migration FOBs for migrating native database to SQL Server 2005 and it done successfully.
Now, as per my client's requirement we have added too many fields in Purchase Header table.
Now, the client wants us to increase the length of those fields, but when I do that I got error like this:
A record may contain maximum of 4000 bytes of active fields in it.
So it doesnt allow me to increase the length. I know I can deactive a few fields by removing tick from enable field. But I dont want to do that.
I tried to change the length from SQL Server and made it of 250 (Varchar) whereas the NAV database contains that field as Text(30).
So when I run the purchase order form, I got the error that SQL Datatype is not compatible with NAV Datatype....
Is there any solution for this senario>>????
Thanks and Regards...
Kashyap
Thanks,
Kashyap
0
Comments
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
Kashyap
This doesn't mean they need to be in the same table.
If I am making a purchase order (import-outside country) and they want a few fields then in which table I can put those fields...????
Kashyap