web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Steps to create new bo...
Finance | Project Operations, Human Resources, ...
Unanswered

Steps to create new book and assets in Fixed Assets

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,850 Moderator

I am looking for confirmation on steps to complete the following:

Client's firm gets purchased.

Auditors are demanding a new book and  calendar

FA Calendar year is changing from fiscal year to calendar year

Here are the steps I believe are necessary:

1) Create new book

2) Assign this book to all the classes

3) Create new calendar based on calendar year

5) Set fixed asset company options for this new book

6) Import the thousands of assets by importing General and Book values

Did I miss anything?

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Rennecia Barran Profile Picture
    Rennecia Barran on at

    Hi Richard, I think that sums it up.

    Just to be sure, I have some questions to help.

    -Are you creating new records for the assets? If so, you can use the Fixed Asset Modifier to change the asset IDs in PSTL. Move the existing assets to some ID that begins with 'Z' or so to drop it to the end of the listing and make them in one group.

    -Also, what are your plans for the GL Impact?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    They want to keep the fiscal year and the original general and book information. I have created a new calendar based on calendar year and I now have new mac files to be imported into general and book. When done both will be in their fixed asset tables. I leave all accounting aspects to their accountants.

  • Rennecia Barran Profile Picture
    Rennecia Barran on at

    Thanks for the update Richard.

    If they want to keep the original data, I think it would be best to use modifier to add a prefix to the 'old' assets, that way they wont get mixed up with the new ones. It would also allow you to pull a smartlist for a particular range of assets.

    If you don't want to add PSTL modifier in the mix to do the re-coding of the old asset IDs, you could instead use the user defined fields on the older assets and use one of those fields to label the older assets. Just a thought.

    Regarding the Accounting - just a reminder that once the assets are uploaded, there will be an entry in the GL Post side for the Fixed Assets. This should be treated with before they begin using the module to run depreciation, etc.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    I am reluctantly getting back to this project. At the present time they have two books. One called INTERNAL and the other called TAX. They now want a new book called POSTSALE which will contain all the same assets in the other two books. So when I am finished they will have three books all with the same assets. The only difference is the calendar year for the new book will be Jan-Dec as opposed to Jul-Jun. I have created the new calendar year. Can PSTL be used to copy all the assets from one book to another? Can I do this using SQL? What would I need to do to perform this copy?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    There are 5,476 assets so using PSTL would not be practical. Using SQL would it be possible to add new records to the asset master table creating new ASSETINDEX values and then populate the book master table with these new assets? They want to put a 5 in front of all the asset IDs. Would there be another other tables that will need to be adjusted? I am a SQL person so I would prefer to go this route as opposed to creating import macros.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 551 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 278 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans