Please enable JavaScript to view this site.

ASSD - Ho(s)tel Management Software PMS 3

Navigation: Technical Reference > Customizing/Parameters > Options Reference

Import CRS Invoice/Prices/Meals (crsimport)

 Scroll Prev Top Next More

 

This function allows each individual CRS invoice line to be imported into the PMS (via XML) in order to add extras to the PMS invoice and to avoid price discrepancies (if prices change before the bookings are downloaded to the PMS).

 

This is defined on article basis. The articles can be imported to tab 'Invoice' or 'Prices'. An entry must be created for each article that is to be imported - its value is the respective article number. As an alternative, it is possible to work with wild cards. The syntax is SQL LIKE, whereby ‘_’ represents a single character and ‘%’ represents none, one or multiple characters. If there are multiple matches, the entry with the longest code is used, e.g. 195 % has priority over 19 %.

 

The function can also be used to import meals that are booked as an additional service via the web check-in as an extra line directly to the ‘Meals’ tab. The meal type of the reservation is not changed.  

 

Field Name: crsimport

 

 

Import CRS invoice lines to tab 'Invoice' (bookings and web check-in):

 

Control Field:

 

Position

Value

Function

1

I

Import invoice lines to tab 'Invoice'

2

6

Added invoice lines behave like manually added invoice lines and can be deleted by user - default ('jbuilder' code)

0

Added invoice lines cannot be deleted by user unless the invoice is switched to M-manual - similar to web deposits ('jbuilder' code)

11-160

[formula]

Formula to modify web price import: placeholder is '#val', e.g. to recalculate/exclude a local tax - example: ROUND(#val/1.05,2)

 

 

Import CRS prices to tab 'Prices' (bookings and web check-in):

 

Control Field:

 

Position

Value

Function

1

P

Import prices to tab 'Prices'

3

Y

Added price rows create invoice lines ("put on bill")

4

Y

Added price rows are locked and cannot be removed by users

S

Added price rows get locking status 'Softlock' (further information can be found here)

11-160

[formula]

Formula to modify web price import: placeholder is '#val', e.g. to recalculate/exclude a local tax - example: ROUND(#val/1.05,2)

 

 

Import additionally booked meals (web check-in only):

 

Control Field:

 

Position

Value

Function

1

M

Import as an extra line to tab ‘Meals’

2

2

Meals: column 'Breakfast'


3

Meals: column 'Morning'


4

Meals: column 'Lunch'


5

Meals: column 'Afternoon'


6

Meals: column 'Dinner'



(meal columns = field 'boardslot', further information can be found here)

3-5

[special type of meals]

Special type of meals (field 'type2' = Breakfast / 'type3' = Morning / 'type4' = Lunch / 'type5' = Afternoon / 'type6' = Dinner, further information can be found here)