Adjust Cost Item Entries not working

daliasetdaliaset Member Posts: 4
dear all

i am using nav 4.0 sp3. i loaded item opening balance and later , finding few entries wrongly posted, deleted the item ledger, value entry, gl entry and Rg entries. i loaded the corrected opening balance again and tried to run "adjust cost item entries" batch process. I am getting the error 'Item Ledger Entry ..... not found.
we are using FIFO costing method..

Please tell me what to do next to accomplish the successful running the batch process.

dalia set

Comments

  • MalajloMalajlo Member Posts: 294
    You should delete Item Application Entry and Value Entry also.
  • ssinglassingla Member Posts: 2,973
    Do not Delete the entries as you have done. [-X

    Delete data from Item Application Entry (Table Id: 339)
    CA Sandeep Singla
    http://ssdynamics.co.in
  • ssinglassingla Member Posts: 2,973
    If error is repeated then start the debugger and check the table in which system is looking for data.
    CA Sandeep Singla
    http://ssdynamics.co.in
  • cernstcernst Member Posts: 280
    First of all deleting entries are a very insecure method and you should make sure that you know exactly what you're doing and which entries you should delete. Deleting entries should be the last way out.
    What I can see you've not deleted any item application entries and I think thats why you get this error. A way to find out which entries are connected and which you should delete is to use the analys button on the entries form.
    _____________________
    NAV Freelance Consultant
  • darshanmdarshanm Member Posts: 280
    Namaste!

    Do always remember, If you have uploaded worng Item balances,
    then do not delete the ILE,VLE,GLE. Always pass the reverese entries
    from journal
    Darshan Mungekar
    Senior Consultan
  • ssinglassingla Member Posts: 2,973
    Do always remember, If you have uploaded worng Item balances,
    then do not delete the ILE,VLE,GLE. Always pass the reverese entries
    from journal

    To Elaborate : For value differences you can use Revaluation Journal and for quantitative diff. use positive /negative adjustment.
    CA Sandeep Singla
    http://ssdynamics.co.in
  • Alex_ChowAlex_Chow Member Posts: 5,063
    #-o. My goodness...

    My suggestion would be to wipe out the database and reload your beginning balance again with the proper dates.

    The ledgers are too sensitive to be messed around with.
Sign In or Register to comment.