Category:Reports: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 55: | Line 55: | ||
<embedvideo service="youtube">https://www.youtube.com/watch?v=cY4-NSPNaLo</embedvideo> | <embedvideo service="youtube">https://www.youtube.com/watch?v=cY4-NSPNaLo</embedvideo> | ||
The "Room Template" columns show the content added in SETTINGS-PROPERTIES-ROOMS-SETUP under "Room Template". These fields can contain template | The "Room Template" columns show the content added in SETTINGS-PROPERTIES-ROOMS-SETUP under "Room Template". These fields can contain template variables and also math variables which allows you to use these colums for custom calculations. | ||
Note: There can be problems exporting data to Excel or CSV in some browsers including Internet Explorer/Edge, it works well with Chrome and Firefox. Problems also occur with Chrome and MAC. | Note: There can be problems exporting data to Excel or CSV in some browsers including Internet Explorer/Edge, it works well with Chrome and Firefox. Problems also occur with Chrome and MAC. | ||
| Line 462: | Line 462: | ||
Drag the columns with the information you want to see from "Available Columns" to "Show Columns". Make sure you choose the "Pending Payments" columns you want to display. | Drag the columns with the information you want to see from "Available Columns" to "Show Columns". Make sure you choose the "Pending Payments" columns you want to display. | ||
==='''Example:''' Commission report for owners=== | |||
Go to SETTINGS-PROPERTIES-ROOMS-SETUP and us template variables in "Room Template" to calculate the commission. | |||
Examples: | |||
*If the commission you charge is 10% of the booking value including all extras use [INVOICECHARGES:10%] | |||
*If the commission you charge is 10% of cost of the lodging use [INVOICEUPSELLNUM0][*]0.1 | |||
Create a custom report: | |||
*Layout = Tabular | |||
*Include Totals= Property | |||
Drag the columns with the information you want to see from "Available Columns" to "Show Columns". Make sure you choose the "Room Template" columns you are using to calculate the commission. | |||