Partial Payments; which GL?

Hi Michael,

Good day.

SELECT     T_ORDER.customer_no, T_SUB_LINEITEM.order_no, T_SUB_LINEITEM.sli_status,T_SLI_DETAIL.due_amt, T_SLI_DETAIL.paid_amt, T_PMAP.gl_hold_no
FROM       T_ORDER INNER JOIN
T_SUB_LINEITEM ON T_ORDER.order_no = T_SUB_LINEITEM.order_no INNER JOIN
T_SLI_DETAIL ON T_SUB_LINEITEM.sli_no = T_SLI_DETAIL.sli_no INNER JOIN
T_PMAP ON T_SLI_DETAIL.pmap_no = T_PMAP.pmap_no
WHERE     (T_ORDER.order_no = @yourOrderNumber)

SELECT     T_TRANSACTION.sequence_no, T_TRANSACTION.transaction_no, T_TRANSACTION.ref_no, T_TRANSACTION.trn_dt, T_TRANSACTION.trn_type,
T_TRANSACTION.trn_amt, T_TRANSACTION.posted_status, T_TRANSACTION.batch_no, T_TRANSACTION.campaign_no, T_TRANSACTION.appeal_no,
T_TRANSACTION.source_no, T_TRANSACTION.fund_no, T_TRANSACTION.fee_no, T_TRANSACTION.pmap_no, T_TRANSACTION.order_no,
T_PAYMENT.payment_no, T_PAYMENT.pmt_amt, T_FEE.fee_gl_no, T_FUND.restricted_income_gl_no, T_FUND.nonrestricted_income_gl_no,
T_FUND.future_rec_gl_no, T_FUND.current_rec_gl_no, T_FUND.written_off_gl_no, T_FUND.constituency, T_PMAP.gl_hold_no
FROM         T_TRANSACTION INNER JOIN
T_PAYMENT ON T_TRANSACTION.sequence_no = T_PAYMENT.sequence_no AND
T_TRANSACTION.transaction_no = T_PAYMENT.transaction_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_no LEFT OUTER JOIN
T_FEE ON T_TRANSACTION.fee_no = T_FEE.fee_no
WHERE     (T_TRANSACTION.order_no = @yourOrderNumber)

put your order number into @yourOrderNumber, then you will have GL.

have fun

Ben

Hello Everyone!

As we are getting ready for a new season launch, my finance dept has brought up some concerns from last season when we went live.

For partial subscription payments they were having a very hard time determining which performances had partial payments towards them and how much those partial payments were.

Our subscription orders do not have contributions (well... they do put it is put to On Account so we all understand that amount is obviously paid first) and we do not have package service charges.

However, each package price type is made up of 3 unique price maps. Is there a way to know which price map is being paid for first during a partial payment?

I *think* using the Ticket Sales by Period report will help with determining which performances got the short end of the stick. Unless someone has a better suggestion? Or a custom report they don't mind sharing?! ;)

Hello Everyone!

As we are getting ready for a new season launch, my finance dept has brought up some concerns from last season when we went live.

For partial subscription payments they were having a very hard time determining which performances had partial payments towards them and how much those partial payments were.

Our subscription orders do not have contributions (well... they do put it is put to On Account so we all understand that amount is obviously paid first) and we do not have package service charges.

However, each package price type is made up of 3 unique price maps. Is there a way to know which price map is being paid for first during a partial payment?

I *think* using the Ticket Sales by Period report will help with determining which performances got the short end of the stick. Unless someone has a better suggestion? Or a custom report they don't mind sharing?! ;)

From: Ryan Creps <bounce-ryancreps9649@tessituranetwork.com>
Sent: 2/11/2010 9:35:40 AM

The order in which payments are applied is…

 

1.       Any contribution on the order

2.       Any fees on the order

3.       Lineitems in date order starting from the earliest performance

 

From the sublineitems tab, you will see an SLI status indicating the paid status of each seat.  A seated, paid sublineitem would show up as “SPD”, while a seated, unpaid sublineitem would show “SUP”. 

 

Hope that helps!  If you need further information, just hit F1 while in the order screen and checking out the various documents related to Order Processing.

 

-Ryan Creps

Tessitura Network

 

From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Michael Ferrari
Sent: Thursday, February 11, 2010 7:26 AM
To: Ryan Creps
Subject: [Tessitura Ticketing Forum] Partial Payments; which GL?

 

Hello,

If I have an order with two line items, each assigned to it's own GL#, is there a way to determine/decide which GL the money will be assigned to if a partial payment is made?

Thanks!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!