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

Word Templates, Office 2010 and the Maintain Compatibility option

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

A while ago I posted an article on Modifying Microsoft Dynamics GP 2010 Word Templates which demonstrated the basic methods for customizing word templates for Microsoft Dynamics GP 2010.

Continue reading

Dynamics Report Writer is the Best Report Writer in the World cont.

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

This is a follow up post to my earlier post, which demonstrated how Report Writer when combined with the power of Visual Basic for Applications (VBA) was able to create a customisation that would not have been possible with Report Writer alone.

Continue reading

Using Barcodes from the Dynamics GP Report Writer

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

A few months ago, I worked on a support case where we needed to add a barcode to a Sales Order Processing transaction print out.  We were able to achieve what we needed using Visual Basic for Applications (VBA) to handle some of the scripting for us.  I have been meaning to write a blog post on how to make a customization like this for a really long time and have finally got around to it.

Continue reading