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

march

03mar10:00 am10:30 amThe Modern Manufacturer - MRP vs. MPS – What, When and How

03mar2:00 pm2:30 pmLot Management Best Practices for Batch Manufacturers

10mar10:00 am10:30 amEnhancing the Customer Experience and Driving More Business with Dynamics 365 Customer Service

10mar2:00 pm2:30 pmThe Five Steps to Managing Sales Tax for Manufacturers

11mar11:00 am12:00 pmConfab with Stoneridge - Livestream - Power Apps Component Framework Power Hour

17mar10:00 am10:30 amThe Modern Manufacturer: Pro Tips for your Finance Team

24mar10:00 am10:30 amUnlock the Potential of Digital Marketing with Dynamics 365 Marketing

25mar11:00 am12:00 pmConfab with Stoneridge - Livestream - The Four Keys to Choosing the Best ERP or CRM Solution

31mar10:00 am10:30 amThe Modern Manufacturer: Keys to Reporting Success

31mar01aprTraining Class: Financial Reporting W/Account Schedules for Dynamics 365 Business Central

april

31mar01aprTraining Class: Financial Reporting W/Account Schedules for Dynamics 365 Business Central

07apr10:00 am10:30 amBoost Seller Productivity and Close More Business with Dynamics 365 Sales

07apr2:00 pm2:30 pmEnsuring Quality for Batch Manufacturers

08apr11:00 am12:00 pmJumping into the Deep End of the Data Lake

14apr10:00 am10:30 amThe Modern Manufacturer: Cost Accounting in D365

22apr11:00 am12:00 pmMoving from Manual to Automated with Strategic Automation Strategies

28apr10:00 am10:30 amThe Modern Manufacturer: Best Practices for Inventory Turn

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