Report Used for the Reprint Check Remittance

● Ian Grieve ●  ● 1 Comment   ● 

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

● Categories: Dynamics, GP, Microsoft ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●

MS Connect Suggestion: Include Multicurrency Vouchers in Select Checks Window

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPThis suggestion is one from MVP Mariano Gomez to improve the payment run process by allowing multicurrency invoices to be included.

Currently, the payment selection process only allows vouchers issued in the batch currency to be selected and added to the check run. If the user wants to add foreign currency vouchers, he/she needs to use the Edit Checks window to add such vouchers. It would be nice to be able to have an option to include functional currency vouchers in the case of a foreign currency batch, or foreign currency vouchers in the case of a functional currency batch.

This is the use case:

Vendor A Invoice 1 CA$10.00
Vendor A Invoice 2 US$20.00
Vendor A Invoice 3 US$30.00

If a payment selection is performed and the batch currency is CA$, only the first voucher will be selected. To add Invoice 2 and 3, you would have to use the Edit Checks window to include both vouchers.

Conversely, if the batch currency is US$ and the payment selection for vendor A is performed, only invoices 2 and 3 would be selected and you would have to use the Edit Checks window to include Invoice 1.

What Mariano would like to see is all invoices selected (based on selection rules) and let the user deal with the exceptions, as it should be.

As mentioned, all the logic is already there via the Edit Checks window and it would be nice to incorporate as part of the payment selection process. As others have mentioned, having multicurrency vouchers included could be a payables configuration item or simply an additional option in the Select Payments (Select Checks) window.

Mark Polino has also suggested that this functionality be optioned with Rod O’Connor further suggesting the option be on the Select Checks window itself to allow maximum flexibility. Both of these seem like a good addition to Mariano’s idea.

The suggestion can be voted on here.

● Categories: Dynamics, GP, Microsoft, Microsoft Connect ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●

Historical Excel Reporting Price Increase Coming

● Ian Grieve ●  ● 3 Comments   ● 

Microsoft Dynamics GPMark Polino has a set of Historical Excel Reports available for sale. The reports available are as follows:

  • Receivables Management Historical Aged Trial Balance
  • Payables Management Historical Aged Trial Balance
  • Historical Inventory Trial Balance
  • Historic Stock Status Report

Now is the ideal time to buy them, as the price is increasing on 1st April 2017.

● Categories: Dynamics, GP, Microsoft, Third Party Add-on ● Tags: , , , , , , , , , , , ,  ● Permalink ● Shortlink ●

SQL Script To Update EFT Payment Register Report

● Ian Grieve ●  ● 2 Comments   ● 

Microsoft Dynamics GPPretty much every client we have of Microsoft Dynamics GP uses the EFT Payment Register Report; a number of the save the file instead of printing it as the report has been customised to generate the EFT payment file for upload to the bank.

The clients who do this are either those whose installations of Microsoft Dynamics GP predate version 10 when the EFT for Payables Management module was made available to the UK market or they implemented before the EFT File Format was enhanced to allow a CSV output.

While some clients have created or amended a file format since the above, not all of them have been willing to spend the time (or money) to make the change.

As such, when they copy live to test they need to amend the path to which the report is being output, to ensure that a live file is not accidentally overwritten.

To faciliate this for users who have automated the live to test restore I created a script they could build into the process:

/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
*/
UPDATE
	SY02200
SET
	FILEXPNM = 'C:\BACS OUTPUT\BACS.TXT'
WHERE
	PTGRPTNM = 'EFT Payment Register'

The highlighted section is the path name which needs to be changed depending on where the test file is to be output.

● Categories: Dynamics, GP, Microsoft ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Receivables & Payables Distribution Line Display UI Change

● Ian Grieve ●  ● 3 Comments   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components and also look at the new functionality introduced; the index for this series can be found here.

The feature I am going “hands on” with is the ninnth Feature of the Day, GL Distribution Line Display UI change.

The status of the scrolling window on the Payables or Distribution Zoom window are remembered:

As with the GL Distribution Line Display UI Change feature, the settings for this feature are stored in the SY01402 table (System User Defaults) in the system database, which is typically called DYNAMICS.

Again is closed and 1 is expanded; the Payables Management setting is where the syDefaultType column is equal to 107 and Receivables Management is 111.

Click to show/hide the Hands On With Microsoft Dynamics GP 2016 R2 Series Index

● Categories: Dynamics, GP, Microsoft, Uncategorized ● Tags: , , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Link Credit Card Invoices To Original Invoice

● Ian Grieve ●  ● 3 Comments   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components and also look at the new functionality introduced; the index for this series can be found here.

The eighth Feature of the Day, which I am “hands on” with in this post, was Link Credit Card Invoices To Original Invoice.

To test this feature, I entered, posted and paid an invoice for Attractive Telephone Co. for $1,000:

Payables Transaction Inquiry - Vendor

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Link Credit Card Invoices To Original Invoice

● Categories: Dynamics, GP, Microsoft ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●

MDGP 2016 R2 Feature of the Day: Safe Pay File Displays Check Name From Check

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2016 R2; as the most recent versions have been, these posts are in the form of PowerPoint slides; I am reposting them here so they can be read more easily.

The series index for this series of posts is here.

The twelvth Feature of the Day is Safe Pay file displays Check Name from Check.

This feature of the day, sets the Check Name from the check on the Safe Pay file, rather than the default from the vendor card:

Vendor Maintenance
Safepay file

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

● Categories: Dynamics, GP, Microsoft, Safe Pay ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

MDGP 2016 R2 Feature of the Day: Receivables/Payables Dist Line Display Expanded

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2016 R2; as the most recent versions have been, these posts are in the form of PowerPoint slides; I am reposting them here so they can be read more easily.

The series index for this series of posts is here.

The ninth Feature of the Day is Receivables/Payables Dist Line Display Expanded.

As with the GL Distribution Line UI Change this feature of the day will default the scrolling window expanded or collapsed based on the previous display date on the Receivables Transaction Entry and Payables Transaction Entry distribution windows:

Sales Transaction Distribution Entry

Continue reading → MDGP 2016 R2 Feature of the Day: Receivables/Payables Dist Line Display Expanded

● Categories: Dynamics, GP, Microsoft ● Tags: , , , , , , , , , ,  ● Permalink ● Shortlink ●

MDGP 2016 R2 Feature of the Day: Link Credit Card Invoices to Original Invoice

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2016 R2; as the most recent versions have been, these posts are in the form of PowerPoint slides; I am reposting them here so they can be read more easily.

The series index for this series of posts is here.

The eighth Feature of the Day is Link Credit Card Invoices to Original Invoice.

This feature of the day, updates the transaction description on the credit card vendor invoice to easily track back to the originating voucher:

Payables Transaction Inquiry

Continue reading → MDGP 2016 R2 Feature of the Day: Link Credit Card Invoices to Original Invoice

● Categories: Dynamics, GP, Microsoft ● Tags: , , , , , , , , ,  ● Permalink ● Shortlink ●

MS Connect Suggestion To Rename Five Microsoft Dynamics GP Payables Windows

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPMariano, Microsoft Dynamics GP MVP and Dynamics GP Blogster has logged a suggestion for improving Microsoft Dynamics GP on the MS Connect site.

The windows are:

  1. Select Payables Checks -> Build Payments Batch
  2. Edit Payables Check Batch -> Edit Payment Batch
  3. Edit Payables Check -> Edit Vendor Payment
  4. Print Payables Checks -> Print Payment Documents
  5. Post Payables Checks -> Post Payment Documents

Mariano has more details on his blog including screenshots of the windows in question.

Renaming these windows would be a good idea as the current names are misleading and cause confusion for new users of the system. From a partner perspective, it also looks quite bad when demoing Dynamics GP to a prospect; especially when considering that in the UK, virtually no-one uses printed cheques anymore, but instead make payments using EFT.

Please take a look at the suggestion and cast your vote.

I have two hopes; that Microsoft do make this change and that they also change it in the UK language pack.

● Categories: Dynamics, GP, Microsoft, Microsoft Connect ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●