Hi, I read Navision inventory costing manual. Isome doubts on this process. I would like to thorw in mibuso. So experts please throw u r advise. I created one item. I purchased this item 3 times with different date and different cost. I selected Fifo costing method for this item. Item rate qty date A 10 1 12/22/07 A 15 1 12/23/07 A 5 1 12/24/07 So when I sold this item on 12/26/07 it is taking average cost at first. When run Adjust item cost entries , then it is taking fifo cost on this of 12/22/07. What my doubt is why Navision doesnot work according to fifo method at first. When AD. Item cost entries it is working according to FIFo. Please throw u r valuable solutions.
How would you expect it to cost a sale that drove inventory negative? Should it pos zero cost?
The FIFO cost of the item is not known at the point of sale "unless" you are using specific costing or serial numbers, this is because there is no DIRECT link between the sale item and the inventory. At the point of sale what IS known is the average cost as this is a calculated field and therefore Navision uses the average cost as an initial cost. The adjust cost item routine then analyses the unadjusted costs and back calculates the TRUE cost of the item. I thin kyou can get this to adjust at the point of posting in 4 (?) onwards depending upon your settings. Ultimately it is how they wrote it!
The art of teaching is clarity and the art of learning is to listen
Don't forget to VERIFY the post(s) that solved your problem. This credits the experts who helped, earns you points and marks your thread as Resolved so we all know you have been helped.