Lot No. field not in value entry table but allowed as filter.

(2) Share

Report

Posted on by TM-17111134-0

Hello all,

After a request of a customer for a report with specific lot filtering I stubbled upon this following situation.

The current Version of the Base Application is 26.5 and I found the exact same behavior in the 27.0

I was able to filter the Value Entries table with lot no of my choosing.

Example:

But when I tried to replicate this in my reporting logic and I found out that Lot No. is actually not a field in the Value Entry Table (5802). I aslo checked the page Value Entries (5802) and still there wasn't a lot no field there. I checked the filtering I did through the UI and it was correct. I know how to get around this, by using a get method on the Item ledger Entry table with the Item Ledger Entry No. field that I have in value entries.

My question still remains though. How is this possible? How can I filter a table with a field that it's not precent on the table and actually get correct results? Is it a bug? Is it a feature? If it's a feature how is it done? I would really like to replicate it. Any thoughts?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Teagen Boll 427 on at

Like (2)

Report

Lot No. field not in value entry table but allowed as filter.

You would have to filter the Value Entries table on the Item Ledger Entry "Entry No." field or the reverse of that like you've already done. That's the only way to link them. I usually pull this data to power BI or other reporting tools and build a report that way instead.

Was this reply helpful? Yes No
Suggested answer

Aman Kakkar 1,581 on at

Like (1)

Report
Lot No. field not in value entry table but allowed as filter.

Hi @TM-17111134-0,

You’re absolutely right — you normally cannot filter on a field that doesn’t exist in the underlying table. Since Lot No. is not part of the standard Value Entry (5802) table, filtering on it should not be possible unless something else is extending the table.

If Lot No. is filterable and working correctly, then the field must come from:

A custom table extension

A partner/ISV app

A localization extension

Please check whether you have any custom extensions or ISV/third-party apps installed that may extend table 5802 with a Lot No. field.

Hope this helps.

Aman K

Was this reply helpful? Yes No

Join the conversation

Community site session details

Lot No. field not in value entry table but allowed as filter.

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Lot No. field not in value entry table but allowed as filter.

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates