Report Used for the Reprint Check Remittance

Microsoft Dynamics GPMicrosoft Dynamics GP 2013 saw the introduction of the ability to reprint the check remittance report. This feature was a very nice one to see, as numerous clients, if not all of them, had been asking for.

At some point after this, and I am not sure in which version, the ability to email the reprinted remittance was introduced:

Payments Payable Zoom

Continue reading “Report Used for the Reprint Check Remittance”

MDGP 2016 R1 Feature of the Day: Word Templates for Batch Approval Workflow

Microsoft Dynamics GP 2013 R2 saw the introduction of the Workflow 2.0 (which was the subject of my fourth book. Workflow 2.0 was enhanced further in both Microsoft Dynamics 2015 R1 and R2, and is again being improved in Dynamics GP 2016 R1.

This time, the enhancement is a twofold one. Firstly, the Batch Edit lists have a default Word Template and, secondly, this can be emailed to the workflow approver:

Workflow Maintenance

Edit List Report

The main features of are:

  • Workflow Batch Approvals now have a default Word Template for the following edit lists:
    • General Ledger Batches
    • Payables Batches
    • Receivables Batches
  • Can be emailed to approver for complete information before approving

I think this feature will prove to be popular with those clietn using Workflow approvals as an approver will always want s much information before approving as possible. This will likely be of great interest when Workflow approvals are being used.

Click to show/hide the MDGP 2016 R1 Feature of the Day Series Index

Transfer Old RM Statement Emails to New Email Fields

Microsoft Dynamics GPI’ve been involved with a recent upgrade of Microsoft Dynamics GP 10 to 2015. Two of the new features we helped introduce is the use of Word Templates and the Email Documents to replace the old statement email functionality which was dependent on Adobe Writer.

To help the client make the transition from the old to the new, I created an SQL script to transfer the email addresses from the table, RM00106 (RM Statement Emails) used by the old Adobe Writer to the SY01200 (Address Email Master) used by the Email Documents functionality.

Continue reading “Transfer Old RM Statement Emails to New Email Fields”

Word Templates XML Update – Make Sure Word Is Closed Before Modifying

Microsoft Dynamics GPWe had a peculiarity the other day when updating a Word template for a client. We added some new fields via Report Writer and then created a new Word Template; when then modifying the Word template the fields usually show in the XML schema, but this time we found they weren’t.

After a couple of fruitless minutes checking the modified report and creating a new version of the Word template without success I started wondering about already open applications. In particular MS Word itself was already running with an unrelated document open.

I closed down all open Word documents and, in Template Maintenance (Administration ¯ Reports ¯ Template Maintenance), clicked the Modify button; when the Word template opened the new fields were showing in the XML schema.

This is something I have experienced before without being able to pin down why which caused..shall we say…a certain level of frustration. I’m not sure why having Word open caused the XML schema not to be refreshed when creating a new document, I am pleased that at least I can void the problem by making sure all open instances of Word are closed before starting.

Error Printing Batch Of Cheque Remittances

Microsoft Dynamics GPI recently assisted a client with an upgrade of Microsoft Dynamics GP 10 to GP 2013 R2. As part of the upgrade we assisted the client to create some Word Template versions of sales invoice, purchase order, and cheque remittance (or check remittance to the American readers).

Everything appeared fine during development and initial testing. Fine that is until we tried producing a batch of twenty remittances which produced the following two error messages:

Microsoft Word - The file Check Remittance~2 cannot be opened because there are problems with the contents.Microsoft Word – The file Check Remittance~2 cannot be opened because there are problems with the contents.

Continue reading “Error Printing Batch Of Cheque Remittances”

Hands On With Microsoft Dynamics GP 2015 RTM: Installing the Microsoft Dynamics GP Add-in for Microsoft Word

Microsoft Dynamics GPNow that Microsoft Dynamics GP 2015 RTM is available, I thought I could follow my usual pattern of posting a series of posts on how to install and configure both Dynamics GP, but also the additional products which ship with it. You can find the series index for these posts here.

One of the very useful additions in Microsoft Dynamics GP 2010 was the ability to create invoice, remittance and other types of documents in a Word Template rather than having to do it all in Report Writer (although Report Writer is still needed if you want to create a custom field or make other fields available to the Word Template). While much of the editing and changing of formatting can be done using Word as is, if you want to add any new fields then the Microsoft Dynamics GP Add-in for Microsoft Word is required on any machine which will be used for doing this.

To install the Microsoft Dynamics GP Add-in for Microsoft Word open the setup.exe from the Microsoft Dynamics GP 2015 installation media and, under Additional Products, select Microsoft Dynamics GP Add-in for Microsoft Word:

Microsoft Dynamics GP 2015

Continue reading “Hands On With Microsoft Dynamics GP 2015 RTM: Installing the Microsoft Dynamics GP Add-in for Microsoft Word”

Blast From The Past: Conditional Company Logos

Microsoft Dynamics GPThis post is a bit of a “blast from the past” which I am posting as it seemed quite hard to find and you never know when I’ll need it again.

A client on Microsoft Dynamics GP 10 (we’re talking to them now about an upgrade to GP 2015) is in the process of setting up a new company and needs to be printing out a few of reports (SI, SR, PO and Remittance) with different logos for the new company.

If you’re a long new GP user you’re probably used to the Word Templates which have the logo supplied from the library in Template Configuration (Administration ¯ Reports ¯ Template Configuration) or by assigning different Word Templates to the different companies.

However, as longer time GP users are aware, the Word Templates were introduced in Dynamics GP 2010; before that all reports were produced using the modified reports created in Report Writer where it wasn’t really possible to have different logos.

That is, it wasn’t possible to have different logos in the same place. Way back in 2008 David Musgrave (while a Microsoftie) did a post on the Developing for Dynamics GP blog on how to have a conditional logo on the modified report by using a conditional field to show or hide logos.

It’s not really a solution that can be called elegant (hey it involves Report Writer!), but it was most certainly a useful one. So until this client gets their upgrade performed (hopefully first quarter 2015) I need to get their modified reports customised to hide the logo for their main company when producing documents and the exact steps had faded from memory somewhat.

So I needed to hunt out the old post I remembered David writing (I also remember using it back in 2008) and it actually took a little finding (found it through a question on the Community Forum).

MDGP 2013 R2 Feature of the Day: Email Or Print Any Report In Word Format

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog started a series of Microsoft Dynamics GP 2013 R2 Feature of the day posts the other day. As they did with the Microsoft Dynamics GP 2013 Feature of the Day posts they are doing them as short posts containing a PowerPoint slide show. I am translating these from the PowerPoints into posts; you can find my series index here.

The twenty-fifth Feature of the Day covered is Email or Print any Report in Word format; again I have a PowerPoint for this feature, but there is no page on the Inside Microsoft Dynamics GP blog. This feature means users will be able to send any report via email using a Word Template.

The Email Options form now has an option for .docx available :

Email Any Report

This feature works differently in the Web Client as opposed the Desktop one.

The Web Client will automatically create a template for the report when it is printed and the template option selected. If the report is being emailed then email addresses can be specified for docx.

However, in the Desktop client a template needs to be created prior to sending via email; the template creation can be facilitated by using the Word Template Generator tool.

Click to show/hide the Microsoft Dynamics GP 2013 R2 Feature of the Day Series Index

Click to show/hide the Microsoft Dynamics GP 2013 R2 Feature of the Day Series Index

Microsoft Dynamics GP 2013 R2 Feature of the Day
MDGP 2013 R2 Feature of the Day: SmartList Designer Go To's
MDGP 2013 R2 Feature of the Day: Identity Management - Login
MDGP 2013 R2 Feature of the Day: Purchase Requisitions
MDGP 2013 R2 Feature of the Day: Copy And Paste To General Ledger Transaction Entry
MDGP 2013 R2 Feature of the Day: Workflow
MDGP 2013 R2 Feature of the Day: Workflow Types
MDGP 2013 R2 Feature of the Day: Workflow User Delegation
MDGP 2013 R2 Feature of the Day: Default Fixed Asset ID From The Asset Class
MDGP 2013 R2 Feature of the Day: Identity Management - Scalability Groups
MDGP 2013 R2 Feature of the Day: Workflow Calendar
MDGP 2013 R2 Feature of the Day: Reprint Outstanding Transaction in Bank Reconciliation
MDGP 2013 R2 Feature of the Day: Requisition Management Integration Points
MDGP 2013 R2 Feature of the Day: Default Sort Order for Checks
MDGP 2013 R2 Feature of the Day: Document Attach - Scan
MDGP 2013 R2 Feature of the Day: Workflow History
MDGP 2013 R2 Feature of the Day: Workflow Email Notifications
MDGP 2013 R2 Feature of the Day: Azure Backups
MDGP 2013 R2 Feature of the Day: Suggested Item Enhancements - Analysis and Assignment
MDGP 2013 R2 Feature of the Day: Suggested Item Enhancements - Sales Script and Additional Information
MDGP 2013 R2 Feature of the Day: Dashboards
MDGP 2013 R2 Feature of the Day: Management Reporter Web Viewer
MDGP 2013 R2 Feature of the Day: Take Company Offline
MDGP 2013 R2 Feature of the Day: Encumbrance SQL Reporting Services Reports
MDGP 2013 R2 Feature of the Day: Email Or Print Any Report In Word Format
MDGP 2013 R2 Feature of the Day: Reverse Year End Close
MDGP 2013 R2 Feature of the Day: Document Attachment On Payables Transactions
MDGP 2013 R2 Feature of the Day: Roll Down Segment Changes
MDGP 2013 R2 Feature of the Day: Assign An Item To Multiple Sites
MDGP 2013 R2 Feature of the Day: Replace OLE Note With Document Attachment
MDGP 2013 R2 Feature of the Day: OLE Notes Migration Utility
MDGP 2013 R2 Feature of the Day: Purchase Order Prepayment Additions
MDGP 2013 R2 Feature of the Day: Print Remaining Documents
MDGP 2013 R2 Feature of the Day: Email By Document Type

SOP Blank Invoice Form Word Template Not Working

Microsoft Dynamics GPI was configuring up a test system a short time ago and found that the Sales Documents (specifically the SOP Blank Invoice Form) were producing into IE rather than Word when I printed them.

The problem was caused by the VAT Daybook being installed. VAT Daybook provides alternative versions of the standard SOP reports which do not work with the Word Template Email functionality. To have the invoices send via Word, I had two choices; make a Word Template version of the SOP Blank Invoice Form or, and as this was only a test system my preferred choice, to change a setting to use the standard SOP template rather than the VAT Daybook one.

To do this, open Alternative/Modified Forms and Reports (Microsoft Dynamics GP menu ¯ Tools ¯ Setup ¯ System), set Product to VAT Daybook and restrict the Type to Reports;

Alternative/Modified Forms and Reports

In the scrolling window, expand SOP Blank Invoice Form and SOP Blank History Invoice Form and mark the Microsoft Dynamics GP option under both.

After saving these changes, the SOP Blank Invoice Form successfully produced to Word.

MDGP 2013 Feature of the Day: Password Protection For Word Forms

Microsoft Dynamics GPMicrosoft have started the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The twenty ninth feature they’ve announced is Password Protection for Word Forms.

Users will now have the ability to email their word documents with password protection. This will ensure the recipient of the document will not be able to edit the document to make changes without entering a password.

Continue reading “MDGP 2013 Feature of the Day: Password Protection For Word Forms”