I'm having an issue, and I think it is just my understanding of NAV. We have multiple locations in the system. Lets just say I have two, Location 101 and Location 102. I also have divisions which are basically the same thing but they are global dimensions. Again, they are 101 and 102. When I purchase $50 of inventory, I make sure the division matches the location. From the chart of accounts, when I have it filtered to 101, I can see that my inventory goes up by $50. Then I create a transfer and transfer it from 101 to 102(location). I ship and receive the transfer but nothing changes from the chart of accounts. When I look into it I see a positive $50 and a negative $50 for the shipment and the receipt. I tried changing the inventory interim group, but that didn't fix it. What am I missing? Thank you for the help.Jason
I think the problem with me setting up a GL for each location is, we have 12 main locations and then each service person has a truck. So closer to 85 locations? Not saying that I can't do that, but it does seem to undermine the dimensions.
Don't know how it would undermine dimensions. They are not the same.
But if you need your inventory to move from one G/L account to another, then you need to set that up with posting groups per location. No way around that. But unless you need to see this in G/L, then there is no reason to do it. Just like you may assign the same account no. to i.e. all personal trucks.
A dimension (like your division) is a marker to divide your individual transaction. But both side of i.e. a transfer transaction will get the same dimensions. It sounds like you need to be able to mark a transfer with a division from and to code. That "could" be done via a customization, but I wouldn't recommend it.
So if I were you, then I would revisit the actual requrement's from the finance/accounting department. Exactly what is it that they need to see happening in G/L when you transfer inventory?
I thought it was standard in Navision that if you add a dimension to the location card then that follows through to the Item Journal and then to value entry and thus posts correctly in the GL. It is possible though that I wrote code to do this, as it is quite a common request.
Just checking and no it's not standard, but an easy fix, just look at the customer or item card and copy the Default dimension code from there to the Location card.