Har du brug for hjælp?
Tag fat i os og lad os sætte et møde op, så kan vi snakke om, hvad vi kan gøre for dig og din forretning
Preparing for Year-End Role Tailored Client (RTC)
Valuta
Year-end in Dynamics NAV RTC
Exchange rates
If exchange rates are used, these should be regulated before a year-end statement is made. If currency is not used or the rates posted are always valid, this section may be skipped.
The exchange rate regulation ensures that an adjustment is made if rates have changed since the accounting of accounts receivable, creditor, financial or bank items.
The run can be found under Departments -> Financial Management -> Periodic Activities -> Currency
Start date: This field is usually not filled in, but you can enter a date to indicate the start of the period in which the records will be regulated.
End date: Here you can specify the last date for regulation of records. This date is usually the same as the posting date in the Posting date field.
Accounting description: Here you can type a text for the financial records that will be created at runtime. By default, exchange rate adjustment of %1 %2 is proposed, where %1 is replaced by the currency code, and %2 of the currency amount that is regulated, i.e. the text could be: Exchange rate adjustment of DEM 38,000.
Posting date: Here you can specify the date on which the financial items should be posted. This date is usually the same as the end date in the End Date field.
Attachment No.: Here you can specify an attachment number to display on the financial records that are created at run time.
Regulate debtor, creditor and bank accounts: Select the check box here if you want to regulate for currency fluctuations in debtor, creditor and bank accounts.
Regulate financial accounts for extra rapp.currency: Here, check the box if you post in an additional reporting currency and you want to regulate the financial accounts for currency fluctuations between the relevant accounting currency and the additional reporting currency.
Click OK to start the run. If you do not want to use the run, click Cancel to close the window.
Cost pricing and inventory regulation
In order to ensure that the inventory value is calculated correctly, the cost of the goods should be regulated. This can either be set up to happen automatically under Inventory Setup, or it can be done intermittently by running built-in runs in Microsoft Dynamics NAV.
If no goods are used, this section may be skipped.
First, run the run “Adjust cost price — commodity porter”. This ensures that the cost prices posted in the financial statements are up to date after you complete the run.
The execution can be found under Departments -> Financial Management -> Inventory -> Tasks
Once the cost prices have been adjusted, the run “Post inventory regulation” is run, which can be found under Departments -> Financial management -> Inventory -> Reports and Analysis -> Cost calculation
The Help for both reports provides a detailed description of what they do.
End of financial year
To be able to finish the year, start by finishing the periods of the year. This is done under Departments -> Financial Management -> Periodic Activities -> Fiscal Years -> Accounting Periods
NOTE: Once a period has ended, it cannot be reopened.
Click on the “End Year” button. It will display the following message:
Fiscal years end in sequence, so if there are periods from previous ones that have not been closed, these will be closed first.
Storage periods can be opened and closed as needed.
Resetting income statement
After that, the result must be transferred to the balance sheet. This is done by unwinding the run “Reset income statement”, which is located under Departments -> Financial management -> Periodic activities -> Financial year
This run will look at the balance of all accounts that are of type Income Statement and make a draft of an End Date. This date does not relate to the old or new financial year and is used solely for accounting for the reset.
Fiscal year end date: Here you can specify the last date of the completed fiscal year. This field must be completed. It is used by the program to determine the end date.
Financial journal type: Here you can specify the name of the financial journal type in which the records will be placed. Click the AssistButton on the right to view the existing ledger types.
Financial journal name: Here you can specify the financial journal name to place the records in. Click the AssistButton on the right to view the existing financial journal names.
Attachment No.: If you have filled in the Financial journal type and Financial journal name fields, this field is automatically filled at runtime with the next available number from the number series to the journal name. You can also fill in the field manually.
Profit account: Specify the account in which profit records will be placed. Click the AssistButton on the right to select the account.
Posting description: Here you can type the text that the entries should be provided with. By default, Reset income statement is suggested.
Reset per. Konc.Enterprise Code: Select the box to create a record for each conc.Enterprise code.
Reset per. Dimensions: To create an entry for each dimension used in the financial account, click the AssistButton on the right and select codes for the dimensions.
If you want to be able to report on dimensions, e.g. Balance reports, so it is important that this field is filled in with the dimensions you want to report on. This could be a department, for example.
The inventory period is closed: This field indicates that storage periods with end dates that are the same as or later than the last date of the accounting period are closed.
If you do not want to close by group companies or dimensions, only one record is created for each account.
Click OK to start the run. If you do not want to use the run, click Cancel to close the window.
The formed draft is reviewed and posted. It is only in the accounting process that the reset itself occurs.
After the accounts have been completed and reset, it is still possible to make postings.
Postpostings shall be accounted for on the date they relate to in the period ended. And the run Reset income statement again and the journal is posted.
These financial items will be marked in the “Postage” field and can therefore easily be found again.
Du skal også være velkommen til at læse videre
Vi opdatere løbende med indsigter, som du kan blive inspireret af
Integration between Salesforce and Dynamics NAV
Get an overview of how integration between Salesforce and Dynamics NAV streamlines data exchange and strengthens collaboration between sales and finance departments.
At a time when digitalisation and automation are crucial to the competitiveness of companies, it is essential to ensure that business-critical systems work seamlessly together. At VisionPeople, we specialize in creating integrations between Microsoft Dynamics NAV and other systems — including the market-leading CRM solution, Salesforce. This article delves into how the integration between Salesforce and Dynamics NAV can optimize workflows, create visibility, and ensure that sales and finance departments work on a common data base. Why integrate Salesforce and Dynamics NAV? When sales and marketing teams work in Salesforce with leads and sales leads, it is crucial that this data can be exchanged with the Dynamics NAV financial system. A tight integration means that the customers you work with in Salesforce are also those billed from NAV. This ensures that all relevant departments have access to up-to-date and consistent customer information.With the integration, revenue and other financial ratios from NAV can be automatically transferred to Salesforce. It gives the salespeople a complete overview of the customer's financial history directly in the CRM system, which strengthens the sales work and enables more targeted customer dialogue.
This is how the integration works
VisionPeople has developed a seamless system integration between Salesforce and Dynamics NAV, based on web service calls from NAV. This solution makes it possible to automate a number of key processes:
- Automatic creation of leads and orders: When new leads or orders are created in Salesforce, they can be automatically created in Dynamics NAV. This means that customers are quickly and efficiently prepared for invoicing in the financial system.
- Synchronization of financial ratios: Revenue figures and other relevant data from NAV can be exchanged with Salesforce so that the sales department always has access to up-to-date information about the customer's purchase history and financial status.
- Common data bases: Integration ensures that both the sales and finance departments work from the same data, minimizing the risk of errors and duplication.
Benefits of integration
A well-functioning integration between Salesforce and Dynamics NAV creates a number of benefits for the company:
- Streamlining work processes: Automating data exchange reduces manual input and frees up time for value-adding tasks.
- Better overview: Sales people access financial ratios directly in Salesforce, strengthening the decision-making base and enabling more qualified customer service.
- Faster billing: New orders from Salesforce can be quickly created in NAV, so invoicing can be initiated without delay.
- Data Quality: Consistent and up-to-date data across systems minimizes errors and ensures that all departments work with the same information.
Technical foundation
The technical foundation of the integration is web service calls from Dynamics NAV. This approach ensures a robust and flexible integration that can be adapted to the specific needs of the company and the existing system landscape. The solution has been developed with a focus on stability, security and scalability to support both small and large businesses.
Business Central as a CRM system — Manage customer relationships and processes
Discover how Business Central can be used as a CRM system and bring together finance, sales, marketing and customer data in one place — with integration for apps and software.
What is CRM and why is it important?
CRM (Customer Relationship Management) is about building, maintaining and leveraging strong relationships with the company's customers. A good CRM system provides an overview of customer data, sales processes, marketing activities and service, so you can create more value for both customers and business. In a modern business, CRM is not just an application, but an integral part of business processes — and this is where it can Business Central make a difference.
Business Central as a CRM system
Microsoft Dynamics 365 Business Central is much more than a financial system. With built-in CRM features, you can:
- Get an overview of all customer data, contacts and history
- Manage sales processes, quotes, orders and follow-ups
- Segment customers and target marketing efforts
- Automate tasks and processes across sales, finance and service
- Integrate with Office 365, Outlook, and other Microsoft products
Business Central makes it easy to gather all relevant information in one place, so your employees can work efficiently and provide customers with a better experience.
Extensions and integrations — get even more out of CRM
Business Central can be expanded with a wide range of apps and software that make CRM work even stronger. Examples:
- VisionDocumentDispatch — Automate and configure the sending of documents to customers and partners directly from Business Central.
- VisionExpense — Integrate expense management and have all attachments and expenses linked to customer data and projects.
- VisionImport — Import and consolidate customer data from other systems so you always have up-to-date and correct data.
- Business Central — Learn more about standard functionality and customization options.
- Power BI — Visualize and analyze CRM data and sales performance directly from Business Central and give insights to the sales people
Benefits and Best Practices
- Get a unified system for finance, sales, marketing and service
- Avoid duplicate entries and errors with automated data flow
- Enhance data quality and improve reporting
- Give employees an easy-to-use tool they already know from the Microsoft universe
- Scale and customize the solution with apps and integrations as needed
Conclusion
Business Central is a strong foundation for CRM in modern companies. With the right apps, integrations and best practices, you can bring all processes and customer data together in one place — creating more value for both customers and business. Contact VisionPeople for advice on how to get the most out of Business Central as a CRM system.
Upgrading to new version of Dynamics NAV or Business Central
Get an overview of the benefits of upgrading to the latest version of Dynamics NAV or Business Central.
Upgrading to new version of Dynamics NAV or Business Central
Is your business still on an older version of Dynamics NAV? Upgrading to the latest version gives you access to the latest features, enhanced security, and integration with modern Microsoft solutions.
Advantages of upgrading:
- Better user experience and role centers
- Stronger integration with Office 365 and the Power Platform
- Improved reporting and analytics
- Greater flexibility and scalability
Vision People helps you securely throughout the upgrade process — from analysis of current solution to implementation and training of employees.
