GST on fees

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

We charge GST on our inside fees - and have it set up as a price map inside the facility and then applied to each price type within the performance.

Thanks Ben! Am attempting to understand all of this......I will have fun indeed :)

Thanks David. I should have been more specific......it's actually for delivery fees that are being used online. I'll get there :)

Hi Emma,

Good day.

The delivery fees are sitting at order level.

It is located at t_order table. but I don't think you can break down to the details.

What you can do is getting the actual fee amount. t_order table links to t_transaction table, in t_tranasction table has a field called fee_no. you can start Mathematics from there.

Please beware of the transaction_no in t_order table can be overwritten if the order has multiple transactions.

SELECT     TOP (100) T_ORDER.order_no, T_ORDER.customer_no, T_ORDER.solicitor, T_ORDER.created_by, T_ORDER.create_dt, T_ORDER.tot_fee_amt,
T_ORDER.tot_fee_paid_amt, T_ORDER.tot_paid_amt, T_ORDER.transaction_no, T_ORDER.delivery, T_TRANSACTION.fee_no, T_FEE.description AS fee_description,
T_TRANSACTION.trn_type, TR_TRANSACTION_TYPE.description AS transaction_type_description, T_TRANSACTION.trn_amt, T_TRANSACTION.ref_no,
T_FEE.fee_gl_no, T_FEE.fiscal_year
FROM         T_ORDER INNER JOIN
T_TRANSACTION ON T_ORDER.order_no = T_TRANSACTION.order_no INNER JOIN
T_FEE ON T_TRANSACTION.fee_no = T_FEE.fee_no INNER JOIN
TR_TRANSACTION_TYPE ON T_TRANSACTION.trn_type = TR_TRANSACTION_TYPE.id
WHERE     (T_ORDER.tot_fee_amt >0)

Cheers.

Ben

Perhaps this is the wrong thread - so my apologies if that's the case.

I'm trying to find the general principles of recording/calculating GST within Tessitura - this is so that we can display it on receipts and email confirmations.  Is this generally held as a specific price map?  In an earlier thread (when I was at a previous organisation), I got a reply that the most likely solution was to have a local SP to do this that could be triggered by the ExecuteLocalProcedure method.

Does anyone have a solution to this I could beg/borrow/steal?

Martin