You’re offline. This is a read only version of the page.
135
This is an inquiry to see if anyone has run into this issue and maybe have some suggestions.
We are using Dynamics Navision 2009 SP1 as our ERP.
Last year, we spent a lot of time looking into transitioning Fixed Assets from a 3rd party software program to NAV's Fixed Asset Module/Ganule.
All looked well until we ran in to an issue with Negative Depreciation.
Our current processes and 3rd party program allows us to import negative numbers and calculate negative depreciation on the negative acq cost. In the Fixed Asset Module in NAV, we can have the "negative acq cost" validation removed, but it seems NAV will not calc negative depreciation.
We use Straight Line w/Half Year Convention as our depreciation method. This we also found to be an issue as in order for NAV to calc STL HY correctly, one has to put in a manual end date of 6/01/XX where xx = final year for depreciation. By doing this, it seems to skew the total depreciable years as if a 10 year asset would now depreciate at 10.74xxxx years.
If anyone has some suggestions, I really feel this module can improve our processes but we face losing historical data that is material if we are unable to bring in the negative figures.
*This post is locked for comments
Many thanks for this suggestion Jens Glathe. This was really helpful
Jens/Dirk
Thank you for your time and input. I was able to work with our consultant and have the validation checks removed tied in to the FA Ledger Check as well as Depr Book Below Zero and Acq Cost below zero.
I am able to post Negative Acquisition Costs and correctly Calculate Depreciaion on those negative layers.
Again, thank you for your replies, you saved this project and ability to use NAV going forward.
Dustin
Hi,
I think you need to differentiate between "Depr. below Zero" and "Negative Depreciation".
"Depr. below Zero" is starting as normal depreciation and allows you to depreciate down to zero and then further below zero (this is often used for internal cost calculations)
"Negative Depreciation" is like the normal depreciation, just with different decimal signs / debit instead of credit.
For "Negative Depreciation" you need to uncheck "USE FA Ledger Check" in table "Depreciation Book" (general) and also in table "FA Depreciation Book" (for the specific fixed asset).
Good luck
Dirk
Hi Dustin,
this should be Table 5611 "Depreciation Book", Field #47 "Allow Acq. Cost below Zero". I've just checked the revision history: it's been there since at least version 4.
I've added it to the "Depreciation Book" Card.
with best regards
Jens
Jens,
Can you specify where you were able to make the "Acquisition Cost Below Zero" option appear visable?
My friend has a Dev License and he could not find this option in the tables.
Thanks,
Dustin
Hi Dustin,
... strange... didn't have to code anything, only:
- You need the "Allow Acquisition Cost below Zero" field being visible in the Depreciation Book card.
- You need to have the "Allow Depreciation below Zero" field being visible in the Depreciation Book card.
The setup of the Depreciation Book should be this way:
- Check both fields.
- Uncheck the "Use FA Ledger Check" field.
- Make sure the "Use FA Ledger Check" field is also unchecked in your FA Depreciation Books. This is true when you create the FA Depreciation Book after setting up the Depreciation Book.
With this I was able to post entirely negative acquisition cost and to calculate and post negative depreciation without a warning.
My test system is a NAV2009R2 W1 Cronus, this should be near enough to a NA version.
HTH.
with best regards
Jens
I would appreciate it, we are looking to change our processes to avoid this going forward, we just want to keep our historical data
Hi Dustin,
I came across a similar problem, twice. I'm sure you can modify the calculate depreciation function in a way that will allow negative depreciation. We gave up the last time because we found other ways to do the posting.
I just had a look on the Depreciation Calculation codeunit, it's worth a try. Can I get back to you on this?
with best regards
Jens Glathe
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (