Microsoft’s Dynamics NAV 2013 R2 enterprise resource planning (ERP) product was released in October of 2013 at the Directions US partner event taking place in Nashville. We from bcFood was there for the launch event.
Dynamics NAV 2013 is aimed at the small and medium-sized business (SMB) market. Its last major version was released in fall 2012. This past summer, Microsoft took the major step of allowing its partners to deploy Windows Azure-hosted versions of Dynamics NAV 2013, for customers who want a cloud-based ERP solution.
The following features and functionality for application users have been introduced with Microsoft Dynamics NAV 2013 and NAV 2013 R2.
RapidStart Services for Microsoft Dynamics NAV
You can deploy RapidStart Services configuration packages across multiple installations of Microsoft Dynamics NAV in an automated way using a Microsoft Dynamics NAV Windows Powershell cmdlet. For more information, see How to: Configure New Companies using a Cmdlet.
Understanding cash inflows and outflows is the key to running a successful business. Measurement of cash flow is not always easy. However, Microsoft Dynamics NAV 2013 provides tools to make this easier. You create a periodic calculation of the forecasted operational revenues and expenses to calculate the cash surplus or the cash deficit. According to these results, the company can take adjustment measures, such as credit reduction for a surplus, or borrowing if there is a deficit.
In your forecast, you can incorporate values from the General Ledger, Sales and Marketing, Purchasing, and Service.
- You set up your own chart of cash flow accounts.
- From the General Ledger, you get information about the liquid funds and the budgeted values of your company.
- From Purchasing, you get information about the current payables and any forecasted debts from open purchase orders.
- From Sales, you get information about the current receivables and any forecasted receipts from open customer orders.
- From Service, you get information about open service invoices.
- From Fixed Assets, if the planned capital expenditures are budgeted and future asset purchases are recorded, then you incorporate these values into the cash flow forecast.
- In addition, you can manage manual revenues and expenses and integrate them in the cash flow forecast.
- You can use various windows and reports to analyze and see the cash flow statistics that relate to availability and timeline overviews.
For more information, see Cash Flow Overview.
In cost accounting, you allocate budgeted and actual costs of operations, departments, products, and projects to analyze the profitability of your company.
Cost accounting has the following main components:
- You define cost types, cost centers, and cost objects to analyze what the costs are, where the costs come from, and who should bear the costs. You define chart of cost types with a structure and functionality that resemble the general ledger chart of accounts. You can transfer the general ledger income statement accounts or create your own chart of cost types. Cost centers are departments and profit centers that are responsible for costs and income. Cost objects are products, product groups, or services that carry the costs in the end. You often link cost centers to departments and cost objects to projects in your company. However, you can link cost centers and cost objects to any dimensions in the general ledger and supplement them with subtotals and titles.
- You can transfer the general ledger entries to cost entries with each posting or use a batch job to transfer the general ledger entries based on daily or monthly summary posting. In the cost journal, you can post entries that do not come from the general ledger or are not generated by allocations. For example, you can post cost entries, internal charges, and corrective entries between cost types, cost centers, and cost objects.
- Cost budgets work similarly as general ledger budgets. You can transfer the general ledger budgets, import and export budgets to and from Excel, or create your own cost budgets.
- Allocations move costs and revenues between cost types, cost centers, and cost objects. Each allocation consists of an allocation source and one or more allocation targets. You can allocate actual values or budgeted values by using the static allocation method based on a definite value, such as square footage, or an established allocation ratio of 5:2:4. You can also allocate actual values or budgeted values by using the dynamic allocation method with nine predefined allocation bases and 12 dynamic date ranges.
- Most reports and statistics are based on the posted cost entries. You can set the sorting of the results and define with filters which data must be displayed. You can create reports for cost distribution analysis. In addition, you can use the standard account schedule to define how your reports for the chart of cost types are displayed.
For more information, see About Cost Accounting.
To support companies that supply products to their customers by combining components in simple processes without the need of manufacturing functionality, Microsoft Dynamics NAV 2013 now includes a complete feature set to manage assemblies in integration with Sales, Planning, and Warehousing.
WMS Inventory Movements
Inventory movement is a new warehouse activity document that is used to move items to and from internal departments, such as production and service departments, where posting of the items occurs as consumption, shipment, or other.
WMS Dedicated Bins
To manage the flow of items in and out of an internal operation area, you can set up locations or machine and work centers with a default bin structure that communicates to warehouse workers where to place components for a particular operation.
WMS Integration to Service Orders
Service lines, just like other outbound document lines, can function as source document lines for picking to shipment. After a service line is released to shipment, the warehouse handling involved in picking and then shipment posting the service order follows the same flow as for other source documents. For more information, see How to: Prepare Service Line Items for Warehouse Handling.
Item Availability Views
To supplement the existing views of item availability, three new availability windows have been added:
To obtain a rational supply plan, a planner adjusts planning parameters to limit rescheduling suggestions, to accumulate demand (dynamic reorder quantity), and to avoid insignificant planning actions.
Five new reorder period fields have been added to the item card planning parameters to help optimize when and how much to reorder.
For more information, see the following field topics:
Calculate and Carry Out
Items on planning lines with warnings typically do not respect the planning parameters. Now, you can define on the Calculate Plan request pages on the planning worksheet and the requisition worksheet that you want certain planning parameters to apply even though the planning line has an exception warning. For more information, see the new option descriptions in Calculate Plan – Plan. Wksh. and Calculate Plan – Req. Wksh., respectively.
Payment Services for Microsoft Dynamics ERP
If you want to enable your customers to pay their sales orders with credit cards, then you can enable online credit card payments for Microsoft Dynamics NAV.
Receiving and processing online credit card payments for online and retail business provides flexibility and faster payments. The online credit card payment feature automates authorizing credit card amounts at the time of the order and processing the actual charge when the order is shipped and invoiced. For more information, see Online Services for Microsoft Dynamics ERP.
You can now integrate with Microsoft Excel to produce Excel-based reports that use Microsoft Dynamics NAV pages as data sources. The data in Excel is provided in a data region format so that you can create PivotTables and reports. You can refresh the data in Excel to reflect updates that are made in Microsoft Dynamics NAV. If you have configured the use of Office 365, the pages open in the Excel Web App. If you have Excel installed, you can then open the data in Excel from the Excel Web App. For more information, see Sending Data to Microsoft Excel.
Manual Payment Processing
The Payment Registration window shows incoming payments as lines that represent sales documents where an amount is due for payment. The window is designed to support you in tasks involved in balancing internal accounts with actual cash figures to ensure effective collection from customers: You can quickly verify and post individual or lump payments, initiate finance charges for overdue payments, process discounted payments in different scenarios, and find specific non-posted documents for which payment is made. For more information, see Process Payments Manually.
Automatic Payment Processing
You must routinely apply incoming and outgoing payments made on your electronic bank site with the related business documents in Microsoft Dynamics NAV and then post the applied payments to customer, vendor, and bank ledger entries to settle your payables and receivables accounts. To quickly process payments based on bank statements, you can use an automatic application function in the General Journal window, and you can specify rules that map payments to debit or credit accounts according to text found in the payment description. For more information, see How to: Apply Payments with Open Documents.
At regular intervals, you must reconcile your bank accounts in Microsoft Dynamics NAV by matching bank ledger entries resulting from posted payments with the related transactions on your electronic bank site. You can use either an automatic or a manual matching function in the Bank Acc. Reconciliation window to reconcile bank accounts. The window is divided into two vertical panes for easy matching: Bank statement lines in the leftmost pane and bank account ledger entries in the rightmost pane. For more information, see How to: Match Bank Statement Lines with Bank Account Ledger Entries.
Bank Statement Import
For automatic payment processing and bank reconciliation, you can use a bank file import function to quickly populate the General Journal and Bank Acc. Reconciliation windows based on setup of the involved bank file formats. For more information, see How to: Import Bank Statements.
Payment File Export
You can export payment files from the Payment Journal window to your electronic bank site as the last step in processing vendor payments. You must set up your vendors, bank accounts, and payment methods to export your payment files according to the SEPA standard for credit transfers. For more information, see How to: Export Payments to a Bank File.
Payroll Data Import
You can import payroll transactions sent to you by your payroll provider into the General Journal window to post the transactions to general ledger accounts or bank accounts in connection with paying salaries. For more information, see How to: Import Payroll Transactions.
Web-Service KPIs Based on Account Schedules
To analyze your financial performance, you can set up KPIs based on account schedules, which you then publish as web services. The published account-schedule KPIs can be viewed on a web site or imported to Microsoft Excel using OData web services. For more information, see How to: Set Up and Publish KPI Web Services Based on Account Schedules.
Incoming Document Files
Some agreements that you make with your business partners are not registered in Microsoft Dynamics NAV from the beginning. Instead, the related business document is sent to you, either as an attachment to email, electronic transfer, or as a paper copy that you have scanned to file. This is typical of purchases, where such files represent invoices from your vendors or payment receipts for expenses or small purchases. All received files for these documents must be created as lines in the Incoming Documents window, where you can convert them to document records or journal lines in Microsoft Dynamics NAV for processing or posting. For more information, see How to: Process Incoming Document Files.
Batch Sales Invoices
You can use the Create Recurring Sales Inv. batch job to create multiple sales invoices according to a standard sales code that is assigned to the customers and with posting dates within a valid period defined on the standard sales code. You can also specify a direct-debit payment method and a direct-debit mandate on the standard sales code. The sales invoices that are created with the Create Recurring Sales Inv. batch job will then include information required to collect payment for the sales invoices with SEPA direct debit. For more information, see How to: Create Multiple Sales Invoices Based on Standard Sales Codes.
Document Renumbering on Journal Lines
In all journals that are based on the general journal, the Document No. field is editable so that you can specify different document numbers for different journal lines or the same document number for related journal lines. If the No. Series field on the journal batch is filled, then the posting function in general journals requires that the document number on individual or grouped journal lines be in sequential order.To make sure that you do not receive posting errors because of the document number order, you can use the Renumber Document Numbers function before you post the journal. If related journal lines were grouped by document number before you used the function, they will remain grouped but may be assigned a different document number. For more information, see How to: Renumber Document Numbers in Journals.
Integration with Office 365
If you have signed up for Office 365 and SharePoint Online, you can set up Microsoft Dynamics NAV to connect to these services. Then, when you export Microsoft Dynamics NAV data to Microsoft Excel or other Microsoft Office products, temporary files are stored in your SharePoint Online document library. The documents open using Office Web Apps.
You specify the SharePoint Online site that the company uses in the Online Doc. Storage Config. window, such as https://Cronus.SharePoint.com. You also specify the folder where temporary files are stored, such as Temp or BusinessDocuments. When users send data to Excel, for example, they are asked to sign in to SharePoint Online. The files are stored in their own Office 365 document libraries, such as Cronus-my.SharePoint.com/Documents/BusinessDocuments. If a folder does not exist, Microsoft Dynamics NAV creates a new folder.
Alternatively, you can specify a shared location and a shared account name.
If you have not configured Microsoft Dynamics NAV to use Office 365, Microsoft Dynamics NAV uses installed versions of Office.
For more information, see Integrating with Office 365 and SharePoint Online.