New book on Jet Reports with Microsoft Dynamics GP available – azurecurve

Ian has a new book out. All of his others have been fantastic. I have no doubt that this one will be worth the money as well.

New book on Jet Reports with Microsoft Dynamics GP available – azurecurve
— Read on www.azurecurve.co.uk/2020/07/new-book-on-jet-reports-with-microsoft-dynamics-gp-available/

SmartList Export: Excel cannot open error – JenKuntz.ca

Jen Kuntz troubleshoots a Smartlist/Excel issue in:

SmartList Export: Excel cannot open error – JenKuntz.ca
— Read on jenkuntz.ca/2020/06/smartlist-export-excel-cannot-open-error/

Microsoft Dynamics GP payment batch no longer visible in Process Remittance – azurecurve

From Ian Grieve:

Microsoft Dynamics GP payment batch no longer visible in Process Remittance – azurecurve
— Read on www.azurecurve.co.uk/2020/07/microsoft-dynamics-gp-payment-batch-no-longer-visible-in-process-remittance/

Received Not Invoice Report is not tying to the Accrued Purchases account on the General Ledger Trial balance – Microsoft Dynamics GP Community

The GP team has some info on tying Received Not Invoiced to Accrued Purchases. I’ve got some info on how to fix transactions once you identify the issues. https://dynamicaccounting.net/controller-series-reconciling-accrued-payables-with-received-not-invoiced/?hilite=%27received%27%2C%27not%27%2C%27invoiced%27


Many of you use the Received not invoiced report to reconcile your Accrued Purchases account to the General Ledger. We often get questions around why it might not reconcile and what thing…
— Read on community.dynamics.com/gp/b/dynamicsgp/posts/received-not-invoice-report-is-not-tying-to-the-accrued-purchases-account-on-the-general-ledger-trial-balance

Error trying to combine sites in the PSTL tool: You cannot combine the sites as it is the same on a transfer record in the history table. – Microsoft Dynamics GP Community

One more error that can come up, all though this one is pretty rare compared to some others.


If you are ever trying to combine sites using out Professional Services Library tool “Inventory Site Combiner” and receiving the following error “You cannot combine the …
— Read on community.dynamics.com/gp/b/dynamicsgp/posts/error-trying-to-combine-sites-in-the-pstl-tool-you-cannot-combine-the-sites-as-it-is-the-same-on-a-transfer-record-in-the-history-table

Microsoft Dynamics GP crashes sending emails using MAPI – azurecurve

Ian Grieve tackles an issue where Microsoft Dynamics GP crashes sending emails using MAPI – azurecurve
— Read on www.azurecurve.co.uk/2020/06/microsoft-dynamics-gp-crashes-sending-emails-using-mapi/

How to prevent users from miskeying document dates in Microsoft Dynamics GP using ‘Doc Date Verify’ tool in Professional Service Tools Library – Microsoft Dynamics GP Community

There are lots of little settings and tools in GP. If you’re frustrated about something, like users keying AP dates incorrectly, there may be an answer. Don’t be afraid to search or to ask. Here’s an example:

Have you ever been querying in SQL tables and noticed dates like ‘5/1/2041’? I see it all the time…. which may skew certain reporting. If you didn’t already …
— Read on community.dynamics.com/gp/b/dynamicsgp/posts/will-the-1099-nec-form-be-available-for-2020-in-microsoft-dynamics-gp

Error: You can’t transfer encumbrances for XXXX when there are outstanding encumbrance amounts for a prior fiscal year. – Microsoft Dynamics GP Community

Grom the GP,  we get troubleshooting around encumbrances.

With Year-end now over, I wanted to share some information around Encumbrance and Year End transfers since many of you are in the process of doing this or will be in June after Fis…
— Read on community.dynamics.com/gp/b/dynamicsgp/posts/error-you-can-t-transfer-encumbrances-for-xxxx-when-there-are-outstanding-encumbrance-amounts-for-a-prior-fiscal-year

Dynamics GP – How to Unapply a Payables Invoice in HISTORY that’s applied to a OPEN Credit Document – The Dynamics Explorer

From Dynamics Explorer we have info on more complicated AP application.

Scenario I often see this request via support so thought I’d document it on my blog. The question varies however it usually goes something like this: “I’ve accidentally applied an invoice to a Payment and now I need to unapply this however when I select the Payment in the “Transactions > Purchasing > Apply Payables…
— Read on thedynamicsexplorer.com/2020/06/10/dynamics-gp-how-to-unapply-a-payables-invoice-in-history-thats-applied-to-a-open-credit-document/

Recovering from failed Payroll processing activity in Dynamics GP – Microsoft Dynamics GP Community

From the GP team comes help with Payroll failure.

When debating what subject to cover in this blog posting in regards to Dynamics GP there wasn’t much doubt as to is the most common ‘urgent’ case issue we see at the support desk, which is…
— Read on community.dynamics.com/gp/b/dynamicsgp/posts/recovering-from-failed-payroll-processing-activity-in-dynamics-gp