ArcherPoint Dynamics NAV Developer Digest - vol 164
The NAV community, including the ArcherPoint technical staff, is made up of developers, project managers, and consultants who are constantly communicating, with the common goal of sharing helpful information with one another to help customers be more successful.
As they run into issues and questions, find the answers, and make new discoveries, they post them on blogs, forums, social media…so everyone can benefit. We in Marketing watch these interactions and never cease to be amazed by the creativity, dedication, and brainpower we’re so fortunate to have in this community—so we thought, wouldn’t it be great to share this great information with everyone who might not have the time to check out the multitude of resources out there? So, the ArcherPoint Microsoft Dynamics NAV Developer Digest was born. Each week, we present a collection of thoughts and findings from NAV experts and devotees around the world. We hope these insights will benefit you, too.
Microsoft’s Team Foundation Server (TFS)
TFS gets kudos from ArcherPoint developer Kyle Hardin:
Kyle: TFS is the bomb! I just did a text compare of an object’s current version against the previous version to see exactly what changed for the most-recent release, all right in Visual Studio.
Jon: Anyone get 2018 in there yet? I’d like to see the delta with 2017.
Kyle: They just released the October developer preview, but the objects will probably drift a bit before the final release.
Dynamics NAV Developer Preview for October 2017
Suresh notes that there are some nice new features in the October update including add-in support, new dictionary and list types. Additionally ForEach is back and Microsoft has added support for the new Label translation syntax.
How to Schedule Dynamics NAV Services to Restart
In Suresh’s blog, he shares the PowerShell script that he uses to schedule a NAV service tier to restart.
Too Many Decimals to do Fixed Asset Depreciations?
Kyle had to fix a problem with a customer that somehow got Fixed Asset depreciations imported with too many decimals. Enough decimals that you couldn’t do disposals or further depreciation.
He wrote a small SQL script to fix the entries.
use [CORNAVSQL]
go
declare @EntryNo int
declare @FALoop cursor
declare @Counter int
set @FALoop = cursor for
select [Entry No_]
from [dbo].[COR – PROD$FA Ledger Entry]
open @FALoop
fetch next from @FALoop into @EntryNo
set @Counter = 1
while @@FETCH_STATUS = 0
begin
update [dbo].[COR – PROD$FA Ledger Entry]
set [Amount] = ROUND([Amount], 2, 1),
[Debit Amount] = ROUND([Debit Amount], 2, 1),
[Amount (LCY)] = ROUND([Amount (LCY)], 2, 1)
from [dbo].[COR – PROD$FA Ledger Entry]
where [Entry No_] = @EntryNo
and [Amount] > 0
update [dbo].[COR – PROD$FA Ledger Entry]
set [Amount] = ROUND([Amount], 2, 1),
[Credit Amount] = ROUND([Credit Amount], 2, 1),
[Amount (LCY)] = ROUND([Amount (LCY)], 2, 1)
from [dbo].[COR – PROD$FA Ledger Entry]
where [Entry No_] = @EntryNo
and [Amount] < 0
fetch next from @FALoop into @EntryNo
set @Counter = @Counter + 1
end
close @FALoop
deallocate @FALoop
select @Counter
Adding Default Dimensions to the Dynamics NAV Location Card
Denise B: Location Default Dimension, has anyone added default dimensions to the Location Card?
Trish: Yes. The scope on this type of modification can be huge, but in this case the client limited it to the Revaluation Journal only. A custom action was added to the Revaluation Journal to update the values for a single Dimension Code from the Location Card default dimensions. The user selects the custom action after running the Calculate Inventory Value function, which establishes the Revaluation Journal records.
Kyle: You would have to decide on an order that wins (e.g., Customer? Item? Vendor? Or your location?).
Matt: You don’t have to decide, that’s what Default Dimension Priorities are for. As long as you run it through the appropriate places in Dimension Management you should be fine. But there are a lot of places to change that code.
Thanks to the ArcherPoint developers, customer service reps, and consultants that make the Developer Digest blog possible!
Stay abreast of what is new in the Microsoft Dynamics NAV community and at ArcherPoint by subscribing to our monthly newsletter, Better Business, by completing the form in our Resource Center.
If you are interested in NAV development, be sure to see our collection of NAV Development Blogs.
Read more “How To” blogs from ArcherPoint for practical advice on using Microsoft Dynamics NAV.