Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Yvonne Jury]

Hello.  There seems to be a length limit on filters in a configuration package which I have managed to reach!  Is there any way around this?  We’re running NAV 2015.

——————————
Yvonne Jury
Business Systems Analyst
Scheid Family Wines
Salinas CA
——————————

[Saurav Dhyani]

Please explain what type of limit?

No. of tables in configuration package or anything else.

A screenshot will help us to reply.

——————————
Saurav Dhyani
ArcherPoint Inc.
Duluth
Blog – https://saurav-nav.blogspot.com
——————————
——————————————-

[Yvonne Jury]

I created a configuration package for the Customer table.  I want to filter out certain customers.  I can only key in 250 characters in the Field Filter.  I was wondering if there is a way to get around this limitation?

——————————
Yvonne Jury
Business Systems Analyst
Scheid Family Wines
Salinas CA
——————————
——————————————-

[Jason Wilder]

That is the field length limitation in NAV and there is no way around it without a mod.  I did notice you have some ‘ in your filter.  Those are not required and can be removed.  This will give you some more characters to enter.

The easiest way around this if you go the mod route, is to add a field to the Customer table called “Skip in RapidStart” or something like that.  Then you can use that field to filter in your rapidstart package.

——————————
Jason Wilder
Senior Application Developer
Stonewall Kitchen
York ME
——————————
——————————————-

[Lewis Rosenberg]

?…and without a mod, maybe the customers you want to exclude have something in common that you can filter on, i.e. Gen. Business Posting Group, Customer Posting Group, etc.  or maybe you can (temporarily) use an existing field like Search Name, Home Page, E-Mail, etc.  (make sure you select a field that will not have any affect on normal operations).

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA
———————————————–
BCUG/NAVUG All-Star
BCUG/NAVUG Board of Advisors, Chairperson
BCUG/NAVUG Programming Committee

Twitter: @RosenbergL
LinkedIn: https://www.linkedin.com/in/rosenbergl/
——————————
——————————————-

[Erik Beissel]

A more efficient filter when filtering to multiple item codes or customer numbers is the | symbol. This will eliminate the &<> from your filter. As you can see below this returned just the two item record listed. 

One other thing to keep in mind is that you can eliminate the customer no filter push all of the customer records into the RST workbook. Then working in Excel you can remove the records you do not want to update.  

——————————
Erik Beissel
Purchasing / Product Management
Veloci Performance Products, Inc.
Savage MN
——————————
——————————————-

[Geovanny Fuentes]

What are you trying to do?
New company setup?

If so you should filter your data before export or import.

This way you are not playing with 100% of data you do not wish to import.
Or

Split your data in parts after you sort them (Excel). This way you are importing just those with limited filters being used.

Good luck.

——————————
Geovanny Fuentes
San Diego CA
——————————
——————————————-