Dynamics GP - Add SOP PO Number to RM Aged trial Balance

Join the RM Open file and RM Hist File to the RM Statement Temporary file

Use a conditional expression to display the po number from the open file, and if blank, then display the po number from the hist file.

Dynamics GP - Extended Pricing View - list of all prices on all sheets

SELECT     IV10402.PRCSHID, IV10402.EPITMTYP, IV10402.ITEMNMBR, IV00101.ITEMDESC, IV10402.UOFM, IV10402.QTYFROM, IV10402.QTYTO, IV10402.PSITMVAL, IV10402.EQUOMQTY,

                      IV10402.QTYBSUOM, IV10402.SEQNUMBR, IV10402.DEX_ROW_ID, IV00101.ITMCLSCD, IV10401.PRODTCOD

FROM         IV10402 INNER JOIN

                      IV00101 ON IV10402.ITEMNMBR = IV00101.ITEMNMBR INNER JOIN

                      IV10401 ON IV10402.PRCSHID = IV10401.PRCSHID AND IV10402.ITEMNMBR = IV10401.ITEMNMBR

[Microsoft][SQL Server Native Client 10.0][SQL Server]The EXECUTE permission was denied on the object 'zDP_SY02100SS_1', database 'master', schema 'dbo'.

http://support.microsoft.com/kb/2870546

Dynamics GP - Unable to Find a Table when installing a chunk file

Your account does not have access to the Dynamics GP program files folder.
Give your account full access and roll down permissions on all subfolders.

Windows XP Compatibility

Windows XP will generally work with

• Dynamics GP up to 2013
• SQL Server up to 2008 R2
• It will connect to SQL 2012 using the SQL 2008 odbc drivers

Dynamics GP - Compass - EBIZMUI.dll is missing

Download and install the POS A00 first before installing the POS A03
Untick Pole Support

Dynamics GP - Releases, Updates, Upgrades, Service Packs

GP 2010
https://mbs.microsoft.com/customersource/northamerica/GP/downloads/service-packs/MDGP10_PatchReleases