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

Standard cost roll up

(1) Share

Report

Posted on by Philj

I am trying to do a standard cost roll up in the standard cost worksheet and keep getting this error "the item does not exist, Identification fields and values: No.=". If anybody has any ideas it would be much appreciated. I have checked and all items have numbers

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Mustafa Omerbegović 1,473 Super User 2025 Season 2 on at

Like (2)

Report

Hello Philj,

Check the last line in the worksheet. Sometimes it can happen that a worksheet row remains created, without actually having an Item No. entered.

Do you start any action after you fill out your Standard Cost Worksheet?

Also, can you paste a call stack from the error? Maybe we will have more information based on the call stack.

Greetings

Was this reply helpful? Yes No
Philj 4 on at

Like (1)

Report

Hi Mustafa,

Thank you for your reply.

We suggest item standard cost and this is the end of the work sheet:

This is the error:

And these are the details:

If requesting support, please provide the following details to help troubleshooting:

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

AL call stack:
"Calculate Standard Cost"(CodeUnit 5812).GetItem line 8 - Base Application by Microsoft
"Calculate Standard Cost"(CodeUnit 5812).CalcAssemblyItem line 38 - Base Application by Microsoft
"Calculate Standard Cost"(CodeUnit 5812).CalcMfgItem line 44 - Base Application by Microsoft
"Calculate Standard Cost"(CodeUnit 5812).CalcItems line 24 - Base Application by Microsoft
"Roll Up Standard Cost"(Report 5854)."Item - OnPreDataItem"(Trigger) line 5 - Base Application by Microsoft

Really appreciate the assistance.

Kind regards

PHIL

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,202 Super User 2025 Season 2 on at

Like (1)

Report

you could try to roll up costs for a few items at a time to identify which one is causing the issue. Then to further looking into it.

Was this reply helpful? Yes No
Mustafa Omerbegović 1,473 Super User 2025 Season 2 on at

Like (1)

Report

Hello Phil,

I tried to get the same error as you get but I did not have any problems with the Suggest Item Standard Cost functionality.

I doubted that there was a problem with the Stockkeeping Unit of this Item, or with BOMs, but I made a suggestion of item costs with any problems with Items that are defined as BOM or with items that have a stockkeeping unit.

As Jun said, you could try to roll up costs for a few items and see what will happen.

Greetings

Was this reply helpful? Yes No