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

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Amit 2,559 on at

Like (0)

Report

Hi,

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

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No