Custom-Reports: Difference between revisions

Jump to navigation Jump to search
Lesley (talk | contribs)
Lesley (talk | contribs)
Line 690: Line 690:
  Auto Actions, in the Booking Info tab, ensure that you set Process Template Variables = '''When created''' otherwise it will try to recalculate when the report is run and could give incorrect values.
  Auto Actions, in the Booking Info tab, ensure that you set Process Template Variables = '''When created''' otherwise it will try to recalculate when the report is run and could give incorrect values.


1.BOOKPRICE - Booking price  -Sum of the Invoice Charges - :- https://screencast-o-matic.com/i/c31ilgV3q9q
 
1.BOOKPRICE - Booking price  -Sum of the Invoice Charges -:- https://screencast-o-matic.com/i/c31ilgV3q9q
 
the value in the Booking Info Text box should be [INVOICECHARGESNUM]


2.EXTCOMM - External Commission  - Commission value sent by the channel (Commission field) :- https://screencast-o-matic.com/i/c31ilEV3qRq
2.EXTCOMM - External Commission  - Commission value sent by the channel (Commission field) :- https://screencast-o-matic.com/i/c31ilEV3qRq
the value in the Booking Info Text box should be [COMMISSONNUM]


3.COMMAMMOUNT - Commission Amount - Base price (first row in the Charges & Payments tab minus the value in the Commission field :- https://screencast-o-matic.com/i/c31il5V3q9R
3.COMMAMMOUNT - Commission Amount - Base price (first row in the Charges & Payments tab minus the value in the Commission field :- https://screencast-o-matic.com/i/c31il5V3q9R


4.OURCOMMISSION - Our Commission  - 20% of the base price - commission (20% of the Commissionable amount :- https://screencast-o-matic.com/i/c31ilmV3qRA
the full value in the Booking Info Text box should be [BASEPRICENUM][-][COMMISSIONNUM]
 
4.OURCOMMISSION - Our Commission  - 20% of the base price - commission (20% of the Commissionable amount :- https://screencast-o-matic.com/i/c31ilmV3qRA
 
the full value in the Booking Info Text box, with 2 decimal places  [BASEPRICENUM][*.2]0.20[-]COMMISSIONNUM][*.2]0.20


https://176.56.237.232/link/92#bkmrk-5.vatcommission---va
5.VATCOMMISSION - Vat Commission - VAT on the Commission values :- https://screencast-o-matic.com/i/c31ilJV3qRd
5.VATCOMMISSION - Vat Commission - VAT on the Commission values :- https://screencast-o-matic.com/i/c31ilJV3qRd


Line 713: Line 720:


7.OWNERPAYOUT - Owner Payout -  Booking price - Total PM charges :- https://screencast-o-matic.com/i/c31ilKV3qSb
7.OWNERPAYOUT - Owner Payout -  Booking price - Total PM charges :- https://screencast-o-matic.com/i/c31ilKV3qSb
the full value in the Booking Info Text box should be
[BOOKINGINFOCODETEXT:1.BOOKPRICE][-][BOOKINGINFOCODETEXT:4.TOTALCHAR]


== Send reports  via EMail==
== Send reports  via EMail==