SELECT GL7Projects.ProjectID "Project Number",
dbo.GL7GetProjectBalance(1, 0, '2003/1/1', GL7PROJECTS.GL7PROJECTSID, 1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, -1)"Beginning Balance"
From dbo.GL7Projects

Details on the parameters of the GL7GetProjectBalance function:

GL7GetProjectBalance (
@UserID integer, User ID
@AccountID integer, Account Id
@BalanceDate DateTime, Balance date.
@ProjectIDString varchar(8000), List of Project IDs to include  example "1, 2, 3, 4"
@GL7GeneralInfoID integer, General Info ID, ( usually 1 )
@OutputNatural smallint, -1= returns Debits/Credits as positive/Negative.  otherwise returns all positive suggest using -1
@TranType smallint, 1 = regular, 2 = Encumbrance, 0 = both.
@Class integer, Table entries ID for Account class table.  ( 0 for all )
@TrancodeValue1 integer, Table entries ID for first Transaction code. ( 0 for all )
@TrancodeValue2 integer, Table entries ID for second Transaction code. ( 0 for all )
@TrancodeValue3 integer, etc
@TrancodeValue4 integer, etc
@TrancodeValue5 integer, etc
@ProjectInstalled smallint, always set to 0.  not used.
@CompanyID integer, Company ID  ( usually 1 )
@Category integer, Account Category.   0 for all  1-Asset, 2-Liability, 3-Net Asset, 4-Revenue, 5-Expense, 6-Gift, 7-Transfer, 8-Gain, 9-Loss
@BeginningBalance integer -1 for beginning balance, 0 for ending balance
Disclaimer: Blackbaud provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes you are familiar with Structured Query Language and the tools used to create and modify SQL statements and Crystal Reports. Blackbaud Customer Support may help explain the functionality of a particular procedure, but we will not modify, or assist you with modifying, these examples to provide additional functionality.