Functional_Description_SIC_Insurances

---

Functional Documentation


SIC – Insurances
Automatic posting/Reporting/Invoicing
BEDEV00023919 - BEDEV00031771 - BEDEV00031774
Ordering party: Connections




Author: Dorte Schusdziara

Disclaimers
The information contained in this document is the proprietary and exclusive property of Bewotec GmbH except as otherwise indicated. No part of this document, in whole or in part, may be reproduced, stored, transmitted, or used for design purposes without the prior written permission of Bewotec GmbH.
The information contained in this document is subject to change without notice.
The information in this document is provided for informational purposes only. Bewotec specifically disclaims all warranties, express or limited, including, but not limited, to the implied warranties of merchantability and fitness for a particular purpose, except as provided for in a separate software license agreement.



Privacy Information
This document may contain information of a sensitive nature. This information should not be given to persons other than those who are involved in the "Integration of Retail functionalities into DaVinci" project or who will become involved during the lifecycle of this project.

General remark:
The final dialog design/layout of the screens may vary, but the described functionality shall be integrated.




Revision History

1. Introduction

This document describes the workflow for the development "SIC – Insurances – Automatic posting/reporting/invoicing.

1. General settings

1. 1. Adress

Within the address of the insurance company you need to flag the tick box "Report & Verbuchung" on tab "Verschiedenes". Here as an example the address card of "Protections".

1. Test bookings

For test and documentation purposes three bookings have been created.

1. 1. Testbooking 552

The requirement needs to be V* as we do get the insurances as retail services from POS. The touroperator needs to be "Protections", client no. 10002. The statistical codes are required for the report to the insurance.

1. 1. Testbooking 553

1. 1. Testbooking 554

1. Supplier Invoice Control

You open the supplier invoice control via the menu <Accounting> <Supplier Invoice Control>


With chosing the supplier "Protections" the SIC will open in the "Insurance mode"

You chose the button <Insurances> and you will get to the following screen:

Here you see a new selection criteria called "Service date" which will be used for the insurance services.
Please enter a date range and you will get the insurances services of the entered service creation date range.

You will get the all insurance services which have been entered to DaVinci in the entered service date range. Select them all and click on <EK´s zufügen> and the purchase price lines will be added.

Status has been changed to "Partly matched". With pressing <OK> you will get to the following screen.

Status has been changed now to "Fully matched". With the Export path you can enter the name of the file and as well the path, just chose the … box, DaVinci wil automatically suggest as a name of the import file the invoice number. Invoice number will be counted onwards, Invoice date, Due date and amount (sum of assigned EK price lines) automatically filled by the system and retail flag set. If you chose <Abbrechen/Cancel> you will get back to the main screen, no invoice will be created and assignment of price lines will be deleted.

With pressing <Post & Export> the invoice and as well the assigned pricelines will be posted and you will get to the following screen:

Invoice has now the status "Fully matched posted" and three EK price lines have been assigned/created and invoice received an internal number (document number). Postings have been made in journal purchase.

Additionally to the postings a report has been generated.

1. Special Cases

Booking Changes and Export of insurance services
Example booking is 674:
Two Passenger
Original sales price: EUR 100.00 x 2EUR 200.00
Original sales price: EUR80.00 x 2EUR 160.00
Supplier invoice has been posted and amount of EUR 200.00 reported to the insurance company.


As you can see the export has been changed, so that one export line will be created by passenger.

The booking changes to:
Two Passenger
Original sales price: EUR 150.00 x 2EUR 300.00
Original sales price: EUR 100.00 x 2EUR 200.00

The system automatically recognizes that EUR 160.00 has been posted already and suggests EUR 40.00 as a new SPL price line.


With posting and exporting the amount you will from now on see the internal number as well.

Within the posting and report process this posting will be done. In our example we did a new invoice for this booking change to show the possibility.

As you can see from the screenshot we added as well a new column called "Exported". This flag is required to find out which sequence should be exported in the insurance report.

Within the export we just export the difference between the first and second sequence, or in other words the difference between the last exported sequence and the new sequence.