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.