23
When you move the mouse cursor over a table, you will see all primary key fields, but they are not always in that order of Field Nos. E.g. "Stockkeeping Unit" table

Move over details of table in AL, fields are sorted by Field No.:
(local) SKU: Record "Stockkeeping Unit"
"Item No." * Code[20]
"Variant Code" * Code[10]
"Location Code" * Code[10]
Description Text[100]
[..]

But the primary key of "Stockkeeping Unit is "Location Code", "Item No.", "Variant Code" and a SKU.Get("Item No.", "Variant Code", "Location Code") does not work.
Category: Development
STATUS DETAILS
Planned
2022 Release Wave 2
Ideas Administrator

Thank you for this suggestion! We are supporting this in 2022 release wave 2, see duplicate idea https://experience.dynamics.com/ideas/idea/?ideaid=f88fb471-6507-ea11-b864-0003ff68ac6b

Best regards,
Business Central Team

Comments

D

I think this is a duplicate of https://experience.dynamics.com/ideas/idea/?ideaid=f88fb471-6507-ea11-b864-0003ff68ac6b

Category: Development