Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Matthew Schwankl]

??Hello,

We use three different Book IDs for each asset that is created.

1. Financial – this is used for our regular book depreciation that is run at month end.
2. AMT – used for AMT depreciation
3. Tax – used for tax depreciation

We are a pass through entity so our Depreciation Method, Averaging Convention and any Special Depreciation Allowance for the current tax year is determined in March – April while the parent company is completing their tax return.  At this point is when our tax advisors let us know what we need to update our Tax Books to for the Fixed Assets placed in service during the tax year.  This is where the manual work in GP kicks in.  If 400 fixed assets were placed in service throughout the tax year they were all initially created using the default Deprecation Method, Averaging Convention, etc. assigned to the Tax Book ID.  If our tax advisors have determined we need to change the Depreciation Method, Averaging Convention, etc from the default in GP, someone has to go in and manually change 400 fixed assets so they depreciate properly on the Tax Book.

We use a SmartConnect  integration to create fixed assets.

Does anyone know, first of all, if it is even possible to use an integration to update fixed asset books?  If so, is there a canned integration available (for SmartConnect or otherwise), or has anyone had success in building an integration for this purpose?

Thank you in advance for any help you may provide on this subject.

Thanks,

——————————
Matthew Schwankl
NorthMarq Capital, LLC
——————————

[Jo deRuiter]

Hi

You cannot update the FA Books with SmartConnect.  They system won’t allow it because DURING the process of updating Book records a separate S?tored Procedure that runs and updates TONS of other things.

Your best bet would be to use a Mail-Merge-Macro as discussed in these steps by the indomitable https://winthropdc.wordpress.com/2008/10/29/how-to-use-word-mail-merge-and-macros-to-import-data/
?

——————————
Jo deRuiter
?? GPUG ALL STAR
??Granite Award Winner
Atlanta Chapter Leader
Aisling Dynamics Business Solutions
Business Applications Practice Manager
jo.deruiter@aislingdynamics.com
9518674366
aislingdynamics.com
——————————
——————————————-

[Charles Allen]

Have you tested the Mass Change option? You can import the list of assets to change into a group and then use the group to do the mass change. 

——————————
Charles Allen
Senior Managing Consultant
BKD Technologies
Houston, TX
——————————
——————————————-