Item Tracing By Timestamp

(0) Share

Report

Posted on by john.ellis

3,510

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 31,485 Super User 2025 Season 2 on at

Like (0)

Report

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

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 95,748 Super User 2025 Season 2 on at

Like (0)

Report

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,510 on at

Like (0)

Report

@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,510 on at

Like (0)

Report

@Yun:

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

John

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

Like (0)

Report

@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

[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 31,485 Super User 2025 Season 2 on at

Like (0)

Report

[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