GST on fees

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 David. I should have been more specific......it's actually for delivery fees that are being used online. I'll get there :)

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