Report Used for the Reprint Check Remittance

June 28th, 2017 by Ian Grieve

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

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):

Report Destination - Reprint Check Remittance

However, when clicking the Email button on the action pane, the report produced is the Separate Remittance:

Report Destination - 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.

Read original post Report Used for the Reprint Check Remittance at azurecurve|Ramblings of a Dynamics GP Consultant

Comments >>

Source: azurecurve

Enabling the PO Email Document Without an Exchange Account.

June 27th, 2017 by Ian Grieve

Microsoft Dynamics GPI 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 (Administration >> Setup >> 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.

Read original post Enabling the PO Email Document Without an Exchange Account. at azurecurve|Ramblings of a Dynamics GP Consultant

Comments >>

Source: azurecurve

Microsoft Dynamics GP Table Reference: Products Added

June 26th, 2017 by Ian Grieve

Microsoft Dynamics GP Table ReferenceOn Thursday last week, I introduced the new Microsoft Dynamics GP Table Reference I was in the process of creating and said I’d be adding new products soon.

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.

Read original post Microsoft Dynamics GP Table Reference: Products Added at azurecurve|Ramblings of a Dynamics GP Consultant

Comments >>

Source: azurecurve