Save Time on Fixed Asset Transactions with Duplication List in Dynamics NAV

by | Updated January 5, 2018 | Dynamics NAV

If your company uses and manages a plethora of fixed assets, filling out journal lines for acquisition costs and disposals can be cumbersome. The problem only amplifies when your company also uses multiple depreciation books. One way to help lighten your load is to utilize the Duplication List in Dynamics NAV.

With duplication lists, you are able to populate one journal line in the FA G/L Journal for the depreciation book you have tied to the general ledger, and upon posting you will find journal lines populated for the remaining depreciation books of your choice in the Fixed Asset Journal. This prevents the need to populate four lines for four depreciation books for one fixed asset. I will walk you through the necessary setup and steps to utilize this feature for a fixed asset.

First, create the depreciation book(s) you will be using. In NAV, start by simply going to the Depreciation Books list. I am using CRONUS, and so the COMPANY book already exists. Add a new book called EXTERNAL and click Edit. Make sure that none of the G/L Integration toggles are checked in the Integration fast tab. This will cause the automatically created journal lines to appear in the FA Journal. Next, go to the Duplication fast tab and check the box for “Part of Duplication List.”

Now that your Depreciation Books are ready, go to the Fixed Assets list to create or modify a fixed asset to include both Depreciation Books.

Navigate to the Fixed Assets list to create or modify a fixed asset to include both Depreciation Books.

Making use of the Duplication list will look the same whether you are using the FA G/L Journal for the Acquisition Cost or Disposal. For instance, to acquire the fixed asset, go to the FA G/L Journal and add a line with the relevant information:

Posting Date

12/1/2017

Document No.

G05002

Account Type

Fixed Asset

Account No.

FA000100

Depreciation Book Code

COMPANY

FA Posting Type

Acquisition Cost

Description

Washer Machine

Amount

2,000.00

Bal. Account Type

G/L Account

Bal. Account No.

22400

Use Duplication List

Yes

This last field is the focus of our exercise. After posting the journal, two things will happen. You will see a new ledger entry for your fixed asset for the COMPANY book with a net book value matching the acquisition cost, and you will see lines populated in the FA Journal for the EXTERNAL book, ready for you to post. This is because the Depreciation Book Setup included the EXTERNAL book in the Duplication List, and the lines populated in the FA Journal instead of the FA G/L Journal because the book setup did not have a checked box indicating that acquisition costs for this book would affect the G/L. After reviewing the FA Journal and posting, you will see the book value change to the acquisition cost on the fixed asset page for the EXTERNAL book.

It is worth noting that this is not as beneficial of a feature for depreciation cost calculation since the Calculate Depreciation will already allow you to calculate book by book and will place the correct lines in the correct Journal, based on whether it has a G/L impact indicated for depreciation cost in the book setup. However, if you wish, you could fill the COMPANY lines in the FA G/L Journal via Calculate Depreciation and then manually check every line to use duplication list. Like with Acquisition Cost, the lines would appear in the correct journals after posting, based on the setup. Running the Calculate Depreciation for each book appears to be less time consuming, but it would depend on the number of fixed assets and books you have.

Related Posts

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events

september

02sep10:00 am10:30 amThe Modern Manufacturer - Cycle Count Management

02sep12:00 pm12:30 pmBest Practices for Work Order Planning and Routing for Field Service Companies

09sep10:00 am11:00 amWhat is Levridge? An Overview of the Ultimate Ag Solution

09sep12:00 pm12:30 pmOverview of Microsoft Promotion for NAV and GP Clients

10sep11:00 am12:00 pmConfab with Stoneridge - Livestream - Field Service Comparisons

16sep10:00 am10:30 amThe Modern Manufacturer - Product Lifecycle Management

16sep12:00 pm12:30 pmHow to Upgrade to Dynamics 365 Finance and Operations: Examining Custom Code and ISV Implications

16sep2:00 pm2:30 pmScheduling and Dispatching for the Modern Field Service Company

23sep12:00 pm1:00 pmDynamics 365 Business Central Wave 2 Release Preview - An Overview of the Most Exciting New Features Coming in October

24sep11:00 am12:00 pmConfab with Stoneridge - Livestream - The Modern Workplace: Teams, Sharepoint, Outlook, Office, and AI Integration

30sep10:00 am10:30 amThe Modern Manufacturer - Return Management

30sep12:00 pm12:30 pmEmpowering Your Field Service Technicians with a Mobile Solution

october

07oct12:00 pm1:00 pmThe Three Paths to Business Central from Dynamics GP

08oct11:00 am12:00 pmConfab with Stoneridge - Livestream - The Vision and Strategy of Microsoft Business Systems

14oct10:00 am10:30 amThe Modern Manufacturer - Complex Cost Modeling

14oct12:00 pm12:30 pmGenerating Custom Inspection or Process Forms

19octAll Day22Stoneridge Connect Fall 2020

22oct11:00 am12:00 pmConfab with Stoneridge - Livestream - Stoneridge Connect Recap

28oct10:00 am10:30 amThe Modern Manufacturer - Engineering Change Orders

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X