Inventory Revaluation Journal Refusing to Post

Comments

• David_Singleton Member Posts: 5,479

  2007-01-12

  Did you create the journal using the "Calc Inventory" function, or did you manually enter the lines and then select applies to ID. It looks like you have a reval applied to a transfer ship line.

  David Singleton
  

  0
• xchild Member Posts: 22

  2007-01-12

  The journal was created using the Standard Cost Worksheet function that implements cost changes.
  
  This is happening on Navision 3.7 database

  0
• David_Singleton Member Posts: 5,479

  2007-01-12

  I would suggest that step one is to try and identify which line is causing the problem. You could go through and look at the item ledger entries that are applied, or maybe its easier to try posting a line at a time until you find the error. Though you may want to do this in a test database not live.
  
  I guess you could use the debugger also, this would at least show the entry that is causing the error.
  
  I know that transfers can be a problem in revaluation. One case I know that can be a problem, is if you have purchased an item, shipped it to a customer, returned it from the customer into a temporary location, and then transfered it to the main location. AND after all that the initial invoice to the customer has not been posted. But I have only seen this happen with FIFO, and it looks like you have Standard costs.
  
  The issue seems to be that sine the sales invoice is not posted, the system does not have the costs for the return.
  
  I hope this give you a starting point.

  David Singleton
  

  0
• xchild Member Posts: 22

  2007-01-13

  Thanks for the tip.
  
  I found the item ledger entry it is trying to apply to by using the debugger.
  
  What can I find out from that item ledger entry?
  
  What can I do with it?

  0
• ecclectic Member Posts: 176

  2007-01-18

  On one item- i have the following dimension validation: item A, Dimension code: Dept, Dimension Value: Store, Value Posting: Same Code
  
  all the transactions on the item A were posted using dimension Dept: Store
  
  If there are transfers on Item A, on revaluation journal, after using calculate inventory and updating unit cost revalued, the transaction won't post. It is looking dimension Dept: Store.
  
  The problem is that the dimension is already present on the transaction line.
  
  The problems seems to arise because there have been transfers.
  
  any idea how to solve it.
  btw using Sp1
  
  EUREKA: Fixed in SP2 onwards: Codeunit 21

  0