• Replies 3 replies
  • Subscribers 332 subscribers
  • Views 15 views
  • Users 0 members are here
Related

Sales & Marketing Reports not matching GL

Amed Hamila
$organization

I'd like to know if there's any way in Tessitura to reconcile GL account posting to a pkg types.

For example, a GL account 'A' comprises several pkgs - say pkgX, pkgY and pkgZ; it is easy to find out $ totals posted to this account at any given day or any given period. BUT, can that be accurately broken to pkgX, pkgY and pkgZ.

I'd say it is not possible to do so in Tessitura for many reasons, one of which is the fact that Tessitura sometimes deletes SLI that have corresponding transactions, the other is that it is impossible to accurately follow order changes since when a performance is exchanged out of a pkg Tessitura does not include which pkg the performance was exchanged out of or into.

So marketing can not get accurate information, for example how much did we sell of each pkg the makes up a certain GL.

If you know of a way let me know. Thanks.

  • $organization

    Hi Amed,

    Good day.

    1, it can be done.

    2, the question is how much time you will spend on this topic?(it cost me two months to finish this.)

    3, it will be heavily customized.

    4, If you plan to do this, the key table is t_transaction, and it is a time-related process.(we take a snapshot of sales records at 2:00am everyday.)

    5,It can become a storage issue if you try to keep all snapshots.(we only keep 7 days snapshot records.)

    6, blueprint:

    A, create a new local table gathering all info you want to know about sales

    LT_SLI_DETAILS_NEW

    B,create a local table gathering all transaction info.

    LT_TRANSACTION

    C,create a local table gathering all GL info.

    LT_GL

    Finally,

    Here is the tricky thing: Comparison.

    You can not compare LT_SLI_DETAILS_NEW with LT_GL.

    It likes you cannot directly compare an apple with an bread which is expensive.

    You compare them with $, then you have the answer.

    Same thing here, you compare them with LT_TRANSACTION table.

     

    Good luck, have fun.

    :-):-):-)

    Ben

     



    [edited by: Ben Gu at 7:30 PM (GMT -6) on 9 Jun 2009]
  • $organization

    The pieces that link the GL and the Package are Price Type/Price Map (the GL physically resides on the price map which is attached to the price type).  Don't know if that's of any help to you or not.

    H




    "Amed Hamila" <bounce-amedhamila1549@tessituranetwork.com>
    Sent by: "Tessitura Marketing Forum" <forums-marketing@tessituranetwork.com>

    06/09/2009 06:51 PM

    Please respond to
    "Tessitura Marketing Forum" <forums-marketing@tessituranetwork.com>
    To
    		heather.fails@houstonsymphony.org
    cc
    Subject
    		[Tessitura Marketing Forum] Sales & Marketing Reports not matching GL





    I'd like to know if there's any way in Tessitura to reconcile GL account posting to a pkg types.

    For example, a GL account 'A' comprises several pkgs - say pkgX, pkgY and pkgZ; it is easy to find out $ totals posted to this account at any given day or any given period. BUT, can that be accurately broken to pkgX, pkgY and pkgZ.

    I'd say it is not possible to do so in Tessitura for many reasons, one of which is the fact that Tessitura sometimes deletes SLI that have corresponding transactions, the other is that it is impossible to accurately follow order changes since when a performance is exchanged out of a pkg Tessitura does not include which pkg the performance was exchanged out of or into.

    So marketing can not get accurate information, for example how much did we sell of each pkg the makes up a certain GL.

    If you know of a way let me know. Thanks.




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

  • $organization in reply to Heather Fails

    I apologize for this post this was meant for internal pruposes.  Duh.