News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Difference Between &qu...

Small and medium business | Business Central, N...

Suggested answer

Difference Between "ID" and "System ID" on Sales Invoice Header

(0) Share

Report

Report

Posted on by Hein Kruger

505

Hi,
A client asked me the difference between the System ID and ID field in the Posted Sales Invoice Header.

The ID is always "Blank".

I'm assuming the System ID is Business Centrals ID and the ID field is related to the Database ID.

Question: What is the difference between the two field? How can I populate the ID field to get values from an API?

Categories:

Dynamics 365 Business Central

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Mohana Yadav 59,194 Super User 2024 Season 2 on at

Like (0)

Report

Difference Between "ID" and "System ID" on Sales Invoice Header

AFAIK, ID field was introduced for APIs/integration GUIDs in some tables but later on, MS implemented platform level field System ID which is available for all tables.
SeGra 44 on at

Like (0)

Report

RE: Difference Between "ID" and "System ID" on Sales Invoice Header

Update:

The ID Field seems to be obsolete. It was replaced by the SystemID.
SeGra 44 on at

Like (0)

Report

RE: Difference Between "ID" and "System ID" on Sales Invoice Header

Hi,

the Field System-ID is - along with other System fields like Created at - part of any table by default without the need for development.

The System-ID gets populated in the OnInsert-Trigger of a table.

The ID field on the other hand might be specific to a certain use case like syncing with CRM.

The table Payment Terms (3) has this Field as well i believe.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans