# Active fields limit error

**URL:** <https://www.dynamicsuser.net/t/active-fields-limit-error/9566>\
**Category:** Developers Forum\
**Created:** [January 12, 2005, 2:50pm UTC](https://www.dynamicsuser.net/t/active-fields-limit-error/9566 "2005-01-12T14:50:55Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![jrpucla](https://avatars.discourse-cdn.com/v4/letter/j/5fc32e/32.png) [@jrpucla](https://www.dynamicsuser.net/u/jrpucla)\
**Post date:** [January 12, 2005, 2:50pm UTC](https://www.dynamicsuser.net/t/active-fields-limit-error/9566/1 "2005-01-12T14:50:55Z")

</div>

Long time lurker first time poster. We are running 3.7 native. The Sales Header table is extremely slow. When I run the table in object designer a record appears about once every second maybe a little longer. I have 6 flow fields set up that I thought might be causing a problem. In our test db, I made the flow fields normal fields and I received an error saying the active fields size exceeded 4000 kb. The table ran a little faster but I don’t know if that was because of the flow fields or getting the active fields size below 4000. Here are a list of the flow fields and their respective keys. Maybe you can see something I am missing. Sum(“Sales Line”.“Line Amount” WHERE (Document Type=FIELD(Document Type),Document No.=FIELD(No.),BOM Item No.=FILTER(=’’))) Document Type,Document No.,BOM Item No. - SIF=Line AMount Sum(“Sales Line”.“Calculated Price” WHERE (Document Type=FIELD(Document Type),Document No.=FIELD(No.),Use Margin in Discount=CONST(Yes),Calculated Price=FILTER(\<\>0),Special Discount ($)=FILTER(=0))) Document Type,Document No.,Use Margin in Discount,Calculated Price,Special Discount ($) - SIF= Calculated Price Sum(“Sales Line”.“Calculated Price” WHERE (Document Type=FIELD(Document Type),Document No.=FIELD(No.),Use Margin in Discount=CONST(No),Calculated Price=FILTER(\<\>0),Gross Profit Margin (%)=FILTER(\<11))) Document Type,Document No.,Use Margin in Discount,Calculated Price,Gross Profit Margin (%) - SIF = Calculated Price Sum(“Sales Line”.“Special Discount ($)” WHERE (Document Type=FIELD(Document Type),Document No.=FIELD(No.),BOM Item No.=FILTER(=’’),Special Discount ($)=FILTER(\<\>0),Quantity=FILTER(\>0))) Document Type,Document No.,BOM Item No.,Special Discount ($),Quantity - SIF = SPecial Discount ($) Sum(“Sales Line”.“Warranty ($)” WHERE (Document Type=FIELD(Document Type),Document No.=FIELD(No.),BOM Item No.=FILTER(=’’),Warranty ($)=FILTER(\<\>0),Quantity=FILTER(\>0))) Document Type,Document No.,BOM Item No.,Warranty ($),Quantity - SIF=Warranty ($) Sum(“Sales Line”.“Calculated Price” WHERE (Document Type=FIELD(Document Type),Document No.=FIELD(No.),Use Margin in Discount=CONST(Yes),Calculated Price=FILTER(\<\>0),Special Discount ($)=FILTER(\<\>0))) Document Type,Document No.,Use Margin in Discount,Calculated Price,Special Discount ($) - SIF = Calculated Price Am I going to have to deactivate or get rid of some fields in the Sales Header table. Is that causing the slowdown? Any help is appreciated.