Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
mark4yesu 2/18/2015 12:17:39 PM

PM Historical Aged Trial Balance - using seepmHATBWrapper

Hi,

I'm trying to directly use the seepmHATBWrapper to create a PM Historical Aged Trial Balance that can be run either in Crystal or Excel. My client doesn't want to use SSRS.  I was able to use the AR HATB proc fine.  I tried to use this code (below) and got the message "Database name 'tempdb' ignored, referenceing object in tempdb."  No results but an empty recordset.  Code is here.  Any ideas?

DECLARE @RC int
DECLARE @I_dAgingDate datetime = '12/31/2014'
DECLARE @I_cStartVendorID char(15) = '0'
DECLARE @I_cEndVendorID char(15) = 'zzzzz'
DECLARE @I_cStartVendorName char(65) = '0'
DECLARE @I_cEndVendorName char(65) = 'zzzzzz'
DECLARE @I_cStartClassID char(15) = '0'
DECLARE @I_cEndClassID char(15) = 'zzzz'
DECLARE @I_cStartUserDefined char(15) = '0'
DECLARE @I_cEndUserDefined char(15) = 'zzz'
DECLARE @I_cStartPaymentPriority char(3) = '0'
DECLARE @I_cEndPaymentPriority char(3) = 'zzz'
DECLARE @I_cStartDocumentNumber char(21) = '0'
DECLARE @I_cEndDocumentNumber char(21) = 'zzzzzzz'
DECLARE @I_tUsingDocumentDate tinyint = 0
DECLARE @I_dStartDate datetime = '1/1/1900'
DECLARE @I_dEndDate datetime = '12/31/9999'
DECLARE @I_tExcludeNoActivity tinyint = 1
DECLARE @I_tExcludeMultiCurrency tinyint = 0
DECLARE @I_tExcludeZeroBalanceVendors tinyint = 1
DECLARE @I_tExcludeFullyPaidTrxs tinyint = 0
DECLARE @I_tExcludeCreditBalance tinyint = 0
DECLARE @I_tExcludeUnpostedAppldCrDocs tinyint = 0

-- TODO: Set parameter values here.

EXECUTE @RC = [seepmHATBWrapper] 
   @I_dAgingDate
  ,@I_cStartVendorID
  ,@I_cEndVendorID
  ,@I_cStartVendorName
  ,@I_cEndVendorName
  ,@I_cStartClassID
  ,@I_cEndClassID
  ,@I_cStartUserDefined
  ,@I_cEndUserDefined
  ,@I_cStartPaymentPriority
  ,@I_cEndPaymentPriority
  ,@I_cStartDocumentNumber
  ,@I_cEndDocumentNumber
  ,@I_tUsingDocumentDate
  ,@I_dStartDate
  ,@I_dEndDate
  ,@I_tExcludeNoActivity
  ,@I_tExcludeMultiCurrency
  ,@I_tExcludeZeroBalanceVendors
  ,@I_tExcludeFullyPaidTrxs
  ,@I_tExcludeCreditBalance
  ,@I_tExcludeUnpostedAppldCrDocs
GO


 

Version: GP 2010
Section: Dynamics GP, SQL Scripts








Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables