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.
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