Small and medium business | Business Central, N...

Field Filter character limit in config package

(1) Share

Report

Posted on by ZK-23072051-0

Hello!

My inventory is currently individually serialized (example barcode 15001,15002,15003, etc.). I would like to export the data via configuration package based on a list of specific numbers, however the field filter character limit is too limiting for this task. It currently can accept about 28 barcodes, however I often need many more in the export (500, 1000, or more).

Is it possible to use an external list in tandem with the field filter so that I can export my needs beyond the character limit? Thanks so much!

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (1)

Report

Field Filter character limit in config package

If you don't want to customize it, you can only export all the data, and then combine, filter and process it outside the system.

Hope this can give you some hints.

Thanks.

ZHU
Suggested answer

Valentin Castravet 24,910 Super User 2024 Season 2 on at

Like (0)

Report

Field Filter character limit in config package

No it's not possible. Is there another field you can filter on? Something like the item category, item posting group etc.? Or you can export all your items and do the filter in excel.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/
gdrenteria 12,290 Most Valuable Professional on at

Like (1)

Report

Field Filter character limit in config package

Hi

You could rely on other ways to export information

Dynamics 365 Business Central: How to export data from tables to CSV (comma-separated values) file | Dynamics 365 Lab (yzhums.com)

Dynamics 365 Business Central and large data export to Excel via Power Automate: use Graph API. – Stefano Demiliani

Best

GR