Dynamics NAV - Currency Factor vs Exchange Rate and Relational Exchange Rate

BC Setup

• Base Currency is USD
• Foreign currency is EUR
• I want 1 EUR = 1.12 USD
• In exchange rate screen for EUR
• Exchange Rate Amount = 1
• Relational Exchange Rate Amount = 1.12
• Fix Exchange Rate Amount = Currency
• 
  

Method 1

• My base currency in the G/L setup is GBP
• My foreign currency is USD
• Currency Factor is 1.7
• 1 GBP * 1.7 = 1.7 USD
• Exchange Rate is 0.55
• 1 USD * 0.55 = 0.55 GBP
• Currency Factor = 1/Exchange Rate

Method 2

• USD Exchange Rate Amount = 1 
• USD Relational Exchange Rate Amount = 7
• Fix Exchange Rate Amount = Currency
• Translates into 1 GBP = 7 USD
• 
  

Dynamics NAV 2015 - Capture Input - Input no longer works. Use Window.InputBox

http://saurav-nav.blogspot.com/2014/09/discontinued-component-nav-2013-later.html

In your CAL code, create a global or local as follows
---------------
Name   = Window
DataType = DOTNET
SubType  = Microsoft.VisualBasic.Interaction.'Microsoft.VisualBasic, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'
Go to properties, Set RunOnClient = Yes
----------------

Now you can call it in your cal code like this
---------------
CustomerNo := Window.InputBox('Input Customer No:', 'INPUT', '', 100, 100);
---------------


Parameter description

>Prompt - Message You Want to Display.
>Title - Title of Input Box.
>DefaultResponse - Response That should be Filled Intially.
>XPos & YPos - X & Y Axis Position of Input Box.

It Returns a Text Value as Output.

Windows Server 2012 - Windows update failed - kb2919355 - does not install - .NET Framework 4.6 failed to install. Management Reporter CU15 Failed to install

Related Errors:

• Trying to install Management Reporter 2012 CU15 - "An Error occurred while installing system components for Management Reporter."
• Trying to install Dot Net 4.6 - "A failure occurred attempting to install the Microsoft .NET Framework 4.6"

Solution:

• Run this in powershell
• robocopy C:\Users\Default\ D:\Users\Default\ *.* /s
• Change the D to any other drive letter you may have installed windows components to.
• To be safe, run this to copy the users\default directory to all other local drives.
• Rerun the windows update, and everything should install correctly.

Dynamics NAV - Item Age Composition vs Inventory Valuation Report

• Item Age Composition Report
• Shows the CURRENT value of stock, broken into aging buckets
• Uses the total of open item ledger entries
• Automatically Uses Expected Costs for receipts with no posted invoices
• Displays value in aging buckets for three periods before the current date
• Inventory Valuation Report
• Shows the Value of Stock AS AT a given date
• Uses the total of open item ledger entries
• By default, the report will only display line items with posted invoices
• User must tick "Expected Costs" to include any line items with unposted invoices, and use an expected cost to value those lines
• Displays total of all transactions in the range selected
• These two reports are not supposed to match for historical dates.
• They will only match for current dates.

Dynamics GP - Month End Financial Procedures

1. Soft Close Fiscal Periods
1. This will prevent posting to the closed periods, and enable posting to the new period
2. GP>Tools>Setup>Company>Fiscal Periods
1. Select The current Year
2. Tick the modules to prevent posting to the last period for those modules
3. Untick the modules to allow posting to the next period for those modules
2. Print Reports
1. Print your Financial>Reports>Trial Balance
2. Print your Sales>Reports>Trial Balance
3. Print your Purchases>Reports>Trial Balance
4. Print your Inventory>Reports>Activity>Historical IV Trial Balance
5. Print your Inventory>Reports>Activity>Stock Status
3. Export Smartlists
1. Item Quantities
2. Customer Balances
3. Vendor Balances
4. GL Account Summary

Dynamics NAV - LS Retail - LS NAV Start cannot connect

• This happens if the NAV service is not running.
• Ensure that the windows account used to run the NAV service is added to the local sql as sysadmin,  db-owner
• Launch the regular NAV client and attempt to connect to the local service before launching the LS NAV start

Solution:
Change default connection string on nav shortcut

• Navigate to C:\Users\<user>\AppData\Roaming\Microsoft\Microsoft Dynamics NAV\110
• Open ClientUserSettings in notepad
• Look for     <add key="ClientServicesPort" value="7046"/>
• Change it to the port of the instance you are trying to connect to
• Look for      <add key="ServerInstance" value="DynamicsNAV71"/>
• Chnage it to the name of the instance you are trying to connect to

Dynamics GP - Stored Procedures - GL Trial Balance Summary

exec [seeglPrintSRSTrialBalance ]
@I_tInactiveAccounts=0,
@I_tIncludeUnitAccounts=0,
@I_tIncludeZeroBalance=0,
@I_cStartingAccountNumber=N'000-1100-00                                                       ',
@I_cEndingAccountNumber=N'000-1120-00                                                       ',
@I_dStartingDate='2019-01-01 00:00:00',
@I_dEndingDate='2019-12-31 00:00:00',
@I_iYear=2014,
@I_tHistoryYear=0,
@I_iRangeByAccount=N'1',
@I_iPostingAccounts=N'1'