NAV/BC - Miminum permission sets required for login

• Using the 
• BASIC

NAV/BC - Responsibility Center FAQ

https://docs.microsoft.com/en-us/dynamics365/business-central/inventory-responsibility-centers

• Responsibility centers can be assigned to
• Customers
• Vendors
• Locations
• By default, it will limit visibility of Purchase and Sale documents to only those that interact with your responsibility centers
• You will still be able to see all customer and Vendors outside of your Responsibility Center
• 
  

Dynamics NAV/BC - Outstanding Quantity would be less than quantity assigned through containers

Go to the Containers link on the header and see what is out of sync.  

You have assigned more on containers that you have left to receive.

The container should be deleted 

The receipt should be cancelled or reversed

Dynamics NAV/BC - Setup Loftware printing options

• Run Loftware Labeling>LPS Configuration to get to labelling service
• Container Labels
• Navigate to Label Printing Connections
• Select Label>Edit
• Under Elements, Select Labelprinting>Edit
• Set/Change the folder
• Case Labels
• Before beginning, ensure Loftware Case Label format exists
• On Item Card, ensure item has a Case Label Defined
• Item Card>Navigate>Item>Labels
• From ADC, 7. Label reprint>Scan Container id or Item Number or Barcode

NAV - Item quantities stuck in In-transit location

• Run location Table
• Untick "Use as In Transit" from the intransit location
• Post reclassification journal to move stock out of Intransit location
• Run location Table
• tick "Use as In Transit" from the intransit location

NAV\BC Views - Item Ledger Value entries

CREATE VIEW [dbo].[BI-ItemValueEntries]
AS
SELECT        [Entry No_] AS IVEEntryNo, [Item Ledger Entry No_], [Item No_], [Posting Date], SUM([Cost Amount (Actual)]) AS [Cost Amount (Actual)], YEAR([Posting Date]) AS Yr, SUM([Valued Quantity]) AS [Valued Quantity], [Location Code],
                         SUM([Sales Amount (Actual)]) AS [Sales Amount (Actual)]
FROM            dbo.[Fresh Supplier Bonaire$Value Entry] AS [5802ValueEntry]
GROUP BY [Item No_], [Posting Date], YEAR([Posting Date]), [Location Code], [Entry No_], [Item Ledger Entry No_]
GO

CREATE VIEW [dbo].[BI-ItemLedgerEntries]

AS

SELECT        [Entry No_] AS ILEEntryNo, [Item No_], [Posting Date], [Location Code], SUM(Quantity) AS Quantity, [Document Type], 

                         CASE WHEN [Document Type] = 0 THEN '' WHEN [Document Type] = 1 THEN 'Sales Shipment' WHEN [Document Type] = 2 THEN 'Sales Invoice' WHEN [Document Type] = 3 THEN 'Sales Return Receipt' WHEN [Document Type] =

                          4 THEN 'Sales Credit Memo' WHEN [Document Type] = 5 THEN 'Purchase Receipt' WHEN [Document Type] = 6 THEN 'Purchase Invoice' WHEN [Document Type] = 7 THEN 'Purchase Return Shipment' WHEN [Document Type] = 8

                          THEN 'Purchase Credit Memo' WHEN [Document Type] = 9 THEN 'Transfer Shipment' WHEN [Document Type] = 10 THEN 'Transfer Receipt' WHEN [Document Type] = 11 THEN 'Service Shipment' WHEN [Document Type] = 12 THEN

                          'Service Invoice' WHEN [Document Type] = 13 THEN 'Service Credit Memo' WHEN [Document Type] = 14 THEN 'Posted Assembly' END AS DocTypeDesc, [Entry Type], 

                         CASE WHEN [Entry Type] = 0 THEN 'Purchase' WHEN [Entry Type] = 1 THEN 'Sale' WHEN [Entry Type] IN (2, 3) THEN 'Adjustment' ELSE 'Other' END AS EntryTypeDesc, [Document No_], Description, [Document Date], 

                         [External Document No_]

FROM            dbo.[Fresh Supplier Bonaire$Item Ledger Entry] AS [32ItemLedgerEntry]

GROUP BY [Item No_], [Posting Date], [Location Code], [Document Type], [Entry Type], [Entry No_], [Document No_], Description, [Document Date], [External Document No_]

GO

USE [FSB]

GO

/****** Object:  View [dbo].[BI-ItemLedgerValueEntries]    Script Date: 7/8/2020 5:44:58 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE VIEW [dbo].[BI-ItemLedgerValueEntries]

AS

SELECT        dbo.[BI-ItemLedgerEntries].ILEEntryNo, SUM(dbo.[BI-ItemValueEntries].[Cost Amount (Actual)]) AS [Cost Amount (Actual)], SUM(dbo.[BI-ItemValueEntries].[Sales Amount (Actual)]) AS [Sales Amount (Actual)], 

                         dbo.[BI-ItemLedgerEntries].[Item No_], dbo.[BI-ItemLedgerEntries].[Posting Date], dbo.[BI-ItemLedgerEntries].[Location Code], dbo.[BI-ItemLedgerEntries].Quantity, dbo.[BI-ItemLedgerEntries].[Document Type], 

                         dbo.[BI-ItemLedgerEntries].DocTypeDesc, dbo.[BI-ItemLedgerEntries].[Entry Type], dbo.[BI-ItemLedgerEntries].EntryTypeDesc, dbo.[BI-ItemLedgerEntries].[Document No_], dbo.[BI-ItemLedgerEntries].Description, 

                         dbo.[BI-ItemLedgerEntries].[Document Date], dbo.[BI-ItemLedgerEntries].[External Document No_], SUM(CASE WHEN EntryTypeDesc = 'Sale' THEN [Sales Amount (Actual)] ELSE [Cost Amount (Actual)] END) AS Amount

FROM            dbo.[BI-ItemLedgerEntries] INNER JOIN

                         dbo.[BI-ItemValueEntries] ON dbo.[BI-ItemLedgerEntries].ILEEntryNo = dbo.[BI-ItemValueEntries].[Item Ledger Entry No_]

GROUP BY dbo.[BI-ItemLedgerEntries].ILEEntryNo, dbo.[BI-ItemLedgerEntries].[Item No_], dbo.[BI-ItemLedgerEntries].[Posting Date], dbo.[BI-ItemLedgerEntries].[Location Code], dbo.[BI-ItemLedgerEntries].Quantity, 

                         dbo.[BI-ItemLedgerEntries].[Document Type], dbo.[BI-ItemLedgerEntries].DocTypeDesc, dbo.[BI-ItemLedgerEntries].[Entry Type], dbo.[BI-ItemLedgerEntries].EntryTypeDesc, dbo.[BI-ItemLedgerEntries].[Document No_], 

                         dbo.[BI-ItemLedgerEntries].Description, dbo.[BI-ItemLedgerEntries].[Document Date], dbo.[BI-ItemLedgerEntries].[External Document No_]

GO

NAV / BC and GL Currency Revaluation

• NAV / BC do not do GL currency revaluation out of the box
• There is a function to adjust exchange rates, but it has the following limitations
• Only filters by Currency, not by GL account
• You cannot control which accounts you want to revalue, only which currencies
• It will revalue ALL GL entries for the filtered currencies TO the exchange rate found on the Ending Date Selected
• It generates a single adjustment journal per currency
• It does not show the beginning and ending exchange rates
• It does not show the detailed journal revaluation information
• Turkish Localization tracks original exchange rate in GL

NAV/BC - How to handle a multicurrency Capital Lease as a Bank Account to allow revaluation to work correctly

• We are the Lessee of a $1000 USD financial or capital loan, our base is GBP
• Bank deposits $1000 into our account
• Terms of loan = $1000 principal repayment, $100 interest expense, $15 tax on interest
• Register Loan to account
• Create Account for loan (or use existing account)
• Create Bank Account for Loan (or use existing bank account)
• General Journal from Long Term Loan into Bank Loan bank account for initial loan value in USD
• General Journal from Bank Loan to Bank Main in USD
• Setup recurring journal to manage repayment schedule to Bank Loan and Interest Expense, and Taxes in USD
• Spend from Bank as usual 
• Repay Loan
• General Journal from Bank Main to Long Term Loan when bank deducts monthly payments in USD
• Revalue Transactions
• Use currency revaluation to make revaluation adjustments to Bank transactions
• If this specific loan should be revalued in a different way, a different currency should be used specifically for this loan to allow for separate revaluation