Today, I got an e-mail from a reader of this blog, who asked me to help them with an actual problem on a project. Their customer is a small manufacturing customer in textile vertical. Whenever they calculate consumption, quantities for certain items get rounded to full numbers. Since the items are usually textile, measured in meters, a consumption of 1.27 meters can end up registered as 2 meters instead. Not that it’s something which can’t be overridden manually, but it is pain in the butt, and hey, why do we have computers in the first place if we have to do their job.
Most of you probably giggle at this point in disbelief, why do I blog about this, as if I rediscovered sliced bread. As much the matter is simple, it definitely isn’t simple to a person who encountered this for the first time in their life. When I decided to start this blog, I promised to myself that I am never ever going to write about something which is covered directly in the documentation, or to the best of my knowledge already available somewhere in the cloud. So before writing this post, I checked about this, and to my surprise, it really wasn’t documented (satisfactorily) either in Help, or available courseware. That’s the first reason I write this.
The second reason is a tragic story, of which I was a protagonist several years back, which forever changed the way I approach people who ask me questions. I was a rookie in Microsoft Dynamics NAV, and at the customer I had a problem with inventory costing, way beyond my capabilities at the time. So I approached a senior consultant, an expert in costing, to ask him for help. The only help I got was an abrupt: “I wasn’t born with that knowledge!”.
Ok, let’s get to the point. Have you noticed how easy it is for me to drift away from the point? Well, if you did, here’s the way to get to the point, in case you want to.
The reason why consumption journal rounds quantities to whole numbers is that it takes the value Rounding Precision from the item card:
Help isn’t too helpful about this field. It says: In this field, you can specify how quantities of this item must be rounded in the various calculations that involve the item. If, for example, the item is available only in indivisable units, enter 1 in this field. It doesn’t bother to explain which are these situations, and yes, it comes with the spelling error.
Default value for this field is 1, which according to the help means that whenever you do various calculations with this item, you get your results rounded to the nearest integer greater than calculated value. This field is so easy to oversee when configuring the system, because Replenishment tab, Production column is rarely visited for raw materials, and even less frequently if you don’t replenish your inventory automatically.
Anyway, if you want your consumption journal not to round up all the component quantities, you need to put the lowest desirable precision into this field, or you put 0 if you don’t want any rounding at all. When you give it a thought, I don’t see why the standard system forces any initial value for this field, because the assumption that components are going to be measured in pieces, or any other countable whole units for that matter, is less safe than the opposite. I’ve worked for six different customers in six different manufacturing verticals, and only one of them had items measured in countable units as components, so in my experience you are far more likely to end up not requiring any rounding. In case this is the case, you can design table 27 Item, locate the field Rounding Precision, and set its InitValue property back to its default value of 0.
To err is human. To really screw up you need a computer.