Locationwise Separation of Accounts ( Trail Balance)

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

Not Answered This post has 0 verified solutions | 4 Replies | 2 Followers

39 Posts
485 Points
Joined: 2007-9-27
Last Online:
2013-1-1 13:45
SBNGH posted on 2012-1-31 15:43

Dear experts,

I am deploying NAV in multi-site environment. I have set up locations for inventory/warehouse and also set up responsibility centers to assign the users and filter their documents and transactions.

In addition there is a need of separation of Financials at GL level for each location. That means each location should do accounting as a branch and should produce its own trail balance. There can be transactions between locations which should be reflected in branch trail balance. I tried to manage this with the location dimension but pretty complex. 

Is there any easy and simple solutions for such needs? I await your response and would highly appreciate your suggestion.

Thanks and regards

SBNGH

 

 

 

All Replies

76 Posts
485 Points
Joined: 2003-6-26
Last Online:
2012-2-1 2:39
Girish replied on 2012-2-1 0:30

Hi,

You can do this by setting up Inventory Posting Setup by providing diffrent GL Accounts on Posting Type and Location Combination.

By Doing this, whenever you do a location transfer, it will reduce the amount from one GL and up into another GL.

Try this, it will work.

Cheerzzzz
Girish

39 Posts
485 Points
Joined: 2007-9-27
Last Online:
2013-1-1 13:45
SBNGH replied on 2012-2-3 9:08

Hi Girish, 

Thank you for the suggestion. I am afraid you didnt understand me clearly. My point is not only the location transfer, each location should function as separate entity as far as accounting is concerned. There can be accounting transactions between location. One location may raise debit note to the other location and vice versa. The location here is not simply the physical location or warehouse. It is a kind of a company's branch (like admin location  or a responsibility centre. )

Since this is my first time doing it, I just want be sure how such requirements are addressed by standard NAV where it's one company , one COA but multiple locations (branches).

 I appreciate your guidance.

Thanks,

SBNGH

Male
1,059 Posts
18,155 Points
Joined: 2011-9-5
Last Online:
2013-6-18 17:51
Location: India
Pranav Kumar replied on 2012-2-3 19:35

Correct if i am wrong.

Do you require trial balance based on financial dimension (Store as dimension)??

Pranav...

-- 

Expect the best, plan for the worst and prepare to be surprised

http://pranavkumaar.wordpress.com/

4 Posts
25 Points
Joined: 2010-1-31
Last Online:
2012-12-6 13:55
Location: Doha, Qatar
Musthafa replied on 2012-10-22 20:37

Dear All

 

I am also facing the same problem. Could anybody help plz

Musthafa

Page 1 of 1 (5 items) | Get this RSS feed | Bookmark and Share