Error: "You cannot change costing method because there are one or more ledger entries for this item."

(0) Share

Report

Posted on by Community Member

Hi,

I am using NAV 2013. I was trying to use Configuration Package tool to update some Item Unit Price.

I imported the template but it shows me error. For each uploaded record, it says "You cannot change Costing Method because there are one or more ledger entries for this item."

But, we didn't change the Costing Method.

Can someone help?

Thanks

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

The error says that you are trying to change costing method of that item which is already having open item ledger entries.

Check your package

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Amol, thanks! Can you tell me more details?

I am not quite understand " Item is already having open item ledger entries".

Which package or part should I check?

Thank you!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Amol,

I was trying to update Item Unit Price, and the package only contains two fields: Item No. and Unit Price. How does the imported data change the costing method?

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

Where you are updating the unit price .is it in item table or some other table

As well as which costing method you are using?

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (0)

Report

Dear Allen C ,

Costing method is a parameter

locate on your item card when you create the Item on First time this parameter will be set to to item

You cannot be change it for any reason : if you having even one single record on Ledger entries for relevant entries

If you need to change it you have to remove whole ledger entries , but i don't think this a good idea to remove ledger entries

check your importing data to : (Item Table)

Was this reply helpful? Yes No
ManishS 86 on at

Like (0)

Report

The package you are trying to use is renaming the No. field, hence this error.

The package you are using is to update or insert items, please check.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

It's Item Table. The Costing Method is FIFO.

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (0)

Report

If you already had posted item entries for that particular item, you would not be able to modify the costing method. Most likely you are trying to import the data in such a way that you modify the item card no and thus it activates the trigger of validation if the item entries exist.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,600 Super User 2025 Season 2 on at

Like (0)

Report

Yes I completely agrees what Alexander says, Ideally what the code is trying to do is not possible if you have ledger entries in the Database. You need to cross verify what exactly you trying to achieve and somehow it's not trying to disturb the standard NAV business processes.

Was this reply helpful? Yes No
Suggested answer

Azqar 52 on at

Like (1)

Report

For learning purposes you can create a duplicate item and change the costing method. You can only select the costing method when you create the item and if you have made any transactions then you can't change the costing method . That means if the item is live you need to select the costing method before you start your transactions ( sales, purchase orders etc) when you made an item.

for more info https://learn.microsoft.com/en-gb/dynamics365/business-central/design-details-costing-methods

Was this reply helpful? Yes No