Burjiis - If you are posting sales by dimension, is there a chance you will want to know what your inventory level is by dimension, and your margins?
Let’s say you buy 100LCY into dimension X, and the person entering the sale posts to dimension Y, either by accident or intentionally. If you were to run inventory valuations, filtered by dimension, the dimension X will show 100LCY on hand, while dimension Y will show negative 100. They offset each other, and unfiltered the value is 0, which is correct. There is no functionality built into NAV that tests or checks that dimensions match on the inflow and outflow of goods. So your inventory valuation, FILTERED BY DIMENSION, is out. Depending on how they do their margin analysis, that may show as out as well. The direct entry should be to the correct dimension, but margin won’t line up with inventory levels.
You may ‘never’ want to run statements or reports this way (filtered by dimension value), but never is a long time.
I spent a lot of time with and for my client reconciling ‘differences’ in their inventory. It always balanced overall, but they were looking at a dimension value level. We finally put some tight controls in, and made sure that they would always sell from the same dimension the purchase went to. This is not an entirely satisfactory situation, because if a ‘mistake’ is made on the inflow, it has to be perpetuated in the outflow. Either that, or they have to do an item journal to correct all the entries, and their volume is such that this is highly inconvenient.
Hope this helps.