Record Size Error while adding new fields to Sales Header.

nrapendranrapendra Member Posts: 208
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??
Nrapendra Singh
(Sr. Tech. Consultant)
Dataman Computer Systems (P) Ltd.
web :www.datamannet.com
mail :[email protected]

Comments

  • DenSterDenSter Member Posts: 8,304
    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.
  • nrapendranrapendra Member Posts: 208
    hi all,
    this is really a bad condition.
    pls suggest how to get rid of this problem.
    i am helpless ??
    Nrapendra Singh
    (Sr. Tech. Consultant)
    Dataman Computer Systems (P) Ltd.
    web :www.datamannet.com
    mail :[email protected]
  • ajhvdbajhvdb Member Posts: 672
    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.
Sign In or Register to comment.