• Replies 8 replies
  • Subscribers 157 subscribers
  • Views 89 views
  • Users 0 members are here
Options
Related

GST on fees

Former Member
Former Member $organization

Hi there

Just wondering if anyone has figured out a way of breaking out the GST component of fees in Tessitura? Or is everyone calculating this outside of the application?

Many thanks

Emma

Parents
  • $organization

    Hi Emma,

    Good day.

    it depends on the price map setup.

    if you have different GL code link to GST on fees, then you can break down the detail inside Tessitura.

    SELECT     TOP (1000) a.detail_sli_no, a.sli_no, b.order_no, o.customer_no, b.perf_no, b.sli_status,
    a.due_amt, a.paid_amt, a.pmap_no, c.gl_hold_no, b.price_type,
    f.description AS price_type_description, f.price_type_category,
    d.description AS PRICE_TYPE_CATEGORY_description, c.price_category,
    e.description AS price_category_description
    FROM         T_SLI_DETAIL AS a INNER JOIN
    T_SUB_LINEITEM AS b ON a.sli_no = b.sli_no INNER JOIN
    T_PMAP AS c ON a.pmap_no = c.pmap_no INNER JOIN
    TR_PRICE_TYPE AS f ON b.price_type = f.id INNER JOIN
    TR_PRICE_TYPE_CATEGORY AS d ON f.price_type_category = d.id INNER JOIN
    T_ORDER AS o ON b.order_no = o.order_no INNER JOIN
    TR_PRICE_CATEGORY AS e ON c.price_category = e.id

    T_sli_detail table is the key table, it links to t_pmap table to pick up GL code.

    and also it links back to t_sub_lineitem table to get Tessitura performacne level info.

    have fun

    Ben

Reply
  • $organization

    Hi Emma,

    Good day.

    it depends on the price map setup.

    if you have different GL code link to GST on fees, then you can break down the detail inside Tessitura.

    SELECT     TOP (1000) a.detail_sli_no, a.sli_no, b.order_no, o.customer_no, b.perf_no, b.sli_status,
    a.due_amt, a.paid_amt, a.pmap_no, c.gl_hold_no, b.price_type,
    f.description AS price_type_description, f.price_type_category,
    d.description AS PRICE_TYPE_CATEGORY_description, c.price_category,
    e.description AS price_category_description
    FROM         T_SLI_DETAIL AS a INNER JOIN
    T_SUB_LINEITEM AS b ON a.sli_no = b.sli_no INNER JOIN
    T_PMAP AS c ON a.pmap_no = c.pmap_no INNER JOIN
    TR_PRICE_TYPE AS f ON b.price_type = f.id INNER JOIN
    TR_PRICE_TYPE_CATEGORY AS d ON f.price_type_category = d.id INNER JOIN
    T_ORDER AS o ON b.order_no = o.order_no INNER JOIN
    TR_PRICE_CATEGORY AS e ON c.price_category = e.id

    T_sli_detail table is the key table, it links to t_pmap table to pick up GL code.

    and also it links back to t_sub_lineitem table to get Tessitura performacne level info.

    have fun

    Ben

Children