Link an exchanged package line back to its lineitem?

Hello, fellow Tessiturian!

There is no direct link between a newly exchanged sub-lineitem and the original package sale.  There are far too many combinations of possibilities that only certain assumptions can be made.  I would never rely on any such report for financial reconciliation, only as an attempt to picture exchange activity.

Some situations that definitely complicate this attempt:

Exchange made by returning seat, placing money on account, then selling seat in same or new order in a different transaction.

Exchange for one seat made for two seats of a lower value.

Exchange made in combination with a sale. Depending on the order of payment, it can appear that what you might consider to be an exchange was paid for by the payment, and the “sale” was handled using the transaction difference of the returned seat.

There are indeed more situations that just these, and why there really isn’t a clean way to handle exchange reporting without a bit of fuzzy logic.

+Ryan Creps

+Tessitura Network

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Andrea Crain
Sent: Thursday, September 15, 2011 12:01 PM
To: Ryan Creps
Subject: [Tessitura Technical Forum] Link an exchanged package line back to its lineitem?

Hi, everyone! I'm making an unspeakably complicated report, and I was just wondering if anyone has a snippet of code to link a subline row back to the package subline (the row from t_sub_lineitem with a package number > 0 and perf no = 0) or line from (t_lineitem row) that it originally came from, even after one or more exchanges have taken place, possibly in another order from the original package sale?

Currently I am sort of arbitrarily assigning such current sublines back to an original package subline from the same customer but it's so imprecise.

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