Record Size Error while adding new fields to Sales Header.

nrapendra

Hi All,

I have a typical problem.

When we make sales order we have to define so many remarks
and details about the order.I have created fields for all of them.
when I go to save the table it shows message that

"The active fields in a record may not take up 4000 bytes.The active fields in sales header take up 4238 bytes.you must reduce either the number or the length of active fields."


what should i do now??

DenSter

That means that you have reached the maximum record size. There's a whole article about that in the application designer guide (w1w1adg.pdf in the Doc folder on the product CD), but basically that means that you have to either disable fields that are not used, or decrease the field size of the additional fields.

You could also create a new table with a one-to-one relationship and link that to the sales header. I don't like that solution though, it brings a lot of headaches with it.

Also consider normalizing some of the additinal fields into separate tables.

nrapendra

hi all,
this is really a bad condition.
pls suggest how to get rid of this problem.
i am helpless ??

ajhvdb

nrapendra wrote:

hi all,
this is really a bad condition.
pls suggest how to get rid of this problem.
i am helpless ??

Please read Daniel's suggestions before complaining.