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

All responses (4)

Answers (0)

Sort by

Mustafa Omerbegović 1,481 Moderator on at

Like (2)

Report
Copy link

Link copied!

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
Philj 4 on at

Like (1)

Report
Copy link

Link copied!

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
Suggested answer

Jun Wang 8,220 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.
Mustafa Omerbegović 1,481 Moderator on at

Like (1)

Report
Copy link

Link copied!

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