Options

Unit Cost is increased (wrong) on some items

Amit_WandhareAmit_Wandhare Member Posts: 4
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 .

Comments

  • Options
    slmaluwaslmaluwa Member Posts: 360
    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.
    "A bove maiore discit arare minor"-"From the old ox, the young one learns to plow."
  • Options
    Amit_WandhareAmit_Wandhare Member Posts: 4
    Thanks for reply.
    I have checked ILE.Entries are correct.
    No higher Cost Entries Exist.

    Is there any solution to rectify these entries?
  • Options
    DevendraSharmaDevendraSharma Member Posts: 23
    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.
  • Options
    Amit_WandhareAmit_Wandhare Member Posts: 4
    Can u tell me in detail how to Reapply Item Application Entry.

    I had never done this.
  • Options
    chengalasettyvsraochengalasettyvsrao Member Posts: 711
    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.
Sign In or Register to comment.