Skip to content
+1-888-319-3663

COMMUNITY FORUM

Business Central and using the System ID

Joerg asked 1 year ago
Business Central has since v15 a new field “System ID” which represents the unique identifier of the record and is a GUID. I created a new API page to use this System ID. Important is to set Editable = true; in the page, otherwise you will receive an error message when using the Web Service.
In this instance I made a Customer Card page and set the AccountID of CE to System ID in BC. However, the new record in BC is not set to the same GUID as the Account. The question is why?
Has anyone used the System ID and can share your experience?
Answers
Joerg Rau answered 1 year ago
I worked it out now. If you add an OnInsertRecord trigger to your page then the SystemID will be set and you can achieve your pairing. Even renames of a Code (PK) field worked fine then.

trigger OnInsertRecord(BelowxRec: Boolean)Boolean
    begin
        Insert(true, true);
        Exit(false);
    end;
Ethan Sorenson Staff replied 1 year ago

Joerg,

Thanks for following up on this. That is a useful trick to note. We may have to write a blog about this topic in case other users are looking to do this. Another approach would be to add a custom GUID field to the existing Customer Table/Page. Map the unique identifier from CE to BC in that field. Then use that as your destination grouping so it is used as the key by SmartConnect.


If you would like to submit an answer or comment, please sign in to the eOne portal.