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)

Sort by

Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Like (0)

Report
Copy link

Link copied!

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