Dimensions – more than one Department?

  • Dimensions – more than one Department?

    Posted by Tracy Hanson on January 18, 2017 at 3:18 pm
    • Tracy Hanson

      Member

      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
      ——————————

    • David Wiser

      Member

      January 18, 2017 at 3:51 PM

      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
      ——————————
      ——————————————-

    • Kim Dallefeld

      Member

      January 19, 2017 at 11:49 AM

      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
      ——————————
      ——————————————-

    • Tammy Radecke

      Member

      January 19, 2017 at 9:47 AM

      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

      Member

      January 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
      ——————————
      ——————————————-

    • Kim Dallefeld

      Member

      January 19, 2017 at 12:14 PM

      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

      Member

      January 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 7 years, 3 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.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!