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

The Item does not exist. Identification fields and values: No.=''

(6) Share

Report

Posted on by O3I

Hi BC Guru's,

I get an error on the Standard Cost Worksheet when I try to Roll Up Standard Cost for Assemblies.

The Item does not exist. Identification fields and values: No.=''

I checked my Item List and found no items without any no. I also checked my Item Config Package Table to see if there were any blank items but none were found.

Not sure what else is triggering this problem.

Any help is very appreciated!

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

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

Like (3)

Report

Hi, is there a blank line without the Item No?

Additionally, If this were in the Sandbox, you can use the debugger and check from where this error is.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
KH-10111904-0 6 on at

Like (2)

Report

We discovered that an old BOM version had a blank line which caused the error.

It wasn't even the active BOM version.

Suggest looking at all BOM versions for the part and searching for a blank line.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,495 Super User 2025 Season 2 on at

Like (4)

Report

As KH-10111904-0 mentioned there must be a line somewhere where the No. field is empty. It would not be in the Item list, try looking at all your assembly boms.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

Gregory Mavrogeorgis 786 on at

Like (3)

Report
Hi

Check the Standard Cost Worksheet
Open it, then filter the No. field to '' (blank).
If you see any lines (especially where Type = Item), either fill in the missing item number or delete those lines.

Check Assembly BOMs
Go to Assembly BOMs → Lines.
Set filters:

Type = Item

No. = ''
If any lines appear, fix or remove them.
Repeat for Assembly BOM Versions if you use them.

heck Production BOMs (if used)
Do the same filters: Type = Item, No. = '', and clean up blanks.
Check Production BOM Versions too.

Other Possible Causes

A subassembly might have a missing or deleted item on its BOM.

A deleted item may still exist as a blank reference.

Data imported via Excel/config packages sometimes adds hidden blank lines.

If you found this helpful please mark it as verified

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 6,375 on at

Like (1)

Report

Hello,

The error means the Standard Cost Roll-Up is hitting a blank or invalid Item No. in an assembly/BOM.

Fix:

Check all Assembly BOM lines, ensure every line has a valid Item No. and Quantity.

Remove or correct any blank BOM components.

Recreate the Standard Cost Worksheet and rerun the roll-up.

Regards,
Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (1)

Report

Hello,

This error usually means the Standard Cost Worksheet or an assembly BOM contains a reference to an item with a blank Item No., even if your Item List looks fine.

Common causes include hidden blank lines in the worksheet, incomplete BOM components, or leftover records from imports/config packages.

To fix it, review the worksheet for empty Item No. rows, check all BOMs for missing components, and remove any invalid references before rerunning the roll-up process.

May this can help : https://archerpoint.com/how-to-use-the-configuration-package-to-update-standard-cost-business-central-nav/

1 people found this reply helpful.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,373 Most Valuable Professional on at

Like (0)

Report

Hi

You can get more details about the error; we could review it and see where it's coming from. There's probably some development involved.

B

Share error details to get help from another user | Microsoft Learn

best

GR

Was this reply helpful? Yes No