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

Shelf No. field Not available to personalise or customise on physical item journal page (page 392)

(7) Share

Report

Posted on by Adrian Ladaniwskyj ...

Hi all-

The Shelf No. Field is used for simple warehouse setups, with fixed item locations, where bins are not set up.

It's just a text field which is an attribute of item cards table (table 27)

I have tried both personalizing, and customizing (via the role page) the Physical item journal page (392) to add this field into the journal; but it is not available, unlike just about every other field on the item card.

We want to add the field to the journal so the journal lines can be sorted by shelf number, so data entry is sequential by location. i.e. Shelf A, B, C etc.

What is do different about the shelf number field that it cannot be personalized into some pages?

Is there a workaround to this which doesn't involve development?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Suresh Kulla 50,269 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

You can only add fields on the page that is available on the Page Source Table. In this case, "Item Journal Line" is the source for page 392, not table 27. If you need that field, you must first add it to the Item Journal Line table as a flow field or similar, and then add it to page 393. Unfortunately, all these require some development.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Sumit Singh 11,757 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Clarification on Personalization vs Development
🔹 Page 392 – Physical Inventory Journal

Source Table: Item Journal Line (Table 83)

Shelf No. is on Item (Table 27), not on the journal line table.

Therefore, Shelf No. cannot be personalized into Page 392 unless it exists on the source table.

Why Development Is Required
To display Shelf No. on the journal page (e.g., Page 392 or 393), you need to:

Extend Table 83 (Item Journal Line):

Add a FlowField or calculated field that pulls Shelf No. from the Item table using a Lookup.

Extend Page 392 or 393:

Add the new field to the page layout so it can be viewed and sorted.

Optional: Add sorting logic or grouping by Shelf No. if needed for data entry.

Note: This response was created in collaboration with Microsoft Copilot to ensure clarity and completeness. I hope it helps to some extent.
Mark the Answer as Verified if this is Helpful.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,084 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi, hope the following can give you some hints.

Business Central 2023 wave 2 (BC23): Add existing table fields to optimize your pages (Adding Table Fields to Page without Page Extensions)

https://yzhums.com/43183/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,169 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

The Shelf No. field is not exposed on the Physical Item Journal (Page 392) by default, which is why it doesn’t show up in personalization. It’s stored on the Item table, but since the journal line comes from Item Journal Line table, it isn’t directly available there.

Without development, there’s no standard way to bring it into the journal page. The only workaround would be to export the journal to Excel, sort by Shelf No. from the Item table, and then work with it. Otherwise, you’d need a small customization to expose that field.

✅ Mark this as the verified answer if helpful.

Was this reply helpful? Yes No