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?