FIFO

A blog reader has asked me for help about an allegedly strange behavior of items with serial number tracking. They had a customer who had serial number tracking switched on for an item with FIFO costing method. Whenever they posted a sales transaction, they chose the serial number manually.

Sorry for this series of totally irrelevant posts, by now you must be thinking that I am either out of ideas, or totally uninterested about the future of this blog. Neither is true, I am actually spending practically all of my time preparing for ten hours of content I have to deliver at a conference next week, and about which I hope I will post a blog in its own right.

They say the only constant is change. I’d say that the only other constant is error. We humans tend to err. Give a repeatable task to a human, and they’ll mess it up every once in a while. Some call it the human factor . One of the many repeatable tasks in Microsoft Dynamics NAV is setting up items.

Due to fluctuations in market prices, purchase cost of goods may vary from one purchase to another. Also, you rarely just purchase goods and immediately sell them in the same quantity. What you usually do is that you purchase the goods, then let them sit in the inventory for a while, then you may…