Hello fellow Tessiturians,
In the GL Summary Report there is a column headed F/Year (which I take to be Fiscal Year).
Can someone tell me where that reads from please? Sales on a performance in 2010 are reading F/Year 2009 and I have look everywhere I can think of to identify a Fiscal Year of 2009 associated with the performance in 2010 - and drawn a blank.
Cheers Darrell
Please consider the environment before printing this email. =====This message is intended for the addressee(s) named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====
-----Original Message-----From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Ken McSwainSent: Wednesday, 31 March 2010 10:26 AMTo: Darrell JonesSubject: Re: [Tessitura Finance Forum] GL Summary Report Hi DarrellIt comes from the fyear on the Campaign that the ticket sales for that performance are associated to. KenKen McSwain +61 (0)418 659 360 Sent from BlackBerry From: Tessitura Finance Forum <forums-finance@tessituranetwork.com> To: Ken McSwain Sent: Wed Mar 31 10:11:22 2010Subject: [Tessitura Finance Forum] GL Summary Report Hello fellow Tessiturians, In the GL Summary Report there is a column headed F/Year (which I take to be Fiscal Year). Can someone tell me where that reads from please? Sales on a performance in 2010 are reading F/Year 2009 and I have look everywhere I can think of to identify a Fiscal Year of 2009 associated with the performance in 2010 - and drawn a blank. Cheers Darrell This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!Please consider the environment before printing this email. =====This message is intended for the addressee(s) named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust===== This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Also note that the campaign assigned to a package affects the FYear for package sale transactions.
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Darrell Jones Sent: Tuesday, March 30, 2010 4:36 PM To: Ryan Creps Subject: RE: [Tessitura Finance Forum] GL Summary Report
I had checked the 2010 campaign but of course the 2009 campaign was still active doh!
Many thanks Ken.
Darrell Jones
Assistant Box Office Coordinator
Tasmanian Symphony Orchestra
GPO Box 1450
HOBART
Tasmania 7001
(03) 6232 4404
-----Original Message----- From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Ken McSwain Sent: Wednesday, 31 March 2010 10:26 AM To: Darrell Jones Subject: Re: [Tessitura Finance Forum] GL Summary Report Hi Darrell It comes from the fyear on the Campaign that the ticket sales for that performance are associated to. Ken Ken McSwain +61 (0)418 659 360 Sent from BlackBerry From: Tessitura Finance Forum <forums-finance@tessituranetwork.com> To: Ken McSwain Sent: Wed Mar 31 10:11:22 2010 Subject: [Tessitura Finance Forum] GL Summary Report Hello fellow Tessiturians, In the GL Summary Report there is a column headed F/Year (which I take to be Fiscal Year). Can someone tell me where that reads from please? Sales on a performance in 2010 are reading F/Year 2009 and I have look everywhere I can think of to identify a Fiscal Year of 2009 associated with the performance in 2010 - and drawn a blank. Cheers Darrell This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you! Please consider the environment before printing this email.=====This message is intended for the addressee(s) named and may contain confidential information.If you are not the intended recipient, please delete it and notify the sender.Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust===== This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
-----Original Message----- From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Ken McSwain Sent: Wednesday, 31 March 2010 10:26 AM To: Darrell Jones Subject: Re: [Tessitura Finance Forum] GL Summary Report
Hi Darrell It comes from the fyear on the Campaign that the ticket sales for that performance are associated to. Ken Ken McSwain +61 (0)418 659 360 Sent from BlackBerry
From: Tessitura Finance Forum <forums-finance@tessituranetwork.com> To: Ken McSwain Sent: Wed Mar 31 10:11:22 2010 Subject: [Tessitura Finance Forum] GL Summary Report
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Please consider the environment before printing this email.
=====This message is intended for the addressee(s) named and may contain confidential information.
If you are not the intended recipient, please delete it and notify the sender.
Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====
Hi Darrell,
Good day.
GL Summary Report comes from one table only: T_GL_POSTING_HISTORY
when you post a batch, catch the sql statement from profiler
part 1:
SELECT T_TRANSACTION.sequence_no, T_TRANSACTION.transaction_no, T_TRANSACTION.trn_dt, T_TRANSACTION.trn_type, T_TRANSACTION.trn_amt, T_TRANSACTION.fund_no, T_FEE_fee_gl_no = ISNULL(T_FEE.fee_gl_no, ''), T_PMAP_gl_hold_no = ISNULL(T_PMAP.gl_hold_no, ''), T_PMAP_gl_realize_no = ISNULL(T_PMAP.gl_realize_no, ''), T_PMAP_gl_benevolent_no = ISNULL(T_PMAP.gl_benevolent_no, ''), T_FUND_restricted_income_gl_no = ISNULL(T_FUND.restricted_income_gl_no, ''), T_FUND_nr_income_gl_no = ISNULL(T_FUND.nonrestricted_income_gl_no, ''), T_FUND_future_rec_gl_no = ISNULL(T_FUND.future_rec_gl_no, ''), T_FUND_current_rec_gl_no = ISNULL(T_FUND.current_rec_gl_no, ''), T_FUND_written_off_gl_no = ISNULL(T_FUND.written_off_gl_no, ''), T_TRANSACTION.batch_no , ISNULL(T_CAMPAIGN.fyear, 0 ), batch_type_group = ISNULL(TR_BATCH_TYPE.batch_type_group, 0) ,T_TRANSACTION.pmap_no,T_TRANSACTION.fee_noFROM T_TRANSACTIONLEFT OUTER JOIN T_FEE ON T_TRANSACTION.fee_no = T_FEE.fee_no LEFT OUTER JOIN T_FUND ON T_TRANSACTION.fund_no = T_FUND.fund_no LEFT OUTER JOIN T_PMAP ON T_TRANSACTION.pmap_no = T_PMAP.pmap_noJOIN T_CAMPAIGN ON T_TRANSACTION.campaign_no = T_CAMPAIGN.campaign_noLEFT OUTER JOIN T_BATCH ON T_TRANSACTION.batch_no = T_BATCH.batch_noLEFT OUTER JOIN TR_BATCH_TYPE ON T_BATCH.batch_type = TR_BATCH_TYPE.idWHERE T_TRANSACTION.batch_no = 6963 --my batch_no
part 2:
SELECT T_PAYMENT.transaction_no, T_PAYMENT.payment_no, T_PAYMENT.pmt_dt, T_PAYMENT.pmt_amt, T_PAYMENT.pmt_method , asset_gl_no = ISNULL(TR_PAYMENT_METHOD.asset_gl_no, '') , fyear = ISNULL(T_CAMPAIGN.fyear, 0) ,batch_type_group = ISNULL(TR_BATCH_TYPE.batch_type_group, 0) FROM T_PAYMENT JOIN TR_PAYMENT_METHOD ON T_PAYMENT.pmt_method = TR_PAYMENT_METHOD.id JOIN T_TRANSACTION ON T_PAYMENT.transaction_no = T_TRANSACTION.transaction_no and T_PAYMENT.sequence_no = T_TRANSACTION.sequence_no JOIN T_CAMPAIGN ON T_TRANSACTION.campaign_no = T_CAMPAIGN.campaign_no LEFT OUTER JOIN T_BATCH ON T_PAYMENT.batch_no = T_BATCH.batch_noLEFT OUTER JOIN TR_BATCH_TYPE ON T_BATCH.batch_type = TR_BATCH_TYPE.idWHERE T_PAYMENT.batch_no = 6963 --my batch_no
So you can see, fyear is ISNULL(T_CAMPAIGN.fyear, 0)
have fun
Ben