GP Transaction Search: Series Index

Precipio ServicesSteve Endow of Precipio Services has recently launched a GP Transaction Search. The initial version is a PM Transaction Search which replaces the Transaction by Document window (Purchasing » Inquiry » Trx by Document) in the Purchasing series.

Over the next few posts, I’m going to be taking a look at the origins, installation, configuration, use and future of this add-on.

Implementing Jet Enterprise: Implementing Jet Professional

Jet ReportsThis post is part of a series of posts on implementing Jet Reports and is part of the Jet Enterprise sub-series.

No, the title is not a mistake. When you purchase Jet Enterprise, you also get a licence for Jet Professional. This ensures you get the full reporting capability available from Jet Reports. It also means that as well as following my series on Implementing Jet Enterprise, you should also follow the series on Implementing Jet Professional.

In the last post, on the Jet Enterprise sample reports, I said you could use the reports for both Jet Professional and Jet Enterprise, but forgot to say how. The how is because you have access to Jet Professional if you install it.

Implementing Jet Enterprise: Sample Reports

Jet ReportsThis post is part of a series of posts on implementing Jet Reports and is part of the Jet Enterprise sub-series.

As with the other versions of Jet Reports, there are sample reports available from Jet Reports. Back in May I posted about the sample reports for Jet Professional.

The download for Jet Professional and Jet Enterprise is the same one; with jet Enterprise all of the files in the download will be able to be used.

To download the use the reports, follow the instructions in the Jet Professional sample reports post.

Remove Yellow Background from Google Adsense Adverts

Microsoft Dynamics GPI’ve been hosting adverts from Google Adsense for a while and, after my last site redesign, I started using responsive adverts which scale according to the size of the browser window (or device size).

Since then, I’ve had yellow background showing either side of the adverts:

Adverts with yellow bars

The other day, I finally had time to track down and fix the issue. The html code for the adverts, which is supplied by Google, places the adverts within an ins tag and a class of adsbygoogle (see two highlighted sections):

...<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
				<!-- azurecurve Responsive Leaderboard -->>
				<ins class="adsbygoogle"
					 style="display:block"
					 data-ad-client="{adsense publisher id}"
					 data-ad-slot="5299901990"
					 data-ad-format="auto"></ins>
				<script>
				(adsbygoogle = window.adsbygoogle || []).push({});
				</script>...

The yellow background is the default colour used by WordPress for ins tags; so to remove it, all you need is a snippet of css in your stylesheet:

ins.adsbygoogle {
	background: transparent;
}

With the css saved, the yellow background disappears:

Integration Manager Bugs Fixed in Microsoft Dynamics GP 2018

Microsoft Dynamics GPEarlier in the year we added a new ERP Support Analyst to our support team and we’ve been doing training to bring him up to speed. While I was doing Integration Manager training, I was giving him some cuationary advice about error messages and tried to reproduce some of the annoying errors I’ve encountered in the past, only to find out that three of them have been fixed without me realising.

The fixes are:

Dynamics GP Transaction Search v1.0 is Available! For FREE!

Microsoft Dynamics GPMVP Steve Endow, on the Dynamics GP Land blog, has announced the release of a new Dynamics GP Transaction Search window for all versions of Microsoft Dynamics GP from version 2013 onwards.

The intention of the new window is that it replaces the Transaction by Document (Purchasing >> Enquiry >> Transaction by Document) window; the default version can be very slow and only allows you to search by one criteria (Document Number).

In contrast, Steve’s new PM Transaction Search window allows you to search on a date range, Vendor ID, Vendor Name, Document Number and range of values, all at the same time:

PM Transaction Search

The new window is also available from Additional menus on several windows including Vendor Maintenance (Purchasing >> Enquiry >> Vendor)

The initial release includes the PM Transaction Search, but Steve has intentions that more search windows are added to other modules and series in Dynamics GP.

Best of all, this new search is absolutely free.

Steve also plans to open source the window so that other people in the Dynamics GP community can contribute.

The Precipio Services website will be updated, but, until then, you can download it from Steve’s blog.

Sample SQL Views for SmartLists (by Jen Kuntz)

Microsoft Dynamics GPI occasionally link to blog posts that other people have done and todays post is one of these.

Jen Kuntz is running a TIP Tuesday series of posts at the moment and her tip this week is looking at a set of SQL views from Microsoft (originally posted by Isaac Olson).

As Jen points out, while Microsoft bill these as for use with SmartList Designer, they will work with SmartList Builder or any other reporting tool (Excel Reports, Reporting Services Reports and so on).

To make use of these SQL views, you do need to have a CustomerSource login to download them and knowledge of creating views and granting permissions.

My addition to this would be a reminder that there are lots of other resources available from the wider community which can be freely amended and used in reporting, such as from Victoria Yudin.

You can read Jen’s full post here.

I try to keep up-to-date with blog posts about Dynamics GP, but the post from Isaac apparently went by without me seeing it, so it was good to get a second chance at reading about it from Jen.

** updated due to wrong name

Implementing Jet Enterprise: Schedule Execution Package

Jet ReportsThis post is part of a series of posts on implementing Jet Reports and is part of the Jet Enterprise sub-series.

The final step in automating the deploy and execution of the project, is to create the scehdule. Do this in the Jet Data Manager Server by selecting the Execution tab, right click on the execution package to which you want to add the schedule and then click Add Schedule:

Jet Data Manager Server: Execution

Continue reading “Implementing Jet Enterprise: Schedule Execution Package”

Implementing Jet Enterprise: Test Execution Package

Jet ReportsThis post is part of a series of posts on implementing Jet Reports and is part of the Jet Enterprise sub-series.

In the last post, I stepped through the creation of an execution package; I am going to set this to execute automatically on a schedule, but first I am going to manually run it to ensure that it works.

To test the execution package, select the Execution tab, right click on the execution package to test and click Execute:

Jet Data Manager Server: Execution

Continue reading “Implementing Jet Enterprise: Test Execution Package”

Implementing Jet Enterprise: Create Execution Package

Jet ReportsThis post is part of a series of posts on implementing Jet Reports and is part of the Jet Enterprise sub-series.

To automatically update the Jet Enterprise cubes, we need to create an execution package.

To do this, select the Execution tab, right click on the Execution {Package node and click Add Execution Package:

Jet Data Manager Server: Execution

Continue reading “Implementing Jet Enterprise: Create Execution Package”