Posted Sales Invoice

(0) Share

Report

Posted on by LiamSc

Hi,

I am trying to get my PowerBI to pull through the systemcreatedat date/time into a report for Posted Sales Invoices.

Is there a page where this is stored or any way of getting this out? We currently have a filter on posted date but miss stuff if someone backdates a posting.

Thanks in advance.

Categories:

Integration to Power BI, Power Apps, Power Automate and Dataverse

All responses (3)

Answers (0)

LiamSc 21 on at

Like (0)

Report

Posted Sales Invoice

Which page does this exist on to add to the web services page so i can pick this up on PowerBI

Suggested answer

YUN ZHU

68,242 Super User 2024 Season 2 on at

Like (0)

Report

Posted Sales Invoice

Hi, as Shauna mentioned, you can use Data audit fields

More details:

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-table-system-fields?wt.mc_id=DX-MVP-5004336#audit

APPLIES TO: Business Central 2020 release wave 2 and later

Every table in Business Central includes the following four system fields, which can be used for auditing records:

Field name (in AL)	Column name (in database)	Data type	Field number	Description
SystemCreatedAt	$systemCreatedAt	DateTime	2000000001	Specifies the data and time that the record was created.
SystemCreatedBy	$systemCreatedBy	GUID	2000000002	Specifies security ID (SID) of the user that created the record.
SystemModifiedAt	$systemModifiedAt	DateTime	2000000003	Specifies the data and time that the record was last modified.
SystemModifiedBy	$systemModifiedBy	GUID	2000000004	Specifies the SID of the user that last modified the record

Hope this helps as well.

Thanks.

ZHU

Suggested answer

Shauna Langley 612 Super User 2024 Season 2 on at

Like (0)

Report

Posted Sales Invoice

Hi,

Depending on the version you are currently on there should be the following field.

That should be what you are looking for.

Thanks,

Shauna