Hi, good day
I hope this can help you, and give you some hints.
Dynamics 365 Business Central: How to get a record by its SystemId | Dynamics 365 Lab
Best Regards
Gerardo
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,235 Most Valuable Professional
nmaenpaa 101,156