Finance | Project Operations, Human Resources, ...

How to filter the products which have barcode hold up to 20 characters

(0) Share

Report

Posted on by ZS-04101531-0

Hello everyone, currently we are working on Zebra label printer to printing some barcode labels, is there a way to filter the Released Products which have the barcode up to 20 characters from D365 F&O? Thank you.

All responses (2)

Answers (0)

ZS-04101531-0 65 on at

Like (0)

Report

How to filter the products which have barcode hold up to 20 characters

Thank you Andre, I do not have access to "+Add table join" which grayed out there, let me check where I can add it. I am a system admin.
Suggested answer

André Arnaud de Cal... 292,884 Super User 2025 Season 1 on at

Like (0)

Report

How to filter the products which have barcode hold up to 20 characters

Hi James,

It is possible to use the advanced query form and add a table join to the item - barcode table. Then you have all released products containing a barcode. If you need up to 20 characters, then you would need to set an additional field range for the barcode field in that query. Maybe the query value '0..9999999999999999999' will work. Otherwise, you can set a range using the question mark, like '?,??,???,????,?????, ... ,????????????????????'

You can read more about the advanced query on my blog: Advanced search to find records in Microsoft Dynamics 365 Finance and Operations - Dynamicspedia