Small and medium business | Business Central, N...

Where can I find the Serial number field when using Power BI in Posted Item Tracking?

(0) Share

Report

Posted on by Sensus-Paul

Hello All,

This is the first-time post here. We are newer to Business Central and have recently set up and have been using BC, and I'd like to pull the data using Power BI. My issue is I can't seem to find the Serial number field in the tables when in Power BI. Does anyone know what table I can find this information in?

Posted Item Tracking Lines is where the serial numbers have been recorded on the Posted Sales Invoice.

Any help would be appreciated.

Thanks

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

TWBlaisdell on at

Like (1)

Report

Hello

Thank you for posting on the Forum. The Serial No. posting would be stored in Table 32 - Item Ledger Entries Table.

I hope this helps.

Best Regards,
Tom

Was this reply helpful? Yes No
Suggested answer

Tabrez Ajaz 785 on at

Like (1)

Report

Hi Paul,

Welcome to the dynamics community forum. The Serial No. including Lot No., expiration date and other posting information is stored in the "32 - Item Ledger Entry" table.

Was this reply helpful? Yes No
Sensus-Paul 5 on at

Like (0)

Report

Hello Tom,

Thank you for the answer, It seems I was able to find it hours later after my post. Thank you for helping.

Was this reply helpful? Yes No
Shani Dobariya 5 on at

Like (0)

Report

Hi How did you find it?

I am not seeing the Serial No., Lot No. columns available in itemLeadgerEntried while using API v2.0 in PowerBI

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

That's where they reside....your query must not have them.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

Hi, The standard API v2.0 may not contain all the fields you need. But since the API page cannot be extended, if you really need it, you need to customize your own API page. Or using Web Service is also possible, but the performance is not as good as using API.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No