To learn more about our club management services please contact us at 954-205-6074

Untitled

Untitled
Demo of Features

Click on the Feature below
to see the demo



Director's Menu

Player Registration

Player Billing

Club Emails

Team List &
Player Page


Downloads to AES & SUTP

Practice Schedule

Reports

Player Account

Coaches Account

Fundraising

Demo for this feature is not fully developed

Player Billing is available from the Director's Menu. Only staff members with "Director" status have access to the Player Billing feature.

The system allows for parents to make payments online via Paypal. The parent does not need to have a Paypal account in order to make payments to the club. Paypal just handles the processing of the payment. Clubs do need to have a Paypal account in order to have Paypal process payments in their behalf. Furthermore, the club must be set up to receive website payments via Paypal. Our staff will help your club set up the Paypal account. All credit card payments made to your club go directly to your Paypal account. It is up to your club to contact Paypal to make the transfer from Paypal to your own bank account. Our system does interface with Paypal, so as to post the payment to the account of the player making the payment.

Below is acopy of the Players Billing screen. The screen is made up of 8 separate panels that handle the entire player billing process. Each panel handles a specific feature of the Player Billing. Below we will list each panel.

To view the function each panel serves, please click on the links below:

Panel #1 - Create Player Invoices
Panel #2 - Player Accounting Reports
Panel #3 - Post Player Payments - Check and cash payments only
Panel #4 - Process Credit Card Payments - Paypal payments only
Panel #5 - Edit a Player's Invoices
Panel #6 - Post a Previously Deposited Payment - either cash, check or credit card
Panel #7 - List of Checks Ready for Deposit
Panel #8 - Email Bills to Players



Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'order'.
 
The error occurred in C:/inetpub/sportsclubservices.com/billing070.cfm: line 41
Called from C:/inetpub/sportsclubservices.com/billing0.cfm: line 89
Called from C:/inetpub/sportsclubservices.com/billing070.cfm: line 41
Called from C:/inetpub/sportsclubservices.com/billing0.cfm: line 89
39 : 	Where		club like '0' or 
40 : 				(club like <cfqueryparam cfsqltype="cf_sql_integer" value="#session.club#"> and
41 : 				(DATE_DUE >=<cfqueryparam cfsqltype="cf_sql_timestamp" value="#tdate#">
42 : 	order by 	club, player_name
43 : </cfquery>

SQLSTATE   HY000
EXCEPTIONS   <small><i>not set</i></small>
DATASOURCE   boomerssql
VENDORERRORCODE   156
SQL   Select club, name + ', ' + first_name as player_name, player From dbo.VIEW_PLAYERS_WITH_BALANCES Where club like '0' or (club like (param 1) and (DATE_DUE >= (param 2) order by club, player_name
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   44.200.30.73
Referrer  
Date/Time   09-Aug-22 10:27 AM
Stack Trace
at cfbilling0702ecfm1693714022.runPage(C:/inetpub/sportsclubservices.com/billing070.cfm:41) at cfbilling02ecfm1572110334.runPage(C:/inetpub/sportsclubservices.com/billing0.cfm:89) at cfbilling0702ecfm1693714022.runPage(C:/inetpub/sportsclubservices.com/billing070.cfm:41) at cfbilling02ecfm1572110334.runPage(C:/inetpub/sportsclubservices.com/billing0.cfm:89)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'order'.
	at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1103)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193)
	at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153)
	at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124)
	at macromedia.jdbc.sqlserver.tds.r.a(TDSRPCRequest.java:1063)
	at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273)
	at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1895)
	at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632)
	at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661)
	at macromedia.jdbc.sqlserverbase.fe.B(BasePreparedStatement.java:530)
	at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470)
	at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322)
	at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java:2656)
	at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java:525)
	at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1601)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1327)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1257)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821)
	at cfbilling0702ecfm1693714022.runPage(C:\inetpub\sportsclubservices.com\billing070.cfm:41)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5201)
	at cfbilling02ecfm1572110334.runPage(C:\inetpub\sportsclubservices.com\billing0.cfm:89)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:231)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:228)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:190)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:163)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:373)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:462)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1723)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:834)