Latest Microsoft Dynamics 365 Blogs | CloudFronts - Page 3

Expense management in NAV 2018

Introduction: In previous versions of NAV, employees had to be set up as vendors to post expenses. Now, NAV 2018 allows expenses to be posted against employee cards, with a range of tools to simplify the process. Features: In NAV 2018, in the Account type field a new value of Employee is added. Create Journal entries directly for employees – only supports local currency (LCY) Employee posting group, definable on the employee card. Make payments to the employee in the Payments Journal. Get payment suggestions with a full list of outstanding employee payments. Apply payments to open employee entries in one go, linking the payment to the employee journal entry and closing both. Correct mistakes with unapply payments. Posting a general journal line with Employee as account type or balancing account type will generate an employee ledger entry. When posting a general journal line for an employee, the Document type field must be either blank or set to Payment. Conclusion: This feature is very useful for Reporting purpose as well as to maintain Employee wise details in the system.

Share Story :

Work Description field in Sales Quote in NAV 2017

In NAV 2017, Microsoft have added new field in Sales Area i.e. Work Description, which help users to add details about the Sales Quote and which gets copied over to Sales Invoice. This is the important field for the Sales people to give special instructions which can be used for Production if the goods are to be produced or for Stores department or Dispatch department for trading goods. The field is used to stored detailed information about the Order. There is no limitation on number of characters and it gets copied over to Posted Sales Invoice. It is a small feature in the system introduced in NAV 2017 but can be very useful.

Share Story :

Increase/Decrease Inventory from Item Card in NAV 2017

Introduction: With Microsoft Dynamics NAV 2017, we can increase or decrease the inventory of an item from the item card itself. Steps: 1. Navigate to Item card. 2. Select assist Edit next to Inventory and enter the New Inventory. 3. If New Inventory is less than current inventory a Negative Adjustment will be passed behind the scene. 4. If New Inventory is greater than current inventory a positive Adjustment will be passed behind the scene. 5. As soon as we enter new Inventory and click ok. 6. System Looks for an Item Journal template, Create a New Batch for the Item Journal. 7. Insert a New Item Journal Line with Default Location as Blank. 8.Post the Transaction. Important points to remember: 1. All the Transaction posted with this will always post with Blank Location Code. 2. The process will not work if item is Mandatory Serial / Lot Tracked. 3. Unit of Measure will be picked from Item Base Unit of Measure.

Share Story :

Smart Notifications in NAV 2017

Partially built using the Notifications in the UI the smart notifications gives you advice when you use the application. As an example; if you create a new sales invoice for a customer that have an overdue balance you will see the below notification. Another example is when you close a sales order you receive a message saying that the order has not been posted (I am a bit skeptical to this one since in my world posting a sales order is not done by the same person that’s entering it). Luckily this is configurable and each user can turn the features off and on through the My Notifications setup where conditions also can be applied. I think this is a cool concept and I see a potential to create custom notifications to support how the business wants to operate and to reduce common user mistakes.

Share Story :

New fields in Sales & Receivable Setup in NAV 2017

As NAV 2017 introduced new features, they have added some fields in Sales & Receivable Setups. These fields are explained below : Following new fields are added in the Sales & Receivable setup as compared to NAV 2016. Default Item Quantity Create Item from Description Allow Document Deletion Before The functionality of these fields are explained below : Default Item Quantity : By default it will not be checked.  If the user checks it then, the default quantity in a sales line will automatically be set to 1 . (This will work only if the Type in the Sales Line is Item). Create Item from Description:  By default it will not be checked.  If the user checks it then, while entering Item description in Sales Line if the system is unable to find the same description in Item master, the system will prompt the user to create a New item or Select an Item From Existing List, as shown below. 3. Allow Document Deletion Before: If the date is provided in this field, system will allow to delete the document (Invoice & credit memo) only after checking the posting date which should be before the date provided in these field. This features might be very small but are very useful in day to day activities  by the user.

Share Story :

Item Categories in NAV 2017

Dynamics NAV 2017 gives the possibility to define own product attributes (e.g. colour or size) and assign them to the corresponding item, so the user can refine and structure his article range much better. Till NAV 2016 Item Categories were a simple List Where we can specify the Categories and some other default parameters but in NAV 2017 user can specify attributes in the Item categories. 1. In the Global Search, search for Item Categories. 2. User can define attributes in Item categories. 3. An Attribute assigned to the Parent will automatically get assigned to the Child Item Categories. Item categories also ensure a better hierarchical structuring of the items. While the previous version of the ERP system only offered one main and one hierarchical level, the Dynamics NAV 2017 version will enable multiple hierarchy levels to be added to the main hierarchy level, which can be defined specifically and in multiple languages. Items can be accordingly allocated to the respective categories. This feature ensures consistency across related items, saving considerable amounts of time during allocation.

Share Story :

Selecting Multiple products for Sales in D365 for operations

Dynamics 365 for finance and operations is an ERP system built and designed to match your business needs in this modern day business scenario. Elements are currently as much a business system as it is innovation deliverable, some portion of a bigger biological system where data pulled from unique channels, (for example, social, IoT, and Office) is caught, investigated, and spread so as to help explicit business objectives. Make planning simpler by giving your spending chiefs simple to-utilize apparatuses. A wizard causes them to make spending plan worksheet formats for Microsoft Excel.  This cloud-based ERP framework gives the pertinent data you have to convey vital, information-driven bits of knowledge to key divisions. Additional quick monetary bits of knowledge drive corporate procedure and development, declining obligation through effective assortment of the board. Generally, users spend lot of time in selecting each product and their variants for sales in Sales order. Dynamics 365 for operations gives option to select the product by category. Following is the process to select multiple products and their variants in a quick way: 1. Create a new Sales Order 2. Click on Add products in Sales Order Line 3.  A new form will open which is divided in to three parts Select category – To select the respective category Available Products – It shows all the products available in the selected category Add Selected products- The products which are selected for the Sales order 4.  Once the category is selected, select the product and click on Add variants to select the variants for that product. 5.  A new form will open listing all the variants for that product. The user can select all the variants by checking on Select all or can select specific variants and can put quantity. 6.  On clicking OK , all the products selected with their variants will come in the sales line. Conclusion : In this way the user can save lot of time in creating Sales order having multiple lines.

Share Story :

Setting Up Ceridian Payroll Extension in D365 for Finance and Operations

If you are planning to get Dynamics 365 for finance and operations, that is an excellent thing. It is wise to plan on getting it as soon as possible. It is an Enterprise Resource Planning (ERP) solution from Microsoft. Entrepreneurs that want their company to scale up high in a few years prefer to get this software.  It is apt for companies that are small and medium-sized. But, even large companies can use it to their benefit. While indeed, so many companies are creating ERP solutions. Nothing comes close to Dynamics 365.  The best part is that it is easy to install and configure than any other ERP solution you can find in the market. The pricing of this software is quite reasonable. Here is a solution to one of the common problems that you might face.  To account for salary payments and related transactions, you must import and post financial transactions made by payroll provider to the general ledger. The extension has been provided in Extension Market place for Importing of Ceridian Payroll Entries. The Ceridian Payroll extension allows you to import payroll transactions from the Ceridian HR/Payroll (US) and Ceridian PowerPay (Canada) services. Please find below the steps on how to install extension and import payroll entries in Financials: In the top right corner, choose theSearch for Page or Report icon, enter Extension, and then choose the related link. Click on Extension Marketplace. Select Ceridian Payroll from the list of apps. Click on Install Once it is installed user needs to logout of the Financials and log in to see the changes. Once the extension is installed the user can now import payroll entries into the system. To Import a file that is received from payroll provider user needs to map the external accounts in the payroll file and then open General Journal by searching in global search. In the General Journal, on the Action tab user needs to click on Import Payroll Transactions. Click on Next to proceed importing transaction. System will ask to provide the path of the file. Once the file is uploaded in the system User can post the general journal. Conclusion: The Ceridian payroll extension helps in reducing time and effort to create manual payroll entries in system and eliminates human error.

Share Story :

Importing Budgets using Excel in Dynamics 365 for Financials

Dynamics 365 for finance and operations is a product from Microsoft. It is an ERP or enterprise resource planning software. Both medium and large companies can benefit from using this ERP solution. Companies can streamline the processes in the finance and operations functions. You will get a detailed view of what’s happening in departments such as warehousing, manufacturing, finance, budget planning, IT, demand forecasting and transportation to name a few.  It is very easy to install and use this ERP solution. But, if you are a new user, you might struggle initially as you do not know how to operate the system and to get what you want on it. For example, you might not know how to import the budget using excel in this application. Dynamics 365 for Financials has a feature of defining Budgets for chart of accounts. The budgets can be defined in a multiple combination using dimensions and periods. Generally, companies have a huge list of Chart of Accounts and it becomes difficult to create budget for each chart of accounts in the system. Thus, Microsoft has provided a tool to import budgets in Dynamics 365 for Financials using Excel. Following are the steps to import budgets: In the global search, search for G/L budgets and click on it. Click on new to create a new budget. Provide a name & description to the budget and then click on Edit budget. Once the budget is created, go to Action tab and click on Export to Excel. On clicking of Export to excel, system will ask for Start date, No. of periods in budget and Period length. This data will be useful to design the budgets. (For e.g. Starting from 1st February 2017 I need to create a two-monthly budget for petty cash, then I will select start date as 01/02/2017, no. of period would be 2 and period length would be 2M). Once OK is clicked, an excel file will be downloaded in the system. Open the excel file and put the amount against the respective ledger and save the file. Once the file is saved, click on Import from Excel in the Action tab. The system will ask the Budget name which will be the newly created budget. There are two options available either to replace entries if there are any entries created previously or to add new entries if the user needs to append already created budget. On clicking of OK, the system will ask the path where the excel file is stored. After providing the path system will automatically either replace or add entries to the budget (depending on the option selected). Conclusion D365 for financials is a very good product for Small and medium size enterprises. The import budget features can become a very effective tool to design complicated budgets in the system within very less time.  

Share Story :

Cross Company Depreciation

In Dynamics 365 for Operation, user can now start a depreciation run for assets across all legal entities from a single page. There is also a new option to automatically post the journals after they are created. The creation and posting of the journals can be sent to batch processing, allowing the depreciation to run in the background. Before running the Depreciation proposal, the user needs to do some setups in Fixed Asset Parameters. (Fixed Assets->Setups->Parameters). The user needs to add the journal names in the Fixed Asset Proposal with the respective Posting layer. This exercise needs to be done in all the entities for which depreciations needs to be ran. Once the setup is done, user can run the Depreciation proposal. (Fixed Assets->Journal Entries->Create depreciation proposal). In the Legal Entities dropdown, user will see the list of all entities where the initial setup of Journal names in parameters was done. The user can select all the entities or an entity based on his requirement of calculation and posting of depreciation. After selection of entities if the user requires that the entries should be posted automatically, he can just activate the Post journals button. This will calculate the depreciation and post all the required entries of depreciation. The user can also set the batch which will then run this process in background based on schedule and recurrence in batch. Conclusion These enhancements reduce the inefficiencies of starting individual depreciation runs separately for each company, as well as better centralized management of all the fixed assets.  

Share Story :

SEARCH BLOGS:

FOLLOW CLOUDFRONTS BLOG :


Secured By miniOrange