Item Tracing By Timestamp

(0) Share

Report

Posted on by john.ellis

3,534

Hi:

Is it possible to generate a report on item tracking of lot or serial numbers by time of day (i.e., timestamp)?

If not, is such data held in a table where it can be reported on within Power BI?

Thanks!

John

All responses (8)

Answers (1)

Sort by

Valentin Castravet 32,808 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

not a report but take a look at the Item Tracing Page - it achieves what you are looking for. It also has a Created On field. If thats not enough you could also just add the 'SystemCreatedAt' field to the page
Suggested answer

CU11121527-0 4 on at

Like (1)

Report
Copy link

Link copied!

Try reading this article from Microsoft on "System Fields". Every table in BC has these fields, since you are using Power BI you maybe able to access them.

Here is the link

Good Luck
Suggested answer

YUN ZHU 103,807 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, just adding some info in BC21.

More details:

https://yzhums.com/29936/

Hope this helps as well.

Thanks.

ZHU
john.ellis 3,534 on at

Like (0)

Report
Copy link

Link copied!

@Valentin:

Thank you. But, the "Created on" field does not offer the time of day. And, I do not see the "SystemCreatedAt" field to be added.

John
john.ellis 3,534 on at

Like (0)

Report
Copy link

Link copied!

@Yun:

Thank you! How would I use this to access timestamps?

John
john.ellis 3,534 on at

Like (0)

Report
Copy link

Link copied!

@WhatWhyHow:

Do you know what table houses the Item Tracing data?

Thanks!

John
Verified answer

CU11121527-0 4 on at

Like (2)

Report
Copy link

Link copied!

[quote user="john.ellis"]
@WhatWhyHow:

Do you know what table houses the Item Tracing data?

Thanks!

John
[/quote]
On the issue of timestamp

Assuming, you are NOT using on-prem BC in order for you to access information from BC cloud via PowerBI you will need to custom create an API in BC and expose those systemfields and any other fields.

On the issue of Item Tracing tables

Try the following tables
338 = Entry Summary
6501 = Item Ledger Entries

They both hold Serial and Lot information

Good Luck
Valentin Castravet 32,808 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

[quote user="john.ellis"]
@Valentin:

Thank you. But, the "Created on" field does not offer the time of day. And, I do not see the "SystemCreatedAt" field to be added.

John
[/quote]
you can get a developer to add the field to the page as it exists in the table, its not a field thats available to be added to the page by a user out of the box