Adjust Cost Item problem

vasam

Hi,

When we try to 'Adjust Cost - Item Entry' we are getting the following error:
'Another user has modified the record for this Avg. Cost Adjmt. Entry Point after you received it from the database ...'

Error always occurs for single Item No. but for different Entry No.
The table 'Avg_ Cost Adjmt_ Entry Point' is empty.

We have found the solution (with LOCKTABLE) for Navision 3.7, but the same could not be applied to Navision 4.0, because the procedure is different.

We have started test database where we are the only user, and then started the adjustment, but yet no result.

We are using Navision 4.0 SP2.

Dave_Cintron

This absolutely should not happen, so:
= Are you running this while users are posting?
= Did anyone modify the Adjust Costs report or Inventory Adjustment codeunit?
= Has anyone gone in and deleted entries from the Avg. Cost Adjmt. Entry Point table?

vasam

Hi,

We have solved this issue.
The problem was in the "Item Ledger Entry" table, field "Applied Entry to Adjust". It was set to 1 which means that the item must be adjusted, but the item was allready shipped, but not invoiced.
We updated this field to 0, run the adjustment procedure and everything is ok now.

thank you all