Serial number Table for my SKU

(1) Share

Report

Posted on by HzJ

Hello,

Most of my products are SNALL (Serial number enabled) and I need to get quick reports based on serial number search in POWERBI.

Can someone assist me in finding the name of the TABLE in business central that has the List of all Serial Numbers of my inventory. So i can connect it to PBI

Thanks.

Huzefa

All responses (2)

Answers (0)

Suggested answer

Amit_Sharma 2,545 on at

Like (0)

Report

RE: Serial number Table for my SKU

Hi,

Item Ledger Entry--> Table No. 32 and Field name is "Serial No.".

Regards

Amit Sharma

www.erpconsultors.com
Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

RE: Serial number Table for my SKU

Look in table 32. Item ledger Entry table. You will find serial no. there for all your inventory transactions.