Dimensions – more than one Department?
-
Dimensions – more than one Department?
Posted by Tracy Hanson on January 18, 2017 at 3:18 pm-
If we have a fixed asset that is used by 2 different departments, is it possible to tell NAVto code 50% of the depreciation to department 100 and 50% to department 200?
——————————
Tracy Hanson
Staff Accountant
Terso Solutions Inc
MADISON WI
—————————— -
Short of manually changing the FA G/L Journal prior to posting or creating a manual journal entry, you might try setting up individual component fixed assets as part of a main asset. each of the components could then have their own department.
——————————
Dave Wiser
Controller
Beckwith & Kuffel
Seattle WA
——————————
——————————————- -
I agree with Dave, split your asset into two individual asset (these are component assets). Setup a Main asset that you link your two individual/components to. Make sure the depreciation book allows for depreciation of component assets and set your dimensions on each of the components. This should work well.
The only other option would be a recurring journal that reclasses 50% of the depreciation from one dimension set to another. If depreciation is straightline, this is easy…otherwise, you have to edit each month.
——————————
Kim Dallefeld
NAV Consultant
Ft Worth, TX
Kim@Dallefeld.com
——————————
——————————————- -
By accessing the FA Posting Groups, Allocations, Depreciation you are able to allocate percentages across any of your dimensions.
——————————
Tammy Rempfer
Group O
Milan IL
——————————
——————————————- -
Alex Chow
MemberJanuary 19, 2017 at 12:04 PM
Tammy’s solution is the right solution. There’s no manual work involved other than the setup.——————————
Alex Chow
Dynamics NAV MVP
AP Commerce
Los Angeles CA
Blog: http://www.dynamicsnavconsultant.com
——————————
——————————————- -
If you only need to allocate for one asset, Tammy’s solution means that you have to put this asset in its own FA posting group. This isn’t a bad move but for reconcile fa posting groups to your GL accounts, you will have to sum the two posting groups. It also means that for every combination of allocation, you need its own FA posting group.
So consider the extent of your allocation combinations, your reconciliation and decide on use of FA posting group allocations or component assets. Either one will work.
——————————
Kim Dallefeld
NAV Consultant
Ft Worth, TX
Kim@Dallefeld.com
——————————
——————————————- -
Caroline Brichford
MemberJanuary 20, 2017 at 7:08 AM
I’m not sure about the posting to multiple departments but why not set up a recurring entry that will move half to the other department? Its a workaround.——————————
Caroline Brichford
Furukawa Roch Drill USA
Kent OH
——————————
——————————————-
Tracy Hanson replied 8 years, 8 months ago 1 Member · 0 Replies -
-
0 Replies
Sorry, there were no replies found.
The discussion ‘Dimensions – more than one Department?’ is closed to new replies.