Unit Cost is increased (wrong) on some items

Amit_Wandhare

Is there any wayout to reduce unit Cost calculated by system.Costing Method is "average"
Cost Batch job run.NAV Version :NAV 2009 SP1.
Value Entry & ILE all are correct.
Unit cost on 21/02/2011 is 780.
Unit cost on 22/02/2011 is 1563. ( It must be in the range of 750 to 780) but showing 1563.
how to identify the problem & is there any solution .

slmaluwa

You can revalue your stock to match the new cost.
By the way, check the item ledger. I am sure you will have one or more entries with higher cost or wrong currency.

Amit_Wandhare

Thanks for reply.
I have checked ILE.Entries are correct.
No higher Cost Entries Exist.

Is there any solution to rectify these entries?

DevendraSharma

Amit_Wandhare wrote:

Thanks for reply.
I have checked ILE.Entries are correct.
No higher Cost Entries Exist.

Is there any solution to rectify these entries?

use reapply item application entry.

Amit_Wandhare

Can u tell me in detail how to Reapply Item Application Entry.

I had never done this.

chengalasettyvsrao

Amit_Wandhare wrote:

Can u tell me in detail how to Reapply Item Application Entry.

I had never done this.

From help :

Removing an Item Application with the Application Worksheet

Open the Application Worksheet. The worksheet shows all item ledger entries.

Select the item ledger entry for which you want to change the application.

To make it easier to find the item ledger entries you need, enter filters in the filter fields at the top of the window.

When you have selected the item ledger entry, click View, Applied Entries. The Application Worksheet - Applied Entries window opens to show the item ledger entrie(s) that are currently applied to the selected entry.

Select the item ledger entry for which you want to remove the application.

Click Remove App. This removes the item application entry that links the two item ledger entries and moves it to the Item Application Entry History table.

The Remaining Quantity fields of the two item ledger entries are increased by the quantity that has been un-applied. The removed item ledger entry is now available for reapplication, either from the Application Worksheet window or from the Application Worksheet - Unapplied Entries window. See below.

Creating an Item Application with the Application Worksheet

Open the Application Worksheet.

To reapply entries removed since the worksheet was opened, select the item ledger entry that you would like to reapply and then click Functions, Reapply. This reapplication to the original balance also happens automatically when you close the Application Worksheet window.

To apply an available open item ledger entry to another entry, select the item ledger entry that you would like to apply and then click View, Entries to Apply. The Application Worksheet - Unapplied Entries window opens.

Select one or more item ledger entries that you would like to apply to the entry selected in the Application Worksheet window, and then click OK. The program creates an item application entry between the two item ledger entries. The Remaining Quantity fields of the two entries are reduced by the applied quantity.

Note: In certain rare situations, the program does not make the application that you are proposing. This is when you have unknowingly chosen to make an application that would create an infinite loop in the cost adjustment process. This is usually in cases where the original entries created negative stock. The program does not make the application, so you must select a different entry for the application.

If in the inventory setup, the Automatic Cost Adjustment field is set to Always, the program automatically runs the cost adjustment batch job after you make a reapplication. Otherwise, run the Adjust Cost - Item Entries batch job to ensure that all costs are up to date.