3,482
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
@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
@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
@WhatWhyHow:
Do you know what table houses the Item Tracing data?
Thanks!
John
@Yun:
Thank you! How would I use this to access timestamps?
John
@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
Hi, just adding some info in BC21.
More details:
Hope this helps as well.
Thanks.
ZHU
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (