Dynamics GP - Upgrade Stalls or freezes

• Most likely the client is corrupted in some way
• Rename the original GP folder to _old
• Reinstall GP to the version required

Dynamics GP - Upgrading from Smartlist Builder 2013 GP Module to eOne Smartlist Builder

If you have paid for the GP2013 Smartlist Builder module, and are current on your support plan, you should already be entitled to eOne smartlist builder keys for future versions. Simply contact eOne and let them provide you with the new keys.

A Save Operation on table 'coAttachMSTR' has created a duplicate key when saving documents in Microsoft GP 2015 R2

https://community.dynamics.com/gp/f/32/t/164431?pi53330=2#responses

This is a bug in GP 2015R2, and has been resolved in the latest GP2015 Service pack

Dynamics GP - Script to Reconcile AP Apply links

https://community.dynamics.com/gp/f/32/t/146495


/*

Every now and then you get posting interruptions in Dynamics GP at exactly the wrong time. Normally

the Batch recovery routine under tools>routines>Batch Recovery, picks these up. However sometimes

this is not the case and you then need to determine what state your data is in within the Dynamics GP product.

The below script is designed to help in these circumstances. It is run against the Dynamics GP

company database and is designed to find those payables transactions with missing apply details.

I would recommend running this script if you have found a PM transaction with missing apply details

to ascertain the extent of the problem.

If you do have a posting interruption or if you find that you do have missing apply info please contact the

helpdesk@touchstone.co.uk and we can investigate further. If you have any questions about the script

etc please feel free to contact me andrew.hall@touchstone.co.uk

Here is the script:

*/

/* Before running this query go to query on the menu bar and select results in text

This query is designed to find open transactions that have missing apply info Open & the info is

in history

4 temp tables are created in the temp db

*/

/*The first part of the script selects transactions from

the PM20000 which have apply info in the PM10200 */

SELECT b.vchrnmbr

, b.vendorid

INTO #temp1

FROM pm10200 a

, pm20000 b

WHERE b.docnumbr = a.aptodcnm

AND a.vendorid = b.vendorid

go

/* The second part of the script selects transactions from

the PM20000 which should have apply info but they did not appear in the

results of the first script */

SELECT vchrnmbr

, vendorid

INTO #temp2

FROM pm20000

WHERE docamnt > curtrxam

AND curtrxam > '0.00000'

AND vchrnmbr NOT IN (SELECT vchrnmbr

FROM #temp1)

ORDER BY vendorid

go

/* The third part of the script selects transactions from

the results of the second script which have apply info in the

PM30300 History table */

SELECT a.vchrnmbr

, a.vendorid

INTO #temp3

FROM #temp2 a

, pm30300 b

WHERE a.vendorid = b.vendorid

AND a.vchrnmbr = b.vchrnmbr

go

/* The Fourth part of the script selects transactions from

the PM20000 that do not appear in the results of the third part or the first part

( open apply info and History apply info) */

SELECT vchrnmbr

, vendorid

, docnumbr

INTO #temp4

FROM pm20000

WHERE docamnt > curtrxam

AND curtrxam > '0.00000'

AND vchrnmbr NOT IN (SELECT vchrnmbr

FROM #temp3)

AND vchrnmbr NOT IN (SELECT vchrnmbr

FROM #temp1)

ORDER BY vendorid

go

/* This part of the script displays the results*/

PRINT 'Transactions from PM20000 missing apply info in PM10200 & PM30300'

SELECT *

FROM #temp4

go

Use tempdb

GO

/* Use this script to drop the temp tables if they persist after

the session closes. You have to close the query window

to end the session */

Select 'DROP TABLE ' + name from sys.objects where name like '%#temp%' and type = 'U'

Select * from sys.objects where name like '%#temp%'

Dynamics GP - Smartlist does not open when clicked

https://community.dynamics.com/gp/f/32/t/120847

Resolution1

• The smartlist has been moved off of the screen
• Click on the gp button in the windows task bar and confirm if you can see the smartlist there
• If it is there, right click on it, click "Move"
• Press the arrow keys left, or up
• The window should now be connected to your mouse
• Move the mouse without clicking
• The window should jump to your current screen and follow the mouse
• Click to release the window

Resolution2

The value for SYUSERDFSTR in the sy01402 table somehow got changed for this user. This was resolved by updating the value to match another user that was not experiencing this issue.

Dynamics GP - Notes Table - SY03900

Main notes table - SY03900

Dynamics GP Workflows - User only sees Recall button and cannot approve

• If you are trying to approve your own documents, Ensure that the option "Allow Originator to be an Approver" is ticked
• You must be logged in to windows as the actual windows user configured to approve that step
• Remove all other approvers from the step if necessary