Jet Reports Integration with Dynamics NAV 2009 through ODBC Drivers

Jet Reports is a reporting and analytics tool that allows users to create and automate reports in Excel, using data from various sources, including Dynamics NAV. In this blog post, we will explore the steps involved in integrating Jet Reports with Dynamics NAV 2009 through ODBC drivers.

Step 1: Install Jet Reports The first step in integrating Jet Reports with Dynamics NAV 2009 is to install the Jet Reports software. You can download the software from the Jet Reports website and follow the installation wizard to complete the installation process.

Step 2: Set Up an ODBC Connection Once Jet Reports is installed, you need to set up an ODBC connection to the Dynamics NAV database. This involves creating a Data Source Name (DSN) in the ODBC Data Source Administrator on the computer where Jet Reports is installed.

To set up the ODBC connection, follow these steps:

  1. Open the ODBC Data Source Administrator.
  2. Go to the System DSN tab and click on the Add button.
  3. Select the Microsoft Dynamics NAV ODBC Driver and click on Finish.
  4. Enter a name for the DSN and select the database server and database name.
  5. Enter the authentication details for the database and click on Test Connection to verify the connection.

Step 3: Create a Jet Reports Data Source After setting up the ODBC connection, you need to create a Jet Reports data source to connect to the Dynamics NAV database. This involves specifying the ODBC connection details and selecting the tables and fields to be included in the data source.

To create a Jet Reports data source, follow these steps:

  1. Open Jet Reports and go to the Data Source Designer.
  2. Click on the New button to create a new data source.
  3. Select the ODBC option and enter the DSN name and authentication details.
  4. Select the tables and fields to be included in the data source and specify any filters or sorting criteria.
  5. Save the data source and test the connection to verify that the data is retrieved correctly.

Step 4: Create a Jet Reports Report Once the data source is set up, you can create a Jet Reports report using the data from the Dynamics NAV database. This involves selecting the data source and designing the report layout using Excel.

To create a Jet Reports report, follow these steps:

  1. Open Jet Reports and go to the Report Designer.
  2. Select the data source created in the previous step.
  3. Drag and drop the fields from the data source into the Excel sheet to create the report layout.
  4. Add any formatting, calculations, or other elements to the report as needed.
  5. Save the report and schedule it to run automatically or run it manually when needed.

Conclusion In conclusion, integrating Jet Reports with Dynamics NAV 2009 through ODBC drivers involves setting up an ODBC connection, creating a Jet Reports data source, and designing a report using Excel. By following these steps, users can retrieve data from the Dynamics NAV database and create customized reports for analysis and decision-making. Jet Reports is a powerful tool that can help businesses streamline their reporting processes and improve their operational efficiency.

Web Portal Research for Users to Place Orders for Computer Equipment

In today’s digital age, online shopping has become the preferred method for many consumers. This is particularly true when it comes to purchasing computer equipment, such as laptops, desktops, and peripherals. For businesses that offer computer equipment for sale, providing a user-friendly and efficient web portal for customers to place orders is essential. In this blog post, we will explore the key factors to consider when researching web portals for users to place orders for computer equipment.

Ease of Use One of the most critical factors to consider when researching web portals for users to place orders for computer equipment is ease of use. Customers should be able to navigate the portal easily and find what they are looking for quickly. A clean, intuitive interface with clear menus and search functions can help ensure a positive user experience.

Product Catalog The product catalog is another critical factor to consider when researching web portals for users to place orders for computer equipment. The portal should provide detailed descriptions of each product, including specifications, images, and pricing. Ideally, users should be able to filter and sort products based on various criteria, such as price range, brand, and features.

Payment and Checkout The payment and checkout process should be seamless and secure. Users should be able to add items to their cart, review their order, and make payment with ease. The portal should support multiple payment methods, such as credit cards, PayPal, and bank transfers, to accommodate a variety of customer preferences.

Shipping and Delivery Shipping and delivery are essential aspects of any online order. The portal should provide users with accurate shipping estimates based on their location and the products they have ordered. Users should also be able to track their orders and receive notifications when their orders have been shipped and delivered.

Customer Support Customer support is crucial for any online portal. Users should be able to access support easily, whether through email, phone, or live chat. The portal should also provide detailed information on returns and refunds policies, as well as warranty information.

Security and Privacy Security and privacy are paramount when it comes to online transactions. The portal should use secure protocols, such as HTTPS, to ensure that customer data is encrypted during transmission. The portal should also comply with relevant data protection regulations, such as GDPR and CCPA, to ensure that user data is collected, processed, and stored in a compliant manner.

Conclusion In conclusion, when researching web portals for users to place orders for computer equipment, it is essential to consider factors such as ease of use, product catalog, payment and checkout, shipping and delivery, customer support, and security and privacy. By ensuring that these factors are in place, businesses can provide a positive user experience and build trust with their customers. A well-designed web portal can not only increase sales but also help to differentiate a business from its competitors in a crowded online marketplace.

Debugging Issue with Posted Payment Certificate in Customer Dynamics NAV 2018

Microsoft Dynamics NAV 2018 is an enterprise resource planning (ERP) solution that helps businesses manage their finances, supply chain, and operations. One of the key features of Dynamics NAV 2018 is its ability to handle payment certificates, which are documents that provide evidence of a payment made to a supplier. However, sometimes issues can arise when posting payment certificates, and it can be difficult to determine the root cause of the problem. In this blog post, we will explore some common debugging techniques for issues with posted payment certificates in Dynamics NAV 2018.

Step 1: Verify Certificate Information The first step in debugging issues with posted payment certificates is to verify the certificate information. To do this, follow these steps:

  1. Navigate to the payment certificate in question.
  2. Verify that the information on the certificate, such as the supplier name, payment amount, and payment date, is correct.
  3. If there are any discrepancies, correct the information and try reposting the payment certificate.

Step 2: Check Posting Setup The next step is to check the posting setup to ensure that it is configured correctly. To do this, follow these steps:

  1. Navigate to the “Posting Setup” page in Dynamics NAV.
  2. Verify that the account numbers and other posting details are correct.
  3. If there are any discrepancies, correct the setup and try reposting the payment certificate.

Step 3: Check Account Balances The third step is to check the account balances to ensure that they are accurate. To do this, follow these steps:

  1. Navigate to the “Chart of Accounts” page in Dynamics NAV.
  2. Verify that the account balances are accurate and match the payment certificate information.
  3. If there are any discrepancies, correct the account balances and try reposting the payment certificate.

Step 4: Check Posting Date The fourth step is to check the posting date to ensure that it is correct. To do this, follow these steps:

  1. Navigate to the payment certificate in question.
  2. Verify that the posting date is correct.
  3. If the posting date is incorrect, correct it and try reposting the payment certificate.

Step 5: Check for Errors The final step is to check for any error messages that may be preventing the payment certificate from posting. To do this, follow these steps:

  1. Navigate to the “Error List” page in Dynamics NAV.
  2. Check for any error messages related to the payment certificate.
  3. If there are any error messages, address them and try reposting the payment certificate.

Conclusion

Debugging issues with posted payment certificates in Dynamics NAV 2018 can be a challenging task. However, by following the steps outlined in this blog post, you can troubleshoot common issues and identify the root cause of the problem. Whether it’s verifying the certificate information, checking the posting setup, or checking for errors, taking a systematic approach can help you resolve the issue and ensure that payment certificates are posted accurately in Dynamics NAV 2018.

Preparing upgrade from BC 14 to BC 17

This week preparing multiple extensions upgrade from Business Central on prem 14 to 17.

Microsoft Dynamics 365 Business Central is a popular enterprise resource planning (ERP) system used by businesses worldwide. Business Central Extensions are a crucial component of the system as they enable businesses to add new functionality and customize the system to their specific needs. Upgrading Business Central Extensions is an important process that ensures your system is running smoothly and utilizing the latest features. In this blog post, we’ll discuss the steps involved in upgrading Business Central Extensions from version 14 to 17.

Step 1: Review the Upgrade Guide Before starting the upgrade process, it’s essential to review the upgrade guide provided by Microsoft. The upgrade guide outlines the steps involved in upgrading Business Central Extensions and highlights any changes or considerations specific to the upgrade.

Step 2: Take a Backup It’s always a good idea to take a backup of your Business Central environment before proceeding with any upgrades. This ensures that you have a copy of your data in case something goes wrong during the upgrade process.

Step 3: Upgrade the Base Application The first step in upgrading Business Central Extensions is to upgrade the base application to version 17. This is done by importing the new application file into your Business Central environment. Once the application is imported, you will need to compile and synchronize the application.

Step 4: Upgrade the Extensions After upgrading the base application, you can proceed with upgrading the extensions. To do this, you will need to follow these steps:

  1. Identify the extensions that need to be upgraded.
  2. Check if there are any dependencies or conflicts with other extensions or the base application.
  3. Uninstall the old version of the extension.
  4. Install the new version of the extension.
  5. Compile and synchronize the extension.

It’s important to note that some extensions may require additional configuration after the upgrade. For example, you may need to update settings or reconfigure workflows.

Step 5: Test the System After upgrading the extensions, it’s essential to test the system thoroughly to ensure that everything is working correctly. This includes testing the new features and functionality introduced by the upgraded extensions.

Step 6: Go Live Once you have tested the system and confirmed that everything is working as expected, you can go live with the upgraded Business Central Extensions.

Conclusion Upgrading Business Central Extensions is a critical process that ensures your system is utilizing the latest features and functionality. The process involves upgrading the base application to version 17 and upgrading the extensions by uninstalling the old version and installing the new version. It’s essential to review the upgrade guide, take a backup of your data, and test the system thoroughly before going live. By following these steps, you can upgrade your Business Central Extensions with confidence and ensure that your system is running smoothly.

Dynamics NAV 2015 objects migration to Business Central SaaS

As businesses grow, so do their needs for better and more efficient systems to manage their operations. For many companies, Microsoft Dynamics NAV 2015 has been the go-to solution for enterprise resource planning (ERP) software. However, with the introduction of Business Central SaaS, many businesses are now considering upgrading their existing Dynamics NAV 2015 systems to take advantage of the benefits of cloud-based ERP.

But upgrading a system as complex as an ERP can be a daunting task, especially when it involves migrating existing customizations and objects. In this blog post, we will discuss the continuing upgrade of Dynamics NAV 2015 objects migration to Business Central SaaS.

Step 1: Evaluate Your Current Dynamics NAV 2015 Environment

Before starting the migration process, it’s important to evaluate your current Dynamics NAV 2015 environment. This will help you identify any potential issues that may arise during the migration process and help you plan accordingly.

Step 2: Identify Customizations and Objects

Next, identify any customizations or objects that you have in your current Dynamics NAV 2015 environment. These may include modifications to existing forms and reports, custom code units, or new objects that you have created.

Step 3: Assess Compatibility with Business Central SaaS

Once you have identified your customizations and objects, you will need to assess their compatibility with Business Central SaaS. Some customizations may not be supported in the cloud environment or may require modifications to work properly. It’s important to evaluate each customization or object and determine the level of effort required to make it compatible with Business Central SaaS.

Step 4: Upgrade Your Customizations and Objects

After assessing compatibility, you can begin upgrading your customizations and objects. This may involve making changes to the code or modifying forms and reports to work properly in the cloud environment. It’s important to test each customization thoroughly to ensure that it works as expected.

Step 5: Test Your Upgraded System

Once all customizations and objects have been upgraded, it’s important to thoroughly test your upgraded system to ensure that it works as expected. This may involve testing business processes, running reports, and verifying data integrity.

Step 6: Deploy Your Upgraded System

Finally, when you are confident that your upgraded system is ready to go, it’s time to deploy it. This may involve migrating data from your old system to the new one, configuring settings, and training users on the new system.

In conclusion, upgrading from Dynamics NAV 2015 to Business Central SaaS can be a complex process, especially when it involves migrating customizations and objects. However, by following the steps outlined in this blog post and working with a qualified partner, you can successfully upgrade your system and take advantage of the benefits of cloud-based ERP.

Preparing release of Progress Reporting Management app

General

o Introduction of “Sync on Sign out” if an app user is being signed out with unsynced data.

o Visual updates and introduction of new colour schemes across app

Measure

o Introduction of Horizontal scrolling in Measure sheets. (user based permission, can be set based on app user preference in app user setup)

o Introduction of “Company Scope” on Column setup to allow narrowing of companies from drop down lists eg on Cable schedules

Allocation Module

o User based permission to allow exceed clocked values (NAV app user setup)

o Introduction of Data limits for types of resource eg Operatives, 24 and Company, 5000 per day.

o On WBS selection, Introduction of Tree like function to enable user quickly find value. User can search this also

o On System/Asset selection, the system list has a search function aswell as select from list function.

o Both WBS and System Asset also have a feature that shows last selected entry on top of list for repetitive data entry tasks

o The “Company Scope” of Measure columns list will obey the same setup, ie help narrow the list of systems under a resource

o Introduction of cross device sync, all app users can see previous entries from different app users for same Resource

o Introduction of complex entries, app user can add additional entries for same Resource & system, but with different WBS and System/Asset allocations

o Clock value for current day now comes into allocation view, app user can exceed this value, but not for previous days

Diary

o On WBS selection, Introduction of Tree like function to enable user quickly find value. User can search this also

o On System/Asset selection, the system list has a search function aswell as select from list function

o Both WBS and System Asset also have a feature that shows last selected entry on top of list for repetitive data entry tasks

Testing

o Bug fix on rejected test sheet where user could not see rejected sheet on device from which previous test sheet was completed, but could see from different device

Snags

o On WBS selection, Introduction of Tree like function to enable user quickly find value. User can search this also

o On System/Asset selection, the system list has a search function aswell as select from list function

o Both WBS and System Asset also have a feature that shows last selected entry on top of list for repetitive data entry tasks

o Changes to Mandatory fields in snag card inline with QA dept requirements

o Draft Snags (incomplete mandatory fields) will not transfer to NAV and assigned app users

o Search bar now can handle multiple search requests, so for example you can search a Discipline, an Assigned Company and System/Asset by placing a space between key words eg ELEC YR

o New Power BI visual to allow BI users interact with project layouts using assigned WBS for snag locations

Enhancing our Logistics App: Implementing Pallet Labels on Returns

Introduction:

Logistics and shipping companies rely heavily on technology to manage their operations. Mobile ALS app have become increasingly popular for their ability to improve efficiency and accuracy in the field. In this article, we’ll explore how implementing pallet labels on returns can enhance your mobile logistics app and streamline your processes.

Why :

Pallet labels on returns help to identify, track, and manage goods that are returned to a warehouse or distribution center. With the implementation of pallet labels on returns in our mobile app, you can streamline the process of receiving and managing these returns. Pallet labels on returns can help you quickly identify the reason for the return, the customer, and the condition of the goods, among other things.

How :

Implementing pallet labels on returns in a logistics app can be a relatively simple process. First, you’ll need to add the functionality to your app. This may involve working with a developer or using an existing API or SDK to integrate the feature. Once you have the functionality in place, you’ll need to train your staff on how to use it effectively. This may involve creating training materials and conducting in-person or virtual training sessions.

Benefits :

Implementing pallet labels on returns in your mobile logistics app can provide several benefits, such as improving inventory management, reducing errors, and increasing efficiency. With pallet labels on returns, you can quickly and accurately track the condition and location of returned goods, which can help you make better decisions about how to manage your inventory. You can also reduce errors by eliminating manual data entry, which can save time and money.

Conclusion:

Implementing pallet labels on returns in your mobile logistics app is a simple yet effective way to improve your operations. With the ability to quickly and accurately track returned goods, you can make better decisions about how to manage your inventory and reduce errors.

Improving Timesheet Portal: New MVC Actions, CSS Changes, and Integration with Backoffice Project Management

Keeping track of employee hours and project tasks is critical for any business, and a timesheet portal is a great way to simplify this process. In this article, we’ll explore some recent improvements to a timesheet portal, including new model-view-controller actions, CSS changes, and integration with a backoffice project management system.

New actions: Model-view-controller (MVC) is a design pattern that separates an application into three interconnected components: the model (which represents data), the view (which displays data to the user), and the controller (which handles user input). The timesheet portal has been updated with several new MVC actions, such as the ability to add a new timesheet entry or edit an existing one. These actions improve the user experience by making it easier to enter and update timesheet data.

CSS : Cascading Style Sheets (CSS) is a language used to describe the look and formatting of a document written in HTML. The timesheet portal has undergone some CSS changes to make it more visually appealing and easier to use. For example, font styles have been updated to be more legible and a new color scheme has been introduced to provide a more modern look.

Integration : A backoffice project management system is used to manage projects and tasks for a business. Integrating the timesheet portal with this system provides several benefits, such as centralizing project-related information and reducing data entry errors. An employee can now submit a timesheet for a project directly through the integrated portal, which eliminates the need to manually enter data into multiple systems.

Conclusion: Improving your timesheet portal can have a significant impact on your business by making it easier to track employee hours and project tasks. The recent updates to this timesheet portal, including new MVC actions, CSS changes, and integration with a backoffice project management system, provide a more streamlined and user-friendly experience.

Time

“Timesheet Entry Journal” is a great tool that simply gets the job done. Full Stop. 

However.

Our PRINCE-2 methodology PM system is not for just time recording – for that we have used Excel spreadsheets from years ago and could have used them now. The purpose of any management system is to attempt as better planning as possible and record the history of such planning, which then should be used to improve on new tasks. 

That is why we are creating Programmes, Projects, Products and Actions for granular control, management and reporting. And as with any planning, a glance into the future is always quite difficult, because you have to budget time and then adjust it as the project progresses, which is not always applicable and much depends on specific needs.

The correct way in my mind is when I can create a plan for at least two weeks ahead and then update my planned actions as I progress through them. Not only this simplify my goal of tracking my own time, but it also gives the management an overview of what each resource is going to do and allows allocation scheduling onto correct tasks.

Analogy from the standard system is General Journal Line of type Invoice, which when posted produces a General Ledger Entry with amount and date. If you try invoicing either of them to a customer, it won’t go well, because you must have supporting documentation and that’s where sales documents come into play, which also in the end produce General Ledger Entry.

I believe, if you are doing a simple registering of past events and it works for you, it’s good only for you, but if you can plan ahead in a sustainable manner, it’s better for everyone.

Kicking off a Dynamics Nav migration this week

Introduction

Migrating from an on-premises installation of Microsoft Dynamics NAV 2013 R2 to the cloud-based software as a service (SaaS) offering of Microsoft Dynamics 365 Business Central can be a challenging project. However, the benefits of the cloud-based platform, such as ease of scalability, accessibility, and security, make it an attractive option for many businesses. In this blog post, I will discuss the key considerations and steps involved in a successful migration project from Dynamics NAV 2013 R2 to Business Central in the cloud.

Step 1: Plan and Prepare The first step in any migration project is to plan and prepare thoroughly. This includes conducting a thorough assessment of the existing on-premises infrastructure, identifying any customizations or integrations that may need to be migrated or replaced, and selecting the appropriate cloud infrastructure and service provider.

It is also important to identify the key stakeholders and their roles in the project, define the timeline and budget, and establish a clear communication plan to keep everyone informed throughout the migration process.

Step 2: Data Migration The next step is to migrate the existing data from the on-premises Dynamics NAV 2013 R2 installation to Business Central in the cloud. This can be done using a variety of tools and methods, such as the Data Migration Wizard in Business Central, Microsoft’s Data Migration Service, or third-party migration tools.

It is important to ensure that the data is accurately migrated and validated, and that any necessary data transformations or mapping are performed to ensure that the data is compatible with the new cloud environment.

Step 3: Application Migration Once the data migration is complete, the next step is to migrate the customizations, integrations, and extensions from the on-premises Dynamics NAV 2013 R2 installation to Business Central in the cloud.

This can involve updating or replacing existing customizations and integrations to ensure compatibility with the cloud-based platform, and testing and validating the migrated applications to ensure they are working correctly.

Step 4: User Acceptance Testing and Training After the application migration is complete, it is important to conduct user acceptance testing to ensure that the new cloud-based system meets the needs of the business and users.

Training and support should also be provided to ensure that users are familiar with the new system and can effectively use it to perform their daily tasks.

Step 5: Go-Live and Post-Migration Support Once user acceptance testing and training are complete, the final step is to go-live with the new cloud-based system. It is important to ensure that any remaining issues are addressed promptly and that the system is stable and functioning correctly.

Ongoing post-migration support should also be provided to ensure that any issues or questions that arise are promptly addressed, and that users are able to fully leverage the benefits of the new cloud-based platform.

Conclusion

Migrating from an on-premises installation of Microsoft Dynamics NAV 2013 R2 to the cloud-based software as a service (SaaS) offering of Microsoft Dynamics 365 Business Central can be a complex and challenging project. However, with careful planning, thorough preparation, and a well-executed migration plan, businesses can successfully migrate to the cloud-based platform and enjoy the benefits of scalability, accessibility, and security.