New April Hotfix and more changes for VAT
Check out the latest updates to Microsoft Dynamics GP 2016 and 2018.
Dynamics 365 2019 release wave 2 plan Discover the latest updates to Dynamics 365.Release Plan | Weekly Deployment Notes
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants.Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements.
ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Talent TechTalks
Pretty 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 sicne 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).
FILEXPNM = 'C:\BACS OUTPUT\BACS.TXT'
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.
Read original post SQL Script To Update EFT Payment Register Report at azurecurve|Ramblings of a Dynamics GP Consultant
Business Applications communities