Contact us today: (866) 4-WEBSAN (932726) Support

 

In this webinar, Andrew King and Ryan Bennett provide an introduction into Jet Reports and Jet Hub. The discussion features an overview of Jet Reports and Jet Hub, overview of our offering and an in-depth look into sample reports/demo of Jet Reports.

 

Jet Reports is a business reporting solution built for Microsoft Dynamics 365 Business Central which gives you the flexibility to create reports in real-time. This allows for you to get the latest information from your database. Additionaly Jet Reports integrates into excel allowing you to extract real-time data efficiently while also eliminating errors and risk.

 

Jet Hub is an Information Management System that allows business users access to their business reports using virtually any device through a simple web interface. Jet Hub is a complete report management system that can quickly locate the report you are after and additionally allow you to share reports within a secured and governed way . There is also an option to automate the report distribution on a regular basis.

 

Integrating Jet Report for your business provides a package solution that has over 100+ Core Financial Reports along with the option for building customized reports. With Jet Reports, there are no hard-coding or programming skills required so your team can explore data and create or modify reports on their own. With controlled spreadsheets, organized workflows, and built-in collaboration, it is proven to enhance productivity company-wide.

 

For a detailed look at the Core Financial Jet Reports, click the link: https://www.websan.com/images/Implementation/Business-Central-Implementation-Reports.pdf

Published in Dynamics 365
Wednesday, 02 October 2013 00:25

VBA Customization Errors

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

I was recently deploying a number of GP customizations in the model of Forms and Reports with VBA, when I encountered the following error during package importing:

4

I had never seen this error before but upon review of the customized form, I realized that my VBA code failed to import along with the form itself. All users had logged out of the current environment and the customizations had been tested successfully in a test system. I was stumped. One common IT phrase came to mind when deciding on the next troubleshooting step: “Have you tried turning it off and on again?”

Although I did not restart the terminal server, I took to a similar strategy: I wiped all customizations and started clean. This step has worked in the past when users were navigating through customized GP windows, where the application would suddenly crash without warning. The following entry was logged in EventViewer on the server:

3

Any time you experience strange application crashes, or error messages when importing custom VBA packages, chances are there are corrupt dictionaries and VBA files sitting in your Dynamics GP program folders. The following are a number of steps to resolve most of these issues in a short period of time:

1)      Export all custom packages from the instance of GP that you are experiencing said errors. If you imported a package and received an error, ensure that you do not include the half-imported customization within your exportation (you will be importing the necessary package separately).

2)      Backup all DIC and VBA files (only VBA files greater than 4kb in size, meaning they are being used) located in the C:\Program Files(x86)\Microsoft Dynamics\GP2013, and GP2013\Data folders, respectively (this example uses the 2013 version of GP, however the GP2010 version would have a similar file path, and also assumes you are using a 64-bit system, otherwise the path would commence with ‘Program Files’).

1

2

3)      Delete all the backed-up DIC and VBA files from the program folders.

4)      Log into GP with a POWERUSER login and open the ‘Customization Maintenance’ window. You should see a blank list. First, import the package with which you were previously experiencing an issue, and then continue with the exported package from your working environment. Verify that all required custom forms and reports are set in the “Alternate Modified Forms/Reports” menu, and that the annoying '()' brackets are removed from the end of any VBA global modules.

5)      Test all the customized items to ensure that the system is functioning as needed.

With everything backed up, there is no risk when running through these steps if you are puzzled by strange VBA issues.

Sometimes, you just need a fresh start.

Brandon Germaine is an Application Specialist at WebSan Solutions Inc, a Microsoft Dynamics GP Silver Partner 2013 Canadian Channel Elite Awards Winner. Brandon can be reached at This email address is being protected from spambots. You need JavaScript enabled to view it. or 416-499-1235 ext 219.

Published in Microsoft Dynamics GP