Keep up to date with the latest information about Microsoft Dynamics GP through articles from the Perfect Image and azurecurve blogs.
June 28th, 2017 by Ian Grieve
Microsoft 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:
I made a discovery recently, when working on creating custom layouts for both the Separate Remittance and Reprint Check Remittance modified report and Word Template.
This might only have been a discovery to me and everyone else is aware of it already. But, when printing the reprint remittance using the Re-create Check Stub button on the Payables Payment Zoom window, the report printed is the Reprint Check Remittance report (as I expected):
However, when clicking the Email button on the action pane, the report produced is the Separate Remittance:
This is the same report used by the Process Payables Remittance window.
So, this means that if the user will be emailing all of the remittances, and never printing one, only the Separate Remittance modified report and/or Word Template need to be amended. Everyone I have worked with is still printing some remittances, so in the short term this won’t save any effort in creating reports, but as time passes and more company accept emailed remittances, this will have a saving.
June 27th, 2017 by Ian Grieve
I am very much an advocate for using the Microsoft Dynamics GP application for making changes to configuration or data rather than jumping straight to the SQL database. However, sometimes needs really must.
I was onsite with a client a few weeks ago to assist them in implementing Purchase Order Processing and, as part of this implementation, I needed to enable the emailing of the purchase order. Typically, I would do this through the Company E-mail Setup ()) window, but the client is configured to use Exchange for emails and I don’t have an Exchange account on their system.
Due to my location compared to the users, it was quicker to create an SQL script to enable the email rather than trying to locate a user with the relevant permissions to screen share with:
UPDATE SY04903 SET EmailDocumentEnabled = 1 ,EmailMessageID = 'PO' WHERE EmailDictionaryID = 0 AND EmailSeriesID = 4 AND MODULE1 = 12 AND EmailDocumentID = 1
The highlighted section is the name of the Message ID for the PO.
As always before running a script, ensure you test the script and have a good backup of your company database.
June 26th, 2017 by Ian Grieve
Well, I got it done a bit quicker than I thought, and now have all of the Microsoft Dynamics GP modules loaded.
I will be adding ISV products through time, but if there are any in particular which you want to me to progress sooner, then please drop me a note using the contact form.