Copying Report Formats between Reports… and a warning about Word Templates

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

There is an unsupported method of copying report formats between reports that is very commonly used (and even recommended by me), but we recently had a case that highlighted a problem with the technique. This blog post will discuss the method and the issue we have seen.

 

Continue reading

The Dynamics GP Blogster works with Report Writer and the Support Debugging Tool

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

My great friend Mariano Gomez, The Dynamics GP Blogster, has been busy recently creating some fantastic step by step posts on customising reports using Report Writer.

Continue reading

Getting data from ISV tables onto reports without needing to create alternate reports

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

As a Dexterity developer, I have written a number of customisations to Microsoft Dynamics GP which add additional fields to the system. These additional fields are often have a relationship to existing data in Dynamics GP.

It is quite common to store the additional data in a parallel table (sometimes called companion or shadow table). This is a table having same primary key as an existing table, with the additional fields.

Continue reading

How to display more than 80 characters of an Extender Long String field in reports using the Support Debugging Tool

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Here is another support case that was resolved simply and quickly using the Support Debugging Tool.

The customer was using Extender to add an additional comment to the inventory stock transfer transaction. They created an Extender ID “ST_COMMENTS” and used the Long String field type in Extender which is a 255 character string. This worked fine.

Continue reading

Quick Tip: Table Hierarchy Inconsistency Errors in Runtime Mode

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Following on from yesterday’s post: Quick Tip: Creating Dexterity System Variables, I want to cover a related issue.

This is when a Dexterity developer is creating a report (either new or alternate) which will display data from newly added tables. To get the data to show on the report the developer creates a table relationship from an existing Dynamics table to their newly added table.

Can you spot the problem yet?

Continue reading

How to calculate Aging Buckets based on documents shown on a Receivables Statement

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I had a case a couple of weeks back, where the customer wanted to filter the transactions shown on a Receivables Management Statement. There was one type of transaction that they did not want included on the statements sent out to the customers. The transactions to be excluded could be identified by a particular value on the Description field on the transaction.

Continue reading

Troubleshooting Named Printers Issues

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I am working on a Named Printers issue at the moment and thought it would be a good opportunity to put some standard troubleshooting steps on the blog.

Quick history: I originally developed Named Printers back on version 3.0 when I worked for the selling ISV partner, Sequel Technology, and later sold the module to Great Plains Software for version 5.5 and it became part of the core Dynamics.dic code for 6.0.

Continue reading

How to add Item Category Long Descriptions to reports using the Support Debugging Tool

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I am currently working on a support case where the customer is making use of the six user defined categories for items. That in itself is nothing remarkable or worth blogging about.  However, they are using Long Description field on the Item Category Setup window and wished to include the data from this field onto reports. That’s the difficult bit.

Continue reading

Accessing Internet Information from Report Writer

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Last week, I had a call from a partner asking how could they access data stored on the Internet Information window.

This is the window opened with the little italic i symbol next to the Address ID field for Company, Customer, Employee and Vendor Addresses as well as next to Employee ID and Salesperson ID fields.

Continue reading

Keeping Word Templates in synch with Report Writer

Dave Dusek - Click for blog homepageThis is a reposting of an article Dave Dusek originally wrote on my Developing for Dynamics GP blog.

If you are working with a specific report in report writer, and you are also using a word template to print the report, one thing that you have to keep in mind is that the report writer fields have to be in synch with the content controls on the word template.  If they are not in synch what happens is that nothing will print in the content control on the word template, not even XX’s.  So you need to go through a process to get the report writer report synched up with the word template.  Here is that process.
Continue reading

Report Prints Incorrectly When Choosing the PDF File Format As The Report Destination

Allan Cahill - Click for blog homepageThis is a reposting of an article Allan Cahill originally wrote on my Developing for Dynamics GP blog.

I recently worked on a PDFWriter printing incident with a Customer and we ran into a format problem when choosing the PDF File format.

The Problem

Since performing an upgrade to Microsoft Dynamics GP 2010, the Customer was having an issue when printing a single page invoice, in this instance, the SOP Blank Invoice Form.  When choosing the PDF file format as the report destination, the invoice was splitting over 2 pages for a single page invoice i.e. the standard report prints with the vertical lines extended past the border in the footer or with the Customer’s modified report, the page is moved up and report was splitting to multiple pages.

Continue reading

Word Templates will not print to screen

Dave Dusek - Click for blog homepageThis is a reposting of an article Dave Dusek originally wrote on my Developing for Dynamics GP blog.

A common scenario that has been happening more and more is that a customer is trying to print out a word template just to the screen and the template won’t print.  You will get a window called “Report Processing Status” and the report will be there and it will list a status of “In Progress” and it just won’t ever print.  Another symptom of this issue is if you go to the Report Template Maintenance window and select a template and click Modify.  You will get an error “File not found” and it will give the path to the template.

Continue reading

Word Template Debugging

Dave Dusek - Click for blog homepageThis is a reposting of an article Dave Dusek originally wrote on my Developing for Dynamics GP blog.

Recently, I have been looking a lot of Word Template cases – I’m the primary Escalation Engineer on that feature.  Since Word Templates are new to GP 2010, I want to get some blog articles written on some of the common issues we are running into.  So this will probably be a series of Word Template posts.

Continue reading

Printing the same Current Amount value on the RM Statement Reprint as on the original RM Statement

Marian Verzosa - Click for blog homepageThis is a reposting of an article Marian Verzosa originally wrote on my Developing for Dynamics GP blog.

Hi everyone.

I wanted to share with you a recent support incident that I worked on. The cause of the issue was one of those weird issues that took a while to track down.

Continue reading

Working with Vertical Lines in Report Writer

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

If you have ever used the SOP Blank Invoice Form or the POP Purchase Order Blank Form in Microsoft Dynamics GP, you will have seen the vertical lines on the report which make up the boxes around the various sections of the report.  This article explains how those vertical lines work and how to easily make changes to them.

Continue reading

Adding more comments to SOP Documents

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

In keeping with my recent theme of Microsoft Dynamics GP Report Writer related articles, I thought I would post an example of how to get more comment lines showing a SOP Document.  This is a follow on from the Working with Text fields in Report Writer post.

Continue reading

Working with Text fields in Report Writer

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

This post will explain what is and is not possible when working with fields of text datatype in the Microsoft Dynamics GP Report Writer.

The text field datatype in Dexterity allows multi-line text to be entered up to a maximum length of 32,000 characters.  A shorter keyable length maybe defined when the field is defined in Dexterity.

Continue reading