Item Tracing By Timestamp

(0) Share

Report

Posted on by john.ellis

3,518

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

I have the same question (0)

All responses (8)

Answers (1)

Valentin Castravet 32,052 Super User 2026 Season 1 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

Was this reply helpful? Yes No
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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 98,498 Super User 2026 Season 1 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

Was this reply helpful? Yes No
john.ellis 3,518 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

Was this reply helpful? Yes No
john.ellis 3,518 on at

Like (0)

Report
Copy link

Link copied!

@Yun:

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

John

Was this reply helpful? Yes No
john.ellis 3,518 on at

Like (0)

Report
Copy link

Link copied!

@WhatWhyHow:

Do you know what table houses the Item Tracing data?

Thanks!

John

Was this reply helpful? Yes No
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

Was this reply helpful? Yes No
Valentin Castravet 32,052 Super User 2026 Season 1 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

Was this reply helpful? Yes No